Validation and adding to a form

[Beany]

i need help!!!!!!!

Has any1 got examples of the following that i can view:

1) simple form field Validations

2) Adding to a database using a form with a adding button

??????

i just need a few examples so i can work from them.

Ur responses will be appreciated.

[nico5038]

Hi Beany, I have some samples at:
www.geocities.c om/nico5038
Especially the "Add" form of the "Datasheet with Filter samples" will show you how to check a form before saving the correct values.
Let me know or you need more.

Nic;o)

[missinglinq]

Here's a couple of generic field validation hacks. The Cancel = True places the cursor back into the offending field if the data entered isn't appropriate.

'Checks if a field has been left empty
Private Sub YourField_BeforeUpdate(Cancel As Integer)
  If IsNull(Me.YourField.Value) Then
     MsgBox "You Must Enter Data In This Field!!!"
     Cancel = True
   End If
End Sub 
 
'Checks to see if the value entered is Numeric
Private Sub YourField_BeforeUpdate(Cancel As Integer)
  If Not IsNumreic(Me.YourField.Value) Then
    MsgBox "You Must Enter Numbers Only In This Field!!!"
    Cancel = True
  End If
End Sub 
 
 

[Beany]

thanks peeps.......... .


but nico........... .. i cant open ur files, they are showing as read-only and ive got access 2003, and it wont open it!

[nico5038]

When opening for the first time in A2003 you need to accept the Conversion option.
Afterwards (when having it in ReadOnly mode) use the Database menu and select the "convert to" option to get an A2003 format.
You'll also have to open the Tools/References, when in VBA code, and uncheck the "Microsoft Active Data Objects" and check the "Microsoft DAO version #.##" library.

Nic;o)

[NeoPa]

Nic;0),

If, as I hope (I like your style), we are going to see more of you in these forums, you may want to know that currently, posting links won't work correctly on the original post.
An edited post will automatically be converted for you though.
To get around this use the [u r l] tags.
Format (lose the spaces) :
[u r l=actual link]Name to Show[/u r l]
or
[u r l]actual link[/u r l]

[nico5038]

Pleased to meet you and thanks for your kind words NeoPa :-)
Learning some new html tricks too, still trying to finding my way here, but it's getting easier by the post.

Nic;o)
(BTW this is my "tag" my real name is just Nico)