Solved

Data Reports

Posted on 2002-04-24
2
134 Views
Last Modified: 2010-05-02
I have a form with a text box and a command button.

If i click the button a report should be generated for the number which i have entered in the text box.

If i pass the query in the Dataenvironment as below
it works fine.

select * from client_table where(number='c.c.no1')

How should i pass the query to place the text box value instead of the above value.

If u could not understand the question plz mail me

@ vivek_g_r@rediffmail.com

Thanx

Vivek
0
Comment
Question by:vivek_chozha
2 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 50 total points
ID: 6965745
Assuming your text box is called Text1 than your SQL statement should look like:

"select * from client_table where number='" & Text1.Text & "'"

Anthony
0
 

Author Comment

by:vivek_chozha
ID: 6965793
Thanx a lot Antony.

I will soon contact thru mail.

Thanx once again.

0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

708 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now