Laser's latest activity
-
LLaser replied to the thread Select Statement Problem.Always had problems with Access and dates.. I suspect you may be right with regard to UnallocatedReceipts.Column(3) but maybe I can pull...
-
LLaser replied to the thread Select Statement Problem.Thanks for responding.. tried your suggestions but nothing worked :(
-
LCan anyone see what my problem is with this: Set MySet4 = MyDB4.OpenRecordset("SELECT * FROM [InvoicePayments] WHERE...
-
LLaser replied to the thread DLookup Problem.Ok people.. many thanks for your contributions. I think I was trying to do something that is impossible so I ended up playing with...
-
LLaser replied to the thread DLookup Problem.Because I want to find the matching [CID] in the [InvoicePayments] table [thats equal to the form that I am on but has no vaule in the...
-
LLaser replied to the thread DLookup Problem.Thanks Gasman but that throws up a compile error
-
LLaser replied to the thread DLookup Problem.Hi Pat, Maybe I didn't explain myself properly so I will try again. Basically I want to check the table [InvoicePayments] for the [CID]...
-
LLaser replied to the thread DLookup Problem.Hi DHookom, Many thanks your response, unfortunately that did not work. The first part of the expression does work as it pulls in the...
-
LI am using.. DLookUp("[CID]","[InvoicePayments]","[CID]=forms!Invoicing![CID]") and which works fine. However I also need to add a...