I have an Access table that is being manipulated as a recordset.  It is a
list of customer details basically.
I need to be able to add a Header row (strHeader variable) to the start of
the recordset, and a Footer row (strFooter variable) to the end.  The 2

i have built a SQL string (union query) that will pass to a recordset and i
want the string to be passed to a form.
the string is built because there are parameters the user will enter (Date,
location) which will query the records with these two parameters...

Each employee has a unique string that identifies them and it is the primary
key in the [tbl Employee]. When deleting this person becomes necessary I want
to capture this unique string (EID) and delete the record. However, I am
having some trouble with the syntax. When I run this ...

I have started a project where i am modifying an existing database. I am
still learning how to go about this database.
1. I am trying to find a table that is not in the table category. In the
form it is related to this table and when i click to find more details, here

I am creating a database in Access with 3 tables.  One table has an auto
number field,  but I need that same field in another table.  I need to create
a relationship between the 2 tables based on this field.
How do I copy the Auto Generated number from table a to table b?

I have the above error on the word "Open"?
Private Sub Command16_Click()
   Dim qdfCurr As DAO.QueryDef
   Dim strPrompt As String

I have several databases where I've set the "Compact on Close" option.  They
are big enough that the compact process takes a couple minutes.  Anybody know
an easy way, other than turning off that option altogether, to bypass the
compact when I'm doing some testing that involves ...

I have a form in which I have a list and a button. On clicking the button and
making a selection from the list box, it imports all the data corresponding
to the selection and transfers the records into a spreadsheet. This is the
code:

My code change the properties o a report and I want to save the report after
that.
Here is the code:
 DoCmd.OpenReport "ReportName", acViewDesign, , , acHidden

I have a purchase order form, when Items are received, they are 'posted';
   Dim db As DAO.Database
   Dim rs As DAO.Recordset
   Set db = CurrentDb

I have a personal data table that I linked to a forms table(refering to a
form that I can hand to people not an Access Form).  What I am trying to do
is pull three field names (last name, first name, and position) and make a
list of names with those three fields on a forms page.  ...

I have made an application with custom toolbars. When opening my application
I disable all standard toolbars and menu's so only my custom toolbars can be
viewed. My only problem is that the user still can rightclick on the menu or
toolbar on wich a popup menu apears to edit the ...

I have the code in my after update events for the fields I want to be yellow
when empty.  What I don't know how to do is make the code only color it for
the specific record on the continuous form that is empty.  Right now, it
colors all records' fields on the continous form if ...

We currently have a process that creates an excel spreadsheet in the
following manner:
If (intFileType = 3) Then 'Excel File
     Dim oXLApp As Excel.Application

Ok ... I used to have this but can't locate any of my own samples -- arghh!!!!
I need to link tables in Access to a SQL server without referencing a
prebuilt ODBC connection - with VBA code when the MDB file is first opened.
I have a table containing the tablenames (source & ...