Hello All.
Specially ADejii.
I had generated a report in VB. For that purpose i am using ACCESS database. This database is connected via Microsoft Jet 4.0 OLE DB provider, and it is working well.
Now i has changed provider for other purpose so i am getting problems in report generation.
Provider : Microsoft OLE DB provider for ODBC Drivers
Connection Status : Test Connection Succeded....
ashutoshvyas
Last Activity: Aug 19 '07, 01:40 PM
Joined: Jul 28 '07
Location:
-
Problem in Data Request through ODBC ACCESS Driver
-
Thank you again.
I had noticed that there is the word expert under your name which was moderator few days ago, so congrats for becoming expert.
Truly u r genius & expert. I like your way to support, that is the right way. Instead of giving straight forward answers u r giving answers in the form of hints or clever language. I like your art.
with the help of your last post i had reached to the solution and now... -
Very correct sir. I had thinked a lot, that if sequential numbers r generated in the underlying SQL, the thing will be very easy. But i found the problem stated below :
One 'form' in visual basic is created by me, which will collect the date as parameter and then this query will be used to give records for that date. The problem is, we did not get the number of records filtered until this query is executed and so in advance we can...Leave a comment:
-
Dear sir,
you r correct. I forgot to mention, so please pardon.
I want to create report using visual basic by data environment.
I am using access query as data provider, by which report is generated in visual basic. I had been successful to generate a report, but I face the problem to give recoard count. so i want to count records and assign sequential record numbers in the report.
The SQL code to link query is...Leave a comment:
-
dear all
i am pasting the code with errors, an effort to take this problem towards solution. If anyone can turn it into functionality, it will be a great help for me.
' I KNOW THIS CODE IS WITH ERRORS BUT I WANT TO MAKE IT ERROR FREE IF POSSIBLE
' SO THAT I CAN GENERATE A REPORT WHICH ACCEPTS DATE AS PARAMETER
' AND FILTER THAT RECORDS BY DATE AND STORES RESULTS IN TEMPORARY TABLE
' SO THAT RECORD COUNT...Leave a comment:
-
dear all
i am pasting the code with errors, an effort to take this problem towards solution. If anyone can turn it into functionality, it will be a great help for me.
' I KNOW THIS CODE IS WITH ERRORS BUT I WANT TO MAKE IT ERROR FREE IF POSSIBLE
' SO THAT I CAN GENERATE A REPORT WHICH ACCEPTS DATE AS PARAMETER
' AND FILTER THAT RECORDS BY DATE AND STORES RESULTS IN TEMPORARY TABLE
' SO THAT RECORD COUNT...Leave a comment:
-
Thanks a lot, Jon. I will try this and very soon I will reply that it was possible to perform or not & it works or not....Leave a comment:
-
No specific formet. Instead of serial no, I can call it reacord count.
In General when this report is executed, each time the records will be counted and they will be numbered sequentially as 1,2,3,4,5...... .. till the last record.
e.g. Report for the records where city = London
Sr.No Name city
1 A London
2 B London
3 X ...Leave a comment:
-
How To Give Serial Numbers To Generated Records In Report
Hello everybody
I had got one more problem.
I want to give serial numbers to each records which are generated in the REPORT by the mean of query. So what to do for generating automic serial no's which are given to each records, each time the report is generated....Leave a comment:
-
Hello Everybody.
I had solved the above question by adding sql command1 in the data environment and by writing the procedure for form which can accept the parameters from the user and will pass value to the query and then generation of report based on that query.
But a new problem had arised.
I want to give serial numbers to all the records which are generated in the report by the means of above mentioned query.
...Leave a comment:
-
Parameter Query of Access is not Available in VB DataReport
I am designing a data report in VB6. In data environment it is possible to selet tables and 'select quries'. But I want to generate a report based on parameters passed by user, so i had created a parameter query in ACCESS which is not available in the properties of command1.
SQL code of query is as under :
SELECT Customers.accou nt_no, Customers.card_ no, Customers.name, payments.amount , payments.paymen t_date, dlt_3.[Second last... -
Thank you very much for your motivation, Sir. Your small help has prepared me to solve complicated problems.
I had successfully builded a set of three queries which can : Filter out each individual records with second last date for date field. The SQL code for that three queries is pasted :
Query_1 : dlt
SELECT payments.accoun t_no, Max(payments.pa yment_date) AS [Latest Date]
FROM payments
GROUP BY...Leave a comment:
-
Dear sir,
Can anything done like following ?
1) Last date records are filtered by the first query method you suggested.
2) with second query, all the records from first query are deducted.
3) The third query will display last records by same method from second query, which are records with secondlast date for first query.
You might generalise this equation....Leave a comment:
-
Thanks for redirecting me towards the way, probably i can go near the solutionLeave a comment:
-
Problem building ACCESS query for retrival of records.
I want to write such criteria in the query of microsoft ACCESS, which can give records with secondlast date?
table & fields......... ...desired output
no-name-date........... ...name-date
1-A-07/15/07............. .A-07/15/07
2-A-08/18/07............. .B-04/12/07
3-B-04/12/07
4-B-08/18/07
5-A-07/03/07
No activity results to display
Leave a comment: