Search results

Always had problems with Access and dates.. I suspect you may be right with regard to UnallocatedReceipts.Column(3) but maybe I can pull the date out of the Combo box and place it in a textbox.. maybe it will work then.. fingers crossed

Thanks for responding.. tried your suggestions but nothing worked :(

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 )

Ok people.. many thanks for your contributions. I think I was trying to do something that is impossible so I ended up playing with DCount which I managed to get working so thanks to all and especially to those suggestions of using DCount.. Cheers All :)

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 [InvoiceNo] field

Thanks Gasman but that throws up a compile error

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] which is a text field and also the [InvoiceNo] field which is a Number field - the ultimate goal is to find a matching [CID] to the form that I am on (This...

Hi DHookom, Many thanks your response, unfortunately that did not work. The first part of the expression does work as it pulls in the correct details from [CID] but will not find the[InvoiceNo] that is blank - I intend to use the forms oncurrent event to respond to fire an event based on what is...

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 Minty.. Thanks for your prompt reply. I accept and understand your concerns regarding future expansion however that will not apply in this database due to the business structure of the customer who is in the service sector as opposed to the consumables sector so therefore does not require...

Use in the afterupdate event of Paymode or oncurrent event If [Paymode]="CASH" Then [Bank Name].visible = False [Account No].visible = False [IFSC].visible = False Else [Bank Name].visible = True [Account No].visible = True [IFSC].visible = True End If

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...

Hi arnelgp, Thanks for looking and responding to my problem. Ancillarydata holds various data under different names so no need for criteria. DLookUp("[Completed]","AncillaryData") works fine as standalone and so does the other part DSum("AmountPaid","InvoicePayments","ChequeNumber <>'Credit'...

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...

FollowHyperlink did work ok for me Pat, but security warnings keep popping up and from what I have read you have to set trusted locations in order for it to work - I don't want the end user to have to delve into the database to have to do that. I had a similar problem trying to use outlook to...

Ah... I see, had me going there for a bit... Just spent some time googling for code tags for ms access Lol

Is this button located within the database design or are you referring to the keyboard? I have only ever used the # for surrounding dates.

Thanks Minty for responding... I am aware of the missing backslashes but the post seems to strip them out although they are there in the code on the form - Tried a couple of times to edit the post but it just removes the back slashes when posted

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...

Following a good nights sleep and digesting the thoughts and comments of people who are obviously far superior to programming than I am. I decided to do away with trying to activate an afterupdate event remotely as good advice indicates that my method would be bad practice. I have this morning...