I'm hoping someone can guide me on solving this vexing problem I have
with a database I built to track a projects.  I'm using MS Access 2003
and here are the basics: the database is designed to track companies
that are supporting projects and the number of personnel in each

I'm need to change my SQL based upon the field that the user selects on
a form.  To follow is the beginning of my code. The selected field is
represented by fName. When I run it I get syntax error 3075 and I think
the problem is that fName returns the field name with quotation marks

I have an A2K app that generates a mail message in Outlook.  It
properly fills in the To and CC lines in Outlook, but Outlook doesn't
attempt to resolve the names until the user manually changes
something. (The user has to manually edit something on both the To

Each time I  run the user-level security wizard to create an mdw for my
database I have noticed the following issue...
Once I have run the wizard, I close the database and open the .mdw file I
have created. As soon as I open the .mdw file I get the following two

I am writing a function to fill in the data in an unbound form.
I have a table with field names of 1, 2, 3 etc up to approx 100. I have
an unbound form with fields called 1, 2 3 etc.
I gave everything names like this because I wanted to simplify the

I need to calculate a score and I'm having a problem getting the logic
of how to do it.
In each record there is a column with a score of 1-10.
The percentage of 9 & 10s minus percentage of those that are 6 and

I need to calculate a score and I'm having a problem getting the logic
of how to do it.
In each record there is a column with a score of 1-10.
The percentage of 9 & 10s minus percentage of those that are 6 and

I've got 4 front end mdbs (different, but related apps) totalling about
10+ Mb in size
and a 250+ Mb back end mdb
and I've got 50+ users running the apps on two terminal servers

How safe is it to back up a single user mdb when it is opened. No tables are
opened at the time of the backup. The only object that is open is the form
from which the backup code is being run.
Thanks in advance,

I have a macro that I use to send three reports every week to about 10
people by email via Lotus Notes.I use the "Send To" command to send the
reports out in Rich Text Format. I used RTF because it was the most
compatible way for everybody to open the report. For reasons unknown to ...

Hope someone can help.
I have a listbox displaying time periods in blocks of 15 mins for a 24
hour period, all up 96 rows.
The listbox can only visibly show 20 rows a time.

Is it possible to use the Excel Equation Solver in an Access Database,
ie call it from vba code?
Thanks,
Tristan

I'm using a Visual Basic front end with an SQL query to select some
data from a MS Access database. I have a table named Tithes with
Columns of
TitheDate

I am trying to write query expression that finds the position of the
first number in a string.   So, this recordset...
DUS2345.4
D2789.6

A developer gave me a Microsoft Access Application approximately 42MB
that I had him design.  I can open the application itself and see the
Access GUI with the buttons & menu he created, but I cannot open the
file in Access designer to modify the IP address from which it pulls