Access report, SQL parameter passing and VB form Design
Posted on 1998-07-25
I am looking few answers and I will raise the points if I get a good answer and if it necessary.
Please keep in mind I am new to VB5 and Access.
I just started Using Expert-Exchange this month and I would
like to know if I asked the question with High/low or reasonable points.
- I designed my database tables, queries and reports in a Microsoft Access and I am using VB5 for my programming requirement.
= I want to open the Access report without opening Access. I already received an answer for this question but unfortunately it opens Access. It can't be done is a good
= I have the query “SELECT * FROM table1 WHERE lname = anygivenname” In Access
I would like to open this query in VB using openRecordset and pass a parameter anygivenname .
How should I pass the parameter "anygivenname" to the query when I am opening it using db.openRecordSet("query1")?
= When I run my program with a low resolution screen the form covers the entire screen, what should I need to do to make sure that the form opens with a reasonable size taking into account the size and the resolution of the screen.