Solved

setting Access critera in VB5

Posted on 1998-06-28
2
134 Views
Last Modified: 2010-05-03
I have a program that writes to 4 different tables, then a query that pulls all the information out. How can I code it so that when a user clicks on a button, it will ask for some information, then put that information into the criteria of the query so I have one listing that comes up, which is then linked to an Access report that will print out?
0
Comment
Question by:Gatewaytech
2 Comments
 
LVL 3

Accepted Solution

by:
AndreasSchindler earned 100 total points
ID: 1464475
For Example: Your Table is ADDRESS
Name Char(30)
Zip char(7)

Your Query in Access:
Select * from Address where Zip=?

Solution:
make a Table Parameter
ZipPar char(7)

and Change Your Query to:
Select Address.* from Address,Parameter where Zip=ZipPar

By entering Values to the Parameter Table you can choose witch Data the Query will use.

0
 

Author Comment

by:Gatewaytech
ID: 1464476
Wasn't exactly what I was looking for, but it got me to the info that I needed to make it work. You have the points and my thanks. :)
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBA error replacing data 6 39
bit defender blocks good applications 2 93
Automatic Email Reminder 4 36
which modules are active in VB6 project? 6 9
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question