If any form or report has code, then you have modules. Uncheck that
referece and try a compile. If all is well, then your problem should be
solved.
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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Mike Bisson
Sent: Monday, April 24, 2006 9:08 AM
To: ms_access@yahoogroups.com
Subject: RE: [ms_access] Query Problem
OK, ran the debug and this is what turned up:
MISSING: Microsoft ActiveX Plugin
C:\windows\system32\plugin.ocx
????
The database does have forms and reports, but nothing under the "module"
tab.
Thanks :)
-----Original Message-----
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of John Viescas
Sent: Monday, April 24, 2006 8:58 AM
To: ms_access@yahoogroups.com
Subject: RE: [ms_access] Query Problem
Mike-
Only queries and tables? No forms or reports? No code whatsoever? Humor
me -- press Ctrl+G to open the VB Editor and choose Compile from the Debug
menu.
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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Mike Bisson
Sent: Monday, April 24, 2006 8:39 AM
To: ms_access@yahoogroups.com
Subject: RE: [ms_access] Query Problem
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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of John Viescas
Sent: Monday, April 24, 2006 8:21 AM
To: ms_access@yahoogroups.com
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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Mike Bisson
Sent: Monday, April 24, 2006 7:53 AM
To: ms_access@yahoogroups.com
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
Yahoo! Groups Links
Yahoo! Groups Links
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
