Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
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
  #1 (permalink)  
Old February 20th, 2006, 05:53 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default 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....
  #2 (permalink)  
Old February 24th, 2006, 09:43 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

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
  #3 (permalink)  
Old February 25th, 2006, 01:22 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

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
  #4 (permalink)  
Old February 27th, 2006, 09:15 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

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
  #5 (permalink)  
Old March 1st, 2006, 07:11 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

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
  #6 (permalink)  
Old March 1st, 2006, 09:13 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Quote:
quote:Did u Understand ..?
Sorry, but no. :(


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
  #7 (permalink)  
Old March 1st, 2006, 09:35 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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
  #8 (permalink)  
Old March 7th, 2006, 07:34 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

Yes thanks i got ur idea

 bye,
 pap raguv


P.A.P.Raguv


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sequential numbering a non auto number field dbartelt Access 3 May 5th, 2005 02:56 PM
Report Page numbering leehambly Access 1 March 17th, 2005 05:33 AM
Page numbering in crystal report 9.0 rajeshnerenki Crystal Reports 2 December 10th, 2004 11:29 AM
Enable auto numbering in an existing table pankaj_daga Oracle 1 June 30th, 2004 05:02 PM
Numbering in Access Report mateenmohd Access 5 April 3rd, 2004 11:55 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.