Oh cool. I'll have to check it out.
What are all those other files that are with the Database? Do I have to make all those files too if I want this method to work with my database?
Oh cool. I'll have to check it out.
What are all those other files that are with the Database? Do I have to make all those files too if I want this method to work with my database?
I did not find any need for them. Just the Access file.
They appear to be exports of the Access objects and code. Probably in case users are unable to open the Access file they could still get the code and maybe import objects.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
@June7
Thanks again for all your help. I have a few more questions about the code we found.
This line of code.
Does this Url reference the field named Url in the table? I'm trying to find out if I need to go through that code and update Url to my actual field name.Code:ByVal Url As String, _
----------------------Update-------
Actually....Never mind. I'm going to use the code as is and make a Url field and just assign a Caption to it and labels for the user.
Last edited by dniezby; 01-26-2023 at 12:22 PM. Reason: Added update
To answer your question: ByVal Url As String declares a variable that happens to be same name as field name. I probably would have done: ByVal strURL As String and use that variable throughout VBA code to reduce confusion.
So no, it is not actually the field but it is holding value from field. Whether that field is named URL is up to you but field can be named anything. Reference that field as argument input when calling the function.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.