Search results

Actually even better than saying DoCmd.Requery "Commodity_Division" is: Me!Commodity_Division.Requery It runs faster that way because it doesn't have to close and then re-open the query from the database.

How typical?! I post a question and then figure out the answer myself. I thought I would post the answer myself in case anyone else has had this problem. The combo box (Commodity_Division) is dependent on 2 other choices from 2 other combo boxes. the second of those two has an afterupdate...

I have a combo box for which the Record Source is an SQL Statement. What is displayed in this combo is the result of selections made in 2 other combos on the same form. All the SQL works fine. When I make my selections from the other combos, the correct (single) selection appears in the first...

I am generating reports that include individual name and address fields (ie. Salutation, Fname, Lname etc). What I wind up with however is a large space after the first name before the last name if the first name is small. Are there any variations or alternatives to the Gan Grow/Shrink...

I have a graph based on a query. It's quite straightforward, a calculation of an average percentage per person per month. The query works fine up to the Print Preview, but somewhere between the preview and the print job the data refreshes. The test data that I'm working from is the month of...

I have a report that prints out 3 to 4 records dependent on criteria selected by the query including date and names. Each of the records has a total percent field which represents the total mark/grade for that record. This field is bound to the underlying table. I would like to show an...