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!

Returning 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
2009luca
  • Locked
  • Question
using edge instead IE
Replies
4
Views
280
sal21
sal21
Niki_S
  • Locked
  • Question
How to read an excel file using VB 6?
Replies
17
Views
489
strongm
strongm
Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
295
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top