How to show rows above an input record number

[Colin Hayes]

Hi

In my query , I want a popup to ask for a record number , and then
display all the rows above that number looking down the autonumber
column. I'm a little stuck for syntax - I'm hoping someone can help.

I'm using this presently in the autonumber column :

Like [Show Records Above : ] & "*"

This gives the popup but then doesn't show all the records equal to or
above the number entered. I've tried several variations on the formula ,
with no success.

Grateful for any assistance.



Best Wishes

 

[Jeff Boyce]

Colin

Define "above"...

Access uses tables to store "buckets o' data", without any particular
sequencing/order.

You have to tell Access to use a particular field to sort by ... and "record
number" means different things to different folks. Some folks imagine that
the count in the bottom left is actually a record number ... NOPE!

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Ron2006]

if the field is indeed an autonumber field then the test/condition
should be:

< [[Show Records Above : ]

This is because an autonumber field is a number not text.

 

[Colin Hayes]

if the field is indeed an autonumber field then the test/condition
should be:

< [[Show Records Above : ]

This is because an autonumber field is a number not text.

Hi

OK , that's got it. Thanks for your expertise - it works perfectly.



Best Wishes

 

[Colin Hayes]

Hi Jeff

Thanks for getting back.

It's looking down the autonumber column , so it's all records with an
autonumber greater than the input number. That's what I had in mind.



Best Wishes


Colin

Colin

Define "above"...

Access uses tables to store "buckets o' data", without any particular
sequencing/order.

You have to tell Access to use a particular field to sort by ... and "record
number" means different things to different folks. Some folks imagine that
the count in the bottom left is actually a record number ... NOPE!

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi

In my query , I want a popup to ask for a record number , and then display
all the rows above that number looking down the autonumber column. I'm a
little stuck for syntax - I'm hoping someone can help.

I'm using this presently in the autonumber column :

Like [Show Records Above : ] & "*"

This gives the popup but then doesn't show all the records equal to or
above the number entered. I've tried several variations on the formula ,
with no success.

Grateful for any assistance.



Best Wishes

 

[Colin Hayes]

if the field is indeed an autonumber field then the test/condition
should be:

< [[Show Records Above : ]

This is because an autonumber field is a number not text.

Hi

BTW Can this be modified to ask for records between two input
autonumbers , do you know?



Best Wishes

 

[Jeff Boyce]

Colin

Between [lower number] And [higher number]


Regards

Jeff Boyce
Microsoft Office/Access MVP

if the field is indeed an autonumber field then the test/condition
should be:

< [[Show Records Above : ]

This is because an autonumber field is a number not text.

Hi

BTW Can this be modified to ask for records between two input autonumbers
, do you know?



Best Wishes

Hi

OK , that's got it. Thanks for your expertise - it works perfectly.



Best Wishes

 

[Colin Hayes]

Colin

Between [lower number] And [higher number]


Regards

Jeff Boyce
Microsoft Office/Access MVP

HI Jeff

OK thanks for that.

I was hoping to do this via a popup input on the autonumber column.

Is this possible?



Best Wishes

if the field is indeed an autonumber field then the test/condition
should be:

< [[Show Records Above : ]

This is because an autonumber field is a number not text.

Hi

BTW Can this be modified to ask for records between two input autonumbers
, do you know?



Best Wishes

Hi

OK , that's got it. Thanks for your expertise - it works perfectly.



Best Wishes

 

[Steve]

Create a pop-up form named PFrmHIghLowNumber. Put two textboxes on
PFrmHIghLowNumber and name one HighNumber and the other LowNumber. Add some
code to check that a number is added in both textboxes when you use the
form. Put the following expression in the criteria of your autonumber field:
Between Forms!PFrmHIghLowNumber!LowNumber And
Forms!PFrmHIghLowNumber!HighNumber.

Steve

Colin

Between [lower number] And [higher number]


Regards

Jeff Boyce
Microsoft Office/Access MVP

HI Jeff

OK thanks for that.

I was hoping to do this via a popup input on the autonumber column.

Is this possible?



Best Wishes

if the field is indeed an autonumber field then the test/condition
should be:

< [[Show Records Above : ]

This is because an autonumber field is a number not text.



Hi

BTW Can this be modified to ask for records between two input
autonumbers
, do you know?



Best Wishes








Hi

OK , that's got it. Thanks for your expertise - it works perfectly.



Best Wishes

 

[Colin Hayes]

Create a pop-up form named PFrmHIghLowNumber. Put two textboxes on
PFrmHIghLowNumber and name one HighNumber and the other LowNumber. Add
some
code to check that a number is added in both textboxes when you use the
form. Put the following expression in the criteria of your autonumber field:
Between Forms!PFrmHIghLowNumber!LowNumber And
Forms!PFrmHIghLowNumber!HighNumber.

Steve

Hi Steve

Thanks for getting back , but that's way beyond my small abilities , I'm
afraid.

Best wishes

Colin

Between [lower number] And [higher number]


Regards

Jeff Boyce
Microsoft Office/Access MVP

HI Jeff

OK thanks for that.

I was hoping to do this via a popup input on the autonumber column.

Is this possible?



Best Wishes

if the field is indeed an autonumber field then the test/condition
should be:

< [[Show Records Above : ]

This is because an autonumber field is a number not text.



Hi

BTW Can this be modified to ask for records between two input
autonumbers
, do you know?



Best Wishes








Hi

OK , that's got it. Thanks for your expertise - it works perfectly.



Best Wishes

Are you aware that we also buy CDs, Vinyl and DVDs? Send your lists of
unwanted items to (e-mail address removed) and we’ll quote you a price…


You can browse and buy direct from my full list of items at these addresses :

http://s1.amazon.co.uk/exec/varzea/ts/my-zshop/SPJK3X6KOJZR6/026-3393902-9
050050

or:

http://www.CDandVinyl.co.uk

or :

http://www.netsoundsmusic.com/chayes

or:

http://chayes.musicstack.com



To DOWNLOAD the full catalogue click here :


http://www.chayes.demon.co.uk/CDandVinyl_full_catalogue.exe



Best Wishes ,

Colin Hayes.



TEL / FAX : (UK) (0)208 804 9181

 

[Steve]

Hi Colin,

It's not too hard!!

1. Open your database to the database window and go to Forms.
2. Click on New and in the dialog that appears, select Design View.
3. Click OK.
4. A raw form will appear. Click on the Properties button in the menu and
go to the Other tab.
5. Change Pop-Up to Yes.
6. Close Properties
7. Click on the Toolbox button
8. Click the textbox (ab) then draw a textbox on your form.
9. While your new textbox is selected, Click on the Properties button in
the menu and go to the Other tab.
10. Change the Name to "LowNumber"
11. Close Properties
12. Click on the Toolbox button
13. Click the textbox (ab) then draw a textbox on your form.
14. While your new textbox is selected, Click on the Properties button in
the menu and go to the Other tab.
15. Change the Name to "HighNumber"
16. Close Properties
17. Close the form. Click Yes to save the form.
18. Access will then ask you for a name for the form. Type in
PFrmHIghLowNumber.
19. Put the following expression in the criteria of your autonumber field:
Between Forms!PFrmHIghLowNumber!LowNumber And
Forms!PFrmHIghLowNumber!HighNumber.
Note: That is all one line.

Steve

Create a pop-up form named PFrmHIghLowNumber. Put two textboxes on
PFrmHIghLowNumber and name one HighNumber and the other LowNumber. Add
some
code to check that a number is added in both textboxes when you use the
form. Put the following expression in the criteria of your autonumber
field:
Between Forms!PFrmHIghLowNumber!LowNumber And
Forms!PFrmHIghLowNumber!HighNumber.

Steve

Hi Steve

Thanks for getting back , but that's way beyond my small abilities , I'm
afraid.

Best wishes

Colin

Between [lower number] And [higher number]


Regards

Jeff Boyce
Microsoft Office/Access MVP

HI Jeff

OK thanks for that.

I was hoping to do this via a popup input on the autonumber column.

Is this possible?



Best Wishes






if the field is indeed an autonumber field then the test/condition
should be:

< [[Show Records Above : ]

This is because an autonumber field is a number not text.



Hi

BTW Can this be modified to ask for records between two input
autonumbers
, do you know?



Best Wishes








Hi

OK , that's got it. Thanks for your expertise - it works perfectly.



Best Wishes

Are you aware that we also buy CDs, Vinyl and DVDs? Send your lists of
unwanted items to (e-mail address removed) and we'll quote you a price.


You can browse and buy direct from my full list of items at these
addresses :

http://s1.amazon.co.uk/exec/varzea/ts/my-zshop/SPJK3X6KOJZR6/026-3393902-9
050050

or:

http://www.CDandVinyl.co.uk

or :

http://www.netsoundsmusic.com/chayes

or:

http://chayes.musicstack.com



To DOWNLOAD the full catalogue click here :


http://www.chayes.demon.co.uk/CDandVinyl_full_catalogue.exe



Best Wishes ,

Colin Hayes.



TEL / FAX : (UK) (0)208 804 9181