| Thread | Last Post | Replies |
|
| bad subform link | 11 Oct 2007 19:21 GMT | 8 |
I've got a scoresheet main form with a subform that is continuous score forms. The links are TruckId, Judge & ClassId. But it's not linking correctly. Whenever I move to the next scoresheet main form, the subforms are still the same (same TruckId, Judge & ClassId as
|
| How can I create a Sales form that can update both the Product and Sales Tables | 11 Oct 2007 18:22 GMT | 7 |
Am creating a Product-Sales Database, and I would like the corresponding Sales made in the Sale Table to be automatically deducted or to be reflected in the Product Table. The product table contains all my stock and has a relationship with the Sales Table. The Sale Table does not ...
|
| date controls | 11 Oct 2007 17:40 GMT | 2 |
I have a date field ona form that I'm trying to prevent the user from entering dates in the past. On the AfterUpdate event I wrote the following code as a warning message if they pick a date older than current:
|
| Auto fill of related fields in a form | 11 Oct 2007 17:17 GMT | 6 |
My quandry: I wish to auto fill related fields in a form. The fields are "employee name" and "employee number". I'd like to select the name from a combo box (bound to a very simple two column table) which displays the emp. name and corresponding emp. number, and then have the ...
|
| Forms and Subforms | 11 Oct 2007 17:12 GMT | 5 |
I would like to create a form that has an Occupation drop down box at the top of the form. The Occupation drop down has 10 values. When the user selects a value from the Occupation drop down, I would like to display all records in a table where Occupation = the selected value in ...
|
| Equipment Library Database | 11 Oct 2007 16:17 GMT | 8 |
I need to create an Equipment Library Database, does anybody have a sample database I could look at for some ideas. An equipment library is the same as a book library but instead of books we loan medical equipment.
|
| Form with tabs | 11 Oct 2007 15:50 GMT | 3 |
I have a form with 5 tabs and I currently have several issues: 1) users are not filling out all the fields on the main form which are used to link the data in the tabs (5 different tables) I've put checks on the main form to prompt if a field is left blank as the user moves ...
|
| calculate age from DOB | 10 Oct 2007 22:57 GMT | 1 |
Please post the exact calculation for DOB "Date of Birth" in the unbound box, so if will show years, months, and days of age from DOB to next Birthday.
|
| #Name? - Change when appears | 10 Oct 2007 22:31 GMT | 2 |
I have a form based on a query. The query output will change depending on the user selection of associated data used by the query. The form fields contains all variations. When the query does not supply the data for the form, #Name? appears in the form field. The form is ...
|
| limit one list box data set based on selection in another list box | 10 Oct 2007 22:13 GMT | 3 |
I am using Access 2k to resolve a form problem where multiple list boxes are partially dependant on the value(s) in other list boxes. I keep reading that an unbound list box can be populated with data from the value of another list box, but how to do it is not explained.
|
| Creating a form for a Password | 10 Oct 2007 22:01 GMT | 1 |
I have created a Password form that will secure another form. Once the password is entered it will open the form that has the list of reports. On the form I have a text box that accepts the user's password and I have 2 command buttons one is OK and the other is CANCEL. Can ...
|
| Combo box not showing all fields | 10 Oct 2007 21:23 GMT | 2 |
I am using Acc03 one of the combo boxes on a form is not showing all of the fields, when the list is viewed. In the combo box cboAppetite, there are 9 fields, only the combo box field will save the others are for display only. When the combo box is selected only the data in ...
|
| Wizards not showing up | 10 Oct 2007 20:58 GMT | 2 |
When I added a command button or a subform to a form in Access 2003, I used to get wizards that nicely walked me through all the steps I needed to use them, including actions for an added command button. Now they no longer appear.
|
| Field not showing up in tab order | 10 Oct 2007 20:54 GMT | 1 |
this question probably has a very simple solution: I'm a new user. I have added a field to a form, but the field name is not showing up in the tab order box, therefor I am unable to select it to change the order of the tabs. Access 2003.
|
| Locally Form appears Blank, Remotely Form is OK | 10 Oct 2007 20:50 GMT | 2 |
sWhen users pull a form from their desktop, the form is blank - only the title bar shows. None of the fields show - therefore they cannot enter data. However, when I log in remotely, the form appears fine -all of the fields. And data can be enterered. The system has been ...
|