Make Table Query question

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

Guest

I want to create a query that will continually prompt the user for a value to
be entered and then store those results in either a fixed table or display
them in an
on-the-fly results query display (haven't decided which one would be better).
1) Is there an easy way to make the query continually prompt for a value to
be entered? If so, then how? And how would the user be able to opt out of
it and view the results of all entered values?
The values to be entered are 5 digit Job #'s with all their associated
versions
(eg) Job #; 12345 with possible versions of 1, 2, 3, 4, 5.

Thanks in advance for helping to shed some light on this.
 
I don't know of any way to do this in pure SQL. The best way would be to
initialize a SQL statement (strSQL="SELECT .... FROM ...... WHERE "), put two
inputboxes in a VBA loop (one for job number, one for version), and
continually build the WHERE clause as long as the user inputs a five-digit
job number. When the user inputs nothing (a null value) in the first inputbox,
finalize the SQL statement and run it (DoCmd.OpenRecordset(strSQL,
dbOpenDynaset).

Hope this helps,

Sam
 
I want to create a query that will continually prompt the user for a value to
be entered and then store those results in either a fixed table or display
them in an
on-the-fly results query display (haven't decided which one would be better).
Click to expand...

The latter. A Select Query lets you do everything needed for a report
- running a MakeTable query adds a lot of overhead (system tables,
indexes, etc.) and is very, very rarely needed in a production
database.
1) Is there an easy way to make the query continually prompt for a value to
be entered? If so, then how? And how would the user be able to opt out of
it and view the results of all entered values?
Click to expand...

Are these criteria to be used in searching for existing records? or is
the user entering new data to be reported? What's the context?
The values to be entered are 5 digit Job #'s with all their associated
versions
(eg) Job #; 12345 with possible versions of 1, 2, 3, 4, 5.
Click to expand...

I'm sorry but that makes no sense whatsoever. What table contains Job
#? Are there existing records that you want the user to select, or do
you want the user to manually or automatically create new job numbers?
Is there any other information associated with these job numbers?
Thanks in advance for helping to shed some light on this.
Click to expand...

Hope you can do the same by shedding a bit more light on your
requirements - I'm still in the fog here!

John W. Vinson[MVP]
 
Sorry, I should have included more background info.

The user would be searching for existing Job #'s that reside in a table
named "Job Tracking". The basis for the search of multiple job numbers with
their associated versions is to see if the other users are updating the other
data fields which are a part of these records. The Job #'s and versions
won't change from week to week, but the user doing the search wants to make
sure that the info in these pulled records are being updated.
I hope that clarifies things a little better?
Thanks!
 
Uh, Ron, I think you may have overlooked my post...

Sam
Sorry, I should have included more background info.

The user would be searching for existing Job #'s that reside in a table
named "Job Tracking". The basis for the search of multiple job numbers with
their associated versions is to see if the other users are updating the other
data fields which are a part of these records. The Job #'s and versions
won't change from week to week, but the user doing the search wants to make
sure that the info in these pulled records are being updated.
I hope that clarifies things a little better?
Thanks![quoted text clipped - 28 lines]
John W. Vinson[MVP]
Click to expand...
Click to expand...
 
Back
Top