Adding common dialog box to form

[IanMullineaux]

Hi
I am fairly new to access but am putting a database together and have used the database splitter to make a front and back end.

I need to be able to tell the front end where the back end is located and have found some sample code that is supposed to do this...

The thing is... on the example i am supposed to add a common dialog box to the form i am creating... and i cant seem to work out how to do this..

the eample tells me to create the following form:
Form: frmNewDataFile

Text box:
Name: txtFileName
Width: 3"

Common Dialog control:
Name: xDialog

Command button:
Name: cmdBrowse
Caption: Browse...
On Click: =Browse()

Command button:
Name: cmdLinkNew
Caption: Refresh Links
On Click: =Processtables()

Command button:
Name: cmdCancel
Caption: Cancel
OnClick: [Event Procedure]
Cancel: Yes


I have looked everywhere and cant find a common dialog box ??

can anyone point me in the right direction please..

If it helps, the link to the example i found is: http://support.microsoft.com/?kbid=209862

 

[ghudson]

I have looked everywhere and cant find a common dialog box ??

Welcome to the forum!

Did you try searching this forum?

Check this sample out... Browse [Find a directory or file]

 

[IanMullineaux]

Thanks for the info - i had a good look around but have to hold my hand up i didnt search - i'll remember that next time -

thanks for taking the time to help

 

[Brian1960]

The search and why?

Hi,
The previous will give you how to Brwose and store a file, but why do you want to do this inside the appliucation. Surely the App and backend Db are linked and you should only do this once, and then refresh it. In practise you would nevver search for a back end as if you distribute the app then you can specify the network path.
Alternative is to hard Code it in the VBA.
Welcome,
Brian

 

[IanMullineaux]

Thanks for replying brian

The reason i was looking at doing this is because there will be ongoing develpment of the database and i want to work on the front end whilst it is connected to a back end containing test data - when i then transfer that to the live system i will need to tell it where the new data source is located...

Ian