Recent content by Maryanne

This is my intro to programming and the programmer at work who has been graciously helping me is on vacation. I am trying to program a subform to automatically set certain fields based on the criteria in the main form or earlier records of the subform. I made the changes my programming friend...

Don't understand your question.

Would adding a button linked to a macro that resets the combo box 'on-click' work?

Look at Pop-up forms and the modal on/off function. I usually put a button on my main form (customer form) which will activate the Pop-up.

have an Escalation database which has a subform which contains a series of price adjustments. The first price adjustment is based on the initial rate in the main form but I need to program the form so it calculates on the 'current rate' from the latest record in the subform. I have tried to...

You can use text boxes but the formatting is not the easy to control. I use "Publish It with MS Word" under Tools/Office Links... Then you just set up a mail merge letter.

I have a subreport/subquery that is based on a query that asks the user to input either 1999 or 2000. When I try to run the report, the parameter query repeats three times. Can I get the subquery to "get" the year from the main query?

I have a Contract Type column in my monthly report. I need to have a listing of all values returned in this column and a count of how many. How can this be done? eg. May PM Contracts: 5 TM Contracts: 2 June AG Contracts: 7 PM Contracts: 12

I have a RecordCount that totals each record in my detail, but I want to have one total in my 'Group by'Branch footer, and one 'subtotal' in my 'Group by' Industry footer. I can only get Access to display the subtotal from the last Industry in a Branch as the Branch Total. If I only try to...

I had a similar problem (which I didn't explain well). If you cannot create a query that links your other queries, then use reports/subreports. According to Access Help you can create an unbound main report and nest subreports in that if there are no fields that you can use to link a main...

I need to create a report based on up to 5 queries and have the results show in an executive summary page (with totals by section) and then list all the detail after. Would it be best to create seperate queries for each section and then one Very Big query for the report, or is there another...