Hi, I am designing a form that my client would like the date and time
automatically recorded in a field and stored so that when they refer back it
shows when the record was done. The 'NOW' function only shows the current
date & time and keeps updating. Is there a way of putting ...

Hey all....
I am getting a dialogue that says
"None of the field names you pasted onto the Clipboard match the field names
on the form."

I am trying to set the tab index values for my form controls. The
problem is that even though I enter a certain value for a particular
tab index, it is not saved. It seems to be automatically reassigned.
I have tried starting from the end and assigning a high number to

I am embarrassed to say I have never been able to get an each, next to
work...probably due to my learn by problem method instead of an organized
class but I am hoping that by conquering this one, I will finally get it.
I need to send an email to each of the people returned by an ...

I have an attachment field named Documents, in a table.  On the field list
of the form it shows Documents and three other objects, Documents.FileData,
Documents.FileName, and Documents.FileType.
When I dragged them onto the form, Documents.FileData is identified as an

I have a form with the control source
=[txtPr]*[txtImpact]/100
When I tab to another field it calculates correctl. What we need is when a
user enters a value in  the field the value above automatically change

I have a frmreferb form and frmrefurbsub form.
the sub form and the following field Supplier - Product - Product Desc -
Serial Number
I want to be able to click on the Supplier List Box and the click on the

After trying to use conditional formatting (which didn't work btw) now
the Conditional Formatting button in the ribbon isn't available or disabled.
I tried Compact and Repair but it didn't work.
Any ideas?

I have a Master form with a master record, when I open the form, i am unable
to edit the data on that form until i move to the next record. I also have
lots of other forms on other tabs, some linked, some unlinked to the master
form, I have the same problem with all these other ...

I have a subform that is in datasheet format. There are 3 controls
ActionDate (Source Date()), ActionTime (Source Time()),  and ActionLog (Text
field). All 3 fields are locked and have this code in onCurrent event
Private Sub Form_Current()

I use a form to input the data into the table.  From time to time, I need to
create a duplicate record from previous records or just completed new
record.  I saw the previous articles here but most of them to copy the last
record to a new record.  However, I need to highlight the ...

I am trying to find a template for birth certificates.  I am trying to
translate a Spanish birth certificate into english, and if I can find a form
that all I have to do is put in the required information, e.g. name, place of
birth, parents name, date of birth, etc, then it would ...

Is it possible to highlight certain items in a list box? Is it even
possible to highlight items in a list box?
The list box is populated through a procedure. Upon update I would
like items that meet a certain criteria to be highlighted.

I have two forms - FORMA and FORMB - that I have not linked.   I want to
place a command button on FORMB that causes it to set a control in FORM B to
a person's id currently showing in FORMA.  Or to automatically set FORM B to
show a record in FORMB related to the record in FORMA ...

Shouldn't this conditional formatting work? (CF
applied to a text box on a form.)
1st cond:    Expression is --- [Missing]=True     Red
2nd cond:  Expression is --- [Deceased]=True  Blue