I have a combo box on a sub form that displays 3 rows of data; device
company, device model, device model number.
In the underlying table (tblDevices) I want to store the key field
fldDeviceNo, which I am able to do just fine. Problem is, after choosing an

I want for a msg box to come up with the msg below if text box is locked.
Please advise on the correct syntax as I am unable to figure it out.
Thanks
Private Sub cmdSet_Click()

Is it possible to change the formatting of a third column in a 4-
column combo box from 20051965 to 20/05/1965, just to make recognition
easier?
20051965 is a date value, and any format to make it easier to read

I am trying to join two strings, an ASP session ID, a field entered into a
tracking form, with a hard-coded address to a data-dump page. The http
address is correct, because cutting and pasting it into a browser's address
bar opens the page. However, clicking the form's ...

I am making a db to handle scoring in a school competition.   Each members of
the group gets a score for completing a task, done in rapid sequence.   Then
the process is repeated in the same student order for a set of 20 tasks in
total.  The score tracking must be done very ...

Using Office 2003 and Windows XP;
I have a subform on a main form. The subform is in datasheet view.
Is there a way to add a character or an image to the record selector buttons
of the subform in datasheet view? That is, the square grey button at the

Showing multiple interactions for multiple contacts from a single
company
I am trying to create a form that will show all the interactions with
all contacts for a particular company.

I and adding to a table data which contains the following:
- a  text field on the calling form
- the value for (2) checkboxes
- an hyperlink entry from another table, based on the value of  (2) fields

What is the best code for the following:
I answer "No" in a field and then I would like it to automatically answer
"No" in 5 differrent fields in the same form and record?

Is there any way to tell access to have the add new record cell of a data
sheet to always be at the top of the sheet as opposed to the bottom.  In
other words, to allways add a new record at the top of the data sheet.
Something like this;

=DateDiff("yyyy", [Birthdate], Now())+ Int( Format(now(), "mmdd") < Format(
[Birthdate], "mmdd") )
I want to modify this code to show months and years
anyone help please.

I have a continuous form called FORM1 with
in the On Click event of the detail section
DoCmd.OpenForm "FORM2", acNormal, , "([fieldid] =" & [fieldid] & ")",
acFormEdit, acWindowNormal, Me.Name

In a continuous form, I have fields memAction and dtmComplete. I do not want
users to enter a completion date if the memAction field is null. So I want
the date field initially hidden for each record, then displayed permanently
by record when the memo field is not null.  I have ...

I would like to write a bit of code into a form that counts the number of
folders in the "D:/1"directory like "* - Done" and like "*". I have found
lots of code that counts files but none that count the folders they reside in.
Can anyone suggest anything?

I posted a few days ago with an issue updating on a form.  The original post
and reply are below.
It worked perfectly while I had a message box popup after the "end with "
statement (so I could see it stepping through.)