Hi Art,
Did you see my previous message?
You need a mechanism to update the status bar. It could
be any suitable Event that occurs at the time that you
want it to be updated. My example suggested the
Form_Current Event to write the value to the StatusBar
and the Form_Close Event to Clear the StatusBar. That
would cover addding deleting or filtering that could
affect the RecordCount.
NoteYou would not want to leave a message like "27 Recs"
showing after the form has closed.
What does the Spec say about the StatuBar?
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini <dbalorenzini@...> wrote:
>
> John,
> It's not my choice, its in the specs. Are their events that can be accessed for the status bar?
>
>
>
> With warm regards,
>
> Arthur Lorenzini
> Sioux Falls, South Dakota
>
>
>
>
>
>
> ________________________________
> From: John Viescas <JohnV@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Tuesday, March 27, 2012 10:15 AM
> Subject: RE: [MS_AccessPros] Re: Working with the status bar
>
>
>
> Â
>
> Art-
>
> Why not just display the Navigation Buttons?
>
> Or, you could try in a text box in the header or footer:
>
> =Count(*)
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> --------------------------------------------
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art
> Sent: Tuesday, March 27, 2012 5:04 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Working with the status bar
>
> Â
> So any ideas or i it even possible?
>
> --- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@> wrote:
> >
> > I have a countinous form and would like to have the count of records displayed
> on the form placed on the status bar such as "20 Records displayed" Is this
> possible?
> >
> > Thanks,
> > Art Lorenzini
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar