Search results for query: *

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...

Yes, I'm using a command button. I put your code in the command button on click event. (Is that the right place?) But what happens is that then the report opens in one page-fit view. When I change fit to 100%, the dead space around the report is there again. Here's my code: Private Sub...

My report itself looks fine. However, the report (white page) does not start at the top of the screen. I have to use the scroll bar to get to the report. I'm wishing for something like a "full" view option. Using the one page button, Fit shows the text too small, so I've tried 100% and 150%, but...

Skip, I recognized that hyperlinked text from Access 2002 Desktop Developers Handbook; thanks. Willir, I appreciate the level of detail. I needed that and more, but I finally got it working. SNicholls

My main table is a list of projects completed. The primary key is ProjectName. Each ProjectName has Staff (more than one). Each Staff has a specific Role in this project; the role may be different for a different project. In addition, each Staff has a yes/no field (does staff have a resume on...

Thanks; we really appreciate the help.