I'm trying to get the numbers of seconds between a time and either midnight,
whether my time is before or after midnight.  (For jobs that run from one day to
the next.  (Or beyond.))  Here's what I'm trying to use:
   Global StartDate As Date, StopDate As Variant

I wanted to set up a click command to delete a record that is comprised of 3
different tables.
The click command would be on form1 which is linked to table1
subforms within form1 are sbfrm2 which is linked to table2 and sbfrm3 linked

How can I tell if an instance of Word is already running from Access so that
I can issue a message to the user to close Word before they run my report?
Thanks
Jerry

Is it possible to pass a variable when using the ALTER Table and UPDATE
commands?  I've used the code below, which works when I specify the actual
table name and number for days, but states it can't find the table when I use
a variable.  I'm currently using Access 97.  Is there a ...

Hello. I have several databases that update files on a daily basis. The
problem is that some users don't close the files when they get out of office
and the update process fails.
How can i programmatically check if the file to be updated is open and if

I am using the following code to open a database located on another computer
on the network.
Private Sub Command6_Click()
Shell """c:\program files\microsoft office\office11\msaccess.exe"" " &

I am building a query that captures alot of info, to feed into another
database. However, the access db has the old ID and the new database has the
new ID. I need to convert 06-1606 to 200601606 (as an example). Any ideas?

I need help with the following set of information.  I am able to get what I
want from excel, but need to do it in Access.  IN Excel I used the if
statement in the subtotal field to create a conditional statement.  I need to
do the same in Access, but I think it will require a ...

I have planning a report display format. Actually, i would like my report to
display a data format like:-
1          6          11
2          7          12

I have many data files containing data from our old system.  I have 12 filenames
to deal with (1 file per table).  I have 5 cycles (we sell utilities) each
containing multiple [meter] books, except for the last (5), which has only 1
book.  Cycle 1 has 28 books, and the other 3 have ...

I am currently working in access, using a form, and I would like to create a
button which opens a specific spreadsheet in a specific excel workbook.  
Currently I am using the following code to open the workbook:
   Dim stAppName As String

Does anyone know how to retrieve the number of records to be deleted that is
displayed in the
You are about to delete N record(s).
message box? Preferably at the OnDelete event.

I am trying to retrieve a recordset from another microsoft database.  My
select statement is.....  
SELECT DISTINCT([CATEGORY]), MAX([FISCAL YEAR]), SUM([ACTUAL COST]) AS
ACTUAL_COST FROM MTB2001 GROUP BY [CATEGORY] HAVING [FISCAL YEAR]='FY05'

Guys, I'm looking to try to connect a table through a connection string in VBA.
Can you please point me at the function I should be using please, or drop me
a line of an example connection string.
Thanks in advance.

In Access VBA, what is the equivalent of Excel's VBA statement:
Application.ScreenUpdating = False ?
In Excel, this statement disables the flickering of the screen while the
application is working.