Message box for a query?

  • Thread starter Thread starter Kerman
  • Start date Start date
K

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
 
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
Click to expand...

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.
 
How do I do this, I'm kinda new at this..Thanks

Armen Stein said:
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
Click to expand...

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.
Click to expand...
 
How do I do this, I'm kinda new at this..Thanks

Armen Stein said:
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
Click to expand...

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.
Click to expand...

We have some sample code at www.jstreettech.com/downloads.asp called
"Report Selection Example" that will help you see how this works.
Click to expand...
 
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.


Armen Stein said:
How do I do this, I'm kinda new at this..Thanks

Armen Stein said:
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
Click to expand...
[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.
Click to expand...

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