A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

step back through 'Find Next' records



 
 
Thread Tools Display Modes
  #1  
Old July 27th, 2006, 07:44 PM posted to microsoft.public.access.forms
madwoman via AccessMonster.com
external usenet poster
 
Posts: 3
Default step back through 'Find Next' records

Hi
I have a set of membership records which have data input via a simple form.
When looking for a particular record I use the standard CTRL+F on the whole
record set from the Form view, and move through the results using the Find
Next button. Is there a way to move back through the records when I have got
to the end of the results. eg. there may be numerous members with a surname
Smith and I can move through the Smith records by using Find and Find Next
but if I have moved past the record that I want is there a way of stepping
back through the records to a previous Find Next record?
Apologies if this is a really obvious question

--
Message posted via http://www.accessmonster.com

  #2  
Old July 27th, 2006, 08:04 PM posted to microsoft.public.access.forms
Dirk Goldgar
external usenet poster
 
Posts: 1,164
Default step back through 'Find Next' records

"madwoman via AccessMonster.com" u24541@uwe wrote in message
news:63e26f99ba96b@uwe
Hi
I have a set of membership records which have data input via a simple
form. When looking for a particular record I use the standard CTRL+F
on the whole record set from the Form view, and move through the
results using the Find Next button. Is there a way to move back
through the records when I have got to the end of the results. eg.
there may be numerous members with a surname Smith and I can move
through the Smith records by using Find and Find Next but if I have
moved past the record that I want is there a way of stepping back
through the records to a previous Find Next record?
Apologies if this is a really obvious question


I never really looked at that, but I don't think there is, using the
Find dialog. You could filter the form instead, and then just page
forward and backward through the filtered records.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


  #3  
Old July 27th, 2006, 08:07 PM posted to microsoft.public.access.forms
Jeff L
external usenet poster
 
Posts: 448
Default step back through 'Find Next' records

There is a drop down box labeled Search and you can change it to Up,
Down, or All. If you go past the record, you could change it to Up to
go back up.

Hope that helps!

  #4  
Old July 27th, 2006, 08:16 PM posted to microsoft.public.access.forms
Dirk Goldgar
external usenet poster
 
Posts: 1,164
Default step back through 'Find Next' records

"Jeff L" wrote in message
ups.com
There is a drop down box labeled Search and you can change it to Up,
Down, or All. If you go past the record, you could change it to Up to
go back up.


Duh! You're right -- how did I forget that!?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


  #5  
Old July 27th, 2006, 08:43 PM posted to microsoft.public.access.forms
madwoman via AccessMonster.com
external usenet poster
 
Posts: 3
Default step back through 'Find Next' records

Hi thanks for that...I should have known that one.


Dirk Goldgar wrote:
Hi
I have a set of membership records which have data input via a simple

[quoted text clipped - 7 lines]
through the records to a previous Find Next record?
Apologies if this is a really obvious question


I never really looked at that, but I don't think there is, using the
Find dialog. You could filter the form instead, and then just page
forward and backward through the filtered records.


--
Message posted via http://www.accessmonster.com

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:06 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.