forms and browse

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Forms and Browse

resolvedResolved · Low Priority · Version 2000

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?

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

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

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds

View all Access hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.11 secs.