Drag in a List Box
in [General]
|
From: Bob Vance on 25 Apr 2010 20:18 If I have a list box that has a row source to a query is it possible to drag my records up and down the list box to give them a certain order to print on a report?? -- Thanks in advance for any help with this......Bob MS Access 2007 accdb Windows XP Home Edition Ver 5.1 Service Pack 3
From: Arvin Meyer [MVP] on 25 Apr 2010 20:44 Stephen Lebans has a number of Listbox examples on his website. Here's just one of them: http://www.lebans.com/vb_listbox.htm -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message news:uooRnXN5KHA.4740(a)TK2MSFTNGP06.phx.gbl... > If I have a list box that has a row source to a query is it possible to > drag my records up and down the list box to give them a certain order to > print on a report?? > > -- > Thanks in advance for any help with this......Bob > MS Access 2007 accdb > Windows XP Home Edition Ver 5.1 Service Pack 3 > >
From: Larry Linson on 25 Apr 2010 21:15 "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message news:uooRnXN5KHA.4740(a)TK2MSFTNGP06.phx.gbl... > If I have a list box that has a row source to a query is it possible to > drag my records up and down the list box to give them a certain order to > print on a report?? I'm wondering how the List Box would affect the order of printing on a Rport? The Sorting and Grouping Properties of the Report are what determines the order in which the Rcords are printed. The List Box's Row Source will determine the order in which information appears in the List Box. Larry Linson Microsoft Office Access MVP
From: Bob Vance on 26 Apr 2010 01:46 Thanks Larry, So no matter what order i put them in my listbox that wont print the prder on my report?.......Regards Bob "Larry Linson" <bouncer(a)localhost.not> wrote in message news:uA$0w3N5KHA.4740(a)TK2MSFTNGP06.phx.gbl... > > "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message > news:uooRnXN5KHA.4740(a)TK2MSFTNGP06.phx.gbl... >> If I have a list box that has a row source to a query is it possible to >> drag my records up and down the list box to give them a certain order to >> print on a report?? > > I'm wondering how the List Box would affect the order of printing on a > Rport? The Sorting and Grouping Properties of the Report are what > determines the order in which the Rcords are printed. > > The List Box's Row Source will determine the order in which information > appears in the List Box. > > Larry Linson > Microsoft Office Access MVP >
From: Bob Quintal on 27 Apr 2010 06:22 "Bob Vance" <rjvance(a)ihug.co.nz> wrote in news:#XfKWPQ5KHA.4740(a)TK2MSFTNGP06.phx.gbl: > Thanks Larry, So no matter what order i put them in my listbox > that wont print the prder on my report?.......Regards Bob > Having some (l)user drag records up and down randomly seems a pretty disorganized way to sort anything. Is there no usable field such as a name, date or id field that could be used to sort the report sequence? If you really need to do this, create a new field, sortorder, type integer. You can then use some code to set this number, based on the dragging, or up and down arrows like in some of the wizards, as the field to sort on in the report. Q > "Larry Linson" <bouncer(a)localhost.not> wrote in message > news:uA$0w3N5KHA.4740(a)TK2MSFTNGP06.phx.gbl... >> >> "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message >> news:uooRnXN5KHA.4740(a)TK2MSFTNGP06.phx.gbl... >>> If I have a list box that has a row source to a query is it >>> possible to drag my records up and down the list box to give >>> them a certain order to print on a report?? >> >> I'm wondering how the List Box would affect the order of printing >> on a Rport? The Sorting and Grouping Properties of the Report >> are what determines the order in which the Rcords are printed. >> >> The List Box's Row Source will determine the order in which >> information appears in the List Box. >> >> Larry Linson >> Microsoft Office Access MVP >> > > >
|
Pages: 1 Prev: Edit textbox Next: trying to open two forms on maximized other usually max. but s |