Form to browse and relink databases

[Graham63]

Hi there experts,

I'm trying to create the form from the link pasted below. I want to issue a user database FE/BE to 3rd party user who will only have runtime. We will both have to update the BE and email it back and forth with changes replacing the old file in the users same location. The user will only be able to re-establish the link between their FE/BE in the runtime environment.

https://support.microsoft.com/en-us/kb/181076

Form: frmNewDataFile
--------------------------

Text box:
Name: txtFileName
Width: 3"
Common Dialog control:
Name: xDialog
Command button:
Name: cmdBrowse
Caption: Browse...
OnClick: =Browse()
Command button:
Name: cmdLinkNew
Caption: Refresh Links
OnClick: =Processtables()
Command button:
Name: cmdCancel
Caption: Cancel
Cancel: Yes


I have created the form and set up the command buttons and text box, coded and referenced the on clicks as required. I don't know how to interpret the common dialog(xdialog) control element or where to place it and how it fits with the rest of the code. I understand what it is as I have produced it on a similar scenario to select a file for use elsewhere in my db in a different way. I be may misunderstanding the method, if you could walk me through I'm sure I can work it out with your help.

Thank you for any help you can provide.

 

[MarkK]

Check out the Office.FileDialog object. That article is so old it goes back to a time when you had to use Windows Common Dialog Control to open a file system browser. Now you can just use an Office.FielDialog instead.