Message box for a query?

[Kerman]

I have a command button on my form connected to an update query. The query
updates the [DateIssued] to a [CertNumber]. Is there a way to create a
message box that will prompt the user to enter the [DateIssued] if it is
accidently by passed? Currently the user can bypass the [DateIssued] and go
to the [CertNumber] without realizing it. Thanks...Randy

 

[Armen Stein]

I have a command button on my form connected to an update query. The query
updates the [DateIssued] to a [CertNumber]. Is there a way to create a
message box that will prompt the user to enter the [DateIssued] if it is
accidently by passed? Currently the user can bypass the [DateIssued] and go
to the [CertNumber] without realizing it. Thanks...Randy

Hi Randy,

I assume you're using a parameter query. A better approach is to open a
form to gather the two values. Allow the OK button to proceed only if
they are entered correctly. The query can reference the values on the
form using Forms!YourFormName!YourControlName.

Hope this helps.

 

[Kerman]

How do I do this, I'm kinda new at this..Thanks

I have a command button on my form connected to an update query. The query
updates the [DateIssued] to a [CertNumber]. Is there a way to create a
message box that will prompt the user to enter the [DateIssued] if it is
accidently by passed? Currently the user can bypass the [DateIssued] and go
to the [CertNumber] without realizing it. Thanks...Randy

Hi Randy,

I assume you're using a parameter query. A better approach is to open a
form to gather the two values. Allow the OK button to proceed only if
they are entered correctly. The query can reference the values on the
form using Forms!YourFormName!YourControlName.

Hope this helps.

 

[Armen Stein]

How do I do this, I'm kinda new at this..Thanks

I have a command button on my form connected to an update query. The query
updates the [DateIssued] to a [CertNumber]. Is there a way to create a
message box that will prompt the user to enter the [DateIssued] if it is
accidently by passed? Currently the user can bypass the [DateIssued] and go
to the [CertNumber] without realizing it. Thanks...Randy

Hi Randy,

I assume you're using a parameter query. A better approach is to open a
form to gather the two values. Allow the OK button to proceed only if
they are entered correctly. The query can reference the values on the
form using Forms!YourFormName!YourControlName.

Hope this helps.

We have some sample code at www.jstreettech.com/downloads.asp called
"Report Selection Example" that will help you see how this works.

 

[PC]

Go to the Properties of the [DateIssued] field and open the Data Tab. In the
Validation rule type Is Null, in the Validation text type your own error
message.

How do I do this, I'm kinda new at this..Thanks

I have a command button on my form connected to an update query. The query
updates the [DateIssued] to a [CertNumber]. Is there a way to create a
message box that will prompt the user to enter the [DateIssued] if it is
accidently by passed? Currently the user can bypass the

[DateIssued]
and go

to the [CertNumber] without realizing it. Thanks...Randy





Hi Randy,

I assume you're using a parameter query. A better approach is to open a
form to gather the two values. Allow the OK button to proceed only if
they are entered correctly. The query can reference the values on the
form using Forms!YourFormName!YourControlName.

Hope this helps.

We have some sample code at www.jstreettech.com/downloads.asp called
"Report Selection Example" that will help you see how this works.