How do I limit the character types entered in a textbox?
Say, I want to accept as valid characters numbers, letters and '-'
only.
Could that be limited in the table itself?

MS ACCESS 2003 on XP PRO.
I have a pair of list box?  on a form that displays fuel cards.  one table
shows what fuel cards are in my inventory and unassigned, and the other shows
what fuel card are currently assigned to that vehicle.

I have a function in Access 2000 which is called by F6 as follows:
Public Function BonaFideFormation()
Forms![Enquiries]![Type] = "FORMB"
Forms![Enquiries]![Price] = "£77.97"

I am wanting to paste a set of comma deliminted data to a field and click a
button and then have that data imported to my attendees table.
The purpose is to accept email registrations and click and drag the data in
the email to a text box. I tried doing it to a CSV file and then ...

I have a database with a form called "Workorders". We send technicians out to
customers to perform service based on the created workorders. Sometimes the
technician return notes (i.e missing 1 screw, replace at next service) for
the next technician to perform at the next service.

I put a button on an unbound form to reset several unbound fields to null.
The code below give me an error "Method or data member not found"
Dim ctl As Control
For Each ctl In Me.Controls

i have 2 problems with sending emails from access through outlook:
1. outlook reports that the email has not been sent even it in sent items
folder.
2. how can i format the email (font, color, align)?

Access 2003...
Creating a data entry form using a datagrid subform.
Data entry operators continually enter data for consecutive ranges and I
want to set default values to fields from the previous record. Every now and

I am moving from Access 2003 to Access 2007 front -end with a SQL Server
Express Back-end.  I have such a lasrge database with many complicated
functions I could not use any migrate process, it bombed out.  
I have found , through trial and error, many of the functions I need to

I had an input form taking the input from user and several queries did the
calculations. Based on the input data and the calculated results, I had to
create another table (originally it was in the Excel sheet, there were about
20 columns, and each time to run a batch calculation, ...

I have a table with two fields: minHgt and maxHgt each being long integer.
I am trying to write code to filter the form with the following syntax:
[minHgt] >= 5 AND [maxHgt] <= 6
When I run the filter I get a prompt (same as query prompt) window asking

I am trying to use the following strings in my form, but am getting nowhere
with all my attempts at trying to have them accepted by VBA.
Print #lngFN <StyleMap id="m_ylw-pushpin">
Print #lngFN <hotSpot x="20" y="2" xunits="pixels" yunits="pixels"/>

I am having a problem getting the button wizard to open the correct forms. I
have my main form (form 1) that is defined by a Unique Primary (ex. CaseID)
key and it is related in a one-to-many relationship to another form (form 2)
that has a primary key (StructureID) and a foreign ...

I have the following code on_exit of a form control to make sure there is a
part # entered before clicking on any other control on the form.  If I click
the close button while my cursor is in the Part control, the msg fires twice.
Is there a way that I can get it to only fire ...

I have a form to take the data from user (the recode source is input table)
and a button on the form to open a report. There are several sub-reports on
this report, and sub reports’ recode source from different queries which use
the input table as the source. When the user update ...