Search results

Yep Yep, I unchecked some MISSING references. Thank you for your help. I have some SQL code which I can copy from the sample query, then just change the appropriate field names etc. That might work. I really appreciate your help. Thank you very much. :):D

w00t, I got a percentage, but it's the same for all fields, lol. * Regular Booking: Money Taken: # of Bookings: Percentage Usage: True £39.00 6 54.55% False £30.00 5 54.55% I get a...

Still happening... Thank you, but it's still happening. :(

Percentage: Format(CountOfRegular Booking/DCount("*","tblBooking"),"Percent") I get an error: 'Undefined function 'Format'' - how can I fix this? The above expression is supposed to convert values into percentages. I copied the expression from someone's sample database (to help me) and I just...

Undefined fucntion Undefined function 'Format' in expression - huh?

Simple question: how do you convert vlaues into percentages? I have a boolean expression so when it's ticked the bookings are regular, and if they're false they are occasional bookings. I have used 10 bookings as test data (5 regular - true, 5 occasional - false). How would I convert these into...

It highlights 'AddItem' with an error... 'Compile error: Argument not optional' Private Sub Command18_Click() Dim BoI As String MsgBox "Booking successfully added!", vbInformation, "Booking" If Month(Me.Date_1) = 1 Then Me.ListJ.AddItem Me.BoI ElseIf Month(Me.Date_1) = 2 Then Me.ListF.AddItem...

I've made a button on my form which adds a booking ID into the listbox, but it doesn't seem to work. This is my code: Private Sub Command18_Click() Dim BoI As String MsgBox "Booking successfully added!", vbInformation, "Booking" If Month(Me.Date_1) = 1 Then ListJ.AddItem Me.BoI...

I changed it to text and used a validation rule "Occasional" Or "Regular" which works fine. When I query it and use the Count function, it finds the total number of bookings which is fine. When I type "Occasional" or "Regulat" into the criteria it says data mismatch expression. What's going...

I can group by the total number of bookings using Count...which gives me 10. But I want to find the individual number of occasional ad regular. Surely I would need to enter something into criteria? :(

In my query I want to find the total number of "occasional" bookings. There are two types: occasional and regular. However, when I select the tblBooking and the field it finds the total number of all the bookings, which is 10 (5 reg. and 5 occ.). However, I only want to find the occasional (5)...

Sorry I'm confused... if (Date() + 40 < [Hiring ID] OR Date() + 7 < [Hiring ID] then 'can't book end if if (Date() + 40 < [Hiring ID] What does the 40 represent? Date() + 7 < [Hiring ID] then Presumably the 7 means 7 days ie a week a week before the hiring can be made, which makes sense...

When I select the booking type (occasional or regular) and in criteria I put "occasional", it says data mismatch expression. Booking type is a drop-down box if that helps. Also, how would I calculate the percentage usage of occasional bookings? Say there are a total of 20 bookings, and 10 of...

How do you calculate usage? For example... If I've got a field named Time, then a drop-down box with "Morning", "Afternoon" and "Evening" How do I make a query so it displays the number of each time... For example... There's two times for Morning, three for afternoon and one for evening. I...

Then what,,, Then what? Do I enter this into the date field or the hiring ID field? Sorry to be a pain. The code changed red indicating an error of some form... thanks.

Hello everyone, if anybody could help me I'd deeply appreciate it. Booking ID = the time when it is booked over the phone Hiring ID = the time when the event is to be held Basically I have to make some booking dates, and use January and February 2006 as test data. My only dilemma is it says...

Says it can't find 'frmCurrentBookings' when it's clearly labelled correctly, lol. Can I add code to save before it adds the item to the listbox in the other form?

MsgBox "Booking successfully added!", vbInformation 'Depending on which month is booked, will determine which listbox is goes in on frmMain If Month(Me.Date_1) = 1 Then Forms!frmCurrentBookings!ListJ.AddItem = Me.BoI 'Add to ListJ on frmCurrentBookings ElseIf Month(Me.Date_1) = 2...

ListJ is located on frmMain My forms are: frmBooking frmHirer frmMain

Forms!frmMain!ListJ.AddItem = Me.BoI Runtime error...says it can't find the form named 'frmMain'... Eh? :confused: Also, off topic a little... Is it possible to open the main form immediately? Like when I click on my database file, then go to 'Open', it opens the main form straight away...