I have a data base that opens directly into a FORM that looks similar to -
but is not a switchboard.  It requires that you hold down the shift key, when
clicking to open the folder to access the design view and do any build.  How
did she set this up?

Access 2003 - After creating a table, I can type in the first field and if I
have already used that student name, it automatically comes up and I can just
press enter.  I would like the second field to come up automatically as soon
as the first field name is complete so I can ...

I am unable to locate the former tool option for showing or hiding hidden
objects. I have recently updated from Access 2000. I have checked in the
Access Optons location, but find everything else but the hidden objects.

I have a text box within a popup form that gives users some notes (specific
to  the form's data)
To make the hints easier to read I have included strings (lines) like this
& vbCrLf & String(25, "_") & vbCrLf &

I have a recipe database, with a picture of each recipe stored with each
record. I add the picture by right-clicking the OLE frame on the form and
inserting it from file.
Any reason why, once I reach 57 records, the new pictures suddenly become

I have an access table that has over 470,000 rows.  I need to delete
the duplicates.  None of the "append" query ideas will work as it
involves copying and pasing the structure, and Access won't allow me
to copy 470,000 rows.  Does anyone have a suggestion on how to

I need help with this. I needed to display all transactions in an outfit. So
I designed a union query to combine all the transactions. The result worked,
but only after a long lunch break so the query would open; it was that slow.
So I decided to break the query into smaller bits ...

I am looking to compute standard deviation and am a little confused. If I
have a table with stores and monthly sales figures how do I run a Stdev
(syntax) for the sales amounts:
Table1

I've been trying to install PDF and XPS, however I'm not having any luck so
far, I would be greatful if you where to give me some basic instructions on
how to save my files through this softwear.
yours sencirly,

I am attempting to reference the values in a subform - the main form is
"Finalise Jobs" the subform is "FinaliseJobDetailsSubform". I have tried the
following :-
"strMessage = strMessage & vbCrLf & "Repair Type - " _

I am using the DateDiff expression to obtain the difference between 2
dates.However I can't get it to run.How exactly is it entered into the query
.I am using MS 2002

Why is my report locked in "Running Query" mode, then I get a message saying
Not enough space on temporary disk.
I am trying to run a report based on a query.

Having problems printing from the web, the page prints text only and the
original page text is embedded in new text.  I have re-installed the printer
software although I don't think this was the fault as it prints non-web docs
perfectly. If I copy a web page to a document then ...

I have created thiis formula " =[PRICE1]+[PRICE2]+[PRICE3]+[PRICE4]+[PRICE5]
" to total the value of the five fields named above, I have to enter data in
all five fieldsfor it to work. How can I get it to total when i only have to
use a partial number of the fields?

According to this page:
http://support.microsoft.com/kb/295619/en-us
Microsoft says the IsNull(fax.value) will evaluate to False when fax.value =
Null. Well it's a good thing I didn't bother to read that article until afer