Is there a way to generate SQL scripts for existing objects(e.g. a table)  in
Access?

We have to save the print to file in a specific folder for an exam question.  
Why does Excel and Access not allow you to have afull dialogue box for
entering the folder and file name?

I have a table with related records in another table.
Each row therefore has a "+" in the first field. If I
click this +, the related records are shown.
Can I expand and collapse these related records by using

I want to use Office XP (Access) to create a template that will allow users
to report computer troubles. I want them to be able to access the template
from a website, report their trouble and receive an automated response (which
could be customised). The troubleshooter would ...

I have forgotten how to create a hider macro.  
Basically the macro hides a row if it has the text "hide" within that row

I've just moved two databases to a folder on a network drive for testing: one
is a database of service requests, which contains several tables linked to a
contacts database. When the first tester created a new service request and
tried to select a contact, she got a message that ...

I never had this problem before; however, I have a main form and subform
linked together.   When I type in data in the first field of the subform - I
get the following error...
"The LinkMasterFields property setting has produced this error: 'The object

I have multiple projects that can be located in multiple places
(muncipalities).  I have a table of projects and a table of municipalities.  
I would like to be able to search and create reports by either municipality
or project.  How do I link these to allow one project to be in ...

I want to set up a database that will assign unique numbers to records in a
table beginning at number 00001 (counting sequentially from that number
onward). I've tried unsuccessfully for 2 days now to create a numbering
scheme that will display as "00001, 00002, 00003" and so on. ...

I want to use an image from your website in a presentation I have to make
for the Business Professionals Club in January.  Can you please grant me your
approval in using your images.

I have a table question that I cannot figure out.  I have a date field in my
table.  All the records have the field populated with the same
date...12/08/2004.  I changed the date in the table to 11/01/2004....when I
open the table all the records have the 11/01 date and if I run ...

Is it possible to re-start an autonumber field with "1" after all the data
has been deleted?

If I have a lookup table consisting of a single field, should I need to have
an autonumber primary key in addition to that single field?
Currently I have only the one field, set as the primary key, with
referential integrity to the main table so if the field changes then it

I've had to break a multi-relationship (three - one-to-one) between two
tables (say "A" & "B") in order to edit the properties one of them. The
problem is each time I try to build the relationship back in the relationship
window I get a message that relationship already exist "Do ...

For design simplicity, all of my lookup tables have two fields, an autonum
for the primary key and text field for the value.  Example:
tblPriority
 PriorityID: Autonum