With the following code (stripped of unnecessary? detail), I am looking to
update the PrintLabel field.
The message proves that  the code is getting to rs1.Edit 4 times - but the
field value in the table remains as false.

Group:
I need help with the code to determine whether a directory (folder) exists.
I would like to pass a path to the function and have the function determine
whether all of the folders exist. For example, if I passed "C:\Documents and

Is there any way to extract images saved in Access tables?
As far as I know, images are stored as an OLE object and can be shown on a
form in Access.
But how do I export these images to files on my computer?

I have a main form, frmClaim_Initial_Entry and a subform
sfrmClaimInfo_InitialEntrysubform.  If the Insured Address is the same as the
loss location address, I want to copy the contents of the 4 insured address
fields from the main to the subform.  I am testing with just one field ...

When i create a macro to run some VBA function.....but the programme can't
find my VBA function....why???
Please help.....thank...
Nelson Chou

I have a database that contains a subform.  The employee information is the
main form and the employee training information is the subform.  Whenever an
employee reaches 100% of their training, I would like their name to be added
as a "trainer" to a combo box in the subform.  

All,
I am trying to automate the generation of a 94 page report.  The user has
already created all of the queries needed for the report and I am just
writing the code to tie everything together.

Hi,
I am relatively new in database administration, and if  I could get the
answer to these 'doubts',  it would be a great helo.
What is the difference between a centralised database and a distributed

Is there anyway to use the environ function to get the City or State?  If
not, does anyone have a recommendation?  Thanks in advance.

I am generating parameter query accepting vaues in from a form.
In this form i have FROM andTO date fields that the user have to enter. Is
there a way i could provide a calander instead of user entering date each
time.

I'm trying to construct a query to a full-text index from an Access 2007
form to SQL Servert 2005.
my query is
   SQLStr = "SELECT EventId " & _

This method change the hieght and Width of the sub form in the form calling
in
form resize event.
I don't know what is 6615 parameter meens

r have a form (with a subform) with an "active" employee and "inactive"
employee checkbox.  When a user clicks the "active" employee the background
of the main form remains the same color (this is what I want).  When the user
clicks the "inactive" employee checkbox the background ...

What would the VB script look like for copying data from a Table in Acces to
a Excel Spreadsheet?

I need to create a combo box that allows the user to select either the
current month plus 1 or one of the five subsequent months i.e.  up to six
months hence (excluding current month). I need to include the year in the
items in the combo box too. My problem is how do I create ...