John W. Colby
jwcolby at colbyconsulting.com
Thu Feb 19 13:32:40 CST 2004
Look for a missing reference.
John W. Colby
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Clark
Sent: Thursday, February 19, 2004 2:14 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Help Charlotte!
I downloaded your zip, but as soon as I ran it, I got an error that
comes up at the following line
...If Left(strFrmName, 10) = "fdlgselect" Then...
the error is: 'Compile Erro: Can't find project or library. I've seen
things about this before, but I've never had any problems like this in
the past, so I do not know what to do. I'm looking now, but I figured
the list usually beats me to it....or usually, I'll find it, get on
Email and the answer is there waiting for me.
>>> cfoust at infostatsystems.com 2/19/2004 1:17:58 PM >>>
Actually, top make it easy, you can download a sample in either 97 or
2000 format from my samples here:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Foust,Charlotte
Charlotte Foust
-----Original Message-----
From: John Clark [mailto:John.Clark at niagaracounty.com]
Sent: Thursday, February 19, 2004 10:10 AM
To: Charlotte Foust
Subject: RE: [AccessD] InputBox sizing...leading
intoyetanotherquestion...using a drop-down for reports
Thanks for the offer Charlotte. I would be very interested in seeing
this! It sounds like it is exactly what I am looking for, and if it
isn't, well I guess I learn something new and maybe get more
ideas...which might be a dangerous thing!
Thanks again...I'll look forward to view this!
John W. Clark
Computer Programmer
Niagara County
Central Data Processing
>>> cfoust at infostatsystems.com 2/19/2004 12:39:17 PM >>>
What I do is create a custom property called DisplayName for each
report
that should appear in a list like that. Then I populate a listbox on
a
popup form with only the reports that have a value in DisplayName.
That
way I can give the reports a user-friendly display name without
abandoning naming conventions. I believe I have a demo somewhere that
shows that and I can send if you would like. Let me know offlist.
Charlotte Foust
-----Original Message-----
From: John Clark [mailto:John.Clark at niagaracounty.com]
Sent: Thursday, February 19, 2004 8:55 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] InputBox sizing...leading into yet
anotherquestion...using a drop-down for reports
Yeah, that's what I figured. Thanks for the help though. I figured on
doing something like the form Lambert had suggested, but I hadn't
thought to use check boxes. But this does give me another idea though.
I originally had this issue because the users quickly outgrew my
reports
menu--they said they wouldn't need more that a couple and I had made
room for five despite what they said. Well they have come up with a
bunch that are very similar, but each has a different specialty--as a
bunch I am referring to them as 'Program Reports', since they each
feature a different program that the department runs.
Since I am doing a separate pop-up, I am thinking of using a drop-down
list with the report names in it--there may be around 12-15 or so of
these reports. Is there a way of creating a table or query listing
available reports, or more specifically, but less probable, certain
types of reports--I could flag them somehow--and have them pipe into a
drop-down. Or will I need to place these in myself, which I think I
will
probably have to do?
Thanks again!
John
>>> prodevmg at yahoo.com 2/19/2004 11:19:53 AM >>>
Bottom line, the Input Box IS NOT sizable. You will have to create
your
own custom dialog box as suggested.
John Clark <John.Clark at niagaracounty.com> wrote:Caution--Potential
'Dumb
Question' warning!!!
I have placed an InputBox behind a command button, and it is a short
question:
'Opt = InputBox("eport or abels", "Report Choice")'
My problem is that this box is huge compared to the needed entry, and
I
would like to shorten it up, if possible. It isn't simply that it
looks
dumb, but you just know user will try to type more if there is room.
Is
there a way to control the size?
Thanks, John
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us
---------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com