Greetings!
I'm asking your help. It's about printing a record. I used ADODC and the data is in access. what i want to happen is that when i choose to print a particular record. how will i do it?
please help me to solve this problem.. i have a deadline to catch!:-|
Thanks so much DANIWEB!
Respectfully,
purplestar86
You can print a record in several ways. Here are 2
1. Create a Data Report / Crystal Report for the Table. Use a Select Query to filter the records for the record you want to print
2. Put the records data in a text file (.txt file) and print it using regprn or some other simple printing utility
You can print a record in several ways. Here are 2
1. Create a Data Report / Crystal Report for the Table. Use a Select Query to filter the records for the record you want to print
2. Put the records data in a text file (.txt file) and print it using regprn or some other simple printing utility
Hi aparnesh! Thanks for the reply! I used a DataEnvironment, dragged the fields to the data report and ready to print. the question is, what will i write/set on the SQL if i want to print a particular record?
Please help me. Our system is due next week. :-|
Thanks!
That would of course depend on your tables and fields.
For example, if you have a table called Table1 and want to print records where the column Field1 contains the value 'ABC', your SQL will be
SELECT * FROM Table1 WHERE Field1 = 'ABC' ;
If you are not comfortable with SQL, try get someone's help or go through any SQL primer. It shouldn't take more than an hour or 2 at most to get a working knowledge of simple SQL
That would of course depend on your tables and fields.
For example, if you have a table called Table1 and want to print records where the column Field1 contains the value 'ABC', your SQL will be
SELECT * FROM Table1 WHERE Field1 = 'ABC' ;
If you are not comfortable with SQL, try get someone's help or go through any SQL primer. It shouldn't take more than an hour or 2 at most to get a working knowledge of simple SQL
Thanks for your reply. the SQL i used is
SELECT * from Recording
In the SQL i used, it prints all the records in the table. which our only requirement is to print a certain record.
Please help. Deadline is due in 3days. Thanks !
Respectfully,
purplestar86
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.