Search results

Literally only just caught back up with this, was moving offices and that kind of puts things on hold! Looking very promising Gizmo, I know this can be done somehow as the outgoing software from 1998 (!) does it superbly. It's also a live view and the whole thing is on a custom frontend with...

Up next, to add in another 20 rows - 10 is too limiting! Gives me something to do tomorrow morning i suppose :rolleyes:

Awesome, thanks sneuberg. It now displays the vehicles correctly - gave me a null error but that was where i accidentally deleted a field that's needed!

Update: Sort of fixed that issue. I'm having a right day of it, someone tell me what's wrong with this select statement that only plucks record where the checkbox is ticked please, i'm having a total mindblank on box statuses etc! SELECT * FROM Vehicles ORDER BY Reg WHERE Available = True;

Fallen at the first hurdle.. entered in my table names etc and instantly got hit with a runtime error 91 - "object variable or With block variable not set" relating to this line: Const cUnitPK As String = "Vehicles.CarID"

Minty, that is bang on what i'm after, fingers crossed you can find the original or a current version i can adapt, would save me a serious amount of work lol

Thanks jdraw I'm going to have a good play around with the various suggestions and see what works best, although on the face of it isskint's method appears to be the best way, but scalability is a concern if for example it was to be implemented on 100+ vehicles etc. So far i've got the...

lol mine is just for about 30 vehicles and however many bookings they have with a 30/31 day display

Isskint, that's exactly the sort of thing I'm looking at, with a bit of expansion and alteration of course! Chris, I can't for the life of me squash the database down under the forum max size limit, so i've linked it instead - i've stripped out everything barring some bare data. The Rentals...

Impressive stuff Chris - completely melted my brain as i've not ventured into classes and my skill level is relatively low haha I'm going to go take a paracetemol and start trying to wrap my head round that!

Thanks all, The software is a VERY old car rental program called "QuickDrive Office" - it's SQL based but as it's a custom front end it's not something that can be amended are looked into to find the underlying codes or queries etc. I can however access the data, and i've imported the vehicle...

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

Awesomeness thanks guys :) Every little issue solved is a step toward completion..... and then finding out another two hundred features that need to be added!

Right. Sussed it by using Me.DateDue = DateSerial(Year([DateOut]), Month([DateOut]) + 1, 1) - Weekday(DateSerial(Year([DateOut]), Month([DateOut]) + 1, 1), vbFriday) However, the problem I now face is if the DateOut is after the last thursday of the month but still within that month, it still...

I'll give it a crack, then see what i've done wrong when someone else posts the solution :D I can quite happily play with forms, reports, etc but VBA is something i've not touched on in any real detail in many years. Now i'm getting back into it, it mostly makes sense and I'll be going proper...

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

Fixed completely by adding in a linked subreport instead, i was running in circles! Now I have a pop up box asking for CustomerID every time the report opens and it makes no difference if i leave it blank or fill it. So somewhere I have a redundant mention of it but do you think i can find it...

Main form. There is a subform but that behaves itself.... But you just got me thinking. The subform doesn't always have data in it. I just created a test record with data on the subform and that produces a populated report, whereas anything with no data produces a blank one. A record is...

Yes, as is the underlying table field

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 = " &...