The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Special Forums > Windows & DOS: Issues & Discussions
.
google unix.com



Windows & DOS: Issues & Discussions All Windows and DOS questions should go here as well. Discuss UNIX to Windows (Desktop or Server) here!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Password criteria mandarin UNIX for Dummies Questions & Answers 1 12-19-2008 10:27 AM
Remote Access to FTP server not working cooljumbo2k8 UNIX for Dummies Questions & Answers 8 11-05-2008 12:43 PM
On optimization criteria for EP applications iBot Complex Event Processing RSS News 0 07-24-2008 05:00 PM
Asigra survey looks at selection criteria for outsourced backup ... - Continuity Cent iBot UNIX and Linux RSS News 0 07-19-2007 01:30 PM
Export Query not Working in Shell GEBRAUN Shell Programming and Scripting 1 07-20-2006 04:44 PM

Closed Thread
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish Bulgarian Greek Powered by Powered by Google
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 03-27-2009
hipockets hipockets is offline
Registered User
  
 

Join Date: Mar 2009
Posts: 1
selection criteria in Access query not working

Attached are views of the components of a dummy Access database. The database represents an example of the problem that has reared its ugly head.

The query example is a simple "Selection" query, which, after getting it to work, will become an "Append" query. The selected data will be appended back to Table T1.

The problem is that the selection criteria in the query does not work.

The same problem occurs on some text boxes in the customer's database -- but not on all of them.

I have compacted and repaired the database, and ran AVG and Anvira AntiVi.

I have thought about reinstalling Access -- but the problem occurs on both my computer at home and the customer's computer.

On both my and the customer's real databases, I have tried deleting the offending text boxes and queries and reinstalling them with no improvement. I also tried deleting and reinstalling the form, with no improvement. This might sound crazy, but it has helped in the past with similar problems

I use XP Pro, SR3, 1 gig memory, no other programs loaded except AVG and Process Explorer, plenty of hard disk space, a 1.8 CPU, and Access 2000 9.0.2720.

I will appreciate help!

David Colbert

Attached Thumbnails
selection-criteria-access-query-not-working-t1design.jpg   selection-criteria-access-query-not-working-t1data.jpg   selection-criteria-access-query-not-working-q1design.jpg   selection-criteria-access-query-not-working-q1data.jpg   selection-criteria-access-query-not-working-f1data.jpg  

  #2 (permalink)  
Old 03-27-2009
joeyg's Avatar
joeyg joeyg is offline Forum Staff  
modérateur
  
 

Join Date: Dec 2007
Location: Home of 17-time world champion Boston Celtics
Posts: 1,311
Cool There are forums perhaps better suited to answer Access questions

Perhaps try:
UtterAccess Discussion Forums - Access Help Center Index
Closed Thread

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT -4. The time now is 05:49 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language Translations Powered by .
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0