would this be a query or a form issue and how to do it ?

f_disk

Registered User.
Local time
Today, 11:01
Joined
Jul 18, 2006
Messages
45
I have lets say 4 items i want to input and
then have the results show up all at one time.
This can also be only one item or five items.

I have it so it will find one but, I can not figure
out how to type in four seperate items and then
either use a command button or something to
tell it to go find the results of the four or so
entries and have them all show up. I do not want
this to show up in a report.

Thanks....
Hope I did not confuse you..
 
Perhaps I'm a little confused.

I sounds as though you are trying to get a listing of multiple item from the same table or query.

If this is what you want, I would use a report or page.

Hope this helps.
 
f_disk said:
I have lets say 4 items i want to input and
then have the results show up all at one time.
This can also be only one item or five items.

I have it so it will find one but, I can not figure
out how to type in four seperate items and then
either use a command button or something to
tell it to go find the results of the four or so
entries and have them all show up. I do not want
this to show up in a report.

Thanks....
Hope I did not confuse you..

I presume you are using a form for Entering data. In one session you may enter one or as many as five items.

Once you have finished entering the one to five items you then want to view them. I presume you want to view them in a query, if this is the case then,

You could add an unbound text box to your form, which would have a default value of the time and date. This control would hold the time and date the form was opened.

Have an extra field in your table to store this information, and in the after update event of one of the controls that you are filling, have this time and date added.

Next on the same form have a command button that runs a query that filters for the time and date existing on this form. Don't forget if you close the form you will lose this time and date and you will not be able to perform the query, if that's a problem then you will have to find some way of storing this time and date, possibly in a separate table.

Cheers Tony...
 
I put the file here to view - maybe this will help....

Here is the URL where the file is stored.
I did not zip it sorry...
http://www.savefile.com/files/8248534

Click the "click here button"....
You will see a pop up window...
Enter the following.... mt20
It then opens with a popup calculator and a query which
I can manually enter data and it shows it immediately
on his page..(that works)...
but, I need all the entries to show uup whether it is
one or five or three so I can do this all at the sametime.


The problem is in the beginning....
When you click the "click here button i need to be able to
input up to 5 items and then have them all show up
on the query page that comes up with the calculator...

I hope this helps you under stand what I am trying to do.
I'm a newb...at this...sorry..

Don't forget I need to be able to enter date on the
query page ...it does not have to save this information
because it does calculations for me....

thanks again...
 
Last edited:

Users who are viewing this thread

Back
Top Bottom