You can apply very basic validation at the table level through field properties but more complicated validation has to be done at the form level using VBA (VB with al the reallly useful bits cut out of it!)
This nearly works, this code is attached to the check box mouse up event;
Public SessionType As String
Private Sub EveningExtension_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
SessionType = BookingSession.Value
'you have to use the .value and not .text here
If SessionType <> "Evening" And EveningExtension.Value = True Then
MsgBox ("You can only book an extension if the Evening session is also being booked")
EveningExtension.Value = False
It works but sometimes needs a double click on the check box to trigger the validation message. Let me know if you can debug it!
Hi im really stuck on this project does anyone have a working system so i can get some ideas? thank you
What you stuck on? Show your code (pseudo if you like) or explain what you want to do and we will try to help.
Im Stuck as i dont really know how to start it or what i am supposed to be doing, i have been told to use access so thats what i will use but im not very familiar with it. And i have read all through the AQA Requirements pages for the coursework but i am quite confused.
Any Help would be gladly accepted, Thanks.
i barely know how to use access and now i've been told that i need to use VBA (visual basics fo applications)
anyone got any ideas where i could get some help?? (my teachers are being of NO help, i have two teachers who keep telling me different things)
My programming isn't top notch and i would be grateful for any advice!!
are the 21 slots:
morning, afternoon and evening for the seven days of the week??
Does nayone know how to run a query or else some visual basic code that will count the number of slots taken, eg friday morning and friiday afternoon will not be counted by just the friday??
Any help with this would be greatly appricated, its just with the monthly stats report.
Hey im doing my coursework in VB and i have two questions.
Firstly, i would like to know how to make my check box show up when the combo box is set to evening and the date booked is a friday or saturday. This is the code i have....
Private Sub Combo1_Click()
Dim dateordered As Date
dateordered = date_ordered
If (Combo1.Text = "Evening") And (Weekday(dateordered) = 6) Then Check1.Visible = True Else Check1.Visible = False
If (Combo1.Text = "Evening") And (Weekday(dateordered) = 7) Then Check1.Visible = True Else Check1.Visible = False
However when i change the combo box to evening even though the date ordered is <> friday or sat the check box still appears, i would appreciate some help here.
My second Problem is; my school does not have visual basic on their system, and i would like to somehow work on my project in school. I was wondering is there any free IDE's that would work, for editing and continuing my project without the need of having visual basic (6).
Would also like to talk to anyone that is doing there project in VB
Thanks in advance....
O and one last problem! This is the fact that when i make the program stand alone and take it away it doesnt work properly as it looks for the databases at the specified place and cant find it. Is there a way that i could put it all in a zip file and make the program point to it, wherever the zipfile is on the system.