Re: required fields question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Steve Goodrich (stevegoodrich_at_btinternet.com)
Date: 03/19/05 

Date: Sat, 19 Mar 2005 19:01:43 +0000 (UTC)

Steve,
Many thanks for the info, works great,

One more question if I may - When the form is complete there is a command
button called "SUBMIT" which runs a simple macro that, Opens a message box
stating that the form has been completed correctly, the user clicks OK. It
then goes to a new record and sets the focus on the top field "first Name"
ready for the next entry.

If any of the fields that are set to IS NOT NULL have been missed, I get
the message that I have set in the validation text
which is what I want - but I also get two message boxes appear that I assume
are telling me that the macro "Sumbit" has not been executed.
The first error message reads "You can't go to the specified record set" I
click OK
The second Dialogue box Titled ACTION FAILED appears, the macro name
"Submit", Condition true, Action Name Go To record and Arguments ,,new,

Is there a way to Submit the record using the macro without getting the
second two error messages

The same way as when you just click on the record selector at the bottom of
the screen. i.e Validation text box appears, click OK and you are returned
to the form to enter the data in the missed field

Hope this maks sence

Many thanks
Steve

"Steve Schapel" <schapel@mvps.org.ns> wrote in message
news:Oj3qAoKLFHA.3500@TK2MSFTNGP14.phx.gbl...
> Steve
>
> Instead of setting the Required property of the field to Yes, set the
> Validation Rule property to...
> Is Not Null
> ... and then you can use the Validation Text property to personalise the
> message.
>
> --
> Steve Schapel, Microsoft Access MVP
>
> Steve Goodrich wrote:
> > Is it possible to have my own message appear when a required field is
> > missed, instead of the standard microsoft one (without using vb)
> >
> > using Access 97
> >
> > cheers
> >
> >

Relevant Pages

  • Re: Make form field required
    ... Steve, open your table in design view, and select the field. ... Instead of setting its Required property in the lower pane of table design, ... Validation Text: Oops: Ya need ta enter MyField. ...
    (microsoft.public.access.forms)
  • Running code on a drop down selection change
    ... I would like to know if it is possible to run a macro when a change in a data ... only when a user makes a selection in a data validation drop down. ... Steve ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: forward and backward slide transitions .. programming differen
    ... macro still doesn't fire. ... "Steve Rindsberg" wrote: ... AutoEvents is enabled within ppt but the event and/or macro is not firing. ... Note that the parameter passed to the event is the slide show window, ...
    (microsoft.public.office.developer.vba)
  • Re: run macro and get error: The command or action "Paste" isnt a
    ... Thank you, Steve, for all this great information. ... Regarding the macro, it seems to me ... > SSN and Lastname should absolutely not be getting put in multiple ... >> Action: RunCommand paste ...
    (microsoft.public.access.macros)
  • Re: Macro referencing data validation doesnt work
    ... I think you will need to use a macro that is fired by a userform, ... So you will need to add the validation to the macro code, ... Bob Greenblatt [MVP], Macintosh ...
    (microsoft.public.mac.office.excel)