I recently went to synch my database to the network. When this happened, my
computer shutdown. When I restarted the computer and went to reopen my
database, I received an error that my database is in an unexpected state. It
states that the database has been converted from a prior ...

I have ODBC Connection to db and I'm trying to insert fldpatacct into a table
dbo_Anesth where the value is equal to the value on a form.  The reason I do
it this way is that I look at several other fields before deciding to actuall
insert the record.    

Could someone give me an examble of how to use a VBF to create the next
highest number in the database. I can not use Auto Number as the table
sometimes needs to exported and then imported back in

I need to send information from a database to a website.  I am using "Run
App" to call IE, but I can't seem to get the data to show up from the table
into the php page.  
This is what I have done so far:

Please see post on internet shortcuts for background, 11/3/2006 10:10 AM PST.
New problem.
Internet shortcuts have a modified date, as well as a date created and a
date accessed. I need to be able to retrieve the modified date. I am assuming

I am converting an MDB (which had links to existing tables) to an ADP. I did
not upsize -- I just created the ADP.
I am concerned about leaving too many footprints in the back-end of a major
(3rd-party) application, as all I want to do is run SELECT queries.

I've writen the following SQL in Excel using DAO:
Transform Count(ComplaintNo)
Select LevelOfComplaint
From tblComplaints

I'm writing a function to provide the time to close for help desk
tickets. There are 6 different departments to take into consideration,
therefore my code looks like this:
Public Function TimeToClose(Dept, LanStatus, TechStatus_1,

Is it possible to display multiple instances of an access form and if so how
is this done?
John.

How can I re-write the below code to allow users to use wildcards in the
SearchPart field.  They'd like to be able to type S* and return all
SearchParts that start with S or type St* and return all SearchParts that
start with St.  I'm not sure how to write it.  Thanks.

I am trying to enumerate the references linked in Outlook VBA with
mixed results.  Sometimes I get an error Illegal Function Call (Error
7952).  I have just worked out that this error occurs if MS Access is
not open at the time.  If I open Access and just leave a blank window

How do I attach 2 documents in an email please, can i still use sendOgject
Thanks

Looking for a function or procedure to calculate work week based on Monday
as the first day of the week. For example Year (2006)
WW: 1
Date: 1/2/06-1/8/06

I'm developing an application that will be used both in Europe and in US.
The application will collect - among many other data - medicatons dosage.
Those data will be used in many procedure in the code behind the application
itself.

I'm using automation to run some Excel vba, then using the
transferspreadsheet method in Access to import data from Excel.  The
transferspreasheet method results in Excel staying in memory after the
procedure completes.  (Tests establish this; it is not due to the automation