RE: Pop-up reminder on Forms??

Tech-Archive recommends: Fix windows errors by optimizing your registry

lastly, I dont want to keep them stuck on this record (as this function does
until they enter data into the 2 fields) - I simply want to alert them to the
fact that the two fields have not been populated...and then allow them to
move on if they wish.

There is a scenario where these elements may not be available...

Can you offer any advice on hiw I can do this?

Thanks again.

BTW, how do I mark a post as "Answered"?

M

"Ofer" wrote:

> No problem, just add the other line again
> Private Sub Form_BeforeUpdate(Cancel As Integer)
> If IsNull(Me.[Sales Alert Date]) Or IsNull(Me.Eligibles) Then
> MsgBox "Please check for valid entries in Sales Alert Date and Eligibles"
> cancel = true
> End If
> End Sub
> --
> If I answered your question, please mark it as an answer. That way, it will
> stay saved for a longer time, so other can benifit from it.
>
> Good luck
>
>
>
> "Monish" wrote:
>
> > This is awesome - thanks so much!!
> >
> > I do have one follow-up qn however: how can I let the user stay on this
> > record, review the 2 fields visually and then decide to continue on with
> > their action, either after entering data in these fields or not (as it may
> > not be available yet)?
> >
> > Currently, because I removed the one line from your code it simply goes to
> > the next record - this was per my earlier request of course, which I now wish
> > to reconsider...
> >
> > Sorry for the extra qns, but I really appreciate your help.
> >
> > M
> >
> > "Ofer" wrote:
> >
> > > What PIPELINE REPORT Stand for?
> > >
> > > Try this
> > > Private Sub Form_BeforeUpdate(Cancel As Integer)
> > > If IsNull(Me.[Sales Alert Date]) Or IsNull(Me.Eligibles) Then
> > > MsgBox "Please check for valid entries in Sales Alert Date and Eligibles"
> > > End If
> > > End Sub
> > >
> > > --
> > > If I answered your question, please mark it as an answer. That way, it will
> > > stay saved for a longer time, so other can benifit from it.
> > >
> > > Good luck
> > >
> > >
> > >
> > > "Monish" wrote:
> > >
> > > > It is giving me a Compile Error when I tried to test as the following:
> > > >
> > > > Private Sub Form_BeforeUpdate(Cancel As Integer)
> > > > If IsNull(PIPELINE REPORT.Sales Alert Date) Or IsNull(PIPELINE
> > > > REPORT.Eligibles) Then
> > > > MsgBox "Please check for valid entries in Sales Alert Date and Eligibles"
> > > > End If
> > > >
> > > > End Sub
> > > >
> > > > Any suggestions??
> > > >
> > > > M
> > > >
> > > > "Ofer" wrote:
> > > >
> > > > > For the first question, it will allow them but you need to remove the
> > > > > cancel = true
> > > > > Line in the code I provided you with
> > > > > ================================
> > > > > The Me stand for the current form
> > > > > Me.Field1name refer to the field Field1name in the current form.
> > > > > To have a loop that check the field you can try this
> > > > >
> > > > > Dim I as Integer
> > > > > For I = 1 To 15
> > > > > If IsNull(me("Fieldname" & I)) then
> > > > > msgbox "Not all data was entered"
> > > > > I = 15 ' To exit the loop
> > > > > End If
> > > > > Next I
> > > > > You can use this loop if all fields has the same name, with an extra number
> > > > > next to it.
> > > > > --
> > > > > If I answered your question, please mark it as an answer. That way, it will
> > > > > stay saved for a longer time, so other can benifit from it.
> > > > >
> > > > > Good luck
> > > > >
> > > > >
> > > > >
> > > > > "Monish" wrote:
> > > > >
> > > > > > Thanks for the guidance...I want to make sure of one thing however:
> > > > > >
> > > > > > I am trying to simply alert the user to the lack of data in certain fields.
> > > > > > I then want to allow them to hit OK and move to the next record if that was
> > > > > > their action (or close the form if that was their action)
> > > > > >
> > > > > > Will this allow them to do so?
> > > > > >
> > > > > > Also, an amateurish qn:
> > > > > > What is within the parentheses? Is me.Field1Name reflective of a field I
> > > > > > want to specify? And if so, can I simply keep adding to the string with
> > > > > > multiple fields ( I am looking at about 12-15 I wish to highlight in this
> > > > > > process)
> > > > > >
> > > > > > M
> > > > > >
> > > > > >
> > > > > > "Ofer" wrote:
> > > > > >
> > > > > > > You can use the before update event of the form, to check if specific fields
> > > > > > > were used.
> > > > > > >
> > > > > > > If IsNull(me.Field1Name) Or IsNull(Me.Field2Name) then
> > > > > > > msgbox "Fields 1 and 2 must be filled"
> > > > > > > cancel = True ' wont let the user move to the next record
> > > > > > > End if
> > > > > > > --
> > > > > > > If I answered your question, please mark it as an answer. That way, it will
> > > > > > > stay saved for a longer time, so other can benifit from it.
> > > > > > >
> > > > > > > Good luck
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Monish" wrote:
> > > > > > >
> > > > > > > > Hi all -
> > > > > > > >
> > > > > > > > Can anyone tell me how to set up a popup reminder when a user moves off a
> > > > > > > > record as they use my form to inpout data?
> > > > > > > >
> > > > > > > > I want to reinforce a few specific fields to them, which I would like ensure
> > > > > > > > they have reviewed before moving to the next record input/update.
> > > > > > > >
> > > > > > > > Thanks anyone!!
> > > > > > > > M
.

Quantcast