I have several VBA functions in my Access Database that do not work.
I have a combobox that filters my subform data however I cannot select
anything when logged in with Read Only permission.
The statusbar comes up with a message saying:

I have and email button on one of my forms but I want to use that code
on a few more forms but don't want to copy the code on each form
because any changes I make to the code will need to be updated on each.
I was thinking I could use a Public Module so I can call it from

Using Access 2002.  I have a form with several subforms.  Subform2
allows the user to insert a record into a table.  One of the fields in
this table is an account number, which is displayed in Subform1.  I
don't want the user to have to enter the account number in Subform2,

I am not a programmer and in the past have only created very simple, flat
file databases.  Although I'm a newbie, I think I could probably figure out
basic Boolean logic and financial functions.
The database I want to create would import quite a few records -- maybe as

I have a report to print envelopes. The report is based on a query. Now I
need to make 10 more queries to make different selections of addresses.
Every query has the same output fields as the already existing query. I know
I can copy the report and base it on another query but ...

I need some suggestions.  We had previously been running our multi-user
Access 2002 applications on a Novell server.  Since switching to
Windows 2003 servers a few months ago, we've been having severe
performance issues whenever multiple users are connected. As simple of

Are there TreeViews that can be sorted on-the-fly?  i.e. that can be sorted
without reloading them?

Dear forum,
I have a database in which each table has to be present in eleven
copies for back-ups/second data entry.  Making a change to a table
therefore appears to require copying and pasting over each of the ten

What might a FN look like to put the following lines in if such
FN accepted an array of desired fieldnames and fieldtypes?
I would like to have the functional lines that follow in a FN
that accepted an array of data that looked like this:

In groupheader in my report I would like to have a page count like "1 of 3"
independent from the report's page count (every new item in the group starts
on a new page). So the group that start on page 7 and has 2 pages should
show 1 of 2.

Greeting!
I hope someone can shine a light on a problem I am having. I have 13 users
on Access 2000 running FE from various PC and the BE on a new HP Server
with Windows 2003, plenty of power and RAM. Problem is, I started getting

I have a multi-table query, link to the following table:
order table
client info table
receipt table

All,
I am trying to import a table from Excel, but I get the 3709 error,
search key not found. Any ideas? My TransferSpreadsheet method
statement is:

With thanx to the group and suggestions to review other news sites,
I've got some code that allows me to open Adobe from Access.  As I am
new at this, I still need some help though.  The code to get Abobe to
open is working really well, however the referenced file I need is not

I'm looking at a table with two date/time columns in it.  One colulmn
has its Default Value set to Null, the other has nothing in the Default
Value entry.  What is the difference between these two Default Values?
Thanks.