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
using ms access queries

Forum home » Delegate support and help forum » Microsoft Access Training and help » Using MS Access queries

Using MS Access queries

ResolvedVersion 2003

Richard has attended:
Access Advanced course

Using MS Access queries

Where I telework, the network speed is extremely slow. This affects me when I am trying to run MS Access queries.

How can I use MS Access to get round this? Is the use of make-table queries the best / only way round a slow network?

RE: Using MS Access queries

Hi Richard

Thank you for your question

Using a make table query would place a copy of a table on your lap top. You could then build queries on that, thus avoiding the need to connect remotely to the database.

The problem would be that the tables you create would be a snapshot of the data at the time you built them and would not necessarily represent the up to date data.

You might want to consider the method you use to connect when working remotely, and seek advice from your IT support.

Regards

Stephen

Wed 11 Mar 2009: Automatically marked as resolved.

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.



Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.



To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.



Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.



However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.



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.1 secs.