Data Flow Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to perform the following:

On a form I have a series of dates which track movement of customer
Containers.

I do not want a user to enter one date until the previous is populated:

A container cannot be [Picked-up] "date" before it is [Empty] "date".

Thanks
 
To use your example, you would put something like this in the Before Update
event of the PickedUp control:

If IsNull(Me.Empty) Then
MsgBox "Container cannot be Picked Up Until it is Empty"
Cancel = True
Me.Empty.Setfocus
End If
 
Yeah Baby!!!!!

I did not use the Setfocus as this populates the Empty date automatically
and I need the user to enter the crrect date.

Thanks

--
A MACKENZIE, CMA, MBA


Klatuu said:
To use your example, you would put something like this in the Before Update
event of the PickedUp control:

If IsNull(Me.Empty) Then
MsgBox "Container cannot be Picked Up Until it is Empty"
Cancel = True
Me.Empty.Setfocus
End If

aMack said:
How to perform the following:

On a form I have a series of dates which track movement of customer
Containers.

I do not want a user to enter one date until the previous is populated:

A container cannot be [Picked-up] "date" before it is [Empty] "date".

Thanks
Click to expand...
Click to expand...
 
How does that populate the Empty control? There is nothing in the code that
does that.

aMack said:
Yeah Baby!!!!!

I did not use the Setfocus as this populates the Empty date automatically
and I need the user to enter the crrect date.

Thanks

--
A MACKENZIE, CMA, MBA


Klatuu said:
To use your example, you would put something like this in the Before Update
event of the PickedUp control:

If IsNull(Me.Empty) Then
MsgBox "Container cannot be Picked Up Until it is Empty"
Cancel = True
Me.Empty.Setfocus
End If

aMack said:
How to perform the following:

On a form I have a series of dates which track movement of customer
Containers.

I do not want a user to enter one date until the previous is populated:

A container cannot be [Picked-up] "date" before it is [Empty] "date".

Thanks
Click to expand...
Click to expand...
Click to expand...
 
There is a On Got Focus Event which makes the default date = "Today".


--
A MACKENZIE, CMA, MBA


Klatuu said:
How does that populate the Empty control? There is nothing in the code that
does that.

aMack said:
Yeah Baby!!!!!

I did not use the Setfocus as this populates the Empty date automatically
and I need the user to enter the crrect date.

Thanks

--
A MACKENZIE, CMA, MBA


Klatuu said:
To use your example, you would put something like this in the Before Update
event of the PickedUp control:

If IsNull(Me.Empty) Then
MsgBox "Container cannot be Picked Up Until it is Empty"
Cancel = True
Me.Empty.Setfocus
End If

:

How to perform the following:

On a form I have a series of dates which track movement of customer
Containers.

I do not want a user to enter one date until the previous is populated:

A container cannot be [Picked-up] "date" before it is [Empty] "date".

Thanks
Click to expand...
Click to expand...
Click to expand...
 
I would take that out. If you have to ensure the user puts in a correct date
and you have a default date, there is no way to ensure they have entered a
correct date.

aMack said:
There is a On Got Focus Event which makes the default date = "Today".


--
A MACKENZIE, CMA, MBA


Klatuu said:
How does that populate the Empty control? There is nothing in the code that
does that.

aMack said:
Yeah Baby!!!!!

I did not use the Setfocus as this populates the Empty date automatically
and I need the user to enter the crrect date.

Thanks

--
A MACKENZIE, CMA, MBA


:

To use your example, you would put something like this in the Before Update
event of the PickedUp control:

If IsNull(Me.Empty) Then
MsgBox "Container cannot be Picked Up Until it is Empty"
Cancel = True
Me.Empty.Setfocus
End If

:

How to perform the following:

On a form I have a series of dates which track movement of customer
Containers.

I do not want a user to enter one date until the previous is populated:

A container cannot be [Picked-up] "date" before it is [Empty] "date".

Thanks
Click to expand...
Click to expand...
Click to expand...
 
The default date is bieng used because these fields use an OLE object
dtpicker. The date always defaults to Oct 18, 2005 (the date we installed the
system) and entries have been made with 2005 dates instead of 2006.

I put the setfocus back in with a different "Text" field. It works.
--
A MACKENZIE, CMA, MBA


Klatuu said:
I would take that out. If you have to ensure the user puts in a correct date
and you have a default date, there is no way to ensure they have entered a
correct date.

aMack said:
There is a On Got Focus Event which makes the default date = "Today".


--
A MACKENZIE, CMA, MBA


Klatuu said:
How does that populate the Empty control? There is nothing in the code that
does that.

:

Yeah Baby!!!!!

I did not use the Setfocus as this populates the Empty date automatically
and I need the user to enter the crrect date.

Thanks

--
A MACKENZIE, CMA, MBA


:

To use your example, you would put something like this in the Before Update
event of the PickedUp control:

If IsNull(Me.Empty) Then
MsgBox "Container cannot be Picked Up Until it is Empty"
Cancel = True
Me.Empty.Setfocus
End If

:

How to perform the following:

On a form I have a series of dates which track movement of customer
Containers.

I do not want a user to enter one date until the previous is populated:

A container cannot be [Picked-up] "date" before it is [Empty] "date".

Thanks
Click to expand...
Click to expand...
Click to expand...
 
dtPicker works fine most of the time. But if you distribute your DB,
it could cause problems. You could use the Calendar control from
Access Developer's Handbook. I _think_ you can download it from the
ADH website. Then you can set any or no date at all when you open it.
 
Back
Top