Recent content by AuroX7

Thank You! Thank you so so so so so so so so much. :D:D:D:D:D Have a good day! :):D:):D

It's still happening. :(:( There's a type mismatch now.

When I enter text into my 'toe' string field, I get an error Private Sub toe_AfterUpdate() Dim toe As String Dim ee As Boolean Dim kip As String Dim kip1 As String If toe = "Play Group" Or "Guides & Brownies" Or "Cub Scouts" Or "Women's Institute" Or "Line Dancing"...

The AddItem seems to work fine, but RemoveItem doesn't, yet I've used precisely the same syntax except for 'RemoveItem' MsgBox "Booking cancelled!", vbInformation, "Booking Cancellation" If Month(Me.Date_1) = 1 Then ListJ.RemoveItem Me.BoI ElseIf Month(Me.Date_1) =...

Private Sub BoI_AfterUpdate() Dim Box As String Box = Msgbox("Is the booking date at least 7 days before the hiring and no more than 8 weeks in advance? If so, click Yes, otherwise, click No. You can check the calender on the Open Form under the 'Miscellanous' tab to check the date. Thank...

I have a field on my form which I want to display a message box when something is entered. Private Sub BoI_AfterUpdate() Box = Msgbox("Is the booking date at least 7 days before the hiring and no more than 8 weeks in advance? If so, click Yes, otherwise, click No. You can check the calender on...

Okay. Could you explain to me what I exactly have to do? I'm no good with Access, lol. Thank you. :D

Hello everyone. I have a form based on one of my tables. When I fill out the fields on the form the data automatically goes into the table. How can I make it so I click a button which adds all the data to the table? I don't want the data to go into the table as I type it on the form, I want to...

In what context. I mean... If < DateAdd("m",2,[=Now()]) Then... I presume that's for the 2 months, but what about the 7 days? I am new to all this so I apologise for my stupidity. :(

Simple question. How do I put 4 queries into one report? I need to display usage statistics for each week of February into one report. Thanks in advance. :D

How could I implement a feature which determines if something is at least 7 days before a booking at a theatre, but no more than 2 months. For example, something like... If =Now() - 7 Then... Elseif =Now() Then... I don't really know how to go about it. Hirer Date is when the booking is to be...

Oh I just put them in some of my field names to indicate they're required fields. Sorry for any confusion. :/ I've managed to divide my monthly queries into 4 weekly slots. Is there any way of displaying the actual date when you look it up? I.e... Week #1: Between 1/1/2006 and 1/7/2006 When I...

I'm going to use that as my general Usage query, but I want to separte the usage data into both months. Since the data is based on January and February, how can I make it so it's divided into each month. I have three queries: qryUsage, qryUsageJan, qryUsageFeb The qryUsage, as you pointed out...

IT WORKS! OMG OMG OMG! I appreciate this so much! Thank you to both of you guys for taking out time to find a solution to this problem. It might seem easy but I'm not overly great with Access, lol. You've both made me understand SQL more too which can only be a good thing! I can't thank you guys...

Ooh, I see you've made it so it shows the percentage paid and unpaid which is cool. :D Although is there a way to make it so it calculates the percentage of the # of bookings? For example... Regular Booking|Money Taken|# of bookings|Time|Percentage Usage| T| £0.00|...