Search results
-
T
How to set value of the bound textbox??
I have a textbox called txtSum, which is bound to the field Sum. Therefore, in its property, the control source would be Sum. The value for this textbox is supposed to be the total of two other textbox controls, say txtNum1 and txtNum2. And after user enter the value for these 2 boxes, the... -
T
Creating a form for adding data
Properties for the form: Record Source....Tbl_Employee Allow Filters........Yes Allow Edits..........Yes Allow Deletions...Yes Allow Additions...Yes Data Entry..........Yes Recordset Type...Dynaset -
T
Creating a form for adding data
1) Yes, I did change it to my own form. i.e: DoCmd.OpenForm "frmEmployeeAdd", acNormal, , , acFormAdd 2) I've checked the form, the navigation bar shows 1 (means first record) instead of the *. So, how do I revert it back to *? -
T
Creating a form for adding data
I've tried this adding this: DoCmd.OpenForm "frmYourForm", acNormal, , , acFormAdd & I can't use this DoCmd.GoToRecord, , acNewRec in form_load because my data is displayed as columnar, not tabular. That's why can't go to add new record. I really don't have a clue of what's the problem. -
T
Creating a form for adding data
I've checked the default value. The default value is not set. I've also tried adding the acFormAdd but the result is still the same. Before this, the form is working fine until I changed the table structure. The table is actually linked from SQL Server. If possible, I prefer not to do any... -
T
Creating a form for adding data
I've created a form in Access for user to add in data. I've set the Property of DataEntry to yes. But when I open the form, the fields are pre-filled with the data of the first record. How can I make the fields to be blank? -
T
How to set the combo box to display the 3rd column after selected by user
I would like the user to see both fields, but after selected, the field that is displayed should be the 3rd one. It will be better if both columns are displayed but I think only one is allowed. -
T
How to set the combo box to display the 3rd column after selected by user
I've created a combo box in Access where I've set the Column Count = 3 and the Column Widths to 0";0.5";1.5". The first field is hidden as it is the ID. The 2 other fields are visible to the user. When the user select the record, the combo box will display the value in the 2nd column as the... -
T
How do I add to a drop down list
How to set the combo box to display the 3rd column after selection by user I've created a combo box in Access where I've set the Column Count = 3 and the Column Widths to 0";0.5";1.5". The first field is hidden as it is the ID. The 2 other fields are visible to the user. When the user select...