[AccessD] InputBox sizing...leading into yet anotherquestion...using a drop-down for reports

John

...I think you may be approaching this in the wrong way ...you might want to
define basic report queries and then provide a generic means for your users
to temporarily modify them as needed without changing your query definitions
...I use a modified version of Nyberg's RFil sample mdb to accomplish this
...makes my life a whole lot simpler while keeping the users happy:

http://www.mile50.com/access/index.htm ...HTH :)

William Hindman "My idea of an agreeable person is a person who agrees with
me." Disraeli


----- Original Message ----- 
From: "John Clark" <John.Clark at niagaracounty.com>
To: <accessd at databaseadvisors.com>
Sent: Thursday, February 19, 2004 11:55 AM
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
>