I can't remember the simple test for alphanumeric in a field. I've seen it a
hundred times, but can't find it. I have a text field (it's the 'sheet name'
from an Excel spreadsheet...) that I need to verify contains only
alphanumeric characters. Quick method? (A2003)

I have a form with a subform that searches my main table and applies a filter.
I use the subform to allow the user to select a record in the filtered list
from the table.  Once selected I have several buttons on the main form.  Each
of these buttons saves the PK from the subform's ...

I have a combo box that I would like to use the arrow keys on my keyboard to
navigate through. The combo box is to select states. When I type in the first
letter I get for example Maine. I would like to be able to use my arrow keys
to move to another state for example Minnesota.

i have a split DB with security.
3 days ago it started giving me a 3033 error, "You do not have the necessary
permissions to use the (path to the Front End) object. Have your system
administrator or the person who created this object

I have one record that I would like to divide into any number of records
that the client chooses as long as it's not a negative number.  Everything
works fine except the check total part.  Lets say a check is $8.39 and you
want to end up with 4 checks or records in the end, each ...

Im new to Access, but heres what's going on:
I have a Spreadsheet with about 13 columns, each column a different
specification for offshore drilling rigs. So i have 13 different combo boxes.
I have set up a form with 13 combo boxes, each pertaining to a column in my

Some users might not have the vpn connected when they start my app...the
odbc timeouts for the passthrough queries on the main form take a long
time (20-30 secs each) to return a failed odbc connection error. Does
anyone know of a quick way to test for an ok odbc connection? So ...

I have been trying to figure this out and can't seem to find an answer by
searching at the moment.
I have two option groups on my main form. The first is "Person Type". I have
3 checkboxes in the option group. "PersonTypeFrame" is the frame name and

Is there any way to pass in the name of a function programmatically? I have
similar parameters for a couple of functions and would like to pass in the
function name to a statement such as:
UpdateAppointment=FunctionName("Appointment",lngAppointmentID)

Is there a way to make the background of a ListBox transparent?  It only
seems to work on the border.
-S

I need to open a form and filter the records to a specific "relative record
number" based on a randomly selected number.  I use Access 2000 and know how
to "Go To" a selected number, but I don't know how to filter records so I
only receive that record number.

I have a form that is the start-up form for my app. It has always operated
correctly and is used to set some security then open a Splash screen.
The app is designed to block the By-Pass key etc and then configure toolbars
and title bar etc making itselft ready for the user.

I need help opening a form that is automaticall parked on the first null
value of a select group of fields. I have tried:
DoCmd.OpenForm "frmActMapUpDte", acNormal, , "IsNull(JVID)", acFormEdit,
acWindowNormal

have a continuos form with a command button that I would like the caption of
that command button to change depending on the transaction type of the record.
For example, if the first record displayed is transaction type "123" then
the caption should be "display report for trans ...

I have following data
MyCode  MyValue
 A         1
 B         2