Help 1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a db which I use frequently now other people have to use it - it is
not friendly- I create a label via a query where I have to change 'date' and
'type' is there any way that i can run a macro or something that ask the user
to input a date and then a type and then print off the report that is
required. I am fairly new to access so if you could make it idiotproof would
be much obliged Thanks Colin
 
colvin said:
I have a db which I use frequently now other people have to use it - it is
not friendly- I create a label via a query where I have to change 'date'
and
'type' is there any way that i can run a macro or something that ask the
user
to input a date and then a type and then print off the report that is
required. I am fairly new to access so if you could make it idiotproof
would
be much obliged Thanks Colin
Click to expand...

It sounds as if you want the user to supply filter criteria to a query on
which a report is based. This being the case then open the report's query
in design mode, find the field you want the user's criteria to apply to and,
in the "criteria" box, put a phrase such as "Please enter the date" in
square brackets, ie [Please enter the date]. When you run the query it will
give you an input box for the user to supply that date.

It isn't "idiot proof" in that the user can enter anything they like and the
query will still try to run with it, but I think it's a step in the right
direction.

HTH - Keith.
www.keithwilby.com
 
thanks keith - spot on.

Keith said:
colvin said:
I have a db which I use frequently now other people have to use it - it is
not friendly- I create a label via a query where I have to change 'date'
and
'type' is there any way that i can run a macro or something that ask the
user
to input a date and then a type and then print off the report that is
required. I am fairly new to access so if you could make it idiotproof
would
be much obliged Thanks Colin
Click to expand...

It sounds as if you want the user to supply filter criteria to a query on
which a report is based. This being the case then open the report's query
in design mode, find the field you want the user's criteria to apply to and,
in the "criteria" box, put a phrase such as "Please enter the date" in
square brackets, ie [Please enter the date]. When you run the query it will
give you an input box for the user to supply that date.

It isn't "idiot proof" in that the user can enter anything they like and the
query will still try to run with it, but I think it's a step in the right
direction.

HTH - Keith.
www.keithwilby.com
Click to expand...
 
Back
Top