Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Forms and Browse

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Forms and Browse

Resolved · Low Priority · Version 2000

Reply Tue 9 Aug 2011, 16:30Delegate Paul said...

Paul has attended:
Access Advanced course
Access VBA course

Forms and Browse

Can I create a field in a form so that a user can browse for a file on their network?

For upcoming training course dates see: Pricing & availability

Reply Fri 19 Aug 2011, 15:43Trainer Simon said...

RE: Forms and Browse

Hi Paul,

Thank you for your question.

There is no answer in the front end of Access but you need to create some Access VBA code. The link below contains the vba code needed.

http://www.access-programmers.co.uk/forums/showthread.php?t=120524

On the form, switch to Design View and create a command button. Now select the button and go to properties. Select the Data Tab and click on the 3 dots at the end.

Copy the code from the link and paste it between the Private Sub and End Sub.

I hope this helps.

Regards

Simon

Fri 26 Aug 2011: Automatically marked as resolved.

Access articles

· How To Change The Data Displayed In A Linked Field In An Access Table
· What Is The Database Documenter And How Is It Used?
· Find Microsoft Access Templates For Any Task
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· Reasons to Consider Microsoft Access Training

Please browse our web site to find out more about
access course london and other Microsoft training courses.

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips