Search results for query: *

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

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

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

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

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

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

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

On SharePoint 2003 (& Windows 2003) on an Intranet, when attempting to upload an Access database to a SharePoint document library, I get the message "Form Validation Error... The following file(s) have been bocked by the administrator: [my database]" It's an in-house server, and the IT guy...

In a Word 2003 macro, I want to create a macro to perform as follows: open the Insert File dialog box change to a specific drive/subdirectory then stop so the user can browse to the appropriate file (which varies) either end there or pause until the user finds the correct file and then resume...