Search results

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|...

I would be really chuffed if you could possibly look at it and see what it is. :D I've tried for ages and nothing's become of it. :( Thank you. :D:D:D If you don't then I guess I'll have to battle on and find the solution...meh. If you do then the password for the database is: yojimbo17 The...

Hey guys. I have a boolean expression which I want to calculate the percentage of. I have the field 'Regular Booking' which is either true or false. I have 6 true and 5 false, equalling to 11 in total. I've tried using: 100*[CountOfRegular Booking] / [TotalRegular Booking] but this gives me the...

:d Works a treat. Thank you buddy. :)

How would you make two prompt boxes which ask for the start and end date so you can select all the data between the two dates... [Start Date?] And [End Date?] E.g., 01/01/2006 And 07/01/2006 So I can select all the data between that week. I also need to use this for the remaining weeks in...

I finally got my add item feature going. I have a list of bookings for both January and February. Just for reference, 'BoI' is the name of the field which I want to add or remove. My code looks like this: If Month(Me.Date_1) = 1 Then ListJ.AddItem Me.BoI ElseIf Month(Me.Date_1) = 2 Then...