Search results

Hi guys thought i'd give some feedback on your excellent work, all suggestions worked fine, but I have now revamped the database and have the main form a continuous form, the listbox double click works fine, but doesn't go the record on the form and the main form remains open, also the combo...

Hi, solved the puzzle I discovered crosstab query for the first time and that solved it.

Me again! Right I did what you suggested and made some other calculations etc further down the road much easier but it has also thrown up another problem. Before I changed the test table to your suggestion I had one vehicle with many dates similiar to an excell matrix so I was able to create a...

Excellent Plog, never even thought of it like that, doh!, thanks again I will put it into practise immediately. The original table has 2000 entries any idea how to repopulate the new table as you suggested with the old data?

Please find attached a table in which I would like to count each field if the dates falls in the past and have the count as a total or individual in a popup to show what is out of date, and if the user requires to see any of the results how to create a form to show those results. Or should I...

Hi all, hope you can help. I have a continuous form show multiple records, fine, I have a text box behind all fields on the form and another hidden unbound text box in the form header, I have this in my oncurrent event of the form, Private Sub Form_Current() If Nz(Me.Unitid) <> "" Then...

Thank you for your help, I don't seem to have explained myself very well, my fault. I have a continuous form that shows all records in a vehicle maintenance db. I have 3 combo boxes that filter 3 fields, location, category and status. They have there source from 3 tables with just a list of...

Hi all, and thanks for looking any help appreciated. I have an unbound form with 2 option groups, one contains a category like MOT, TAX etc the other group contains the 12 months, so I can choose from the first group a category then choose a month, then I would like those choices to run a query...

Thanks for your reply, this is fine if I were using a single form scenario, but I am using a continuous form. I have 3 combo boxes based on 3 tables which are just lists that feed a main table, I have a qry behind the continuous form, each combo box filters 3 different columns succesfully but I...

Hi, I know there has been many threads written around cascading combo boxes, but I can't seem to figure out if any of them fit my problem. I have a continuous form. in the header I have 3 combo boxes based on 3 tables of single firlds, each one filters the form i.e location, category and status...

Hi everyone, hope this makes sense if not someone point me in the right direction please. I have a form for vehicle maintenance. I have 3 conditional formats to show red for out of inspection, yellow for those coming up for inspection and green for ok, that works fine. the form is in continuous...

Thanks for your reply, but after a few tweaks I have managed to combine the 2 queries so I have all the data I need for the form, however on a similar note, on my form I have 2 text boxes that are controlled by the 2 queries, both invisible, so I have a combo box that when a category is selected...

Ok I think I get the drift but not being fully converse with coding as yet, but i'm getting there, could you be a little bit more specific please.

Not sure which is the best wat to go here, I have one form amd two queries, the only difference between the two queries is a 6 weekly date and a 12 weekly date for inspecting vehicles. I have created a form based on the 6weekly query and all is fine, I use a combo box to filter all hgv's or all...

Hi and thanks for all your help but found a cracking article in MSDN Microsoft library did the trick exactly what I wanted. It takes the not in list item typed opens up a new form to enter the item, creates a new entry into the main table and then returns to the opening form so any other details...

Hi Pat thanks for your insight and youre right I have had a rethink and created as combo box for the unit from the main table then inserts the unitid into the invoice table based on the choice this works great. However, if an item doesn't exist in the main table how do I redirect the user to...

I have a main table which is autonumbered on unitid, I have another table which is linked via the unitid which holds items purchased for the main table, so the second table is a subform of the suppliers and will have multiple entries of the same unitid. What I would like to do is when an item is...

Hi guys and gals! I have a dilema that I have been looking at for days now and still can't see the wood for the trees. I have a databse that monitors vehicle maintenance, servicing schedules and stuff like that. My problem is we purchase items for the vehicles and I am trying to link the items...

Can't do that becuase the jobdate is sometimes different from the service date, the jobs whether they be inspections or services or just brake pad change are taken from the work sheets so they are never today (now()) if you know what I mean.

Yes I know you shouldnt have duplicate valuse, let me explain. It is a vehicle database, one table holds the vehicle info, another keeps the work completed on that vehicle and another keeps the test dates of servicing etc. Everything works brilliantly sao worries there, I am just being lazy I...