LinkBack URL
About LinkBacks
Hi Team,
Need assistance to check my VBA macros and find the errors when retrieving and updating files. Please see attached file.
Thanks,
Emmieshane
Hi Team,
Need assistance to check my VBA macros and find the errors when retrieving and updating files. Please see attached file.
Thanks,
Emmieshane
Would you offer some explanation about which macro you refer to and where it fails
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard,
The retrieve and update command buttons are not working. I'm thinking it's because I'm using a wrong reference number to retrieve my files. What I want to do is, when I type in the record number in cell A1, the corresponding file on the Database will auto populate on the Form.
Thanks,
Emmieshane
The first lines in Private Sub Retrieve_Click() macro should be
It's always good practice to Dim Variables first, and refer to sheets with their VBA code name not tab name
Dim Rowcount2 As Long Rowcount2 = Sheet1.Range("A1").Value
Your code would have worked had you used
but as I said use the sheet codename, the tab name is too easily changed by the user and a macro that uses it will fall over.Rowcount2 = Sheets("Form").Range("A1").Value
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks