Search results

Can anyone see what my problem is with this: Set MySet4 = MyDB4.OpenRecordset("SELECT * FROM [InvoicePayments] WHERE ((([InvoicePayments.PaymentDate])= ([UnallocatedReceipts].Column(3)))") Keeps telling me I'm missing something like ] or )

I am using.. DLookUp("[CID]","[InvoicePayments]","[CID]=forms!Invoicing![CID]") and which works fine. However I also need to add a number field which contains a NULL value from [InvoiceNo] from the same table but I cannot find the correct syntax for the lookup.. Does anyone know how to rectify...

Hello all.. I am hoping that the gurus on this forum can answer a query for me. I would like to be able to create a tab control where there is a separate tab for each record in the same table. There would be no more than five records at any given time within the table so no more than five tabs...

I dont know if it's me or what, but I always have problems with the correct syntax for the D's... You know the Dlookup, DSum,DLast and so on but I generally find the answer using Google and various forums to glean an answer. But this one has me flumoxed. My question is can I use a Dlookup within...

After researching various methods to open a PDF file such as Shellexecute and hyperlink I found a helpful post from Kiwiman going back to 2008 with some success. Although I can get it to run correctly if I provide the full file location and file name I cannot get it to run correctly when pulling...

The following code used to work fine in Access 2003 but refuses to work in Access 2016... Googled many results and tried various suggestions to get the call working but nothing works. Any idea as to the correct syntax I should be using please? Call Forms.Invoices.InvoiceSearch_AfterUpdate

A have noticed a lot of queries regarding changing the back colour of a text box in continuous forms within these forums and others. Years ago I created our database which has just this feature incorporated.. it has no events or code associated with Table1 or Form1, yet the CID field on Form1...