Recent content by LizzleJ

Hi Asking for a bit of help yet again i have declared m varible Dim Booking As Interger and i want to set the value for that varible by using the result of a query. How? Thanks

It works great, thanks again

I'm sure this is on the forum somewhere but have searched and searched... and had no luck. I want my date feild to be set to enter a date no more than 2months in advance but a minium of a week in advance. I have done this lol I don;t actually have a clue, do you use "" to represent the...

Hey, I have an extension checkbox on my form of which i only want visible when Friday or Saturday is selected from the "day" combo list. Private Sub Day_Change() If Day = "Friday" Or "Saturday" Then Extension.SetFocus Extension.Visible = True Else Extension.SetFocus Extension.Visible = False...

Hey, I have an extension checkbox on my form of which i only want visible when Friday or Saturday is selected from the "day" combo list. Private Sub Day_Change() If Day = "Friday" Or "Saturday" Then Extension.SetFocus Extension.Visible = True Else Extension.SetFocus Extension.Visible = False...

Ahh thanks to both Wazz and raskew, i wasn't going to use raskew's way as i didn't understand the +1 and -1. Then i read again i now understand. Thanks

Hey i have used MSCAL.Calendar.7 is my booking form however for some reason its one day out, it dose not seem to be syncing with the date on the computer and is showing a day out, the date for today says 8th on the calender however it is the 7th of april 2006. any ideas once again thanks in...

Hi thanks for the info, i see im stil ldoing something wrong as no records are found, i have attached a screenshot to the post. where do i put the (1) criteria as i tried both and no record are found when they are in the table. i also tried this without that extra booking type field. Thanks

Hi I have the date on my table as 01/02/2006, there are others like this, i'm wondering how i can search for the whole month, something like **/02/2006. i have tried that way and didn;t work. Any ideas?? Thanks

Hi I've nearly done my coursework and got into a problem Now the way i have made my system is so i enter details into a booking table of a new booking and they are saved as one booking. I do not have records to show a booking thats not made. How can i do this? (Hopefully this is not too...