mauricionava
Programmer
Hello, I have a query with another query inside it that can be ran by pressing a button from a switchboard. The first query is the following:
And the __acct and tittle is as follows:
When I click the button to run this query it gives me an error "If you're running a Visual Basic module that is using OLE or DDE, you may need to interrupt the module."
I dont know what it means and I have researched but nothing found.
I am not using Visual Basic on these queries that I know.
Please help!! Thanks!
Code:
SELECT [__acct and title].ACCT, [__acct and title].NEWSTOCK, [__acct and title].STATUS, TRDATA.NEWSTKLOT, TRDATA.LOT, TRDATA.BUYER, [__acct and title].TITLE, [__acct and title].SOLDDATE, Int(Now()-trdata.SOLDDATE) AS days
FROM [__acct and title] RIGHT JOIN TRDATA ON [__acct and title].ACCT = TRDATA.ACCT
WHERE ((([__acct and title].STATUS)<>"P") AND (([__acct and title].TITLE) Is Null Or ([__acct and title].TITLE)="") AND (([Principal]-[princ_pd])>10))
ORDER BY Int(Now()-trdata.SOLDDATE) DESC;
Code:
SELECT TRDATA.ACCT, TRDATA.STATUS, TRDATA.NEWSTOCK, TRDATA.SOLDDATE, INVPLUS.TITLE
FROM TRDATA LEFT JOIN INVPLUS ON (TRDATA.NEWSTKLOT = INVPLUS.LOT) AND (TRDATA.NEWSTOCK = INVPLUS.STOCK)
WHERE (((TRDATA.SOLDDATE)>#1/1/2001#));
I dont know what it means and I have researched but nothing found.
I am not using Visual Basic on these queries that I know.
Please help!! Thanks!