I would like to use a QBF in which I only need the basic functionality of the
Autofilter in MS Excel, nothing more. The people using the database will be
completely confused if they have to open queries and search/sort on their
own. Since they are very familiar with the ...

How do I use Word to make a fille label using the Avery 8366 file label?

When I specify "Enforce Referential Integrity" on a table relationship in MS
Access 2003 it fails saying that the child table FK cannot be NULL.
SQL Server allows NULL FKs.
Is there any way to enforce referential integrity in MS Access and still

I'm new to access, coming from MySQL and more server orientated databases.
Can somebody confirm that I can have an access database file sitting on
a fileserver, and two different people on different computers can access
that file at the same time and update the database without ...

I have carried out a database split as an experiment into what it did, but I
now need to move the files to another computer and I need to undo the split.  
Any ideas on how I go about this?

How do I open a file dialog object in VBA.  I searched the MS Knowledge base
and found the following code, however, it fails:
Error:  "Undefined user object" on the line that creates the variable fd.  I
have referenced the Access 11.0 library.

When I import new data for a table, I first like to delete all existing
records. But opening the table, pressing Ctrl-A, then the delete key, will
take a really long time if many records. Is there a faster way?
It is not clear to me that if I import data to an existing table with ...

I would greatly appreciate some help here.  I need to count the number of
days a client was in residence at a facility during the last fiscal quarter.  
Sometimes the client will be admitted before the first day of the quarter and
sometimes after the last day.  I need to capture ...

In Services (Local) I have the following entries:
COM+ Event System                 Status (No Entry)    Start up Type
Manual
COM+ System Application       Status (No Entry)    Start up Type

I have a field that is using a military time format.    23:15 for example. I
want to convert the values to text so it can interact better with programs
like MAPINFO.  When I attempt to convert them I usually get 1's or
12/30/1899. I would like it to be 2315 in text format?

How do you get rid of the lookup fields that were created with the Lookup
field Wizard?

I don't know if this can even be done but I have an Excel spreadsheet
that I created that is ready to go already and is up to specs needed.
I'd like to do up a contact db in Access and was wondering if this
could be incorporated into it to form the report structure ... The

Warning: newbie
I've already posted this in the wrong area, sorry. Anywho...
I'm trying to design a table around a dlookup statement I have.
I'm having trouble putting it all together.

I have set up and unbound text field Text17 to Count the number of
Status fields in a report.  It works fine.  I grouped by Date1 field.
That works fine.  I now need an average of the count by Date.  I have
grouped by Date1 Field.

I have a subform which calculates totals, but it does not store them in the
table on which the subform is based.
I'm sure the answer is easy as to why this is not happening, but I cannot
figure it out!!