On the form itself, there is a setting that I'm trying to capture.
(txtTmember = Total family members) I need the ability to allow the user to
add new records for the family and come back with an error when txtTmembers
reaches zero. Only if they happened to hit the NEXT button ...

I am trying to customize the Quick Access toolbar in start-from-scratch mode,
and have added the following XML:
<qat>
        <sharedControls>

I wasn't even sure what to search this on, but can I do this?:
   v_ctr = 1
   Do Until v_ctr > 3
       dim (ssql & v_ctr) as String

I'm trying to work out a kink I'm having with one of the pieces of my
database.
Users of my db have the ability to print Word documents from a form.
Sequentially, they go to the "Letters" form, select which letter to print

I have an Access project in which I open an Excel workbook. With the workbook
there is code that runs a query and gets information from the db. Everything
rns fine until the user closes the workbook and then the database object
locks up and I must Ctrl-Alt-Delete and close th db ...

I want to calculate a field, from two different tables. It will auto
calculate a date based on a past date (from a log table). How can I write a
formula using a controlsource.
For instance I want to take the most recent date from the datelog and add to

I tested using Rich text in acc2007. When I export the text  to excel or word
text via adodb.recordset, it exports the RTF with code.
I'm thinking create a second column to store text unformatted. Unfortunately
I don't know how I can convert RTF to plain text (unformatted text)

Hello, I need help getting the ADO connection string syntax right for
my Access 2007 Db application.  Below is my code.  My backend
database
file is located at "f:\data\mydb.accdb".  I basically need to replace

Can anyone explain to me why I would get an error at run time with the
following code:
Private Sub FindRecord_BeforeUpdate(Cancel As Integer)
Dim rs As Object

I think I am having a brain fart.
  I have a vba loop that is running in a module which also calls a form
that acts like a progress meter.  The form is set up to be a pop-up form, so
the form is always on top - which shows the user the progress of the loop

This might be really simple but i need help figuring out how to do it.
If field "Ref#" contains "091/16"
How can i split the numbers to use only the "091" in another field?
Thanks in Advance.

I have been running a MsAccess appication on our office network for over 2
years now with no issues.
The MsAccess .mde file is accessed by multiple people in the company and
this issue is only happening only on one PC which leads me to believe it may

I am getting the error that says the specific field [product number] could
refer to more than one table listed in the form clause of your statement.
Here is the from statement of the SQL..
FROM [New Product Design Input Form Target] INNER JOIN [The New Design OutPut

i have been VBA programming for a while now, and i have noticed that i do a
lot of things multiple times over and over again.
for instance, the whole thing of opening a form to find a related record.
the code usually goes like this:

anyone knows an activex to use tree views in access 2007?
Is is simple to configure?
Thanks
jcpi