Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problems after converting from XP to 97

Status
Not open for further replies.
ccs2

ccs2

Instructor
Oct 8, 2003
37
GB
I recently converted a dbase which worked fine on Access XP but on conversion to 97 I found that my append query would not function. The error message told me that I had either typed the expression incorrectly that it may be too complex.

The query is simple enough as it asks the dbase to append all records that are older than today i.e. out of date. The expression I am using in the date field criteria is <Date().

The relevant line in SQL is WHERE (((tblbookings.Date)<Date())); which also seems fine. Try as I might I cannot get it to run on 97 but it works fine on the XP version. Is the conversion itself corrupting the hwole dbase? Please help!!!!!

Cavan
 
Sort by date Sort by votes
Hi

I have someimes encountered problems with using DAte() in queries, on PC with both versions of Access installed, the problems have been cause ny missing references (generally)

Have you checked references (open any code modeule in design view, choose tools\references)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
 
Upvote 0 Downvote
Hi

I have someimes encountered problems with using DAte() in queries, on PC with both versions of Access installed, the problems have been cause by missing references (generally)

Have you checked references (open any code modeule in design view, choose tools\references)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
 
Upvote 0 Downvote
Hi Ken
Not sure what you mean by references in the code. What exactly will I be looking for?

Cavan
 
Upvote 0 Downvote
Hi

I mean references to object libraries, you will have to check as I said:

(open any code modeule in design view, choose tools\references)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Style change after Windows Update
Replies
0
Views
529
TrekBiker
TrekBiker
OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
5K
OCM
OCM
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
4K
lmcate
lmcate
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
1K
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top