Microsoft Access Visual Basic coding help

[divx]

on access forms, at the bottom (status bar) display "Record 1 out of 10000", where is the 2 number variable stored in? I'd like to display that as a label on the main form, rather then looking at the small text at the bottom.

this is what I want to do, (not exactly as shown)

Page_Label.Caption = Current Record # + "Out of" + Total # of Records

the problem is I can't find the object of which those two variable are stored in, spent 2 days on msdn and no luck. Too bad Access only allow vb code, I'd rather use C#, C++, or Delphi

If anyone knows about Access and VB, your help is very much appreciated. Thank you.

[ronny1980]

dude wrong forum

[divx]

Oops, it suppose to be in OT

[kingsley]

Wish I could help but without the code I can't do much.

[guest10586]

Why don't you just make an autonumber in the table for the current record number in the form and do a count([autonumber]) to get the maximum number of records.

I used to be wicked at access but I haven't made anything in access in a while... I used to be able to do anything in it... Hope that helps.

[blexann]

worst programming lanuage ever

[chatbox]

You're looking at AbsolutePosition and RecordCount of a Recordset.

[chatbox]

worst programming lanuage ever

LoL....please explain...?

[blexann]

its a microsoft thing - if youve programmed in other languages u should know what i mean.

[divx]

You're looking at AbsolutePosition and RecordCount of a Recordset.

AbsolutePosition and RecordCount are integer variables right? It can be accessed by Recordset.AbsolutePosition and Recordset.RecordCount?

does the object Recordset automatically recognize the currect data source? there is lots tables and quaries, it uses the current data source right?

So I would write as this

Page_Label.Caption = Recordset.AbsolutePosition + "Out of" + Recordset.RecordCount

currect? I won't be able to find out until monday, when i test it out at work

[guest10586]

LoL....please explain...?

He can't seem to fatham any other language other then C or Java.... I hope you're not a computer nerd... Man, I swear those guys are weird..."Lynx and Macs are cool, Windows sux."

[grant]

worst programming lanuage ever

He must be, to be making silly generalizations like that. Ignore him.

[chatbox]

He can't seem to fatham any other language other then C or Java.... I hope you're not a computer nerd... Man, I swear those guys are weird..."Lynx and Macs are cool, Windows sux."

Not the nerdy type...just good (if I may say so) at it.

[chatbox]

AbsolutePosition and RecordCount are integer variables right? It can be accessed by Recordset.AbsolutePosition and Recordset.RecordCount?

does the object Recordset automatically recognize the currect data source? there is lots tables and quaries, it uses the current data source right?

So I would write as this

Page_Label.Caption = Recordset.AbsolutePosition + "Out of" + Recordset.RecordCount

currect? I won't be able to find out until monday, when i test it out at work

Depending on how the form is designed. You'll need to grab the recordset that's in use within the form. Sometimes, you will see multiple recordsets within the same form by the use of different controls.

What you can do is this:
Add an action sub-routine for the form's Change (or whatever action, can't remember exactly)event, or form's Update, or form's RecordChange event...or something...
Have the routine read in the status bar text, check if the text is in the form of "xxx of xxx records", if so, then replace the text with what you want (and this will give you the two values that you need). This is probably an easier way to get what you want rather than dealing with recordset.

[guest10586]

Not the nerdy type...just good (if I may say so) at it.

Not u, other dude.