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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
access

ResolvedVersion 2010

Kulbir has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course

Access 2010

How do you give an end user a Form to use without them having ANY access to Access. From the end users point of view they should be filling a FORM and not even be aware of the technology involved, let alone be able to change the settings. How is this achieved?

RE: Access 2010

Hi Kulbir

Thanks for your question

You can create an access front end database that simply contains a single form and uses the start up tools to hide everything but that form, which also opens automatically. You could also create a desk top shortcut so that the user directly accesses this database by double clicking on it.
To access these options, choose database options from the file menu

Hope this helps

Regards

Stephen

Mon 6 Dec 2010: Automatically marked as resolved.

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.