| Thread | Last Post | Replies |
|
| Find the record that matches the control. | 27 Jul 2007 14:14 GMT | 3 |
Hi. I have this code in a combobox to find a record. This is automatically generated from Access. It really works good. My problem is that my form that has this combobox control is in a form that is a sub-form. So when I open the form as mais form works ok, but if I open the form ...
|
| A form I made in access 2007 won't let me ad new records | 27 Jul 2007 12:24 GMT | 11 |
I have a form I've made won't let me click add a new record. I'm not sure what I changed because it used to work.
|
| How can I prevent user from resizing fields in subform ? | 27 Jul 2007 11:09 GMT | 1 |
If a user clicks on a column heading in a subform, he can then resize the field. How can I prevent the user from doing so? Thanks Mark
|
| Pre-fill controls in subsequent records of continuous form | 27 Jul 2007 10:18 GMT | 7 |
In a form (actually subform - but I don't think that makes a difference) in which multiple records all have mostly the same control information (except one control-StudentName) I would like all those other fields on the form to pre-fill with the previous record info. Now, they ...
|
| How can i simulate the code in Macro? | 27 Jul 2007 04:44 GMT | 6 |
I need to write in procedure code when the macro is truncated the criteria. I have two fields, and I would do in the macro on the subject of to open report in print preview format and its where criteria as follows: [hb] Like "*" & [Forms]![searchHearB]![Ssearch] & "*" Or [hb] Like ...
|
| Combo Box Columns - Selecting | 27 Jul 2007 00:51 GMT | 2 |
I am new user of Access 2003. I created a combo box with row source from a query. The 3 three fields from the query appear in the combo box; however, when I select a row, only the first column is displayed.
|
| Control Source Format for rounding | 27 Jul 2007 00:46 GMT | 1 |
I have a box that calculates discounts or allows me to enter a manual amount. The control source for it is :=IIF([Discount]<=0, [ManDisc], ([DisTx]+[DisNTx])). The last 2 fields handle taxable and non-taxable discounts. The fields (except for manual)are percentages. These ...
|
| Continous form input | 26 Jul 2007 23:46 GMT | 2 |
I have an empty table that I want to input data into, I would like to use a continous form and when one row in inputted it will jump to an empty row so user could just enter the next line. There are combo boxes for the user to select names or products from. The problem is when ...
|
| Currency format | 26 Jul 2007 22:30 GMT | 10 |
I have a field in my form with this control source: =[cboScreenCat].[Column](2) which gives me: 0
|
| List box with multi-select? | 26 Jul 2007 22:23 GMT | 2 |
I'm a .Net programmer who all of the sudden needs to do a litte work in Access 2003. It's quite straight forward, except for one thing: how do I do a ListBox with multi-select functionality?
|
| Combo Box default value | 26 Jul 2007 22:16 GMT | 3 |
I have table that stores group members and their relative information (name, supervisor, etc). I have created a query to find only the current members. I also have a table to store meeting attendance. I am developing a form for this table. I have 10 combo boxed to select a ...
|
| Best way to link popup form? | 26 Jul 2007 22:14 GMT | 6 |
I have a main form Form1 with another form Form2 that gets opened as a popup from a button on Form1. I want to know the best way to link these in a one-to-one relationship, so the data in Form2 relates to the data in Form1 through a shared key (ID).
|
| 2nd search box not sort properly after using 1st search box | 26 Jul 2007 22:06 GMT | 1 |
I have 2 combo boxes on a continuse form. One to search name and Other to search Department. Private Sub cboFind_AfterUpdate() ' Find the record that matches the control.
|
| one scroll bar to navigate in both form? | 26 Jul 2007 21:54 GMT | 2 |
I have two forms. First form allows data entry while the second form shows formulated data for each data row. I currently have the Master/child linked up correctly but some records have more then what can fit on a form. When I scroll in the main form the other form is stagnant ...
|
| How to open a popup form already filtered | 26 Jul 2007 21:42 GMT | 3 |
I have a form with a list of products. Each product has a unique product ID but could have several that have the same name and the only difference being (other then a different productID) is they are different colors.
|