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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Drag in a List Box
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 |
#2
|
|||
|
|||
Drag in a List Box
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" wrote in message ... 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 |
#3
|
|||
|
|||
Drag in a List Box
"Bob Vance" wrote in message ... 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 |
#4
|
|||
|
|||
Drag in a List Box
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" wrote in message ... "Bob Vance" wrote in message ... 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 |
#5
|
|||
|
|||
Drag in a List Box
"Bob Vance" wrote in
: 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" wrote in message ... "Bob Vance" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|