How can I see the number of records in a table when looking at the tables in
a database?

Hi (again),
I am trying to write some code to read records from a table and perform
actions based on the contents of Field3.
I get and eror (qualifier must be collection) at the point of '!field3' from

Have created a Form to use as an application for data input, editing and
deletion. There is only one Table. I need to make it so that Joe-User can
open the Form and see ONLY the Form, no Table, no access to the database
itself. I don't even see the name of the Form in Windows ...

I have a Discount label & text box on my Invoice report.
Problem is, I would rather that they didn't appear for on invoices for
customers who do not get a discount.
Is there a way of controlling the visibility of these based on the value of

I had StarOffice and am unable to read my documents in MS Office.  How can I
convert?

I want to compare 2 tables.  Table one has tape numbers that were ejected.
Table 2 has the tape numbers that were suppose to be ejected. I want to
compare the 2 tables and show the tapes that were not ejected or any other
discrepancies.

Hey, Im making this post short,
Ive got an Excel Sheet filled with standard data, name, address, phone ect..
for our employees, I'm having trouble transfering in all of that data using
the wizard with MSAccess, I constantly get errors, and my data is a complete

I haven't used Access yet, but would like to know if an "application"
(table, forms, reports, etc.) can be compiled into a stand alone exe file.
One that can be used on a computer without Access.
Thanks for your help!

I have a form that adds a new record then I close the form and it saves
another record.  Is there a way to prevent this?

I have a form [f_Request_List], which contains a box [UrgencyID_Box] that is
a numerical value, just on it's own it display a result number just fine. The
lookup table [t_Urgency] contains two fields, [t_Urgency] (text) and
[UrgencyID] (numeric), there's only 3 records.

When my table was set up and data first entered, the "Date Started" field was
a text field.  I went through all my records and entered a specific date in
the format "dd/mm/yy", and then changed the format to "Date" with the "short
date" input mask.  When I saved the table design, ...

This may be a very simple question but i am not an experienced access user.
I have a date field in the format - 'dd/mm/yyyy' I am trying to get get
access to recognise the date in just months and years and forget about days.
I have used the syntax 'Right' and have extracted the ...

Will these return the same records?
Between [StartDate] And [EndDate]

Thanks,

   I have a table where I enter payments made, the date on which they were
made, and the next payment due date. I now want to select the records where
the due date has passed without a payment haveing been made.I need to select
out the records where the "next payment due date" ...

I have two tables, joined by BoxNumber in a one to many relationship,
with fields:
Table1
BoxNumber/FridgeLocation/NumberOfSamples