| Recent Answers |
 |
|
2008-09-01 Data Management & Storage - access vba: Use a SELECT CASE then. You can put the code in the On Current event of your form as well as the After Update event, this will set the colors as you cycle through the records. For the Report, use...
|
2008-08-29 Data Management & Storage - access vba: In the After Update event of the first combo use code like: If Not IsNull(Me.cboFirst) then Me.cboFirst.BackColor = Yellow Else Me.cboFirst.BackColor = White End If Use similar code for the second...
|
2008-08-26 Data Management & Storage - subform: Set up a WHERE cluase in your OpenForm method: doCmd.Openform "formname",,,"[Partnum] = " & Me.txtpartnum where [Partnum] is the name of the PK field oin your table and Me.txtpartnum the name of...
|
2008-08-21 Data Management & Storage - Hard drive: How big is the D? Some machines create a small recovery partition. As far as using the space, if its indeed open space, I would move all my data and programs to that drive. Uninstall your software and...
|
2008-08-19 Data Management & Storage - DB acess lockout: The best method is to split your database between backend (tables) and frontend (everything else). For the best performance the front end should be on the local drive. You then have a development front...
|