| Thread | Last Post | Replies |
|
| Message from macro if a particular item on a list is selected | 01 Sep 2008 00:29 GMT | 2 |
I am using Access 2003. I have a message in a Macro which I would like to appear when a particular word is selected from a drop down list. I can make the message appear when the particular field with the drop down list in it
|
| Form hangs access displaying caculating when loading | 31 Aug 2008 22:23 GMT | 4 |
I have an app written in 2000 that loads a form just fine. When I try to open it with Access 2007, the form hangs access displaying "Calculating . . . " in the status bar causing a Not responding state. The form has 4 tabs, 1 subform and several lookup fields in the primary tab.
|
| hide or unhide a control depending on the result of another | 31 Aug 2008 19:42 GMT | 1 |
I have developed a form that allows the user to append the current record to one of two tables depending on whether or not the steps are complete. The determining factor are some check boxes placed on the form I have also placed 2 cmd buttons for each check box. The first allow ...
|
| Multi Column Combo Box | 31 Aug 2008 19:41 GMT | 3 |
I've created a multi-column combo box, and the first column is the bound column feeding the info back to the table. However for some reason the first column does not display (i.e. looks blank) in the drop down. Once a value is selected, the onfo from the first column is displayed in ...
|
| Search box | 31 Aug 2008 18:32 GMT | 2 |
I am using Access 2003/ I have a very simple database, which contains in the text box in a form a name of a user "Ron Beacon" what I am looking for is coding to create a search box that will look for "Ron Beacon" using "Ron Be*" or like "Ron*". I really need to create a search ...
|
| Line Items for Invoices | 31 Aug 2008 09:21 GMT | 1 |
I have an Invoice table linked to a Products purchased table. I created a form showing the Invoice information and a subform to enter in the Products purchased. On the subform, a customer can purchase many products and I want the subform to generate a "Line Item" number for ...
|
| List Box | 31 Aug 2008 03:33 GMT | 7 |
I want to ensure that when people exit a form that in certain list boxes information must be entered is there are simple way to do this. Thanks
|
| Printing pictures in forms or report | 30 Aug 2008 19:11 GMT | 3 |
I developed an identification card for emloyees listed is a database, I linked to another table and created field formatedd as OLE object. when I try to print the ID, the background colors and the pictures are not printing. The display in the screen is fine and the foprm is set to ...
|
| use a list box to populate a text box | 30 Aug 2008 19:01 GMT | 6 |
I have table called "manifest" that has clients'names (first name etc...) , and I have another table called "programme". I have a form called "programmefrm" that has a text box called " clients names ". I usually input manually up 7 first names in this textbox "clients names" by ...
|
| Conditional format based on value in parent form | 30 Aug 2008 13:42 GMT | 1 |
I have a form with severaveal subforms, and what I want is: When a record is selected in one subform Then the format of the corresponding records in another subform is changed
|
| disable record selector for subform? | 30 Aug 2008 12:17 GMT | 2 |
I have a form that has a subform that has its recordsource to a table or query (in order for updates in the table to be reflected on the subform) Following this advantage there is a setback. The record selector is always visible. Is there a way to hide the record selector for the ...
|
| Incrementing serial number in a form | 30 Aug 2008 12:08 GMT | 2 |
There is a field named "serial_no" in a table called "tbl_register" which will get incremental values like 1, 2, 3 etc. for each record. The numbering will start from January each year and run serially till December. On January next year, the number will re-start from 1. There is a ...
|
| You cannot add or change a record because a related record is requ | 30 Aug 2008 08:00 GMT | 7 |
I have two tables joined with a many to one relationship. In the many table I have made a foreign key to match the key ID field in the one table. Then I made the foreign key a combo box with the row source the primary key in the one table but to show the info from a text box ...
|
| Dropdown that automatically adds new tables, button to empty data | 30 Aug 2008 02:53 GMT | 5 |
My database has many tables, all with the same structure, but different data. One master table "Table1", one master query "Query1", one master report "Report1". Source record for Query1 is Table1. Source record for Report1 is Query1.
|
| How to print mainform and subform together? | 30 Aug 2008 01:40 GMT | 5 |
I designed a form with a main form on top and a subform at the bottom. The main form is automatically populated by data from a query whereas the subform is linked to a blank table for data entry. When I printed the form, only the main form showed up in the printout. The subform ...
|