Search results

Not sure if this is for the forms thread or tables, think I am in the right place I have 2 tables tblworkdone and tbltests, both have a date field and are both subforms in a tabbed form on the main form. When I enter a date into the tbltests subform I would like the date to automatically be...

Ok here goes, there are duplicates in the tblmain which are redundant, they will be deleted soon. I started this about 4 years ago, and have been picking up tips along the way so this is partly an evolution of sorts.

Looks ok but mine is quite a bit more involved but I see your point, that is more to do with the maintenance, we are similar to a hire company within the main company we do all maintenance, testing, servicing, we have a fleet of vehicles so need to know whos driving where it is in the contry...

I will take a look

Hi everyone, I have had a look at similar threads but not quite what I am looking for hopefully someone has come accross this before and can help. Heres the thing. I have designed a vehicle maintenance database, I have a query listing vehicle tests due between 2 dates from a form. This works...

I prefer to have them displayed at the startup then something can be done about them there and then, the likelyhood is the user will never go and check at least this way they will see what is due and what has to be chased up.

Thanks for your thoughts, in some respect I could do what you have suggested, but they do need to run at startup because they are the reminders for out of date inspections etc and those due in the next month.

Hi guys and many thanks for your help we got there in the end I tried the comboflag option in the current and still had the same problem then moved it to the onload and everything works perfectly. I am self taught, I guess llike most. So any help is much appreciated. The database I have is for...

Yes that's about the size of it. If I dont use the list box then a combo box looks for a record on the form and takes me there, but as soon as I use the list box double click and it takes me to the record that is fine but then the combo box nor the record selectors work correclty, they try and...

Yes I know. I did say it works perfectly aprt from it is still restricted to the record selected from the list box, so I can't go forward a record or backwards a record or select another record from a drop down combo box. I was just asking if there was something else I should be doing to still...

Thanks that works brilliantly, however haha! I have another problem now. On the main form I use a combo box to goto a record, but after going from my list box and opening the main form at the correct record the combo box tries to goto the record but keeps reverting back to the list box...

Thanks for that but not what I am looking for. I have a list box and I can double click in the list box to open another form with the chosen record from the list box, but all I get is the single record in the main form, in order to see all records again i need to close the main form and reopen...

Hi guys and gals lol, Newbie to the forum and world of access. I have searched the forum for a solution and found one that works in part, DoCmd.OpenForm "frmfleettruck", acNormal, , "[unitid]=" & Me.searchresults.Column(0) This takes me from a list box on a double click event which id fine but...