I am using the Shell("G:\Max411\impmeter.exe") command to start an application. The impmeter.exe imports data into my database, then closes automatically.
This works fine, but I do not want my code to continue until the impmeter.exe application is closed. Is there a that I can do...
I have problem with my data report. I have developed a search program that displays the query results, from an Oracle database, in a data repeater. Then I created a report to print the results. When I preview or print the report for the first time, all of the records are displayed on the...
The only thing that I don't do is requery before passing the datasource to the report. I know that it works if I requery, but it also makes the program run slower. A requery should not have to be done for this to work, should it?
Brad Pitcher
The Hoover Company
I have problem with my data report. I have a search program that displays the query results in a data repeater. Then I created a report to print the results. When I preview the report for the first time, all of the records are displayed on the report. But if I close the report and preview it...
I'm sorry!! I am writing the file from an oracle database. I will have to look and see if there is a "replace" command that I can use. Do you have any ideas on what I can do?
Thanks,
Brad Pitcher
The Hoover Company
bpitcher@hoover.com
I know how to replace the comma with a different character, but how to do I read that character in VB. Here is my code to open the recordset:
******************************************************
Dim TextPath As String
Set conn = New ADODB.Connection
TextPath = "c:\INDIRECT\"...
I am using ADO to query a comma delimited text file. I have run into a problem. Some fields that I am using, have a comma(,) or quotes (to represent inches) in them. This is breaking up the one field into two or more fields when the records are diplayed in a Flex Grid. Any suggestions?
I...
Problem solved!!
Thanks for your help!!
It was the way I was opening my recordset(adUseClient)
(adOpenStatic), etc.
Thanks again,
Brad Pitcher
The Hoover Company
bpitcher@hoover.com
Here is my code for the form in which the data repeater exisits. This is where I call my connection string (global variable) and set up the datasource for my ADO data control. Then I set up the Data Repeater (Data1) using code (I have tried this both ways, using the properties and by using the...
I am not getting an error, it is just that my data is not displaying in the repeater. I did run the active x in it's own project and I get an image of form with no data.
Brad Pitcher
The Hoover Company
bpitcher@hoover.com
I am using the active x in a standard .exe project. I am using an Oracle database. Like I said, there is data in my recordset, because I can view the list in a list box. I just cannot get it to work in the Data Repeater.
Brad Pitcher
The Hoover Company
bpitcher@hoover.com
I am working on search tool in which I would like to display the query results in a DataRepeater. I built the .ocx ActiveX control, assigned the properties (let and get), and created the bindings. Repeater is linked to an ADODC user control. My problem is that no data is being displayed in...
Here is my code for the control. I you need to see the code that I am using to call the control and set my bindings in the data repeater, let me konw.
*******************************************************
Option Explicit
Private Sub txtBinnum_Change()
PropertyChanged "Binnum"...
I am working on search tool in which I would like to display the query results in a DataRepeater. I built the .ocx ActiveX control, assigned the properties, and created the bindings. Repeater is linked to an ADO user control. My problem is that no data is being displayed in the repeater. I...
That is exactly what I am interested in. I have not tried it yet, but I will let you know how it works when I do.
Thank you very much!! Brad Pitcher
The Hoover Company
bpitcher@hoover.com
I know how to make my database compact on exit, but I need to do something a little more complicated. I have a database that I use an import procedure with. The database is strictly used for reporting. I am using a flag that is set to "True" when the import is run. I want to use...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.