Recent content by grogmi1

Great !! Thanks again Minty

Minty this is great, I have the query worjing thanks to you but how do I get the update query to run from the command button using code ? (Total novice!!)

Hello, I am looking for a little more help with a database I am currently creating. I have a main form which contains a subform, both of these forms are controlled by a combo box which allows me to select records on the main form and displays the matching information in the subform. I would...

Scratch that, It works !!!! Id entered the control name incorrectly. Thankyou so much for you help

I entered exactly this : Me.[CarHist_FRM]![ActiveAD] = False

I have no code at the moment just a combo box on a form that looks up records

Thanks for the reply. I tried putting the exact above statement into the After Update Event and it didn't work. Sorry, I'm a bit of a Access dummie so any steps on how to do this would be much appreciated

Hello, I am looking for some help with a Yes/No tick box on a subform. I have a combo box (combo20) on my main form which finds records on my main form and the relevant matching details on my subform. What I would like to do is -------------When the Vehicle number is selected from the combo...

Thanks for the reply. I've decided to scrap that plan based on your advice and go back to the drawing board. Thank you

Hello, I'm hoping someone can help me (Im not the best with MS access so please bear with me. I have not yet started this database yet but what I need to do is have 2 tables, 1 which records 'live' data about our fleet of vehicles and 1 which contains the historical data, both tables will have...

Thanks again Minty. I've been dragged into a meeting so probably wont get a chance to try this today. Ill message back once I've tried it and let you know either way. Thanks so much for your quick responses

Thankyou both for your quick responses. I take on board that the Dlookup may be slower but could you give me help with this (how would I write this in a textbox on my report)

Hello, I am looking for a little help. I have a report which works fine but I want to pull in data from a different table that the report is not based on. The report is based on a query named MaintenanceQRY and it has a field in there named 'ItemUsed'. Like I say the report works fine...

Looks good, thankyou. Now to put it into practice

We are a Taxi business and we check our vehicles every 2 weeks. when the vehicles are checked we need to record the details of the checks. The sub form shows a summary of the historical checks I want the open form to show all of the checks for the vehicle on that date. I am still getting to...