Hi all, i am a beginner at this and would like to know if it is possible
to freeze a record on exit. In other words the user cannot go back and
change his record.
Les Stout

I have two combo boxes: Parameter and SensorComponent.
When Parameter is changed, I want SensorComponent to requery &
dropdown.
It does requery & dropdown, but it drops down for only an instant.

I have an excel worksheet that i am beginnning to import in to access
for anaysis, the person who designed the worksheet has used input forms
to gather the data unfortunlately  the date field has been sesigned as
a text field (dd/mm/yyyy)

I want to do a quick check of a group of textboxes only to see if they
contain anything.
I tried this code but it appears to go from box to box based on the
boxes time of creation.

I have a option group M F and is stored into a field called gender.
I also have a 2 text boxes on a form one called male one called female
What i want to do is when the user select m from the option group it
will display an X in in the text box called male if user selects F from

I have an A97 app that automatically sends eMail using
OutLook Express. Each installation requires the user to
reconfigure Outlook Express to avoid prompts waiting for
them to authorize or deny the email SEND attempts.

I need a procedure for a DeliveryCharge field value of $0, the
MaxDistance field value must equal 0. if the DelivelryChare field value
is invalid, then i'm to display the appropriate message, cancel the
event, undo the change, and move the focus to the DeliveryCharge field

is there a way to add a class property an run-time?
If so, how?
any code samples?

My form/subform combination that allows user to display 'ColorSet'
records, move to other records via a selector, to add,delete, and
edit them, and to manage the related 'Color' records from the subform
is close to completion, but I still need help...

I'm developing an application that runs on laptops that periodically
connect to network.  I am collecting data in local tables within the
MDB.  I want to recognize the occasional network connection so I can
upload the collected data to SQL server and retrieve updated look-up

The following SQL does as I intend, but ...
SELECT offender_id, off_name, inv_ppo_id,
add_note, add_zip_id, it_name AS Purpose
FROM (offender INNER JOIN (investigation

I need to send faxes from Access to some companies that doesn't have a
computer (!) or some that prefer receiving a fax.
On Friday-evening a routine should send a ToDo-list for the next week to all
the contractants. Most as email but some as fax.

I have an access database full with data written in hebrew charecters.
any query which uses a hebrew charecter field for the ORDER BY clause
is not sorted properly.
The database is sitting in a hosting company server and is the standard

Here is what we need to do.   On a Linux Apache server,  we need to
write PHP or Perl scripts to pull the data directly from the Access
database and display extracted data on the web.  Anybody have done that
and would like to share how?

Dear reader,
The following code delivers a wild card in the result of the query.
But the ORDER BY is not longer working.
SELECT Dis_ID, [Dis_No]&"  "& [Dis_Description] As Discipline