I have a table that SSN is the primary key.  On my form i am trying to make
it so that after entering a social into the program it immediately gives me
an error message since we do not want duplicate records.  Do i need to use an
after update function or a validation rule?  Any ...

Acc2007
I have a main form with TabCtl2 with pages and cboRecord to choose records.
PageA has a SubF_01 wtih txtDtBorn to write date born and another txtAge to
calc Age.

I cannot figure out how to resize & move controls?. I was told to use the
"Properties dialog"....which I presume is the "Properties sheet"?....but no
matter what I do with it, anything I change, changes all the controls the
same? What am I missing?...Anothe said that the controls ...

Can I implement the Access 2007 split form in Access 2003? Or simulate it?

I have a split database with a frontend and backend.
Users would like to archive the current data that is in the backend and  
start fresh for a new year.  But would like to be able to click a button  
to view the old data and switch back again.  (Or perhaps a combo box with  

I have a control on a form.  The name of the control is STATUS.  
If the data in STATUS shows to be “Inactive” I would like a label to be
visible.  
The name of the label in question is lblInactive.  

I am trying to use a switch function on my form that reads as follows...
=Switch([Field 1]="1","Yes",[Field 1]="2","No")
However, the results to this function always read...
#Error

I have a form that enters a number into my table. I want the database to tell
me if the number I am entering is a duplicate. Right now if I duplicate the
number it will let me continue but it does not save the latest information.

When I am going thru my records in a form, I get to the end of the
records(the last record) and usually it would have a blank primary key. But
not anymore, it creates a new number since the primary key is AutoNumber. I
created a VB procedure in the On Current property, would that ...

I want to input my song times into my subform and have them automatically
calculated in a main form control. i.e. type 3:50 in one song and 3:50 in
another song and have them both add up to 7:00 on the main form.
Is there anyone who could help me with this?

I have a form that I have two fields I want to show or hide based on the
value in another field.  Previously I had one field that worked OK.  Recently
I added another field but it is not working.  
I have the following in an event but in the Private Sub Form_Current() I am

I have a set of fields on a form that are bound(using Control Source
property) to a table. Everytime I close the form by clicking X, it always add
new row to the table. Is there a way to avoid this without clearing out
Control Source property ?

I'm working on what should be a really simple supplier audit database
and I thought I had set up the relationships OK until I started
trying
to create some forms for data entry and now I'm really stumped.

Please Tell Me How Can I Get The Type Of The Control In VB6
In Access We Use The Code
For Each Ctlr In Me.Controls
   msgbox Ctrl.ControlType

Hello NG,
is it possible to update code in forms and modules using a vba-routine
to replace f.e. everywhere where used, "SumOfDollars" with
"SumOfEuros"