I appoligize if I'm asking a question that's already been answered in
the group - I've scoured for about two hours and I can't find a
solution.  I also appoligize if I over complicate my question, but I
want to be sure that I communicate my thought(s).

On my Access database form I have a command button which opens a Word mail
merge document in which I have created a number of fields (Title, FirstName,
LastName, Address1 etc.)
I would like to be able to populate the Word document with the contents of

I'm having trouble with what seems like a very simple function,
although it's the first I've used in Access so I could have it all
mixed up.   It still works fine in forms I designed until yesterday,
but doesn't work in any new forms.   Does anyone know what is going

Got small tables - hundreds of 'em.
If someone selects a table to view,
don't wanna create a hundred forms
Planning on creating a temp table

I am able to add new records with insert and delete records just fine,
but when I go to update nothing happens. Below is the asp.net vc code
in question.
 Public Sub UserGrid_Update (Source As Object, E As

1. I want to have the value 01 if the number is 1
 waht would be the function?
2.  i think i need to use the function formatnumber.
Where can I find on the web the syntex of cstr(  ,

I have 2 subforms, neither of which is linked to the main form.  Of the
left of my form is a subform with a list of organisations and on the
right is a subform with details of the organisation currently selected
on the left.

I have an ADP file that stores dates in a datetime field type and I want to
query the table for all records for a single date (ie. ignore the time). I
want it to automatically return all records for a single day that is 7 days
prior to todays date.(in dd/mm/yyyy format)

Talking about high number of record seem ridiculus, if this number is
about 88.000
but
when I open a form, linked via ODBC to a MYSQL table, the open and the

I've got an Excel spread sheet with one row of id's and I'd like to use
these in a query and put the results into Excel.
Basically I'd like to do something like
SELECT txtFileTitle, txtFileYear FROM tblFiles WHERE fileID =

I am wondering if this query is possible somehow:
I have a table with many fields that all can have a value from 1 to 5.
if I wanna see the count of each value from one field, then this is
easy:

I am trying calculate the previous business day from today.  I am
trying to use the code below i found on this site, but keep getting
error message when i try and compile, does not recognize rst.FindFirst.
I am using Access 2002:

i used the wisard to create a find button in a form
by default it matches the whole field to whatever i type in, how can i
change the default search to any part of the field

Has anyone cunstructed a function to remove multiple carriage returns
and replace it with a single return?
Replace(mytext, Chr(13) & Chr(10) & Chr(13) & Chr(10), Chr(13) &
Chr(10)) ...

i have this form, with quantity recieved (Ir0N), quantity listed
on-ebay(LQ0N) and quantity available(ir0av)
if i receive 10 items i can list 5 with one e-bay number . . . the
quantity available is reduced to 5, and i can list 3 with another e-bay