Pass Form Variable to Report (DataReport)

Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Navigation

		Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
Pass Form Variable to Report (DataReport)

VB How-To Ask your "How do I do this with VB?" questions in this forum.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .

Reply

Search this Thread

#1 (permalink)

Old

September 20th, 2004, 04:41 AM

coboy

coboy is offline

Registered User

Join Date: Sep 2004

Location: jeddah, , Saudi Arabia.

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Send a message via MSN to coboy

Default

Pass Form Variable to Report (DataReport)

:) Hi all, (using VB 6)

How can include a variable from a FORM into a DataReport print page.
Also

,

How include the varible to the cratria insdie the SQL of the DataRepot.

Thanks.

Reply With Quote

#2 (permalink)

Old

September 22nd, 2004, 12:19 PM

SerranoG

SerranoG is offline

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

Use the DoCmd.OpenReport method. For example, to filter on a text variable,

DoCmd.OpenReport "Your Report Name", acPreviewPrint, , "[Your Table or Query Field] = '" & Me.txtYourTextboxField & "'"

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are Off Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
To pass value of string variable to another form	thillai	Visual Basic 2005 Basics	5	March 13th, 2008 03:29 AM
pass session variable to report select where	nutrino	ASP.NET 2.0 Basics	0	October 25th, 2006 09:16 AM
Pass variable to main form dataset	spacky001	ASP.NET 1.0 and 1.1 Basics	2	September 13th, 2006 10:10 PM
How to pass data directly into datareport .	baburam	VB How-To	1	May 23rd, 2006 03:43 AM
pass form elements variable	vickyj	Classic ASP Basics	0	October 29th, 2005 04:58 AM

All times are GMT -4. The time now is 04:21 PM.