SQL

Resolved · Low Priority · Version 2003

Mon 20 Jul 2009, 13:53 Delegate Vishal said...

Vishal has attended:
Access Introduction course
Access Intermediate course
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Access Advanced course

SQL

I'm using a database which has a number of queries which have been created using SQL statements rather than using Design view. Please explain how I can understand what it is doing, without learning SQL.

Thu 23 Jul 2009, 14:54 Trainer Stephen said...

RE: SQL

Hi Vishal

Thank you for your question

I am assuming that the database you are using is in fact an Access database. If this is the case then you should be able to open the query in design view in the normal way. You will then see the tables and fields that the query is selecting, as well as the relationships between the tables.

Simply go to query view, select the query in question and then click on the design view button on the left hand side of the main tool bar

Regards

Stephen

Thu 23 Jul 2009, 15:05 Delegate Vishal said...

RE: SQL

Thank you for your response.

Yes, it is an access database.

I have tried to view the query in design view and it doesn't work, hence my question. This query seems to be written using SQL rather than using the design view.

Thu 17 Sep 2009, 13:46 Trainer Stephen said...

RE: SQL

Hi Vishal

Thanks for your question

Again, apologies for the delay. I have had a number of ongoing health issues recently combined with on site training,and have been away from work.

Can I suggest you copy and paste the SQL into an email and send it to me. I will then have a look at it, annotate it and then send you back an explanation.

My email is stephen@stl-training.co.uk

Regards

Stephen

Thu 19 Nov 2009, 09:28 Trainer Rich said...

RE: SQL

Hi,

This question has now been left unattended for a while.

Vishal, did you e-mail Stephen with the required details?

We like to keep down the large number of active forum posts we receive.

As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).

We look forward to hearing from you.

Thank you.
Regards, Rich

Wed 25 Nov 2009: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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.