Store user-entered parameter

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

Let me start out by saying that I'm a bit of a novice when it comes to Access
so I'm probably not even usuing the right terms and I'm probably taking the
long way around)

But anyway, in a database that I'm running I ask the user a couple of
questions in order to fill in some data and either create or delete entries
from new and old months. (To be more specific, I'm uploading monthly
spreadsheets with customers and their data and some months there are new
customers and deleted customers from previous months. In the end I have one
query that gives me the sums for all the customers up to date. Therefore I
must have a number in each cell in order to get a sum.)

Basically, so that I don't have to continue to ask the user for the same
information, is there a way to store it and use it later in the process?
 
You could create a table that has the data you need keyed on a user name. I
personally use the user's "NT" user name as a key, but you could just ask
them what their username is, look it up in the table and either load up what
you find, or load in data for a new user....
 
Hi Jennifer

I assume you only want to "remember" these parameters for the duration of
the import procedure session, is this right?

In which case, I suggest you create an unbound form where you can enter or
select dates and other criteria, then have buttons on the form to perform
the various stages of the process, passing the parameters as required.

Need a few more details before I can provide more specific help, sorry!
 
Back
Top