access 97
can someone tell me the syntax for a with stement for multiple
controls?
pseudo (doesn't work)

I'd like to print mailing labels. Simple enough eh? In the db I just took
over, the previous fellow had some names listed multiple times, if those
folk got more than one copy of the our monthly newsletter. I'd like to clean
things up and have each name listed just once. Ideally, ...

Here is the scenario. We have a database with patient case information.
This database was previously solely used in Access. The problem is our
users connect to this database (located in California) from locations
across a large network. California to Virginia. Naturally the east

Is there a way to get the index of an item in an array? For instance,
if I have:
MyArray = Array("NY","CT","TX","NM")
...can I see what position CT is in the array?

Is this possible?
I know about a bit about ODBC and found how to import an ODBC database
stored on the computer, however I am after accessing an SQL database
stored on a webserver. I'd like to keep it up to date, but that could

I read in this group, that setting the subdatasheet property  to [none] for
linked tables is recommended. In my database I have 4 linked tables. They
are all ODBC links to views on a SQL server. I change the table property
from [auto] to [none] and save. But when I re-open they are ...

I have a database for my students' grades.  A grade sheet is opened via
a form in which you select which student(s) you want to see.  I have a
few different types of grade sheet reports.  If I want to print out 2
reports together, is there a way do it besides for docmd.openreport...

As I take on more complex database work, the main problem seems to be
getting the specification from the client.
I have created some simple spread sheets that allow the client to enter
field names, type, size and sample data. But this isn't enough. I have been

In a subform I have a simple SQL statement that links an order details table
to a product table. The form is used to enter order details. Most fields are
obviously from the details table, with only a UOM field from the product
table.

When I try to access the back end of a split database, I get the error
message, that it's not trusted by access, and that I should move it to
my computer, or an accessible network location?  What gives?  Thank You.

I am seeking to create links to excel spreadsheets using DAO and VBA.
The links will be "linked tables."
I have working code to refresh links, but that is not what I want to
do.  I also need to create them from.

I have a database that strips an attachment from an MS Outlook e-mail
and saves it to a designated folder.  Is there any way to save the
actual message itself?

I usually preview a report and click the button to publish the report to
Word document from time to time.  It works correctly until today.  It
produced below error message.
Microsoft Office Access can't complete the Output operation.

Here's the scenario.  I'm building an integrated electronic health
record for maternal/infant outpatient case management for my employer,
a hospital.  We are basing the EHR in Access 2003 (fully expecting to
move to SQL server after we go live and add users).

I have a text box that contains the number 1234, I want the value form
the text box to display in a second text box so I used:
[NewTextBox]=[OldTextBox]
The problems is that this displays 1234 and I want it to display 1,234