Still battling with Reminder Pop-up Any help??

[Guest]

Thanks that worked but one more problem.

The user loggon - from there the form opens as this form open the reminder
needs to po-up displaying info. A setvalue function sets the value of hidden
fields on the form to the detais of the person logging in. and another field
is set to Date(). The link criteria is these two fields searching for
reminders corresponding to the name of the forensic investigator and current
date set.

What happens is when the form is opened the pop-up appears with no info
displaying. This means that the link criteria function run before the
setvalue function and the date() function because it is evaluating blank
fields and giving me a blank reminder. But still the setvalue function is set
on the previous page

The setvalue function is on the On click function of the first page.

Any suggestions on this?

Pieter accidentally left off the closing quote for Forensic Investigator.
Also, remember that dates must be in mm/dd/yyyy format, regardless of what
your Short Date format has been set to through Regional Settings. Since you
can't always be sure what your users will use, it's best to be explicit.

Try:

stLinkCriteria = "[Forensic Investigator]=" & Chr$(34) & _
Me![Text24] & Chr$(34) & " AND [Date]=" & _
Format(CDate(Me![Text15]), "\#mm\/dd\/yyyy\#")


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Thanks. Getting a compile error: Expexted: end of statement.

stLinkCriteria = "[Forensic Investigator]=" & "'" & Me![Text24] & " AND
[Date]=" & "#" & Me![Text15] & "#"

Pieter

 

[Douglas J. Steele]

Try putting your code into a different event, once you know that the form
has been completely populated.

What event are you using to populate the fields?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Thanks that worked but one more problem.

The user loggon - from there the form opens as this form open the reminder
needs to po-up displaying info. A setvalue function sets the value of
hidden
fields on the form to the detais of the person logging in. and another
field
is set to Date(). The link criteria is these two fields searching for
reminders corresponding to the name of the forensic investigator and
current
date set.

What happens is when the form is opened the pop-up appears with no info
displaying. This means that the link criteria function run before the
setvalue function and the date() function because it is evaluating blank
fields and giving me a blank reminder. But still the setvalue function is
set
on the previous page

The setvalue function is on the On click function of the first page.

Any suggestions on this?

Pieter accidentally left off the closing quote for Forensic Investigator.
Also, remember that dates must be in mm/dd/yyyy format, regardless of
what
your Short Date format has been set to through Regional Settings. Since
you
can't always be sure what your users will use, it's best to be explicit.

Try:

stLinkCriteria = "[Forensic Investigator]=" & Chr$(34) & _
Me![Text24] & Chr$(34) & " AND [Date]=" & _
Format(CDate(Me![Text15]), "\#mm\/dd\/yyyy\#")


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Thanks. Getting a compile error: Expexted: end of statement.

:

stLinkCriteria = "[Forensic Investigator]=" & "'" & Me![Text24] & "
AND
[Date]=" & "#" & Me![Text15] & "#"

Pieter

 

[Guest]

Text24 is a Unbound field that are populated with a setvalue function when
enter is clicked on the log-on page.

Text15 is also a unbound field and its Control source is Date()

Try putting your code into a different event, once you know that the form
has been completely populated.

What event are you using to populate the fields?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Thanks that worked but one more problem.

The user loggon - from there the form opens as this form open the reminder
needs to po-up displaying info. A setvalue function sets the value of
hidden
fields on the form to the detais of the person logging in. and another
field
is set to Date(). The link criteria is these two fields searching for
reminders corresponding to the name of the forensic investigator and
current
date set.

What happens is when the form is opened the pop-up appears with no info
displaying. This means that the link criteria function run before the
setvalue function and the date() function because it is evaluating blank
fields and giving me a blank reminder. But still the setvalue function is
set
on the previous page

The setvalue function is on the On click function of the first page.

Any suggestions on this?

Pieter accidentally left off the closing quote for Forensic Investigator.
Also, remember that dates must be in mm/dd/yyyy format, regardless of
what
your Short Date format has been set to through Regional Settings. Since
you
can't always be sure what your users will use, it's best to be explicit.

Try:

stLinkCriteria = "[Forensic Investigator]=" & Chr$(34) & _
Me![Text24] & Chr$(34) & " AND [Date]=" & _
Format(CDate(Me![Text15]), "\#mm\/dd\/yyyy\#")


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Thanks. Getting a compile error: Expexted: end of statement.

:

stLinkCriteria = "[Forensic Investigator]=" & "'" & Me![Text24] & "
AND
[Date]=" & "#" & Me![Text15] & "#"

Pieter

 

[Douglas J. Steele]

"when enter is clicked" doesn't really tell me much.

What's the exact event you're using?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Text24 is a Unbound field that are populated with a setvalue function when
enter is clicked on the log-on page.

Text15 is also a unbound field and its Control source is Date()

Try putting your code into a different event, once you know that the form
has been completely populated.

What event are you using to populate the fields?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Thanks that worked but one more problem.

The user loggon - from there the form opens as this form open the
reminder
needs to po-up displaying info. A setvalue function sets the value of
hidden
fields on the form to the detais of the person logging in. and another
field
is set to Date(). The link criteria is these two fields searching for
reminders corresponding to the name of the forensic investigator and
current
date set.

What happens is when the form is opened the pop-up appears with no info
displaying. This means that the link criteria function run before the
setvalue function and the date() function because it is evaluating
blank
fields and giving me a blank reminder. But still the setvalue function
is
set
on the previous page

The setvalue function is on the On click function of the first page.

Any suggestions on this?

:

Pieter accidentally left off the closing quote for Forensic
Investigator.
Also, remember that dates must be in mm/dd/yyyy format, regardless of
what
your Short Date format has been set to through Regional Settings.
Since
you
can't always be sure what your users will use, it's best to be
explicit.

Try:

stLinkCriteria = "[Forensic Investigator]=" & Chr$(34) & _
Me![Text24] & Chr$(34) & " AND [Date]=" & _
Format(CDate(Me![Text15]), "\#mm\/dd\/yyyy\#")


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Thanks. Getting a compile error: Expexted: end of statement.

:

stLinkCriteria = "[Forensic Investigator]=" & "'" & Me![Text24] &
"
AND
[Date]=" & "#" & Me![Text15] & "#"

Pieter

 

[Guest]

Text15's CotrolSource in the property Menu is set to =Date()

Private Sub Command8_Click()

If Username = UserVeri And Password = PassVeri Then
DoCmd.OpenForm "Front Page", acNormal, , , , acWindowNormal
DoCmd.RunMacro "SetVPE"
DoCmd.RunMacro "SetUserFP" <-----(Sets Text24)

DoCmd.Close acForm, "EntryPass", acSavePrompt
Else
MsgBox "Incorrect Username or Password"
End If
End Sub

Could it be that these two are unbound?

"when enter is clicked" doesn't really tell me much.

What's the exact event you're using?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Text24 is a Unbound field that are populated with a setvalue function when
enter is clicked on the log-on page.

Text15 is also a unbound field and its Control source is Date()

Try putting your code into a different event, once you know that the form
has been completely populated.

What event are you using to populate the fields?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Thanks that worked but one more problem.

The user loggon - from there the form opens as this form open the
reminder
needs to po-up displaying info. A setvalue function sets the value of
hidden
fields on the form to the detais of the person logging in. and another
field
is set to Date(). The link criteria is these two fields searching for
reminders corresponding to the name of the forensic investigator and
current
date set.

What happens is when the form is opened the pop-up appears with no info
displaying. This means that the link criteria function run before the
setvalue function and the date() function because it is evaluating
blank
fields and giving me a blank reminder. But still the setvalue function
is
set
on the previous page

The setvalue function is on the On click function of the first page.

Any suggestions on this?

:

Pieter accidentally left off the closing quote for Forensic
Investigator.
Also, remember that dates must be in mm/dd/yyyy format, regardless of
what
your Short Date format has been set to through Regional Settings.
Since
you
can't always be sure what your users will use, it's best to be
explicit.

Try:

stLinkCriteria = "[Forensic Investigator]=" & Chr$(34) & _
Me![Text24] & Chr$(34) & " AND [Date]=" & _
Format(CDate(Me![Text15]), "\#mm\/dd\/yyyy\#")


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Thanks. Getting a compile error: Expexted: end of statement.

:

stLinkCriteria = "[Forensic Investigator]=" & "'" & Me![Text24] &
"
AND
[Date]=" & "#" & Me![Text15] & "#"

Pieter