Count Records - microsoft.public.access.formscoding

Count the records in the rowsource of the combobox: NumRecord = DCount("*","NameOfTheRowSource") PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications resource@pcdatasheet.com "John" <johnlee2509@btopenworld.com> wrote in message news:0E1DBE7E-AD54-4715-A547-EC2DDE9CDE39@microsoft.com... > Hi Guys, > How can I count records in a a combobox to allow me to scroll using the > slider bar without first having to scroll to the bottom of the list? > > Regards > > John >

Or, simpler and faster (and likely more accurate) NumRecord = Me!NameOfCombobox.ListCount -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Steve" <Sorry@private.emailaddress> wrote in message news:F7qni.8871$Od7.8171@newsread1.news.pas.earthlink.net... > Count the records in the rowsource of the combobox: > > NumRecord = DCount("*","NameOfTheRowSource") > > PC Datasheet > Providing Customers A Resource For Help With Access, Excel And Word > Applications > resource@pcdatasheet.com > > > > > > > "John" <johnlee2509@btopenworld.com> wrote in message > news:0E1DBE7E-AD54-4715-A547-EC2DDE9CDE39@microsoft.com... >> Hi Guys, >> How can I count records in a a combobox to allow me to scroll using the >> slider bar without first having to scroll to the bottom of the list? >> >> Regards >> >> John >> > >

HI Guys Thanks for the replies. I have put this code in the onclick event of the combobox but it does not seem to work. I am using access 2007, would this make a difference? Regards John "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message news:%23OpQ0CVyHHA.4928@TK2MSFTNGP03.phx.gbl... > Or, simpler and faster (and likely more accurate) > > NumRecord = Me!NameOfCombobox.ListCount > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "Steve" <Sorry@private.emailaddress> wrote in message > news:F7qni.8871$Od7.8171@newsread1.news.pas.earthlink.net... >> Count the records in the rowsource of the combobox: >> >> NumRecord = DCount("*","NameOfTheRowSource") >> >> PC Datasheet >> Providing Customers A Resource For Help With Access, Excel And Word >> Applications >> resource@pcdatasheet.com >> >> >> >> >> >> >> "John" <johnlee2509@btopenworld.com> wrote in message >> news:0E1DBE7E-AD54-4715-A547-EC2DDE9CDE39@microsoft.com... >>> Hi Guys, >>> How can I count records in a a combobox to allow me to scroll using the >>> slider bar without first having to scroll to the bottom of the list? >>> >>> Regards >>> >>> John >>> >> >> > >

What does "does not seem to work" mean? Are you getting an error message? If so, what's the error? If you're not getting an error message, what are you getting (and what do you expect to be getting)? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "John" <johnlee2509@btopenworld.com> wrote in message news:B836E99D-312F-4206-9832-A92031F1B494@microsoft.com... > HI Guys > Thanks for the replies. > I have put this code in the onclick event of the combobox but it does not > seem to work. > I am using access 2007, would this make a difference? > > Regards > > John > > > "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message > news:%23OpQ0CVyHHA.4928@TK2MSFTNGP03.phx.gbl... >> Or, simpler and faster (and likely more accurate) >> >> NumRecord = Me!NameOfCombobox.ListCount >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no e-mails, please!) >> >> >> "Steve" <Sorry@private.emailaddress> wrote in message >> news:F7qni.8871$Od7.8171@newsread1.news.pas.earthlink.net... >>> Count the records in the rowsource of the combobox: >>> >>> NumRecord = DCount("*","NameOfTheRowSource") >>> >>> PC Datasheet >>> Providing Customers A Resource For Help With Access, Excel And Word >>> Applications >>> resource@pcdatasheet.com >>> >>> >>> >>> >>> >>> >>> "John" <johnlee2509@btopenworld.com> wrote in message >>> news:0E1DBE7E-AD54-4715-A547-EC2DDE9CDE39@microsoft.com... >>>> Hi Guys, >>>> How can I count records in a a combobox to allow me to scroll using the >>>> slider bar without first having to scroll to the bottom of the list? >>>> >>>> Regards >>>> >>>> John >>>> >>> >>> >> >> >

Thanks for the Reply Douglas, Sorry for being vague. There are no error messages, I have changed the code to use the name of my combobox. If I drag the slder bar nothing happens, if I scroll to the last record I can then use the slider bar to move up and down. I want to be able to scroll through the combobox list without going to the last record. Reagrds John "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message news:OPEZjBWyHHA.5380@TK2MSFTNGP04.phx.gbl... > What does "does not seem to work" mean? Are you getting an error message? > If so, what's the error? If you're not getting an error message, what are > you getting (and what do you expect to be getting)? > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "John" <johnlee2509@btopenworld.com> wrote in message > news:B836E99D-312F-4206-9832-A92031F1B494@microsoft.com... >> HI Guys >> Thanks for the replies. >> I have put this code in the onclick event of the combobox but it does not >> seem to work. >> I am using access 2007, would this make a difference? >> >> Regards >> >> John >> >> >> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message >> news:%23OpQ0CVyHHA.4928@TK2MSFTNGP03.phx.gbl... >>> Or, simpler and faster (and likely more accurate) >>> >>> NumRecord = Me!NameOfCombobox.ListCount >>> >>> -- >>> Doug Steele, Microsoft Access MVP >>> http://I.Am/DougSteele >>> (no e-mails, please!) >>> >>> >>> "Steve" <Sorry@private.emailaddress> wrote in message >>> news:F7qni.8871$Od7.8171@newsread1.news.pas.earthlink.net... >>>> Count the records in the rowsource of the combobox: >>>> >>>> NumRecord = DCount("*","NameOfTheRowSource") >>>> >>>> PC Datasheet >>>> Providing Customers A Resource For Help With Access, Excel And Word >>>> Applications >>>> resource@pcdatasheet.com >>>> >>>> >>>> >>>> >>>> >>>> >>>> "John" <johnlee2509@btopenworld.com> wrote in message >>>> news:0E1DBE7E-AD54-4715-A547-EC2DDE9CDE39@microsoft.com... >>>>> Hi Guys, >>>>> How can I count records in a a combobox to allow me to scroll using >>>>> the slider bar without first having to scroll to the bottom of the >>>>> list? >>>>> >>>>> Regards >>>>> >>>>> John >>>>> >>>> >>>> >>> >>> >> > >

To what slider bar are you referring? If you can't drag the slider bar, how do you get to the last record? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "John" <johnlee2509@btopenworld.com> wrote in message news:83437D02-1DD7-4BD8-B9F8-4EB88DDF3BCF@microsoft.com... > Thanks for the Reply Douglas, > Sorry for being vague. > > There are no error messages, I have changed the code to use the name of my > combobox. > If I drag the slder bar nothing happens, if I scroll to the last record I > can then use the slider bar to move up and down. > I want to be able to scroll through the combobox list without going to the > last record. > > Reagrds > > John > > "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message > news:OPEZjBWyHHA.5380@TK2MSFTNGP04.phx.gbl... >> What does "does not seem to work" mean? Are you getting an error message? >> If so, what's the error? If you're not getting an error message, what are >> you getting (and what do you expect to be getting)? >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no e-mails, please!) >> >> >> "John" <johnlee2509@btopenworld.com> wrote in message >> news:B836E99D-312F-4206-9832-A92031F1B494@microsoft.com... >>> HI Guys >>> Thanks for the replies. >>> I have put this code in the onclick event of the combobox but it does >>> not seem to work. >>> I am using access 2007, would this make a difference? >>> >>> Regards >>> >>> John >>> >>> >>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message >>> news:%23OpQ0CVyHHA.4928@TK2MSFTNGP03.phx.gbl... >>>> Or, simpler and faster (and likely more accurate) >>>> >>>> NumRecord = Me!NameOfCombobox.ListCount >>>> >>>> -- >>>> Doug Steele, Microsoft Access MVP >>>> http://I.Am/DougSteele >>>> (no e-mails, please!) >>>> >>>> >>>> "Steve" <Sorry@private.emailaddress> wrote in message >>>> news:F7qni.8871$Od7.8171@newsread1.news.pas.earthlink.net... >>>>> Count the records in the rowsource of the combobox: >>>>> >>>>> NumRecord = DCount("*","NameOfTheRowSource") >>>>> >>>>> PC Datasheet >>>>> Providing Customers A Resource For Help With Access, Excel And Word >>>>> Applications >>>>> resource@pcdatasheet.com >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> "John" <johnlee2509@btopenworld.com> wrote in message >>>>> news:0E1DBE7E-AD54-4715-A547-EC2DDE9CDE39@microsoft.com... >>>>>> Hi Guys, >>>>>> How can I count records in a a combobox to allow me to scroll using >>>>>> the slider bar without first having to scroll to the bottom of the >>>>>> list? >>>>>> >>>>>> Regards >>>>>> >>>>>> John >>>>>> >>>>> >>>>> >>>> >>>> >>> >> >> >

Douglas, I can select and drag the slider bar but the records do not scroll at all. If i click the sliderbar up and down arrows then i can scroll but i need to scroll faster. If i select the sliderbar marker and drag downwards the records do not scroll. When I stop scrolling with the sliderbar and release the left mouse button, a record is selected depending on how far doen i have scrolled. this is not what i am looking for. I have seen this done in other databases where the sliderbar can be selected and dragged up or down and the records scroll in synchronisation. Regards John "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message news:unHpmiWyHHA.1168@TK2MSFTNGP02.phx.gbl... > To what slider bar are you referring? If you can't drag the slider bar, > how do you get to the last record? > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "John" <johnlee2509@btopenworld.com> wrote in message > news:83437D02-1DD7-4BD8-B9F8-4EB88DDF3BCF@microsoft.com... >> Thanks for the Reply Douglas, >> Sorry for being vague. >> >> There are no error messages, I have changed the code to use the name of >> my combobox. >> If I drag the slder bar nothing happens, if I scroll to the last record I >> can then use the slider bar to move up and down. >> I want to be able to scroll through the combobox list without going to >> the last record. >> >> Reagrds >> >> John >> >> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message >> news:OPEZjBWyHHA.5380@TK2MSFTNGP04.phx.gbl... >>> What does "does not seem to work" mean? Are you getting an error >>> message? If so, what's the error? If you're not getting an error >>> message, what are you getting (and what do you expect to be getting)? >>> >>> -- >>> Doug Steele, Microsoft Access MVP >>> http://I.Am/DougSteele >>> (no e-mails, please!) >>> >>> >>> "John" <johnlee2509@btopenworld.com> wrote in message >>> news:B836E99D-312F-4206-9832-A92031F1B494@microsoft.com... >>>> HI Guys >>>> Thanks for the replies. >>>> I have put this code in the onclick event of the combobox but it does >>>> not seem to work. >>>> I am using access 2007, would this make a difference? >>>> >>>> Regards >>>> >>>> John >>>> >>>> >>>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in >>>> message news:%23OpQ0CVyHHA.4928@TK2MSFTNGP03.phx.gbl... >>>>> Or, simpler and faster (and likely more accurate) >>>>> >>>>> NumRecord = Me!NameOfCombobox.ListCount >>>>> >>>>> -- >>>>> Doug Steele, Microsoft Access MVP >>>>> http://I.Am/DougSteele >>>>> (no e-mails, please!) >>>>> >>>>> >>>>> "Steve" <Sorry@private.emailaddress> wrote in message >>>>> news:F7qni.8871$Od7.8171@newsread1.news.pas.earthlink.net... >>>>>> Count the records in the rowsource of the combobox: >>>>>> >>>>>> NumRecord = DCount("*","NameOfTheRowSource") >>>>>> >>>>>> PC Datasheet >>>>>> Providing Customers A Resource For Help With Access, Excel And Word >>>>>> Applications >>>>>> resource@pcdatasheet.com >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> "John" <johnlee2509@btopenworld.com> wrote in message >>>>>> news:0E1DBE7E-AD54-4715-A547-EC2DDE9CDE39@microsoft.com... >>>>>>> Hi Guys, >>>>>>> How can I count records in a a combobox to allow me to scroll using >>>>>>> the slider bar without first having to scroll to the bottom of the >>>>>>> list? >>>>>>> >>>>>>> Regards >>>>>>> >>>>>>> John >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>> >>> >> > >

I'm very confused. It sounds as though you're talking about the scroll bar for the form itself. What does that have to do with knowing how many records exist in the combo box? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "John" <johnlee2509@btopenworld.com> wrote in message news:D59937ED-6D41-4911-A3F5-894A0B4EA790@microsoft.com... > Douglas, > I can select and drag the slider bar but the records do not scroll at all. > If i click the sliderbar up and down arrows then i can scroll but i need > to scroll faster. > > If i select the sliderbar marker and drag downwards the records do not > scroll. > When I stop scrolling with the sliderbar and release the left mouse > button, a record is selected depending on how far doen i have scrolled. > this is not what i am looking for. > > I have seen this done in other databases where the sliderbar can be > selected and dragged up or down and the records scroll in synchronisation. > > Regards > > John > > > > "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message > news:unHpmiWyHHA.1168@TK2MSFTNGP02.phx.gbl... >> To what slider bar are you referring? If you can't drag the slider bar, >> how do you get to the last record? >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no e-mails, please!) >> >> >> "John" <johnlee2509@btopenworld.com> wrote in message >> news:83437D02-1DD7-4BD8-B9F8-4EB88DDF3BCF@microsoft.com... >>> Thanks for the Reply Douglas, >>> Sorry for being vague. >>> >>> There are no error messages, I have changed the code to use the name of >>> my combobox. >>> If I drag the slder bar nothing happens, if I scroll to the last record >>> I can then use the slider bar to move up and down. >>> I want to be able to scroll through the combobox list without going to >>> the last record. >>> >>> Reagrds >>> >>> John >>> >>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message >>> news:OPEZjBWyHHA.5380@TK2MSFTNGP04.phx.gbl... >>>> What does "does not seem to work" mean? Are you getting an error >>>> message? If so, what's the error? If you're not getting an error >>>> message, what are you getting (and what do you expect to be getting)? >>>> >>>> -- >>>> Doug Steele, Microsoft Access MVP >>>> http://I.Am/DougSteele >>>> (no e-mails, please!) >>>> >>>> >>>> "John" <johnlee2509@btopenworld.com> wrote in message >>>> news:B836E99D-312F-4206-9832-A92031F1B494@microsoft.com... >>>>> HI Guys >>>>> Thanks for the replies. >>>>> I have put this code in the onclick event of the combobox but it does >>>>> not seem to work. >>>>> I am using access 2007, would this make a difference? >>>>> >>>>> Regards >>>>> >>>>> John >>>>> >>>>> >>>>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in >>>>> message news:%23OpQ0CVyHHA.4928@TK2MSFTNGP03.phx.gbl... >>>>>> Or, simpler and faster (and likely more accurate) >>>>>> >>>>>> NumRecord = Me!NameOfCombobox.ListCount >>>>>> >>>>>> -- >>>>>> Doug Steele, Microsoft Access MVP >>>>>> http://I.Am/DougSteele >>>>>> (no e-mails, please!) >>>>>> >>>>>> >>>>>> "Steve" <Sorry@private.emailaddress> wrote in message >>>>>> news:F7qni.8871$Od7.8171@newsread1.news.pas.earthlink.net... >>>>>>> Count the records in the rowsource of the combobox: >>>>>>> >>>>>>> NumRecord = DCount("*","NameOfTheRowSource") >>>>>>> >>>>>>> PC Datasheet >>>>>>> Providing Customers A Resource For Help With Access, Excel And Word >>>>>>> Applications >>>>>>> resource@pcdatasheet.com >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> "John" <johnlee2509@btopenworld.com> wrote in message >>>>>>> news:0E1DBE7E-AD54-4715-A547-EC2DDE9CDE39@microsoft.com... >>>>>>>> Hi Guys, >>>>>>>> How can I count records in a a combobox to allow me to scroll using >>>>>>>> the slider bar without first having to scroll to the bottom of the >>>>>>>> list? >>>>>>>> >>>>>>>> Regards >>>>>>>> >>>>>>>> John >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>>> >>> >> >> >

Douglas, I cannot make this any more clear than I already have. When you have a combobox which has its listrows set to 20 and there are more than 20 records a scroll bar appears to be able to view further than the 20 records shown. I want to be able to drag "the box on the scroll bar" in the combobox and scroll through records, without first having to goto the bottom of the list (Counting the Records) If you are confused, imagine my Dilemma. Regards John "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message news:eEbddzWyHHA.1204@TK2MSFTNGP03.phx.gbl... > I'm very confused. It sounds as though you're talking about the scroll bar > for the form itself. What does that have to do with knowing how many > records exist in the combo box? > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "John" <johnlee2509@btopenworld.com> wrote in message > news:D59937ED-6D41-4911-A3F5-894A0B4EA790@microsoft.com... >> Douglas, >> I can select and drag the slider bar but the records do not scroll at >> all. >> If i click the sliderbar up and down arrows then i can scroll but i need >> to scroll faster. >> >> If i select the sliderbar marker and drag downwards the records do not >> scroll. >> When I stop scrolling with the sliderbar and release the left mouse >> button, a record is selected depending on how far doen i have scrolled. >> this is not what i am looking for. >> >> I have seen this done in other databases where the sliderbar can be >> selected and dragged up or down and the records scroll in >> synchronisation. >> >> Regards >> >> John >> >> >> >> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message >> news:unHpmiWyHHA.1168@TK2MSFTNGP02.phx.gbl... >>> To what slider bar are you referring? If you can't drag the slider bar, >>> how do you get to the last record? >>> >>> -- >>> Doug Steele, Microsoft Access MVP >>> http://I.Am/DougSteele >>> (no e-mails, please!) >>> >>> >>> "John" <johnlee2509@btopenworld.com> wrote in message >>> news:83437D02-1DD7-4BD8-B9F8-4EB88DDF3BCF@microsoft.com... >>>> Thanks for the Reply Douglas, >>>> Sorry for being vague. >>>> >>>> There are no error messages, I have changed the code to use the name of >>>> my combobox. >>>> If I drag the slder bar nothing happens, if I scroll to the last record >>>> I can then use the slider bar to move up and down. >>>> I want to be able to scroll through the combobox list without going to >>>> the last record. >>>> >>>> Reagrds >>>> >>>> John >>>> >>>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in >>>> message news:OPEZjBWyHHA.5380@TK2MSFTNGP04.phx.gbl... >>>>> What does "does not seem to work" mean? Are you getting an error >>>>> message? If so, what's the error? If you're not getting an error >>>>> message, what are you getting (and what do you expect to be getting)? >>>>> >>>>> -- >>>>> Doug Steele, Microsoft Access MVP >>>>> http://I.Am/DougSteele >>>>> (no e-mails, please!) >>>>> >>>>> >>>>> "John" <johnlee2509@btopenworld.com> wrote in message >>>>> news:B836E99D-312F-4206-9832-A92031F1B494@microsoft.com... >>>>>> HI Guys >>>>>> Thanks for the replies. >>>>>> I have put this code in the onclick event of the combobox but it does >>>>>> not seem to work. >>>>>> I am using access 2007, would this make a difference? >>>>>> >>>>>> Regards >>>>>> >>>>>> John >>>>>> >>>>>> >>>>>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in >>>>>> message news:%23OpQ0CVyHHA.4928@TK2MSFTNGP03.phx.gbl... >>>>>>> Or, simpler and faster (and likely more accurate) >>>>>>> >>>>>>> NumRecord = Me!NameOfCombobox.ListCount >>>>>>> >>>>>>> -- >>>>>>> Doug Steele, Microsoft Access MVP >>>>>>> http://I.Am/DougSteele >>>>>>> (no e-mails, please!) >>>>>>> >>>>>>> >>>>>>> "Steve" <Sorry@private.emailaddress> wrote in message >>>>>>> news:F7qni.8871$Od7.8171@newsread1.news.pas.earthlink.net... >>>>>>>> Count the records in the rowsource of the combobox: >>>>>>>> >>>>>>>> NumRecord = DCount("*","NameOfTheRowSource") >>>>>>>> >>>>>>>> PC Datasheet >>>>>>>> Providing Customers A Resource For Help With Access, Excel And Word >>>>>>>> Applications >>>>>>>> resource@pcdatasheet.com >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> "John" <johnlee2509@btopenworld.com> wrote in message >>>>>>>> news:0E1DBE7E-AD54-4715-A547-EC2DDE9CDE39@microsoft.com... >>>>>>>>> Hi Guys, >>>>>>>>> How can I count records in a a combobox to allow me to scroll >>>>>>>>> using the slider bar without first having to scroll to the bottom >>>>>>>>> of the list? >>>>>>>>> >>>>>>>>> Regards >>>>>>>>> >>>>>>>>> John >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>>> >>>> >>> >>> >> > >

John is right. I never noticed this peculiarity before. If you have a combobox that displays say, 20 rows and the total number of rows is in the hundreds, you can't get to the bottom of the list easily. If you drag the scroll button to the bottom, when you release the mouse button, the button jumps up and you don't get the bottom of the list. You may have to drag the button to the bottom a dozen times or more to finally get it down there where the 'zzzz's are. Clicking or Shift-Clicking the bottom of the scroll column does no better. A workaround is to type an 'x' or a 'z' and then click the combobox drop down. The list will start with the first row matching 'x' or 'z'. Maybe this is what I do intuitively, so I never noticed the behavior above. UpRider "John" <johnlee2509@btopenworld.com> wrote in message news:31EC6B61-8EC4-4460-B183-5FDF63117DCF@microsoft.com... > Douglas, > I cannot make this any more clear than I already have. > > When you have a combobox which has its listrows set to 20 and there are > more than 20 records a scroll bar appears to be able to view further than > the 20 records shown. > > I want to be able to drag "the box on the scroll bar" in the combobox and > scroll through records, without first having to goto the bottom of the > list (Counting the Records) > > If you are confused, imagine my Dilemma. > > Regards > > John > > > > > "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message > news:eEbddzWyHHA.1204@TK2MSFTNGP03.phx.gbl... >> I'm very confused. It sounds as though you're talking about the scroll >> bar for the form itself. What does that have to do with knowing how many >> records exist in the combo box? >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no e-mails, please!) >> >> >> "John" <johnlee2509@btopenworld.com> wrote in message >> news:D59937ED-6D41-4911-A3F5-894A0B4EA790@microsoft.com... >>> Douglas, >>> I can select and drag the slider bar but the records do not scroll at >>> all. >>> If i click the sliderbar up and down arrows then i can scroll but i need >>> to scroll faster. >>> >>> If i select the sliderbar marker and drag downwards the records do not >>> scroll. >>> When I stop scrolling with the sliderbar and release the left mouse >>> button, a record is selected depending on how far doen i have scrolled. >>> this is not what i am looking for. >>> >>> I have seen this done in other databases where the sliderbar can be >>> selected and dragged up or down and the records scroll in >>> synchronisation. >>> >>> Regards >>> >>> John >>> >>> >>> >>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message >>> news:unHpmiWyHHA.1168@TK2MSFTNGP02.phx.gbl... >>>> To what slider bar are you referring? If you can't drag the slider bar, >>>> how do you get to the last record? >>>> >>>> -- >>>> Doug Steele, Microsoft Access MVP >>>> http://I.Am/DougSteele >>>> (no e-mails, please!) >>>> >>>> >>>> "John" <johnlee2509@btopenworld.com> wrote in message >>>> news:83437D02-1DD7-4BD8-B9F8-4EB88DDF3BCF@microsoft.com... >>>>> Thanks for the Reply Douglas, >>>>> Sorry for being vague. >>>>> >>>>> There are no error messages, I have changed the code to use the name >>>>> of my combobox. >>>>> If I drag the slder bar nothing happens, if I scroll to the last >>>>> record I can then use the slider bar to move up and down. >>>>> I want to be able to scroll through the combobox list without going to >>>>> the last record. >>>>> >>>>> Reagrds >>>>> >>>>> John >>>>> >>>>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in >>>>> message news:OPEZjBWyHHA.5380@TK2MSFTNGP04.phx.gbl... >>>>>> What does "does not seem to work" mean? Are you getting an error >>>>>> message? If so, what's the error? If you're not getting an error >>>>>> message, what are you getting (and what do you expect to be getting)? >>>>>> >>>>>> -- >>>>>> Doug Steele, Microsoft Access MVP >>>>>> http://I.Am/DougSteele >>>>>> (no e-mails, please!) >>>>>> >>>>>> >>>>>> "John" <johnlee2509@btopenworld.com> wrote in message >>>>>> news:B836E99D-312F-4206-9832-A92031F1B494@microsoft.com... >>>>>>> HI Guys >>>>>>> Thanks for the replies. >>>>>>> I have put this code in the onclick event of the combobox but it >>>>>>> does not seem to work. >>>>>>> I am using access 2007, would this make a difference? >>>>>>> >>>>>>> Regards >>>>>>> >>>>>>> John >>>>>>> >>>>>>> >>>>>>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in >>>>>>> message news:%23OpQ0CVyHHA.4928@TK2MSFTNGP03.phx.gbl... >>>>>>>> Or, simpler and faster (and likely more accurate) >>>>>>>> >>>>>>>> NumRecord = Me!NameOfCombobox.ListCount >>>>>>>> >>>>>>>> -- >>>>>>>> Doug Steele, Microsoft Access MVP >>>>>>>> http://I.Am/DougSteele >>>>>>>> (no e-mails, please!) >>>>>>>> >>>>>>>> >>>>>>>> "Steve" <Sorry@private.emailaddress> wrote in message >>>>>>>> news:F7qni.8871$Od7.8171@newsread1.news.pas.earthlink.net... >>>>>>>>> Count the records in the rowsource of the combobox: >>>>>>>>> >>>>>>>>> NumRecord = DCount("*","NameOfTheRowSource") >>>>>>>>> >>>>>>>>> PC Datasheet >>>>>>>>> Providing Customers A Resource For Help With Access, Excel And >>>>>>>>> Word >>>>>>>>> Applications >>>>>>>>> resource@pcdatasheet.com >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> "John" <johnlee2509@btopenworld.com> wrote in message >>>>>>>>> news:0E1DBE7E-AD54-4715-A547-EC2DDE9CDE39@microsoft.com... >>>>>>>>>> Hi Guys, >>>>>>>>>> How can I count records in a a combobox to allow me to scroll >>>>>>>>>> using the slider bar without first having to scroll to the bottom >>>>>>>>>> of the list? >>>>>>>>>> >>>>>>>>>> Regards >>>>>>>>>> >>>>>>>>>> John >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>>> >>> >> >> >

John wrote: >When you have a combobox which has its listrows set to 20 and there are more >than 20 records a scroll bar appears to be able to view further than the 20 >records shown. > >I want to be able to drag "the box on the scroll bar" in the combobox and >scroll through records, without first having to goto the bottom of the list >(Counting the Records) Kahuna had this same question just yesterday. Try using a line of code in the form's Load event: x = combobox.ListCount -- Marsh MVP [MS Access]

Thanks Marshall I though I was going mad. That worked a treat. Thanks for all your help Douglas, sorry for causing any headaches. Kind Regards John "Marshall Barton" <marshbarton@wowway.com> wrote in message news:e75t93hk8u5k9qqdt4mcb5fapgrgr66o7e@4ax.com... > John wrote: >>When you have a combobox which has its listrows set to 20 and there are >>more >>than 20 records a scroll bar appears to be able to view further than the >>20 >>records shown. >> >>I want to be able to drag "the box on the scroll bar" in the combobox and >>scroll through records, without first having to goto the bottom of the >>list >>(Counting the Records) > > > Kahuna had this same question just yesterday. Try using a > line of code in the form's Load event: > > x = combobox.ListCount > > -- > Marsh > MVP [MS Access]

Similiar Articles:

Count Records for this week, this month, this quarter, this year ...
Count Records for this week, this month, this quarter, this year Follow

count records by date range - microsoft.public.access.reports ...
count records by date range DataBase - DataBase Discussion List ... Please forgive the repost - someone supplied answer for running sum over report pages and I only ...

Count number of records after filtering - microsoft.public.access ...
Hello, Probably a question that's easy to answer but I have been searching for hours now & it's driving me rather crazy: I have applied a filte...

Count Records in a SubForm - microsoft.public.access
Hey everyone... Struggling with some syntax here. I'm trying to Count records in a subform. I have a textbox and have set it equal to many varia...

count related records - microsoft.public.access
2 tables - 1) tickets and 2) messages. Tickets contains the main data and messages contains all the comments made relating to that ticket. How do I count the number ...

count the number of unique records in a field within Access ...
How do I count the number of unique records in a field within Access? ...

Count records from different table - microsoft.public.access.forms ...
Not sure if this is even do-able or not. I have a form (lets call it FORM A) that has details information about each Case. Each case can have multi...

Count total records by date - microsoft.public.access ...
I Have a table containing names, age, id number, and date of entry. I would like to count the total number of records by month on a report. -- N...

count visible records only on continuous forms - microsoft.public ...
I would like to programmitically count # of visible records/rows in a continuous forms or datasheet format. So, I may have 200 records as the total...

Records Count and Records Navigation Control - microsoft.public ...
Access 2007 I need to place on a "Personel Table Datasheet" an automated Value for the "ID" field. The Automated Value depends from the Type of Per...

Count number of records on a report page - microsoft.public.access ...
Hi All, My report has several grouping levels and works OK. I am OK with creating a text box to count the entire number of records in a report and ...

How to Count Records from a Field in a Report Form - microsoft ...
I have a dbase with many fields with dates. One field is a text field and will only accept certain 2 character alpha characters such as MA, NA, SA, ...

using count in a query - microsoft.public.access
I have a query that I am using to show all records in a table, based on a couple criteria. One of the fields in the query [MEMBER ID] has data the ...

Count records based on combo box value - microsoft.public.access ...
Hi I have a continuous form set up that stores person details name, DoB, gender etc. Gender is a combo box which stores either a 1 or 0. I have two ...

Count Records in multiple tables - microsoft.public.access.queries ...
I am trying to get a count of Appointments from multiple tables using this statement - when I try to run it I get the unspecified expression error. ...

Counting number of records based on criteria - microsoft.public ...
Hello, (Try again to get the question in the google-groups. Perhaps not pushed on the send button). For counting records as expression in a rep...

Count of records where checkbox 1 is unchecked, checkbox 2 is chec ...
Hello, I have a table with several check boxes. I'd like to place in the report footer a count of the number of records where both conditions exis...

Count Records on a Subform while on the Main Form. - microsoft ...
I have a Form and Subform, I want to have a textbox on the Main Form that counts the records in the subform. I don not want to count all records, ju...

Need Subform Record Count in Report - microsoft.public.access ...
I have a form and figured out how to determine the number of associated records that appear in a subform for each ID using the RecordCount object pr...

Query and Count no records Want a Zero - microsoft.public.access ...
You probably use a where clause. The WHERE clause is evaluated first, before the GROUP/COUNT, and if no record passes the condition, no record would return.

How to: Count the Number of Records in a DAO Recordset
You may want to know the number of records in a Recordset object. For example, you may want to create a form that shows how many records are in each of the tables in ...

SQL COUNT for total number of records in mysql table
SQL COUNT Command We can count the number of records in a table with different combinations. Let us first count the total number of records in the table with this ...

Counting Values in a Database Table with the SQL COUNT Function
The COUNT() function in SQL allows you to count database records based upon a variety of criteria. You can use it to count all records in a table, count unique values ...

Welcome To Four Count Records !!!
To order CD's you must call in your order, be billed and pay in advance. Very sorry for this inconvenience. New Release From FCR Tildon Gillum Band!

Counting records | Microsoft Dynamics CRM | Resource Center for On ...
This article describes various ways of counting records in Microsoft Dynamics CRM.

How to Count Unique Records in a Microsoft Access Database | eHow.com
As you enter data into a Microsoft Access database, duplicates are possible, especially in portions of a record, such as a first name. To discover the number of ...

Count records in a report DataBase - DataBase Discussion List ...
The aggregate functions do not work in the page header/footer sections because a page is not a data related grouping. Put the Count(*) text box in the report header ...

how to count unique records with sql - Justinsomnia
is there a way with a single standard SQL query to count the unique records in that column? (the query should return “4″) answer. the following sql works in MySQL ...

Counting in reports - Access - Office.com
Count records or add a line number for each record in a record or group in Access 2007.

VB Helper: HowTo: Count the records in a database table
Title: Count the records in a database table: Keywords: database, table, count records: Categories: Database

7/26/2012 8:20:42 PM