Is there any capability to match data input with a pattern in VB code? I want
to compare user input with a pattern and return a match or not. I do not want
to do this via an input mask on a form.

A client wants to change the color scheme for 50+ forms.
1) Anyone know of an already existing tool available to assist with this
before I try to create my own? [ Cause I sure ain't about to do it all
manually:-) ]

I asked this on anoter board:
If I have 2 list boxes, one that contains part numbers and one that contains
reasons why that part may be defective, how to do make it to where the list
given in the "reason" list box changes based on the part number selected in

    I have a section of code that returns a string of group names
from a user controlled criteria form.  I want to pass this string to a
query and use it to limit the records returned to only those groups.
the code works great, at least in the immediate window but when I put

I am using the following code:
Private Sub DeleteRecord_Click()
Dim intResponse As String
intResponse = MsgBox("Do you wish to delete this record?", vbYesNo, "Delete

I'm having problems with an idle user detect for.
I created an unbound blank form and set the form properties to:
On Timer.... [Event Procedure]
Timer Interval....1000

In Access 2007, I have a combo box that I perform a requery on based on the
on change event of another combo box.  Suddenly I started receiving the error
message Return without gosub error 3 when I clicked the drop down triggering
the event.  When I go to the debugger the code ...

The object doesn't contain the Automation object CAR.
Private Sub cmbxEmailCarRequest_Click()
Dim stDocName As String
   stDocName = "CarRequest.Email Car Request"

I am trying to use a query that is produced from user defined variables to
populate one field in the table. One the query is made it displays in a list
box and I would like the user to be able to select a record (which displays
multiple fields) and then to pull the reference from ...

So Then I Have a Combo List Box thats have a selectable values, to
select from, unbound of course,
I Select the required value then i click on a button which opens
another form which shows all related records that match the value in

I currently have a button with the following click event (which works
fine):
Private Sub Labor_Vendors_Form_Click()
On Error GoTo Err_Labor_Vendors_Form_Click

Is there a quick way to turn off a listbox selection? This is a listbox that
allows only one selection.

I have a bound data entry form that opens up blank (to a new record).  On
this form, I have 6 command buttons (add, undo, find, edit, delete, save).  I
do not want the user to be able to enter any data into the blank form fields
until he clicks one of these command buttons.  How ...

Is there a way to have an If statement compare against a few values
instead of just one? I need to convert some strings to convert some
reserved characters (& < > " and '). I would like to have an if
statement that checks for all of them... something like SQL's In

Hi
Keep getting a type mismatch error with this code. I have DAO as a reference,
but not ADO.
Private Sub cmdCreateQuery_Click()