I'm troubleshooing a problem on a machine without a full version of Access
installed.  How can I tell if and what version of the dlls, ocx and oether
libraries are running on the target machine (since I can't check the db
references)?

I have a query that gets the information of customers according to a job
number. I have to add an extra field now that tells me the number of records
found in a field so I can merge it to a Word document. Does anyone know how
to do this?

Access 2000 Windows XP
Hi Everybody
I have got a weird one here.
I have a large form frmTransactions based on a single table

I need to use the windows browse dialog to select and store a
fileaname.
I can get the filename with the path no problem.  But I ONLY want to
return the filename.

I've got an adp (Metrix.adp) with a reference to another adp
(InteractSQL.adp). InteractSQL sits on a server, and is refered to by
all of the clients (Metrix), which sit on the client machines (There's
also a SQL Server that sits on the server, but that's besides the point

Thanks for taking the time to read my question.  I've downloaded some
code created by Chuck Grimsby (thanks Chuck!!)  from
http://www.mvps.org/access/modules/mdl0057.htm, but I am having problems
implementing it.  I've read through this post, but am still not catching

I have a very simple problem indeed, but I am unable to solve it.  I
am inputing  a short date into an unbound text box with a short date
input mask. I am in the UK so my date format is dd/mm/yyyy. Everything
works superbly well with one exception.

The largest integer A97 can deal with is 2,147,483,647,
as I understand it from HELP. I would be content to represent
larger integers as strings. For example, "2147483648" would
suit me fine. I would be interested in converting larger HEX

Hey kids.
So I've got a non-updateable recordset in continuous forms, and each
row has a button they can click to update the data in that row.  So
here's the trick I'm using:

how are you guys??
Here's my problem:
I have two columns in my database : Products and Componants.  A product
is actually built from many componants.  The data is showed like this :

Access 97, trying to print on Avery 5260 label sheet.
I used the label wizard and told it the query to use.  The results give
me what I want on the label however when I hit print or print preview,
all I see is 1 label in the upper left corner.  Why isn't the entire

I have one table of the form:
Delivery     Product
101           A
101           B

how can I get this type date into Access:
Where the Contact_xxxxx is the field name and the other text the data
Contact_FullName    Martha Fuentes
Contact_StreetAddress    185 S. Oleander

A while back I imported tables to a new database via Files-->Get
External Data --> Import...
All was well for several months, and then the database started behaving
badly in a couple of ways, including slow (actually speed was fine when

I'd like to prevent users from accidently going into design view of a form
and screwing it up.
I've googled the group and have found that the normal method is to use MDE
or user level security. I'd like to avoid both of those options as I'm only