John Clark
John.Clark at niagaracounty.com
Thu Feb 19 12:14:19 CST 2004
Thank you William and Charlotte!
It would be great to do what you suggest William, but I'm not sure I
can--although the reports are very much alike, there are a couple of
them that have slight differences. I am going to look into accounting
for these differences programmically though, in which case this would
work for me.
I think I was trying to say exactly what Charlotte ended up
saying--regarding the custom property. I'm looking forward to checking
this out.
Thanks again!
John W Clark
>>> wdhindman at bellsouth.net 2/19/2004 12:08:53 PM >>>
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
>
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com