[AccessD] A2K: Stop User from oving to new record

John W. Colby jwcolby at colbyconsulting.com
Mon Apr 5 15:08:37 CDT 2004


Lambert,

>If cmbOffence & "" = "" Then

This is the kind of thing that you should add an explanation of why it works
in your email.  Less experienced developers might not understand what is
going on.  Further the explanation of why it works would add to their
understanding of empty strings and nulls.

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Heenan,
Lambert
Sent: Monday, April 05, 2004 11:20 AM
To: 'Access Developers discussion and problem solving'
Cc: 'd.dick at uws.edu.au'
Subject: RE: [AccessD] A2K: Stop User from oving to new record


"no joy" - what did not work? It's totally routine to do this kind of thing
in the BeforeUpdate event (but what you might have missed is that you also
need to do it in the BeforeInsert event too - that way you can validate NEW
records as well as existing ones that get edited.)

No need to mess with table validation rules and trapping the error. Just do
your own validation in the above two events.

BTW here's a way to check for nulls and empty string in one step, and it's a
tad easier to read (IMHO).

Instead of ...

If IsNull(Me.cmbOffence) Or Me.cmbOffence = "" Then

use...

If cmbOffence & "" = "" Then


> -----Original Message-----
> From:	Darren DICK [SMTP:d.dick at uws.edu.au]
> Sent:	Sunday, April 04, 2004 9:29 PM
> To:	Access Developers discussion and problem solving
> Subject:	Re: [AccessD] A2K: Stop User from oving to new record
>
> Hi Bryan
> I did that no joy eg.
>
> Private Sub Form_BeforeUpdate(Cancel As Integer)
>
> If IsNull(Me.cmbOffence) Or Me.cmbOffence = "" Then
>     MsgBox "Enter an offence"
>     Cancel = True
> End If
>
> End Sub
>
> What I need to do is somehow test if the user is on a new fresh record or
> has left th previous record with unfilled combos. Of
> course I can do it on the lost and got focus event.Thats fine whilst I am
> in the record
> EG record 5 has no offence recorded
> User goes to record 6 How do i alert the user that record 5 has a missing
> value then go back to that record?
>
>
> ----- Original Message -----
> From: "Bryan Carbonnell" <carbonnb at sympatico.ca>
> To: "Access Developers discussion and problemsolving"
> <accessd at databaseadvisors.com>
> Sent: Monday, April 05, 2004 10:25 AM
> Subject: Re: [AccessD] A2K: Stop User from oving to new record
>
>
> > On 5 Apr 2004 at 10:08, Darren DICK wrote:
> >
> > >  I have a simple subform with 4 fields on it
> > > ID (PK),  txtDateOfOccurence, cboClientName, cboOffence
> > >
> > > How can I tell if the user goes to a new record and they have not
> > > completed ALL fields in the previous record How do I alert them and
> > > then direct them back to the previous record?
> >
> > Use the before update event of the form. Check to make sure they
> > entered a vale and if not set Cancel = true in the event. That should
> > prevent the record from being saved and keep the sub form on the
> > "unfinished" record
> >
> > --
> > Bryan Carbonnell - carbonnb at sympatico.ca
> > The trouble with doing something right the first time is that nobody
> > appreciates how difficult it is.
> >
> >
> > --
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list