I have a form with 3 combo box's that can select a part id that will appear
in a locked text box.  The combo box's use differnt variations of the same
query(Part numbers that start with 4 the next for P/n that start with 5 and
the last with 3.  The problem of course is that after ...

Morning to All
I have a Db that imports a large amount of data and I have decided that a
way to manage this is to calll another instance of access with an imbedded
form that calls my code on launch

I have a table in Access. There are two date columns and another column which
is suppose to contain a number representing the difference between this to
dates.
Is this possible? If so, how do I do this?

Here is what I have:
I have 2 forms. The 1st has a cmbBox and a button. The 2nd form has a
txtBox, a button and a Subform.
This is what I want to accomplish:

Is there a command that can be ran from inside Access 07 (VBA) to move a file
from one folder to another?

at once access vba became doesn't know left$ ?????
i got such error  method or data member not found
i was working on a project and when i sent it to the client and he tried at
his PC .got such error at left$ function and other functions

I've a third party '.exe' file that I'm using to extract zipped files. I've
written a procedure that uses 'Shell and Wait' function found at
http://www.mvps.org/access/api/api0004.htm
Even then, VBA seems to be in a hurry and executing the next line of code

I have a form which is a list of queries and I want to create a load event
that will place the focus on the first query in the list box automatically.  
It seems simple, but I keep getting an error:
Private Sub Form_Load()    

I'm trying to store data associated with an object that is created as a
result of a class module I've built.  I thought I read somewhere that you
could do so in a table with a field that has it's data type set to OLE.  Is
such a thing possible or did I just dream about such a ...

Can I change the default text 'Record:' on Navigation bar? to, say, "Customer:
" or whatever?

I have a strange problem with a combo box. It sometimes does not show all of
the rows from the query that is used for the RowSource. In the Open Event of
the form, I set the RowSource to one of two queries, depending on a
variable's value. In the one case, the combobox always ...

Using Access 2007.  I am attempting to add code to my Visual Basic project
but I get a
'File Not Found' error and my changes are not saved.  Can someone tell me the
syntax for the file name?  I have another issue which I believe is caused by

We initially had a process that ran in Excel VBA that checked our remote
servers and then updated an MS Access database.
I have now moved the VBA from Excel to MS Access.
So far the process seems to work OK, but none of the tables that should have

I built an SQL statement the I then execute.  The problem being that some
info within it contain special caharacter and thus generates errors.  How can
I get around this?
sSQL ="UPDATE tbl_clients " & _

Any idea why this won't work in AC2003 - SP3?
Option Compare Database
' Declare an instance of our class
Private CF As clsConditionalFormattingDataSheetView