Search results

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

the open form button opens up the 'view vehicle checks' form and the dates on the sub form 'Vehiclechks_TBL-Query' should match the date on the 'view vehicle checks' form

Hi Jdraw thanks for getting back to me, I've added the database to a zip file and posted it. It's in its infancy but if you open up form 'Carnumbers' and select vehicle number 3 you will see the dummy check history drop and the problem i'm having with the 'open form' button

Hello, I have a main form which in turn has a subform showing the brief details of vehicle checks that we carry out. The subform has a field next to each check 'Date checked' and also a command button which when clicked opens up a another form which shows all of the checks carried out on a...

Here is the sql view SELECT Agent_Activity.Extension, Agent_Activity.User, Agent_Activity.Date, Agent_Activity.Time, Agent_Activity.[ACTUAL Duration], Agent_Activity.[Status ID], Agent_Activity.[Reason Code], Agent_Activity.[INBOUND CALL], Agent_Activity.[OUTBOUND CALL], IIf([Reason...

Hi, I have a search query on my access database which uses a form to set it's search criteria. The form asks for Start Date, Start time, End date, End time. If the user specifies 1 day and a set time criteria the search works fine. If the user specifies a date range we then have problems...