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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Start App at first record in db

Status
Not open for further replies.
JackBurton07

JackBurton07

IS-IT--Management
Oct 17, 2007
75
GB
Hi I want to begin my application at the first record

is this correct? thanks !

sub frm_main

myrecordset.open( select* from "client" where bof)

 
Sort by date Sort by votes
No it isn't. You need to use ORDER BY and the list the fields and whether you want them ascending or descending.
'The first record' doesn't really make sense in many ways.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
delete first line in txt and rewrite
Replies
2
Views
340
sal21
sal21
sacsac
  • Locked
  • Question
Commas in CSV fle
Replies
8
Views
462
gmmastros
gmmastros
sal21
  • Locked
  • Question
SORT DATE in msflexgrid not correct
Replies
4
Views
235
sal21
sal21
sal21
  • Question
CREATE msflexgrid as in xlsx file 2
Replies
8
Views
401
strongm
strongm
sal21
  • Question
WHY the sort dont work in msflexgrid
Replies
1
Views
163
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top