I have a table that contains an AUTONumber ID field.  Some records were
deleted from the table inadvertantly.  I would like to re-add these records
preserving their original Auto ID number.  Is this possible?  I do not want
to disturb any other records numbers in the process.

I am working with data collected automatically.  When the sensor collecting
the data is not working it displays really large numbers. I need to get an
average of the data.
I am trying to first eliminate the really large numbers then get an average

Does Access 2007 have a command to sort an array the user creates?
Would you provide an example of the syntax?

I have a form that I am using to append a memo field.  The user clicks a
button which executes the following:
DoCmd.SetWarnings False
DoCmd.OpenQuery "AppECNItem"

This is a part of one public function made with Access 2003
Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.CreateTextFile("d:Posdb.xml", True)
a.WriteLine ([Forms]![Tabelle1].[FirstLine])

I have an access database with a link table, which is linked to an excel
spreadsheet which is saved by users on daily basis with new date. I would
like to update the link table to the latest spreadsheet through code. The
code I have works for OpenFileDialog, but I need some ...

a long time ago I wrote an access program containing a visual basic
module, using access 2000.
This program I used for many years without altering any code, but now
suddenly I get the message that a library is missing. The debugger

I have been creating Access databases for about 10 years.  A few days ago I
had a reason to use the Internet Transfer Control (available in the Office XL
developer Edition) which worked just fine in an Access form.  The only
problem is the application that I put it in is not a ...

I'm trying to archive a table my moving it to another database and
then adding the current date to the end of it by using the code shown
below.
The table in the current database is "tbl_A20_AcctStatusCurrMo"

I have a table in Access that contains the recipients name, email address and
a check box.  Does anybody know how to send an automatic email (after the
user clicks a command button) to all recipients that have their corresponding
checkbox checked with a message entered from ...

I am trying to retrieve a the contents of the value field for a textbox and
it's been driving me crazy! I have tried every combination imaginable but
can't seem to get the magic incantation of "." and or "!". I tried
me.controlname.value and that gave me an error. I saw alot of ...

I need some help with VBA
1:what I need to do is import a spreadsheet from excel and place it into a
table already named.
2:while it is importing I would like for it to capture the file name and

I don't want the users of my database to have to run queries so I would like
to have it run with a command button.  I have the select portion of the query
running fine with the command button...the select is [What school would you
like to update, enter the school number].....but ...

Is there a way to use SendKeys while the computer screen is locked.
I have an automated process that works fine when i'm sitting in from of my
desk, but I need it to run when I'm not at my desk and it doesn't work when
the screensaver is on or the computer is locked.   Is there ...

I have a FE/BE db where the BE is part of MKS (a Documentation control
software.)  I want to be able to check whether or not the BE is set to read-
only and then alert the user that they need to check out the file before
proceeding.