Search results

@BeeJayEff - I request information but it trickles slowly and I have to work within the constraints of how they operate. It is what it is,I have no reputation to maintain, no commercial business to satisfy, this is a little pro bono work. I see your point on the van return date though. Cheers, Lol

@ plog: the table Tbl_Vehicle_Issue keeps a record of the "keeper" of each vehicle as it occurs and hence a history. Cheers, Lol

Well spotted on the Driver_ID :-) I hear you on the Tbl_Fuel_Card Primary key, however, the company is using that data for reasons I cannot ascertain at the moment so for now it stays :-) Don't need a returned date at this time for the vehicle since they are generally long term assigns. MOT_date...

Okay, after a bit of a brain ache the penny dropped once more and I came upon the attached structure. It works for me, allows the logging of vehicle and fuel card assignment as well as handling data on drivers and vehicles. Regards, Lol

Problem solved, data structure re-evaluated. Thanks for the input. Regards, Lol

Yeah i need to re-daw the relationship between fuel card table and drivers table because a fuelcard will have many users during its life. People cn have many vehicles because as their role in the company changes, or due to logistical requirements, they may exchange vehicles with someone else for...

No, this is another project altogether. Yes, a fuel card is a payment card and is used in this instance to pay for fuel only.

Okay, I've re-named some fields and redone the relationships. The db is just to monitor who has which vehicle, which fuel card and to track vehicle servicing and MOT testing. I just want to run simple queries to ascertain if any MOT, road tax or servicing is due. At some point management may...

Yeah the second link from Tbl_Vehicla to Tbl_Fuel_Card was a bit of madness on my part :-) I hear what you are saying about reserved names, that's all reversible. I'll do a bit of re-labelling and repost with a description. Cheers, Lol

I've been asked to amalgamate 4 Excel spreadsheets into a single database, and from that run automated queries to prompt the booking of vehicle servicing etc. The spreadsheets had the following fields: Driving Licence Chart Name Copy of Licence Held Expiry Date Points Held Tow or...

Believe me when I tell you that all those points you raised have been considered and the data structure remains the same. I might need my skills on db updating but systems and methodologies is something I'm quite au fait with. This is not some hastily put together solution, many hours have been...

Ah, therein lies part of the problem. Tools cannot be pre-booked, this is simply a method to know where they are. So, they are either in stores, or they are on site. The purpose of the db is to locate tools when they are due for recall for test. The tools themselves are such things as extension...

I'm going to watch the videos to refresh the brain, but in the mean time can anyone explain what is wrong with the relationship attached? A tool can be booked to many locations but only one at a time, and a location can have many tools booked to it. Thanks, Lol

The penny has just dropped with a huge clunk! Part of what I am trying to do was never going to happen the way I was doing it, don't know what happened to my brain but there you go :eek: I have re-made the original database from scratch. I will have some new questions I suspect but I will try...

Okay, the spec is this: The company want to be able to identify where tools are, either in stores or a job location. This is to enable them to recall as necessary for PAT testing. The guys operating the system are not computer savvy to the extent of working with databases so I am trying to...

What should have been a nice simple little database has turned into a nightmare for all concerned. Firstly, please appreciate that when I post on here it is because I am at a loss as to what to do next. I have researched the problem and either cannot find the solution or need it explaining to...

Okay, please see below for an explanation of what I am trying to achieve.

Okay, Frm_Booking works exactly as I want it to so no problems there. By trying to rapidly re-learn skills from years ago I have often been unable to see the wood for the trees so as to speak. I've made all the text boxes on Frm_Find unbound, but when I try and run the AfterUpdate event it...

Thanks for the help, it gives me somewhere to start. Cheers, Lol

Attached is the offending database