Recent content by jackerman

I am building a small access application and would like to create a button that allows the user to repair and compact the database periodically.  Ive tried using the DBEngine.RepairDatabase / DBEngine.CompactDatabase methods but they error out - saying the database must be...

Elizabeth:<br><br>There actually is no scroll bar (because it's not displaying in datasheet view), but you can use the record selectors to go up to the first row.&nbsp;&nbsp;But because this is an application for an end user, I need to hide the record selector.<br><br>Thanks for replying

Cornerstone's solution should work fine, but if it doesn't try to make the four fields empty strings instead of null.<br><br>If mycheckbox = False Then<br>&nbsp;&nbsp;&nbsp;field1 = &quot;&quot;<br>&nbsp;&nbsp;&nbsp;field2 = &quot;&quot;<br>&nbsp;&nbsp;&nbsp;field3 =...

I have a main form with a subform which is supposed to display six rows of data (form view - not datasheet (from query)).&nbsp;&nbsp;When the form loads, it shows all six rows of data, but if you leave the cursor in the 2nd, 3rd, 4th, 5th, or 6th row and reload the subfrm, it (the subform)...