| Thread | Last Post | Replies |
|
| Opening a report from a form | 20 Apr 2006 20:56 GMT | 3 |
OK, my brain must be fried because I can't seem to get this to work properly. I have an unbound form with a combo box and a command button that I wish to use to open several reports. I have tried unsuccessfully to make the report open to show all records if
|
| How do I populate a control from data in another control? | 20 Apr 2006 20:05 GMT | 6 |
Hi I have a check box control [COPD] and a memo control [Problem List] in a subform. I would like the [Problem List] control to be populated with the word "COPD" everytime the [COPD] check box is checked. In the same manner I would like it to clear [Problem List] if [COPD] is ...
|
| Preventing Sort Changes | 20 Apr 2006 19:07 GMT | 1 |
Is it possible to configure a form prevent changes to form sorting or filtering being saved unless in design view?
|
| Subtotals in forms | 20 Apr 2006 19:05 GMT | 2 |
I have the following problem which I can not figure out. I have a database in which I have products which are also assigned to product groups. What I would like to do is to create a form in which I could have all products listed and at the end of each group a subtotal. e.g.:
|
| Find Completion Date | 20 Apr 2006 18:31 GMT | 2 |
I'd like to show in a text box [CD] what the completion date will be if a user enters in the start date [SD] and the estimated work hours [EH]. I hope to do this excluding weekends and with the 8 hour workday as a standard. Thank you for your help.
|
| forms subform filters | 20 Apr 2006 18:12 GMT | 1 |
Subform filter creating parameter at open of form. Have two tables StylePc and Chopsheet. For each StylePC there are many entries in the Chopsheet. Tables are linked by StylePC. Form is based on StylePC and has subform Chopsheet. Records are calling up
|
| "Select Distinct" in combo box | 20 Apr 2006 17:50 GMT | 1 |
Hello, I am an Access beginner trying to build a database and I'm stuck. I have a tblCenterInfo with information organized by the field CenterNumber (the primary key). I have a form based on a query of tblCenterInfo, the query with a paramater value [Enter CenterNumber]. I've ...
|
| Attaching Documents | 20 Apr 2006 17:26 GMT | 17 |
I would like to provide my users the ability to 'attach' a document from Word or Excel to a record. Is this possible?
|
| Center pop-up form on screen ? | 20 Apr 2006 16:24 GMT | 1 |
When I opens a pop-up form, I want it to startup in the middel of the screen, insted of in the corner of the screen. How can I do this ?
|
| Is Null/Is Not Null only options when doing a Filter | 20 Apr 2006 15:49 GMT | 2 |
I did not setup this database but I am now the one working with it. I used to be able to filter by form and click on the drop down menu and selet any of the names that I have entered to be my filter. Now all I get is a choice of is: Is Null/Is Not Null
|
| Listing Field Descriptions in List Box | 20 Apr 2006 15:06 GMT | 4 |
I have two list boxes on a form. One lists the tables in the database, the second lists the corresponding fields of the table selected in listbox 1. However, field names are short and difficult to understand. How can I have the second list box list what is typed in the 'field ...
|
| Trimming problem | 20 Apr 2006 15:05 GMT | 2 |
I am using a text box for a password (with Input mask as Password).The text box is trimming the trailing spaces(spaces after the word) but not the leading spaces(spaces before the word).I don't want the Access to trim the trailing spaces also.
|
| Auto Fill Control | 20 Apr 2006 15:02 GMT | 5 |
I trying to autofill a control with the value from another control. After which I would like to lock the original control so that it may not be altered anymore, but the second control can be altered from then onwards. Currently I can auto fill using the original value but cannot ...
|
| Data Validation To Prevent No Entry | 20 Apr 2006 14:58 GMT | 3 |
I have a form which i used to collect data used by an update query. When I click a button on the form I trigger a macro that opens the query. The form passes parameters to the query. When the button is pressed I want to validate that an entry has been made in a specific text box. ...
|
| Subform and Tab Order | 20 Apr 2006 14:47 GMT | 2 |
I have a form which contains a subform. I want users to be able to 'Tab' through the textboxes on the subform and then have the cursor move on to the texboxes on the form as 'Tab' continues to be pressed. I have used the following code in the last textbox on the subform's ...
|