RE: [ms_access] Query Problem

Mon, 24 Apr 2006 06:42:18 -0700

Hey John,

The database doesn't have any modules.  I haven't touched the design of this
database in probably over a year.  Can I debug in some other window other
then the modules?  I'm going to go try it on another machine and see what
happens.

-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of John Viescas
Sent: Monday, April 24, 2006 8:21 AM
To: [email protected]
Subject: RE: [ms_access] Query Problem


Mike-

First, I would be tempted to put brackets around the table name: [MAX]  --
that is a reserved word in SQL.

But this sort of problem is usually related to a bad VB reference or some
new code that has a compile error.  Open any module in the VB Editor and
choose Compile from the Debug menu.  If it complains about a library being
invalid, choose References from the Tools menu and fix anything that's
broken.  Did you recently add code or move this database to a different
machine?

John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/


-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Mike Bisson
Sent: Monday, April 24, 2006 7:53 AM
To: [email protected]
Subject: [ms_access] Query Problem

Hi All,

I came in this morning to a problem with one of my queries.  It worked fine
on Saturday, but when it tried to run last night, it produced this error:

"Function isn't available in expressions in query _expression_" with the
remainder of the message being made up of my query parameters.

Here is the SQL for my query.

INSERT INTO MAX ( PRTNUM_15, TNXDTE_15, TNXTIM_15, ORDNUM_15, TNXCDE_15,
STKID_15, TNXQTY_15, UDFKEY_15, REFDES_15 ) SELECT [Transaction
History].PRTNUM_15, [Transaction History].TNXDTE_15, [Transaction
History].TNXTIM_15, [Transaction History].ORDNUM_15, [Transaction
History].TNXCDE_15, [Transaction History].STKID_15, [Transaction
History].TNXQTY_15, [Transaction History].UDFKEY_15, [Transaction
History].REFDES_15 FROM [Transaction History] WHERE ((([Transaction
History].TNXDTE_15)=Date()-1) AND (([Transaction
History].ORDNUM_15)="0000000000") AND (([Transaction
History].TNXCDE_15)="R") AND (([Transaction History].STKID_15)="FG" Or
([Transaction History].STKID_15)="WIP"));

This query has worked every night for the last 2 years, now all of a sudden
it no longer works.

As always, any help/advice is greatly appreciated! :)

==================================
Mike Bisson
Manager of IT & Logistics
Carthuplas, Inc.
V: 207-985-4972 x658  F: 207-985-2105
[EMAIL PROTECTED]  http://www.carthuplas.com



[Non-text portions of this message have been removed]




Yahoo! Groups Links











Yahoo! Groups Links







YAHOO! GROUPS LINKS



Reply via email to