Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: 384437
- Order by date
-
Clear contents of a Form when opening
Hi You could always open the form in add new entry mode I.e. DoCmd.OpenForm "formname", acNormal, , , acFormAdd This would bring up a blank sheet. Then in the code for the combo box put it so that when you select an option the form closes and then opens again in edit or read only...- 384437
- Post #2
- Forum: Microsoft: Access Forms
-
Change a cell format based on information in the cell
Hiya You could have somthing as simple as the following contected to a button. You can obviously add to this by add 'elseif (statement)'. I hope this helps. Andy Code: Sub Button1_Click() If ActiveCell.Value = "40" Then Selection.Font.ColorIndex = 3 With Selection.Interior...- 384437
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
