I have an Access DB exporting schedule data to MS Project via code. It works
fine on my laptop. The DB and Project files are on a server. When anyone else
runs the export function in the DB from another PC it reports a syntax error
at the "Set oProject = GetObject(PathName)" ...

I had a table having field 'Date' with 'Medium date' property.I don't know
how user entered something that now some records show date as '12-dec-1899'
but in table when i click the field the text converted to '00:00:09'and
when out the field it agains become 12-dec-1899. When i run ...

I am creating several reports and forms from a third party database.  A
number of them require the balance due on them (original amount, minus
payments, plus interest, etc).
The writer of this program gave me the code to paste into a module for the

I have a form with a look-up combo box.  It was created with the
wizard.
I want users to add records but I don't want them to edit or delete.
So I set the Allow Edits and Allow Deletions to No and the Allow

I have some code that has some SQL.  This works fine and produces the
results in the usual query window.  The data is mainly numbers and I would
like to format the results in the standard number format.  At the moment
there are no commas and is at 16 decimal places which is not ...

I need to build a recordset where a date in the record is => 'n' months ago.
I guess its something like:
[months] = Forms!MonthsCombo
[Date] = rstSQL!Date

I got two text box namely [text1] and [text2]
when i type==> 22 X 33 X 52 (a Measurement) in [text1]
automatically [text2] become 22mm X 33mm X 52mm
In short, i want to know code that add the letter "mm"

Is there a good way to allow the user to change the connection string rather
than allow them access to the actual code? If I use an input box, then it
seems possible that at times that variable would be empty, causing an error.
What's the best way?

I need to create temporary recordsets which get looped over and over again,
but I don't need to keep the data when I'm done.  Is there any way to create
a recordset in memory, then releasing the memory when I'm done, without
having the data saved to a table?

Good morning, I have a query with the following columns:
Date                 Bill Order          Amount        
01/05/05           1101                  1520
01/05/05           1102                   432

I am very new to VBA (6.0).  Unfortunately, I am running MS Access 97.   I
have had only a brief introduction to VBA in my MS App college course.  I am
trying to get a value in a calculated control from the form's query to round
up or down depending on the value.  This is a ...

Access 2003.  I need to check to see if a particular process (ClickYes.exe) is
running and to kick it off if it is not running.  How would I do this
programmatically?  Thanks for the help.

I want to learn how to add a "<Add New>" value to the dropdown list of a
combo box or a list box.  Whenever you click on this <Add New> you can run
code obviously to add a new value to the dropdown list.  I read an example
somewhere, but I can't seem to find it... Murphy's law eh ...

I am developing a program in visual basic that contains an array of text
boxes, and i want to export the data from those boxes to a ms. access file
and create a new record each time the data is sent rather than overwrite the
data each time the user sends the data.  Any help will ...

I had to change Excel Macro to reference different column.
That is now working, but only if I launch the macro from Excel.
I was able to launch it from Access and everything worked properly before
adding