MS Access and FileMaker...

Error handling

Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Feb 2008

Posts: 198

Reputation: dinilkarun is an unknown quantity at this point

Solved Threads: 0

dinilkarun dinilkarun is offline

Offline

Junior Poster

Error handling

Nov 17th, 2008

On not filling a text box of a field that is madatory in the database i want to throw a error message to user and set the focus to that particular Text box
Please help me in setting focus to that particulat text box.

Help with Code Tags

(Toggle Plain Text)

Private Sub Form_Error(DataErr As Integer, Response As Integer)
Select Case DataErr
Case 3314
    
    MsgBox "A required field is blank.", vbCritical
    Response = acDataErrContinue
End Select
End Sub

Regards
Jagadeep Reddy

Last edited by peter_budo; Nov 18th, 2008 at 6:59 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Aug 2007

Posts: 160

Reputation: kb.net is an unknown quantity at this point

Solved Threads: 26

kb.net

Offline

Junior Poster

Re: Error handling

Nov 20th, 2008

Hi,
If you are using access you have to include the code in the before_update event of the text box.

It is never about the number of languages you know, you either have the logic of programming or you don't ...

Some of the codes I post are collected from different sites during the past couple of years, so I would like to thank them for their help and for enabling me to help.