Recent content by Laser

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

Thanks Galaxiom for your input but... Form_Invoices.InvoiceSearch_AfterUpdate = Works OK Form!Invoices.InvoiceSearch_AfterUpdate = Does not work! - I get the return "Runtime error 2465 Microsoft Access can't find the field invoices referred to in your expression"

Many thanks for looking at my query your suggestions put me on the right track and the call I have found to use is Form_Invoices.InvoiceSearch_AfterUpdate

Thank you for responding. In order to keep it simple I created two forms. Form1 has a text box with a private sub changed to a public sub which for testing purposes has a message box response. Form2 just has a command button with the code to call the afterupdate event of the text box on...

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