rev_ollie
Thread Starter
- Joined
- Aug 28, 2008
- Messages
- 36
Hi everyone
Im trying to learn a load of stuff in access to get some practice in for when i find my project out next year and decided to make a hotel system.
Im looking at the moment at a few barriers i hope you can help me with
Firstly i have a text box called txt (origional or what
) and a check box called check.
Im sure this has been asked before but i cant get it to work. I would like the check box to make the text box appear when ticked so when there is no value eg no tick in check then txt is invisible.
At the moment i have this:
Private Sub check_Click()
If check.Value = 1 Then
txt.Visible = True
Else
txt.Visible = False
End If
End Sub
It makes the text box dissapear but when i go to click it again it does nothing. I though i could add another IF statment to then say if there was
check.Value = 0
txt.Visible=False
But id doesnt work so can you help me on this one.
Also whats the best validation method to use to stop people booking the day before. Eg the date now is the 28 Sept 08 how can i stop someone booking a room for the 27 sept 08? Will i just use a date diff function to stop it. the field for that is just called date.
Thanks any help would be great
Im trying to learn a load of stuff in access to get some practice in for when i find my project out next year and decided to make a hotel system.
Im looking at the moment at a few barriers i hope you can help me with
Firstly i have a text box called txt (origional or what
Im sure this has been asked before but i cant get it to work. I would like the check box to make the text box appear when ticked so when there is no value eg no tick in check then txt is invisible.
At the moment i have this:
Private Sub check_Click()
If check.Value = 1 Then
txt.Visible = True
Else
txt.Visible = False
End If
End Sub
It makes the text box dissapear but when i go to click it again it does nothing. I though i could add another IF statment to then say if there was
check.Value = 0
txt.Visible=False
But id doesnt work so can you help me on this one.
Also whats the best validation method to use to stop people booking the day before. Eg the date now is the 28 Sept 08 how can i stop someone booking a room for the 27 sept 08? Will i just use a date diff function to stop it. the field for that is just called date.
Thanks any help would be great