 |
| Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
February 20th, 2006, 05:53 AM
|
|
Friend of Wrox
|
|
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Auto Numbering in Report View
Hi All,
I have created an Report in My Database in that i want to creat an List Box which should automatically creat the Sl.No. (i.e.) 1,2,3.... . Is it possible for me to get the Serial Number in the Report View if so give me idea or sent the expression which i have to build in the unbound tabular box.
expecting ur reply ,
thank in advance,
Bye,
pap.Raguv....
|
|
February 24th, 2006, 09:43 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
|
|
Reports cannot contain comboboxes or listboxes. Reports are passive, not active. Put the listbox on your form that calls the report and then show it as a textbox in your report after it opens.
Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
|
|
February 25th, 2006, 01:22 AM
|
|
Friend of Wrox
|
|
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
OK greg ,
But how can I build the Expression , i.e. when i view the report the Sl.no should automatically generate ..bcs i viewing different data in the same report
bye,
pap raguv
P.A.P.Raguv
|
|
February 27th, 2006, 09:15 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
|
|
Please explain more what you mean by "But how can I build the Expression." Do you mean how can you populate the list in the listbox? I would need to know more about where you're getting the data, e.g. table structure, etc.
Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
|
|
March 1st, 2006, 07:11 AM
|
|
Friend of Wrox
|
|
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Ok i ill Explain ..
For Example table Contain Computer and the Computer type as HP, Compaq , HCL ..Ect and Scanner as Umax , HP,TVS ..Just like that .. then the types as owned by some persons A,B,C,D . The Data are in One table and the Structure is Sl.No , Name of the Person ,Name of the Equipment & Cost .. and the Equipment are in Contuinous in the table data . But when i trying to generate by Equipmentwise report The Sl.no ill Fumble bsc the report will shuffled then defaultlly the sl.no also suffled . But I want an Continous Sl.No..
Did u Understand ..?
Pls help me .
Bye,
pap Raguv
P.A.P.Raguv
|
|
March 1st, 2006, 09:13 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
|
|
Quote:
|
quote:Did u Understand ..?
|
Sorry, but no. :(
Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
|
|
March 1st, 2006, 09:35 AM
|
|
Friend of Wrox
|
|
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
|
|
In your report, go to Design View,
Select the Detail header, then right click and select Sorting and Grouping, then select the Serial Number field, then select Ascending.
The serial number field should be the only or first field from the detail section.
Is this what you want?
HTH
mmcdonal
|
|
March 7th, 2006, 07:34 AM
|
|
Friend of Wrox
|
|
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Yes thanks i got ur idea
bye,
pap raguv
P.A.P.Raguv
|
|
|
