Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Store run time data
- Thread starter sthandwa
- Start date
depends on where you are putting the parameters...
if you have created your own forms, and are linking to those parameters, then that value can be accessed at any time, until you manually change it. If you want to store that, then there are numerous ways to do it.
if you are letting the automatic popup input forms to handle the parameter inputs, then you can't easily store the inputed values.
--------------------
Procrastinate Now!
if you have created your own forms, and are linking to those parameters, then that value can be accessed at any time, until you manually change it. If you want to store that, then there are numerous ways to do it.
if you are letting the automatic popup input forms to handle the parameter inputs, then you can't easily store the inputed values.
--------------------
Procrastinate Now!
- Thread starter
- #3
Here is my scenario,
I've got a query that ask for a start date and an end date as parameters at run time.I need those dates to use on other queries that I use to produce a report.
Is this the right way to do it or should I create a form and if so how should I do it?
As I said I'm not too familiar with Access.
I've got a query that ask for a start date and an end date as parameters at run time.I need those dates to use on other queries that I use to produce a report.
Is this the right way to do it or should I create a form and if so how should I do it?
As I said I'm not too familiar with Access.
phantom49601
Technical User
Create a table - called for example params
in it create a field call topic and one called value.I would make both text fields of sufficient length. Make the primary key the topic. You can then store and retrieve the values on the fly. The values will be there the next time you open the database as well. I have code that you can use in vba to accomplish the storage and retrieval of the topics and values if you need it.
in it create a field call topic and one called value.I would make both text fields of sufficient length. Make the primary key the topic. You can then store and retrieve the values on the fly. The values will be there the next time you open the database as well. I have code that you can use in vba to accomplish the storage and retrieval of the topics and values if you need it.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question