I have a routine I'd like to run when a form closes, that associated with a
command button on another form.  Can I trigger the event associated with the
command button by using VBA attached to the onclose event of the first form?

I want to assign total number of days in the current month to a text field.
Please let me know if there is a function that does that.
Thank you!

Here's my code:
   strFileName = Dir(strPath & "*.xls")
   Do While strFileName <> vbNullString
       strFullPath = strPath & strFileName

I have a form, frmAssociates, that displays employee information (name,
address, shift, employee no., etc.) for one employee at a time.
A drop-down box, cmbAssocPicker (in the form header), contains all employees
in the database.  Using the drop-down box, the user can select an ...

Can survey data either be exported or linked to an Access 2003 Database?
Thank you!
MN

When asked if entry is to be added to combo box is answered as "No" and the
focus is returned to the combo box, how can you prevent the drop down list
from re-appearing?

When I exe the recordset VBA program the line one was
Dim dbo as Database
the computer show to me was error
Why?

I am working on and import form so the user can import multiple files into a
database.  I have it set to work except many of the file names are longer
than 64 characters.  It needs to be this way.
I would like to rename the filename right before the transfertext operation

I'm trying to do 2 things:
1) Transfer a table (tbl A70 Final Remit Detail) to an excel file
2) Assign a name to the file using a field (FileName) from another
table (tbl A02 Report Year Temp tbl)

i'd like to have a function, to retrieve User's IP or other system information.
right now, i'm able to retrive "MachineName".
Reason: I need to make a log file, everytime when a user open my database,
their IP and systemStam will be saved as into my Sys_Log table for further

My database has some lengthy code in the startup that only needs to be done
once a day.  If I can store the date when the database is opened the first
time each day then I can bypass the startup code for subsequent startups that
day.  Is there anyway to set a constant equal to ...

This question is a repost and was also posted in General Questions....
I am having to go back to an Access 97 format.  In the current project we use
the FileSystemObject to reference, parse, and do other essential file
manipulations.  

My database grows very big. How could i enter a code that compresses the
database on exit ? Is it possible to revert to the original zize of the file ?

I have this process that retrieve data from two Oracle tables.  Lately, we
have been receiving the OLE error: Multiple-step OLE DB operation generated
errors. Check OLE DB status value, if available. No work was done.
There are two Oracle tables that are processed, the first ...

Hi, I have a database for custom parts, I need to take a picture of each part
and associate the picture with is corresponding record, I have 15 producion
lines and an a front end application controling the flow of each part, there
are a lot of parts (1000's each day) so linking ...