I have got database which imports data from csv every night. So all data are
up to date next day when the clients are "downloading" the data to their
local mdb through sql query.
But their are over 100.000 records and this takes a while to download. I

I had added a reference to Outlook 11, but my shared user has Outlook 10.  I
tried to set the reference on his computer to Outlook 10 and then tried to
save the code but it crashed.
Now my database is corrupt and I can't get into the code at all to remove

I want to open a new instance of Access 2007 application from current Access
application, But the window returns to current. I want to keep the new
application on top view without closing current Access. Can anybody out there
hlep me?

I'm trying to automate an email and would like to bold a portion of the email
body but cannot figure out how.  Here is my code for it:  strMessage2 is the
portion i would like to bold.
Dim strMessageBody As String

I have a form that I need to use in 2 different types of circumstances.  In
one, it is used to add a child to the record of an existing client.  In order
to get it to link correctly, I tried to use the following code:
Private Sub CommandAddChild_Click()

Here is my situation:
I have two forms: frmInputRecord and frmAuto
I need for when a user inputs mileage it will look at another field for the
interval to update the next oil change.

I want to export all queries as follows
Dim FrontDB As DAO.Database, BackDB As DAO.Database, Qry As QueryDef
Set FrontDB = CurrentDb
Set BackDB = OpenDatabase("C:\BE\MGP\Survey\Survey.mdb")

Trying to pass a SQL expression to a subform. The SQL expression returns
records using Query view in access, but using this...
...
SQLString = "SELECT * FROM Processos"

I have an access database that gets updated with new data once per month.  
At that time I have a form that goes through:
1. all of the queries and programmatically adds the new month field to the
SQL strings, and

The following statement works fine for me with the  table name TABLE1 and
field name FIELD1 hardcoded:
iType = CurrentDb.TableDefs!TABLE1.Fields!FIELD1.Properties!Type
Is there a way to make the table name and field name variable, something

Good morning,
I need to try and automatically process e-mails.  I already have the
function to parse the content so I can work with it.  Now however I need to
create the code to actually append each e-mail into my db.  Problem being the

According to documentation EndDateCalendar.Value = Date will display the
current date in the calendar control. I have the control bounded to a field.
I'm not sure how or where to place this statement to get it to work properly.
Any help would be greatly appreciated.

I am trying to make a "Badge" report for instructors in our organization to
properly identify their qualifications to students. There are two possible
qualifications: Non-Restricted and Restricted.
EVERY INSTRUCTOR is qualified for non-restricted, and some are also

I've successfully used Ken Getz api0001 Dialog Box code for Importing and
Exporting files.  I now need to simply open a Dialog box to locate a file,
and then save that file to a different location.  It seems that it would be
simple but I simply can't get the code correct for it ...

Private Sub procLerUltDezNumInseridos()
   SQLString = "SELECT TOP 10 NrSubscritor FROM Processos WHERE UserID = " _
   & lngUserNumber & " ORDER BY TimeStamp DESC;"
       funcCorrerSQL SQLString