Recent content by KMBSNT

I have already uninstalled and reinstalled with no luck and have done the Microsoft fix. This is running by itself on a windows 7 64 bit machine. Since I can get the info I need off an old XP machine hooked to the server I think I will give up until the XP dies. The IT guy suggested I contact...

I have checked the service packs and installed the hot fix with no good results. I still have one XP computer that I can connect to the POS server and use 97 on it until the computer dies. I don't know what else to try and still suspect there is a conflict between 2003 and windows 7. I had...

I will try these suggestions tonight - hope this solves the problem.

I removed all fields from the query except date and still get the "search key not found in any record" message. I also created other queries using different tables and fields and have the same result. Is it possible there is a conflict between Access 2003 and Windows 7 running on a 64 bit...

Thanks for the comment but I am not sure I understand your suggestion. The word DATE is not my wording but this is the word that is in the point of sale data base. All I have done with Access is select the date field I want from the POS data. As I said in an earlier post, the query runs fine...

I am sorry for the confusion. The issue involves to 2003. If I run the query without a specific date in the date field it runs perfectly and lists all transactions for all dates. If I select a specific date I get the message that the search key was not found in any record. Below is the SQL...

Yes, I can print a date from the POS database and it prints mm/dd/yyyy. I can also run the query without specifying a date and it will print all records with dates back to the implementation date of the POS system, but if I select one of the dates and put it in the query to only select that...

The query I used to select a specific date is mm/dd/yyyy.

I have a query using Access 2003 accessing invoice information from a table linked from our point of sale system. The query runs perfectly displaying all info including dates if there are no specific dates indicated in the criteria. If I select a date in the criteria field I get the message...

I have used Access 97 for many years but have recently upgraded computers to Windows 7 so it is time to learn a new Access. My first attempt has been a little frustrating so I was glad when I stumbled across this forum while searching Google for help.