Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting a recordset of random records using DAO

Status
Not open for further replies.
cadore

cadore

Programmer
Nov 1, 2000
5
US
I'm trying to pull 100 random records from a table of 1000 (Access) using DAO. I can get it to work in Access using a funcion call within the SQL statement but it wont work in VB6. I get a function undefined error. Any suggestions ?
 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
UPDATE DAO RECORDSET 1
Replies
11
Views
415
strongm
strongm
sal21
  • Question
FILL RICHTEXTBOX WITH RECORDSET
Replies
4
Views
301
strongm
strongm
Ken01
  • Locked
  • Question
Extraction of Picture box point / pixel colors. 3
Replies
13
Views
2K
klima
K
sal21
  • Locked
  • Question
get controll type, controll name from the second panel of SStab 1
Replies
4
Views
601
strongm
strongm
2009luca
  • Locked
  • Question
CHECK color of shape 2
Replies
5
Views
348
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top