I'm trying to write some code that will check to see if a table is open and
if it is I want to close that table.
Is there an If statement I can use to do this.  Thanks for the help......

I posted earlier today asking how to prevent code from executing until a form
was fully opened.  That's been solved.
However, the next step is programmatically forcing the report to the last
page.  I tried the following code:

I have the following function that sets a calendar entry in MS. Outlook from
one of my forms. This works fine but it always sets the appointment to "Busy"
time instead of "Free"
When someone uses this I want it to set the appointment but have it still

I'd like to send html email with access 2000.
I understand how to send regular text using the Outlook library, but how can
I send html in the body?
I saw a referent to a property of .BodyFormat but maybe Acesss 2000 doesn't

I use the following RunSQL command to update a field in a table based on a
single criteria.  I would like to modifiy this command for multiple criteria
but I'm having trouble with the syntax.
DoCmd.RunSQL "UPDATE[Table1] set[Comments] = Null  WHERE [Stock Number] = '"

Found this code to play MIDI, WAV, or AVI files at the following URL ...
http://www.mvps.org/access/api/api0011.htm
But having problems with this code (well at least what I want it to do)
Private Sub cmdPlayAvi_Click()

I've started using MODI to merge tifs to one tif
I have Access 2003 with windows XP
Will the MODI will run on:
   Access XP ?

I am using a function to send an email through lotus notes, which is fine
however I need to attach recent files to the outgoing email.
my files are stored as name_surname dd.mm.yy
my question is, is there a way of using VB to check for the most recent date?

Can anyone give me a step by step guide on how to a insert popup calendar in
several different fields on an Access database?

I am trying to use the following code to grab data from a table to create a
variable, but it keeps blowing up.  Any suggestions would be appreciated.
Thanks!!
Tim

I'm using the DoCmd.TransferSpreadsheet command to export  to a spreadsheed
the results of a query.
   DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3,
"Qry_EmpHrs_Total", "Summary_Project_Hours", True

Why is int(1.4/.05) = 27?
It should be 28.
TIA,
Josh

I have a main form with a subform called "DynamicQuerySub". There is a
combo-box on the main form listing queries that the user can pick from. The
query selected is then set as the SourceObject for the subform. I also have a
button which exports the SourceObject of the ...

I have some code that I run to update my tables, and it also creates a filter
statement as a string that I would like to use later for the form (not
directly after I've run the code, so I can't just use the 'where' condition
in the 'open form' method). How would I go about ...

I am using the SendObject method to send an email to a "resource" letting
them know that they have just been assigned to a task. This works great but
I'm curious to know whether I can turn off the warning that pops up warning
the user that the system is trying to automatically ...