Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
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
 
Old January 12th, 2006, 02:20 AM
Friend of Wrox
 
Join Date: Dec 2005
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 problem while generating report,through front end


 Hi friends :),

 I created an DB in that i have created an from with combo box the combo as the data from an table i am try to generate the report by using that combo box , I have created the query for that report and rep view for that report , in the from i add command button name report view . i planned to kept as by selecting the data in the combo box and when clicking the button the report preview to disply . I use "Open.Report" code for that report which is not supporting . As i am new ot VB, friends pls help me to make the report. Is it possible for me to generate the rport in the switch board by which i desire.'
pls help me,
 I am waiting for ur reply,.:D

 Bye ,
 Pap
 
Old January 12th, 2006, 03:24 AM
Friend of Wrox
 
Join Date: Dec 2005
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

Hi friends u can sent the clarification through E-mail : anukagni@gmail.com

Bye
Pap
Today's Mess (Thirukural)
"Learning is wealth none could destroy
Nothing else gives genuine joy"
 
Old January 13th, 2006, 08:56 AM
Friend of Wrox
 
Join Date: Jun 2003
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

To open the report filtered down by what you select in the combobox, use the OpenReport method as follows

DoCmd.OpenReport "ReportName", acPreview, , "[FieldName] = '" & Me.cboComboBox & "'"

Where you replace my fake names of ReportName, FieldName, and cboComboBox with your real names.

FieldName is the name of the field in your query you want to set during runtime.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old January 16th, 2006, 03:06 AM
Friend of Wrox
 
Join Date: Dec 2005
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

Hi,:)
Gerg thanks for reply i had tried that but i got an mess that Run-time error "Object deosn't support this property or method"
Pls clarify the mistake i had done in the DB .,

'OpenReport.
    DoCmd.OpenReport (Query1,[acViewPreview],[Issue to whom] "'" & Me.EmployeeName & "'")
iam trying to finish the mistake ,but i am new to the DB pls
thanks again

Regards,
Pap:)

Today's Mess (Thirukkural)
"To meet with joy and part with thought
Of learned men this is the art" (2:1:2:394)
 
Old January 16th, 2006, 07:01 AM
Friend of Wrox
 
Join Date: Dec 2005
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

Hi Greg ,

 I got the function correctlly , thanks for ur help,
 and now i have posted an new topic pls give me an posotive reply on that Issue.

 Bye,
 Pap
Today's Mess (Thirukkural)
"To meet with joy and part with thought
Of learned men this is the art" (2.1.2:394)
 
Old January 17th, 2006, 11:12 AM
Friend of Wrox
 
Join Date: Jun 2003
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

Great... it should look something like

DoCmd.OpenReport "Query1", acViewPreview, ,"[Issue to whom] = '" & Me.EmployeeName & "'"


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old January 20th, 2006, 03:28 AM
Friend of Wrox
 
Join Date: Dec 2005
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 greg i got it ,

 simillarlly i got the report , But while generating the report the data in the report repeating 20-30 time , I don't know what to do
 Pls help me in this issue

P.A.P.Raguv
 
Old January 20th, 2006, 08:58 AM
Friend of Wrox
 
Join Date: Jun 2003
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

Is it possible that your query is not set to give you distinct records and is repeating due to your criteria? If your query has joined tables, you may have to double-click anywhere in the gray area (not on a table) and choose "Unique Record" or "Unique Value" from that dialog box.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old January 21st, 2006, 02:07 AM
Friend of Wrox
 
Join Date: Dec 2005
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

 Hi gerg,

  I got the answer thanks again for the reply and i happy to see your respones and solving the issue to develope the beginers like me.
  thanks from my deep heart
bye,

P.A.P.Raguv





Similar Threads
Thread Thread Starter Forum Replies Last Post
Front end Vs Back end ricmar Access VBA 3 May 27th, 2008 02:36 PM
Ms Access front End with Oracle 10g Back End rahul123 Oracle 1 July 9th, 2007 01:03 AM
Oracle back-end MS-Access 2003 client front-end Corey Access 2 February 16th, 2007 08:31 AM
Oracle Back End - MS Access Front End - Multi User ckaliveas Oracle 1 February 1st, 2007 06:00 AM
creating Front - End anukagni Access 8 April 22nd, 2006 04:11 AM





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