I have a table which stores SQL statements as strings.  I'm trying to filter
the table for a particular SQL string in VBA.
The code fails at: Set rst = db.OpenRecordset(strSQL).  I get Run-time
error: 3075.  The error message indicates that I'm missing an operator.

I am getting an error # 3219 Invalid operation when opening a connection. The
code is as follows:
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection

Using Microsoft Access 2003,
I would like to assign the current form's name to a variable.
So opening the VBA code for a particular form, at the top I want to
Dim strFormName as String

I have a table that has data based on 15 minute increments.  The table has an
ID field, a time field, and a total field.  I would like to identify the
highest total hour for the data which typical spans 12 hours.  How do I
create the loop to evaluate the total for four 15 minute ...

I'm using Access xp.
I'm racking my brain over this...I have an Access mdb front-end with a SQL
2005 table linked in via ODBC.
But when I run the following code (this is just a snippet of the

My thanks to Marshall for his patience with me in trying to code a database
to check for the presence of the lock file before opening. His suggestion was
to attach the following to the open event of an unbound form that opens at
startup:

I currently have a listbox that gets its list information from a constant.
eg
in a module:
Public Const GeneralList = "'K8','Jet4','Ch900','N47'"

I have a for next loop that I thought should work.  Basically am setting
certain fields to visible based on a number from a combo box on another form.
What I can't figure out is how to set it up so that I can use the string I
create as part of the me. .visible command.

in Access 2003, I'm trying to "conditionally" concatenate strings. It's been
my understanding that the "+" symbol does the job. This is what I'm trying to
do:
       If InStr(1, strInput, "A", vbTextCompare) > 0 Then _

I have a very substantial and complex Access application that has been
developed over about 5 years.   Currently we are trying to make it work in
Access 2003 with SP3.  One of the problems I have encountered is a Reserve
Error 2950 pops up when a user clicks on a button that ...

Hi.  I'm an ASP.NET developer who's trying to work with a Microsoft Access
project.  The access .mdb file is 225 meg, and it's a hugh database.
Whenever I set a breakpoint in the code, it never hits.  This occurs every
time I insert a breakpoint.  I verify that the code executes ...

I am very new to VBA and would like to know if there is a way to have a
function return the number of week days in a given month for then entire
year?
I have supervisors who are required to make rounds of their assignments on a

I have a form with one selection criteria and also one with two selections
criteria to filter the results. The one selection criteria worked well, but
somehow the two criteria selection is not filtering. Here is a sample code of
one selection.

OK so why do I get a Type mismatch on the openform line?
Private Sub butOpenForm_Click()
Dim stData As String
Dim stWhere As String

I have a form with several fields that can be filtered. I would like to put
in a VBA in ON OPEN or ON LOAD, so if any field is filtered (or if they have
the same records), then disabled that field or change the background color of
that filtered field?