A friend has a very large "flat" database table of 367,000
records, with approx. 25 Text fields per record.
He said that his PrimaryKey AutoNumber field (IDNo) is
Indexed/NoDupes, and 12 other fields (about half of his table)

What's the easiest way to prevent users from opening any
forms, queries or reports in Design view?
Thanks in advance for your help.
Gee

I have a blank form used as a "menu" on which numerous command buttons have been placed. These command buttons open up other forms or reports and even perform some updating and appending to the database once selected forms have been closed. There has been no problems with any of ...

How can I pass a parameter to both the Report and the Sub-Report?
I have two queries based on the same table and I want them to use the same
date (set up as a parameter that the user is asked at selection time).
My report has one as the main report and the other query as a ...

If I create the following query and run it I get no
records:
SELECT AVAILABILITY.BookingDate
FROM AVAILABILITY

I'm trying to do something like the following but keep
getting error messages like type mismatch. What should
this look like?
Dim rs As ADODB.Recordset

I am a beginner, have access 2000 on my computer, should
I upgrade to 2003?

I am an Access novice and am trying to design an
application using primarily macros.  I am able to use
forms and buttons to create a decent navigation system.
I would also like to associate a macro with a command

I need to backup and transfer data from Access 97. I was
advised to copy them from MDB files. Can anyone please
tell me where exctly are those MDB files located and if I
can simply copy them and then drop them in a corresponding

Hi, How do I print address book using the access?
back and front and staple ?
Thanks
Simon Yee

Is there a way that when my "Spash screen" is displaying
I can use the On Load or something similar to run a
query? Following the splash is a menu, where among other
things, you can look at a report. This report pulls form

Maybe I don't understand table relationships,etc but I'm
not getting what I expect in my query.
I created a table to store equipment information:
tblEquip

When you use a form and sub-form e.g. a purchase order with a vendor table,
a purchase order table, and a purchase order detail table, I know the vendor
to purchase order relationship has to be part of a query but does the
sub-form, (the detail line items), have to be part of the ...

On a form I want the choice input to one field (category) to automatically give an output in another field (location). That is, if someone inputs "cooking" in (category) I want  to automatically show "kitchen" in (location).  I have a number of categories all of which i want to ...

I have a number of fields on a continuous form which contain values
from 0-100. At the moment, using Conditional Formatting I can make a
value that's over 90 appear in a thick red font or whatever. Now I'd
like to have more control so that for example 1-10 appears very light