User Inputed Coding

  • Thread starter Thread starter Curtis Stevens
  • Start date Start date
C

Curtis Stevens

In the event coding of a report, what do you use if you want a reference or
coding to be inserted by the user, such as text like the current month. So
when the code execute, part of the code it uses will come from the user when
they type in the box that pops up asking for that data?

Thanks
Curtis
 
In the event coding of a report, what do you use if you want a reference or
coding to be inserted by the user, such as text like the current month. So
when the code execute, part of the code it uses will come from the user when
they type in the box that pops up asking for that data?

Thanks
Curtis
Click to expand...

In the Open event of the report, you can call a form that asks the
user for data before the report displays. This can include selection
criteria or anything else you need for the report.

For some examples, see the Report Selection Techniques on our web
site:
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
I setup the query to ask for the data, then added a text field using that
query filed name on the report, white text so it is hidden and then it works!

Thanks
Curtis
 
I setup the query to ask for the data, then added a text field using that
query filed name on the report, white text so it is hidden and then it works!

Thanks
Curtis
Click to expand...

Hi Curtis,

That's what's called a parameter query, and it will work fine for
simple stuff like prompting for a text value. It doesn't work so well
for fields from a lookup table, formatted fields like dates, etc.
That's when the pop-up form technique works better. But I'm glad you
found a solution.

Also, you don't have to make the text white to make the field
invisible; just set it's Visible property to False.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Back
Top