Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Sunday, January 04, 2015 – Permalink –
Display the Current Record Number
You may want to remove the navigation buttons from an Access form but still display the current record number. Not the ID or serial number, but the record number that would appear in the navigation box.
To provide this feature, you can use VBA to place the form's CurrentRecord value in an unbound text box, and then update the value during the Current event.
To utilize this property, add an unbound text box to your form in Design view. Then, on the Event tab of the form's Property list, click the ellipsis or Build button. Choose Code Builder.
Add the following code in the Visual Basic Editor:
(where MyTextBox is the name of the control that displays the record number.)
Now, when you navigate from record to record, the MyTextBox control will update automatically to reflect the current number.
See all Topics access
<Doug Klippert@ 3:34 AM
Comments: Post a Comment