What is the syntax to insert a new record into a Table. The table has only
two fields.
The first field should be a value from a textbox called textbox1 and the
second should be the value "Done"

Hello I am trying to create and populate a recordset using ADO. Here is my
code:
Dim dbcurr As ADODB.Connection
Dim rstCurr As ADODB.Recordset

I have a client that has been running some code I put together to open up
outlook and set up a new message. Up until today it has worked fine on all
the machines in their office (various OS's).  Today, their IT guy installed
XP SP2 on two of the XP machines.  Now the line:

My computer recently totally crashed.  I had to reload everything, but I am
missing the security code to run my Microsoft 2000, what can I do?

Coding to sent emails automatically;  database holds trigger date; email id;
work date; workorder information and work instructions.
After reviewing help for email confusion has set in, can someone offer
additional insight?

this code collects entries from a listbox and sends it to a query.  I get a
run-time error 2001 You cancelled the previous operation.   Debug references
line  
DoCmd.OpenQuery "qryPayroll_MultiSelect"

Here is a snippet of code:
Dim dtCheckDate As Date 'Changed to Public to allow use in report
Dim rsCheckDate ' As Recordset
Dim strSponsor As String

In object Browser is there any documentation of the description of members of
a Class and what exactly the members function is ?
Does microsoft or someone else provide all function descriptions somewhere ??

I am trying to use this code to select a file
http://www.mvps.org/access/api/api0001.htm
when I try to run it I get "Only comments may appear after end sub, end function or end property" Debug lights up the function declaration following the "end Type" statement. Can someone help.

Hi,
Hoping someone can help with this problem:
From within Access XP, I'm trying to open an Explorer window to a particular
network folder and ensure that the new Explorer window moves in front of all

I need help searching for a record in a table.
The table:  Patient Registry
The field: SubjectNum
I have  a text box where the number is to be input I just don't know how to

I keep getting a data conversion error with the following code:
Set tmpRecset = db.CreateQueryDef("")
  With tmpRecset
      .SQL = "SELECT * FROM tblCustXRef WHERE tblCustXRef!ID = ID"

I have an unbound form which I use to search too see if a record already
exists. I have set up a message box which displays when this is the case.
Message box currently reads "Record Found"
How can I get it to show the record it has found in the body of the message

I want to be able to take a lot code and break it up into 50 seperate items
refferencing that lot code number. Then adding a new lot code and do it all
again. Is this possible? Thanks for any information on the subject.

Hello I am trying to create and populate a recordset using ADO. Here is my
code:
Dim dbcurr As ADODB.Connection
Dim rstCurr As ADODB.Recordset