Search results

No, there is no time and the length of time varies. This morning we had the database up on two different labtops and one of them did this switch thing and the other did not. they were both up for the same length of time and both in the same database.:confused:

I have a Database that has a main menu and 5 other forms. The problem I am encountering is that in Access when I let it set for a few min.(no set amount of time) it bounces back to the Main menu. The current menu does not go away and you do not lose any information entered it is just a pain. if...

I agree and after looking at the requirements we will not need to have that big a UNION. we have only selected the fields for the reporting and it work find. Thanks for all you help

It worked great! Thanks

Thanks, I will give it a try.

Thank you, that was what I had come with also but I was hoping someone have a different way. I will use that solution.

I have two tables that I need to put together for reporting. The problem is that when I run a UNION query it tells me that I have exceeded the number of fields. Each table has about 160 fields. One table is the current information and the other is a purged history. Is there another way I can...

Thank you for your help.

I just want a list of the names, but I am not sure how to use what you sent me. where do I put the code? do I define a tbl first?

Is there a way to print a list of all the queries that are part of a DataBase?

Thank you Sue, I keep forgetting that integer is a smaller number than Long. I will learn. Again thank you.

On the Main Menu is a search function (it has a Binocular) for a pic. when you press the cmd it takes you to another form. On this form if you put '9906' in the 'Case Track #' yellow box and press the filter it will show the correct records. if you double click any of the rows it will take you...

Sue, Since you have a copy of the Database could you look at something that I found and don't understand. I have a search process. if I try to enter a number in the txtFilterCaseTrackNbr that is 4 pos or less it works. but if I enter a number that is greater that 4 say 5 or 6 pos it get a...

Thank you Sue, This worked. Sometimes I don't understand when to use the FormName: when not to or when to set the name to a string. :) Again, Thank you very much.:D

You have to open the frmMainMenu and the problem is in the NewCaseTrack. You get there by pressing the cmdNewCaseTrack#. Once there add a new record by entering something in the Case Name field and then select either MED or SBD from the Case Type Drop Down I have been using the MED and then...

Now nothing is working. the save record says that you can run this now and every other docmd goes to the err routine.

On my form I am submitting a query and when it runs I get messages from the completion. I put the SetWarnings False and True in to end the messages. Now when it runs I get a different message that says: "You Canceled the previous operation" and wants me to reply 'OK' Can someone tell me...

I have a tbl that I do a search on and when I get the results I place the record selector beside the record I want to look at and then press the View Detail cmd button. It takes me to the form I want but does not show the record I am looking for. The form is built from a query. Here is the code...

I have a routine that does a search and return all the records from a table that meet the request. This could be 0 to any number. It brings it back in a continious display on a form. Is it possible to be able to place my mouse next to the line I want and click it and then be able to read the...

In otherwords it is trying to find the record I requested? When I clear the filter it opens the records I requested because the record in the last or first on the file. (dep on sort seq) but if there is more than one user I can I be sure I am opening the right record?:confused: