In an Access 2003 db, I am writing an If statement on a combo box field on
After Update.
I want to disable certain fields depending upon what the user selects from
the combo box.  Here is what I have done so far.

I am trying to copy some values from the table Product_data_new using a combo
box [Code as below] to pick out the ID value from the table and then the code
should pick out the other values from the same line and copy these  into a
form - but the code is not recognising the  ...

I am working on a Search Form that utilizes 2 texts boxes (Text9 and Text11)
to look up the respective fields "Symbol" and "SerialNo" on my "Items" table
and open a separate Form (Form1) with the history of the "Item". I want to
enter both numbers so that it can locate that ...

I have been using a technique where the front-end checks an update table
that indicates the Fields, Relationships and defaults etc to be updated in
the back-end, and goes ahead and makes the relevant changes.
However, two things have changed:

Let's say for example I have a filepath:
"N:/Private/LPC/RegTeam3/Washington/CAAR.xls"
With the Split function and using "/" and passing to an Array I know I
can get the LBound (N:) and Ubound (CAAR.xls), but how do I get the

I have had a good look through various posts re date counting and there is
alot of similar cases but can't find one to match mine.
I have a table which captures projects coming into the department.
It includes fields that capture, date arrived, date required, and date

Is there a way to set an SQL Result As Variable?
The reason why I want to do this, is because of a date comparison.
An example: if the date variable is 1-1-2007 and the other date variable is
also 1-1-2007 then .....

Does anyone knows whether it is possible to refer
to a cell from a worksheet and store the value of
that cell in a variable using VBA? Is there an easy
way to accomplish that using Access VBA?

I would like to automatically run a macro or query, everyday at 3:30pm. What
is the best method to do this? I do not want any user intervention. It needs
to run in the "background", as long as the Access file remains open....And
lets assume its always open...., and can be ...

Anybody is aware of linking oracle tables through ODBC connection in MS
Access database using ADO through VB programming.
I used docmd command but it will prompt for "select unique record
identifier" for each table. I want to be linked without promting.

I've found out (through experimentation!) how to use a form to put in unbound
controls and then use VBA so that when I hit [OK] button (with the VBA in 'On
click') it opens up a query and form based on the data in the controls.  So,
for example, I have a start date and end date.  ...

Is there a good reference listing Access error descriptions given the error
number?
Or... is there a good way to use the immediate window to read error
descriptions when I input an error number?  (I'm trying to follow examples of

I have developed a purchase order form which has a subform that is the
itemized list of of purchases.  On this subform I have a footer with an
unbound text box (Total) with this formula in it  =(Sum([DebitAmount])).  
This works well except it only updates when I go to add the ...

Is there any way to close open message boxes programmatically before forcing
a database to quit?
Thanks in advance
Dave

I have a database that I am building (I am very new to VBA, so please be
patient) and I figured out how to create a number for each different type of
record based on the starting letter of the file. For example:
Medical = M