Hello;
I am working on Historical Crude Oil Monthly-Spread Analysis.
The spread is between the front month and 2 months out.  Example:  Today's
trade date is 2-18-06.  I am trading the spread between March/May.

Does anyone have a VBA script that they would be willing to share that
appends all fields from Table A into Table B without using Access Append
Queries? These tables will always have the same fields and structures.
I am trying to get this accomplished with wildcards and without ...

I have a template.xls file that contains one "form" (actually a range, A1:
AE28, formatted for my data) for displaying store data. This "form" includes
8 small charts that have datasources on the same range as the charts. I can
easily determine the datasource range for each of the 8 ...

I'm having trouble getting the necessary columns out of a linked table into a
query.  Every day I have a linked table showing data by month (with numeric
column headers 1,2,3....) starting in the current month (with current month
column header always listed as 1).  The problem is ...

At my work users with ACCES runtime installed are using ACCESS 2002 DB on
server. Just recently they are getting following message when starting an
Access 2002 database on their PC.
"Your database or project contains a missing or broken reference to the file

I can't figure it out.  Once I have rst set as the query, how do I get the
data out of it?
strSQL = "SELECT DISTINCT tblContacts.CompanyName " & vbCrLf & _
"FROM tblContacts;"

Does Office 2007 have the same capabiity to be set up as 2003. Meaning can i
have the same "Start up" options as 2003. 2003 would let me have the option
to start the program with a form as the start up page with no table or query
or other forms showing. if this is an option for ...

I have a treeview control with levels (level1 and level2).  I'm trying to add
a popup menu when I right click on a level2 node.  here is the code:
Private Sub ShowPopup(SourceType As String, SourceText As String, SourceNode
As Node)

Could someone take a look at this code and maybe locate why I'm getting error
on the rst.movenext command? This is from the Law Track example and it is
supposed to give the user an error if a duplicate contact is entered... I
just get an error message saying it's too complex to ...

Is there a way to allow users select the fields that they want in a report
via a form check boxes or radio buttons?
If this is possible, how would the code look like, and where would the code
go under - on Open? and what properties would this involve?

I set up a short cut in windows and specified the following information;
(1) In the short cut target I typed; "\\ftwdoors\JSFITCoord\acWKspace\F-35
Dash Board\Tactical DashBoard.mdb" / runtime
(2) In the Start in I typed:"\\ftwdoors\JSFITCoord\acWKspace\F-35 Dash Board"

I am trying to create a copy of a report in word after displaying it on the
screen. After saving another form is then displayed. It is left to the user
to decide where to save the word document. The following code works fine if
the user selects ok on the form after selecting ...

I have an Access/SQL Server application that uses ODBC link tables to
communicate between the Access cllients and SQL Server.  I was wondering if
Access used connection pooling by default, or if I could affect it by adding
a Min Pool Size item to the connection string.

Hello Smart People!
This one is driving me nuts.  After doing quite a bit of research, I cannot
find the answer that I need, so I am posting...
For a new record on frm1 I am trying to make the label (lblTest) for a text

I have a table that contains users' Passwords and Role codes
Users need to access certain forms depending on the Role Code entered in
txtRCode textbox.
For example: