Search results

Afternoon all, I'm building a bespoke car rental system to replace a 20 year old piece of software (yep, 20!), and the one feature that i've been asked to keep in is our car view calendar, which enables us to see at a glance where vehicles are, if they're booked, etc. While i would have no...

Afternoon all, I'm manipulating dates and days quite a bit at the moment, and I need to identify the last thursday of whichever month we are currently in - we bill our account customers on this day so ongoing invoices need to be raised with this date in mind. I know I can select manually using...

Hiya, I'm scratching my head on this one. :banghead: I have a button on my "Customers" Form to open the "CustomerReport" Report. I've put the standard DoCmd with a where condition in the OnClick of the button on the form. DoCmd.OpenReport "CustomerReport", acViewPreview, , "Cust_ID = " &...

Afternoon, I'm banging my head on a wall here with this - i had solved it before but only on single value report controls. I'm combining three/four fields into one on a report, as below: =[EAStaff1] & "," & [EAStaff2] & "," & [EAStaff3] But instead of getting the [Staff Member] field...

Afternoon, An extra feature I need to add to my database is puzzling me a little, yet I know it can be done! Access 2007... When I create a booking, i want to make sure that the staff member i book onto it isn't already allocated to another booking, and alert me with a pop up that says...

Morning all, I'm having real fun with Access '07.... not. I've designed a report that effectively prints a list of bookings based on a user-input date range, grouped by the staff member that's booked to lead. All well and good (did have a minor problem with a multiple value list but sorted...

Afternoon all, I'm making good headway on sorting out everything that needs sorting ( had a fight with some reports and duplicate field names, sorted that out after a few hours piddling around.....:o).. One of my forms has a cost field in it, and i want this to be automatic. not a problem...

Morning all, I'm a bit rusty at the moment having been away from databases for some time, and now my job takes me back to them again... a quick question i'm stuck on if I may: I'm working on a bookings database for school visits, and having got almost everything sorted, i have a few...