Hey i fixed my last problem (silly mistake put date_ordered instead of text3.text, to into access i guess!)
Anyway, i have got this code to stop people from booking a slot that is alreasy taken by Brownies and guides and playgroup etc....
If (Combo1.Text = "Morning") And ((Weekday(Text3.Text) = 2) Or (Weekday(Text3.Text) = 4)) Then MsgBox ("Error! This slot is allocated to: Play Group")
If (Combo1.Text = "Morning") And ((Weekday(Text3.Text) = 2) Or (Weekday(Text3.Text) = 4)) Then Text3.Text = ""
If (Combo1.Text = "Evening") And (Weekday(Text3.Text) = 3) Then MsgBox ("Error! This slot is allocated to: Guides & Brownies")
If (Combo1.Text = "Evening") And (Weekday(Text3.Text) = 3) Then Text3.Text = ""
If (Combo1.Text = "Evening") And (Weekday(Text3.Text) = 5) Then MsgBox ("Error! This slot is allocated to: Clubs & Scouts")
If (Combo1.Text = "Evening") And (Weekday(Text3.Text) = 5) Then Text3.Text = ""
The problem is when i try it the first time it works fine (message box shows etc....) but then if i change the date to one of the different dates that are taken an error occurs. It says "Run-time error '13'" "Type Mismatch" then when you click debug it goes down to the next line of code i.e. "If (Combo1.Text = "Evening") And (Weekday(Text3.Text) = 3) Then"
Appreciate help thankyou.
and also how the hell do you relate the tables in VB?
hii am in nr da same situation as u. i ent dat gd at access. how far have u gt in ur project?
hey mate culd u show me wat a data flow diagram for the village hall project will look like please?
i would like to create a drop down column (in Access) that will show all the available dates for this year. my teacher said something about importing the dates from excel.
can anyone help?
Hey im working on regular bookings at the moment. I was wondering what ways people have found to stop people from booking at the same time as the women's institute (every thrird tuesday a month), i have done the main ones this one im stuck with!
Thanks any help will be greatly appreciated.
hey, were just starting this coursework now, our teacher has taught the class COMAL and a little MS Access... since COMAL doesnt have date functions and cant interface with any database its use can be discarded (as far as i know, its a 20 year old language intended to teach people programming concepts)
... we havent been taught any VB or any other language
i however have experience with PHP/MySQL setup so have started some work on that.
my question, is that combination acceptable to the board? and also, will i be able to use the same combination in A2 or need to use somthing else? i was told that in the past you couldnt use a database both years, the spec seems to indicate this is no longer valid?
Rob, good layout for starters, mines pretty similar.
I got another question on this, do we have to provide step by step pictures to accommodate the documentation? Or do we just take pictures when we have finished?
I'm setting up the tables now, I've got Customer ID 3 times (once in every table) I presume this is wrong since I can't set up a relationship like this?
ok, this isnt that great a query but it works. not sure how Access SQL differs from MySQL, should be very similar
LEFT JOIN tvh_customers ON tvh_bookings.customerid = tvh_customers.customerid
LEFT JOIN tvh_billing ON tvh_bookings.bookingid = tvh_billing.bookingid
WHERE tvh_bookings.bookingid = 1
im not joining billing via customerid since one customer can make more than one booking.... we dont need customerid in the billing table
gives access to following fields;
rob, I am crap with code... can you explain what that will do? Set up a relationship between all 3?
OK, cheers Rob.
After all the advice in this thread I'm still stumped with this coursework. I don't understand what I should now that I've made the tables and (fingers crossed) corrected relationships. Queries I presume... in what way?
Well how do I go about making forms or queries? I mean I've made all this stuff before but I am still really crap and new to it at the same time...
Any links with websites would be good, I need some serious help.
My teacher explains things in a useless mannor that doesn't help atall!