Selecting All Records Using Command Button

[FCCC]

Hi,

I am trying to create a command button for "selecting all records" in the database. This is like you go to Edit->Select All form the MS Acess edit pulldown menu. I couldn't not find this action on the "command button wizard" so I thought that it is possible to make one.

Does anyone have an idea? Would appreciate any help.

 

[WildHare]

Well, you can't select ALL records in the database without opening up each table, but this might work on a table-by-table basis

DoCmd.RunCommand acCmdSelectAllRecords Ex-JimAtTheFAA
78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Neat Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[HowieG]

I haven't used this, but try:

DoCmd.RunCommand acCmdSelectAllRecords

 

[HowieG]

D'oh! Beaten by seconds...

 

[WildHare]

Ya gotta get up awful quick sometimes to beat the ol' Bunny to the punch...

Ex-JimAtTheFAA
78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Neat Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[FCCC]

Yuppppp, it works..

Thanks guys...