|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 2nd, 2006, 08:13 PM
posted to microsoft.public.access.queries
|
|||
|
|||
"No Record Found" Message
The previous owner of this database created a query that would allow people
to choose a "Unit" and a "Region (this can be entered or left blank for all regions)." This would then create a query based on what was entered. This has always up until about a week ago. It works for all units except for one, when I enter the unit and leave "region" blank, I get a "No Records Found" message when there really are records. If I enter the unit and a region, it works. Hard to explain, any help? 
|
|
#2
February 2nd, 2006, 08:17 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"No Record Found" Message
Keri
A look at the query's SQL statement might provide a clue... Regards Jeff Boyce Office/Access MVP "Keri" wrote in message ... The previous owner of this database created a query that would allow people to choose a "Unit" and a "Region (this can be entered or left blank for all regions)." This would then create a query based on what was entered. This has always up until about a week ago. It works for all units except for one, when I enter the unit and leave "region" blank, I get a "No Records Found" message when there really are records. If I enter the unit and a region, it works. Hard to explain, any help?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Adding tables | Gertjan | Running & Setting Up Queries | 1 | December 19th, 2005 04:20 PM |
| Creating Records in tables automatically | peterg290935 | Using Forms | 8 | June 22nd, 2005 08:12 AM |
| strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
| Outlook Express is slow | ava cohen | Outlook Express | 18 | August 27th, 2004 12:17 AM |
| Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |
Linear Mode
