Recent content by SNicholls

Thank you! SNicholls

I have a form (switchboard) that includes a command button to open a report. When I click the button to open the report, the report is set to maximize on open. When I close the report, the switchboard has resized itself to maximum. I want the switchboard to remain the original size. How can I...

A friend suggested an easy answer: use an update query and update click-to-select to no. Then I used a command button on click to run the query. SNicholls

Thank you both; but I tried each suggested code and nothing happens. There's no error message but the check marks are not removed. SNicholls

My users open a table and click on a yes/no field to select rows, which go into a report. I want to use a command button on click to uncheck the boxes for the next user. The table is Species the field is click-to-select. Could someone please give me, a nonprogrammer, the code to do this? I tried...

I need more basic help, please. My Access Bible 2003 says that to use multiple selections I need to "define a program to capture the selection." How do I do that? And then will I be able to query that field in the usual way? Thank you. SNicholls

In a database that contains a history of previous company projects, the data entry form includes a dropdown list of corporate offices from a lookup table. Users may query by office. (Users aren't familiar with Access; I provide command buttons to query [which office?] and produce the results in...

Yes! That fixed it. Thanks very much. Sabrina

I have a database of about 10 tables, 300 records. ProjectName is the primary field. There's a (single view) form that shows the data; it contains a lookup combo box to take the viewer directly to that item in the form. In the combo box, there's this AfterUpdate event procedure: Private Sub...

Someone erroneously entered data into an older version of a database. I need to bring all that data into the current database. The database has 10 tables - the main table + 7 "lookup" tables (two of which permit adding if the choice isn't there) + 2 join tables. Five of the lookup tables and the...

Finally got it right. Thanks very much!

That works with a standard query but with the form-query, it doesn't give the dropdown box choices.

In Access 2003, I usually provide a “query” button that is actually creating a report based on a query. But I wanted to offer choices on which to base the query. I created a very simple form: -a label that says “click below for search choices:” -followed by a combo box with a dropdown list...

I wonder whether it's something about how Access places objects on the screen rather than something related to a report. I noticed that any object I open is some distance down from the top of the page. Can this be set somewhere in Access? SNicholls

Is the white space there on purpose?? Not sure exactly what you mean; let me explain another way. When the screen is maximized and I use the "fit" view, the report fills the screen top to bottom but to the left and right of the report is background/blank. When I click 100% instead of fit, the...