I'm sure this is an easy question for someone out there, and I used to be able
to do this..
I have 2 queries that produce the results I need, but I would like to remember
how to do it with a sub-query.

max

Is there a way to adjust the size of a report printed in MS Access?  I ask
because MS Excel has a function that allows you to print a document in a
certain percentage of its original size.  For instance, if I want to print
something that normally exceeds one printed page, I use ...

Good afternoon all:
  I have a table with 3 columns: ID, Name, Profession. In one of my forms,
I have a textbox with a name of a person that exists on the table. I would
like to retrieve the profession of that person by looking in the table and

I have created a database application in MS Access for a safety officer who
works for a construction company, the database holds employee details and is
used on the safety officers laptop only.
The safety officers manager has seen my work and wants me to create the same

All -
I ran into something today that is going to kill me if I don't figure it
out.  I'm working on a db that uses Access 07 as the front end and SQL as
the backend. Here's my problem...

I have a fairly large database with with one of the tables having +- 100,000
records.  This database is on a server and about 15 people working on it
simulateous.  
Somehow the autonumber resets itself and starts from 300,000 thus wanting to

I cannot get my Switchboard to work.  Here is what I'm doing (possibly
wrong!)...
Swtichboard Manager > New... [text = "Add Record"] OK
Add Record > Edit > New...

Hi, I have a problem and I'm hoping people here can help me.
I have a Access 2007 Database with a table with a field Surname. I have
added a module to the project and wrote a public Soundex function which takes
a string input and processes it into a 4 character Soundex code.

I'm in Excel VBA, trying to make things happen in an MS Access .MDB.
e.g.
----------------------------------------------------------------------------------------------
Private Sub cmdImport_Click()

Hopefully this will be an easy fix and I am just missing something stupid.
I have 5 textboxes that I want to populate dependent upon 2 cascaded combo
boxes. Here is copy of the module:
Public Sub Text4_AfterUpdate()

I have this query:
---------------------
SELECT DISTINCT tblAdditionCharge.AdditionCharge,
tblAdditionCharge.AdditionChargeAmount

Any idea howto convert a MS Access 2003 Database (MDB-Format) to a MS
Access 2007 Database (ACCDB- Format) programmatically?
Suppose that MS Access 2007 is not installed.
The MDB-database is just a very simple one, without forms, VBA,

Hi and thanks for your help in advance.
an example of my table as below:
WEN         Name           Gender        
123          ABC             M

I have an Access Database designed in Access 2003 which I have distributed
with the runtime version of Access included with Visual Studio Tools for
Office 2005.
The database works well for the majority of users, but a small number of