| Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free! |
VB Data Reports its urgent
|
Original Message
|
Name: pallavi
Date: November 15, 2002 at 01:46:42 Pacific
Subject: VB Data Reports its urgentOS: win98CPU/Ram: 32 |
Comment: Using VB6 for front end/MSAccess for back end
I need to create a VB datareport. I have designed such a report using a dataenvironment and it shows all the records in the Access Back end---Problem---- I need to restrict which records the data report displays and I need it to work similar to this... A InputBox prompts for a persons ID no. Then the report is displayed showing only those records that have that id number.
Any help would be great???!!!
Report Offensive Message For Removal
|
|
Response Number 1
|
Name: Pete
Date: November 15, 2002 at 06:16:17 Pacific
|
Reply: (edit)Sounds to me like you need to modify your query. I mostly work with SQL so I'm not to sure about Access queries but it would read somthing like Select * from tablename
where PersonalIDfield = '" & inputboxVar & "'
 Report Offensive Follow Up For Removal
|
Post Locked
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
Go to Programming Forum Home
