[AccessD] Counting Records on Form (when Nav buttons are turned off)

Stuart McLachlan stuart at lexacorp.com.pg
Thu Sep 4 01:32:59 CDT 2008


One way:-

Two text boxes in the form's Footer:
txtCurrent and txtCount

Set txtCount's control source to "=Count([ID])"
where [ID] is a field in the forms recordset

txtCurrent is unbound.

Insert the following  in the form's On_Current event:
Private Sub Form_Current()
txtCurrent = Me.CurrentRecord
End Sub



On 4 Sep 2008 at 15:27, Darryl Collins wrote:

> Hi All,
> 
> Am sure this is easy (which usually means it turns out to be absurdly complicated!!).  I have my own custom Nav button on the bottom of a form, but it would be nice to have: "Record x of y" showing somewhere down the bottom like it does when you have the built in Nav buttons visible.
> 
> I tried to search for this, but I must be getting the syntax wrong (or the words are too common - not really getting the results I need).
> 
> Any pointers?
> 
> Cheers
> Darryl
> 
> This email and any attachments may contain privileged and confidential information
> and are intended for the named addressee only. If you have received this e-mail in
> error, please notify the sender and delete this e-mail immediately. Any
> confidentiality, privilege or copyright is not waived or lost because this e-mail
> has been sent to you in error. It is your responsibility to check this e-mail and
> any attachments for viruses.  No warranty is made that this material is free from
> computer virus or any other defect or error.  Any loss/damage incurred by using this
> material is not the sender's responsibility.  The sender's entire liability will be
> limited to resupplying the material.
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

-- 
Stuart Mclachlan





More information about the AccessD mailing list