Recent content by student90210

I have a form with three input feilds for Morning, Afternoon, and Evening, if something is inputted into either of these i want it to be stored in its respective slot but also in another field in an unrelated table called Event name. Im not sure how to put multiple storage points into the...

I have a bookng system and i want to figure out the percentage usage of each slot in the week, i have 7 days a week with 3 booking slots for each day. Each month i have to determine the usage for each slot of the week. I understand how to determine the usage but i do not know how to figure out...

Private Sub Event_Date_AfterUpdate() If Weekday(Module1.[Event Date]) > 5 Then Module1.[Check21].Enabled = True Else Module1.[Check21].Enabled = False End If End Sub thanks

I think its close to working, as in its in the right place with the right names, but now it comes back with Compile Error: External Name Not Defined. What does this mean? Thanks

thanks, where it says me. am i supposed to put something relevant to my database in there, sorry i've never used visual basic before.

Basically i have a booking system and on certain days i need to allow an "extension", to do this i am using a yes/no and a check box. I need to creat a validation rule so that the box is only tickable if my Event_date field is a friday or saturday. Do i need to use something like...

duplicate data thanks, I set the event date and time slot to be composite keys, but now i cannot enter any data in the form that would be stored in those tables. Thanks again

I have a form in Access which has event date and then also an event time slot such as "Morning, Afternoon, Evening" . I need to make it so that you cannot have a duplicate time booking, i assume i will need to code some VBA but if anyone could tell me what it would be much appreciated. Thanks