I've read through some of the post here on changing to upper case, and I
cannot figure out how to apply it....
If the user enters a licence plate of 1553hs, I want to change it to 1553HS.
This would also apply to avd123, being changed to AVD123.

I use a form to filter a rptinventory.
I have 5 filter comboboxs and the only one giving me trouble is the cboprice.
here is my setup for my formats for my fields in my tbl, frm, and rpt
tblinventory

Attempting to add combobox item not in list. Code. used worked in earlier
versions. Using:   Set DB=DBENGINE.Workspaces(0).Databases(0).  Set
RS=DB.Openrecordset("tablename"). The last statement issues a type mismatch
error (error=13), therefore, not getting to update tablename ...

I have a form filter that I use to filter a report on the fly.
I can enter my search criteria (7 combobox's), the Filter is based on my
rptinventory, which in turn is based on my qryinventory.
When I enter a filter criteria in my combobox and click the apply filter

I need to store data in one field of a specific record by assigning it in
VB.  How would I do this? I am using Access 2002.
Thanks,

As I've understood the "itemsselected"-collection of a multiselect listbox
is read only is that correct?
I'd like to be able to store the selection for later use, say in a small
string like 1,4,7,11,12 indicating what values were selected.

i have a form called "Concomitant Medications" which has a PK comprised of
"Patient Number" and "Med Number" in the underlying table of my a2k mdb file.
Med number (MN) is automatically incremented for any given patient number
(PN) when a new medication is entered by the user.

I have the the code below for opening a form with link  criteria.
need to open the form as read only..how?
Mattias
Private Sub Form_Open(Cancel As Integer)

Hello All...
I have a combo box that I use for a search feature on form for a field
'size' from form orders.
I want the combo box to just show one value for each of size rather that

I am using Pendragon Forms to put my access database on the palm, this
program uses a timestamp to limit hte record on the palm to the last 28 days.
I need a code to chagne the timestamp to the current date and time in
several tables which have the patient i want on the palm.  ...

I'm using Sql 2000 and Access 2002.
I have a Maintenance database that has a button when clicked sends a report
as a e-mail attachemnt.
The problem I'm having is if someone uses the database that their e-mail

I have a front end database on multiple machines sharing a back end
database.  In my form on the front end, I would do a DLookUp to verify a
 variable was in a table, then display various forms.  The recordsource
for these forms are simple queries into the back end data.

tblEmployeeProfile    as EP
tblApplicationList  as AL
tblEmployeeAssignedApplications  as EAA
I have a list of 125 different applications that need to be associated with

From Access 97 form, how do I establish a TCP/IP connection and receive
TCP/IP messages from a TCP/IP Server? If not, any alternative?

i'm having some problems with this code.  i'm trying to see if a subform is
dirty from another subform in the same form.
here is the code
If Forms!ProctorForm!ProctorSbfrm1.Form.Dirty = True Then