Search results

Thank you so much Pat, It's working perfectly.

Its ???-???-???? instead of COACODE.

Thank you arnel. I'll let you know. Just give me some time to reach home. Travelling...

I am sorry I was reading your reply and understanding it.

Ok Pat now I will show the extension of my files. Actually I have saved the master copy of FE on my local disk and copy it to the server. You mean I have to save the .bat file to the server and then share its shortcut to my local disk and to the users as well?

Sure

Thanks for sharing Pat, I tried but could not understand this. Can you guide me through simple steps? According to my database?

Hi, Pat I have created FE (ACCDE) file on my Local Disk (D:) and then created a batch file with .bat extension please check the screenshot below: Then I created its shortcut on the server location where my backend file and a copy of front-end file is already exist (I also created shortcuts to...

Pat you didn't use ACCDE file extension in any line? Let me share you the location of my files Main DB in my Computer: D:\HR\Employee Database\BTIEmployeeSharedDB\22-Nov-2022 (For Server Sharing)\BTI_Employee_Database_Testing.accdb Backend File: \\Book-dc\hr\BTI Employee...

Thank you Pat

But I have to select AccountGroupID twice then AccountType appears: After Second Selection it appears:

I am still facing a problem, when I am selecting AccountGroup from AccountGroupID field an error occurs: Then I am clicking end, Nothing is appearing in COACODE and AccountType: When I am clicking on Debug then

Thank you so much it's working perfectly.

Can I use this code for also other 2 fields? Like COACODE and AccountGroup etc?

Arnel this error appeared

Hi, june7, Thank you so much dear, Can you please explain it through screenshots?

Thank you so much Pat, can you guide me on where should I put this code? in module?

Hi, I am using DLookup in Microsoft Visual Basic for Applications, I actually want to get the values of 3 fields: 1) COACODE 2) AccountGroup 3) AccountType in a form, from a query "COACODE". Visual Basic Code is: Private Sub AccountGroupID_AfterUpdate() Me.COACODE.Value =...

Thank you ebs to guide me. I am trying this solution.

How can I get a front-end updater?