Search results

The report groupings is where you need to break the report into the sections from the combo box. If you want just one value from the combo then filter the query by that one value. Post the db if the above is not clear!

use a totals query and select group by in the Totals line for NGR. Nitrate level field select avg.

zip up the db and post it here and I will look at it for u?

all u need to do is set the 2nd combo box enabled to no in the properties then on change event on the 1st combo box put the following: if me.combo1.value="whatever?" then me.combo2.enabled=true else me.combo2.enabled=false end if

see attached

Me.cmdNext.Enabled = True

Please be a bit more specific with your request and post a zip of the db if possible??

the combo returns detail for the main account. there must be a link id between main account and sub accounts. So create another form with the sub account details on and then use that form as a sub form to the main account form and requery on change of the combo.

Dear all, My DBA has created two views in Oracle for me to connect to called vvvActuals & vvvBudgets. The access system that needs to connect is a single mde file which is used by 40 users. The last time I attempted this I had to change regedit setting on NT in order to limit the list of...

Dear all, I have a attached my db so someone can give me advice on structure? I want to book out apartments but I am stumped on how to stop the same apartment being double booked? Thanks Mark

ok, what i want is to record which weeks a contractor is going to spend time in the apartment they have purchased from me so i can bill them for maintenance on a weekly basis and when the contractor hires out their apartment I want to bill the customer of the contractor for maintenace? Thanks Mark

Dear all, I need a little advice please. I have many properties for sale. Each property is charged a weekly maintenance charge. When the owner has let the property then the person who let it pays the maintenance. My thoughts are: tblProperty tblBookings tblCustomer I would like some help...

Pat, Can u look at my A2002 crash post please?

Dear all, I am using a converted 97 db in a2002, I have a main form called frmDocumentRegister with a tab control on with many sub forms. I have placed the following code in one of the controls and the db keeps crashing after update: Private Sub ApprovedBudget_AfterUpdate()...

Dear all, I am using a converted 97 db in a2002, I have a main form called frmDocumentRegister with a tab control on with many sub forms. I have placed the following in one of the controls and the db keeps crashing after update: Private Sub ApprovedBudget_AfterUpdate() Me.listbox206.Requery...

Pat, The same thoughts crossed my mind and I guess instead of offering advice on the initial problem I should look at the bigger picture, like your good self! I agree that the design looks to be the problem.

Well so long as your forms are built on a query and that query has the status field then you can: 1) Insert a combo box with the record source showing the status. 2) On_Change Event of the combo me.frmName.requery 3) In the underlying query reference the combo box in the status field criteria.

Thanks for that mate! but not for the cricket thrashings over the past decade!!!

Dear all, Using code like the sub section below I am trying to check the content of the rngVariable against strCriteria but my code will just not pick up any of the strCriteria. What am I doing wrong??? strCriteria = "In...

sorry all