By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,066 Members | 1,841 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,066 IT Pros & Developers. It's quick & easy.

Creating A Report in VB from a database

P: 5
Hello there,
Please someone to help:I am trying to create a report in VB with access 2003.I've first moved to project/Data environment/data report.In data report i can only go as far as "drawing" the text ("UNBOUND") controls.I dont know what to do next and what properties I need to set to these text boxes.Could anyone help by listing for me step by step,from start, what I need to do.Will greatly appreciate any assistance.
Andy
Sep 7 '07 #1
Share this Question
Share on Google+
1 Reply


QVeen72
Expert 100+
P: 1,445
Hi,

In DataEnvironment, Add a Connection Object Set the Database/Login/Password and Test The Conn. And Add a Command Object to this Connection (By Right Click). Goto Properties of Command Object, Change to SQL Query, Design the Query and Save. Expand the Command Object, depending on the Query, u will be having ield Objects.
Now in DataReport Drag and Drop the Field Objects of the Command object.
Save and Run
to call report :

DataReport1.Show

REgards
Veena
Sep 7 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.