Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dawtes
  • Order by date
  1. dawtes

    Record Selection

    I have this record selection formula, but when I check it, it gives me an error message. I am giving the users a multiple selection option. (if {?month} in [1,2,3,4,5,6,7,8,9,10,11,12] then Month ({WMS_MBP_PERMITS.DATE_OF_ISSUE}) in [{?month}] else if {?month} <= 0 then True ) The error...
  2. dawtes

    Record Selection

    Hi all, I have a parameter in my report and users can select multiple values. Can someone explain to me how I need to assign the values to the table field in the record selection? Thanks
  3. dawtes

    Slow data grid

    Someone this morning suggested to me that i should use dataget control and display a certain number of records that way it will increase the the time for the selected resulted to be displayed.I took his suggestion and spent a fair amount of time and move from data grid to data set and the...
  4. dawtes

    Slow data grid

    ...<Body> <table width="100%" border="0" > <form runat="server"> <div align="center"><span class="style4">Bid Letting </span><br> Trns*port Item Lists (Metric System -This list went into effect with the 2000 Spec. Book) </div> <P align="right"> Metric system item list data below...
  5. dawtes

    Oracle Connection

    ..._ "Data Source=c:\Inetpub\wwwroot\Dorknozzle\Database\" & _ "Dorknozzle.mdb") filename = "products.csv" cmd = New OleDbCommand("Select * from employees ",cn) cmd.Connection.open() dr = cmd.ExecuteReader() sb = New System.Text.StringBuilder 'for field name For i=0 to dr.FieldCount-1...
  6. dawtes

    Unable to see CSV file

    ..._ "Data Source=c:\Inetpub\wwwroot\Dorknozzle\Database\" & _ "Dorknozzle.mdb") filename="products.csv" cmd = New OleDbCommand("Select * from Employees", cn) cmd.Connection.open() dr = cmd.ExecuteReader() sb= New System.Text.StringBuilder 'for field name For i=0 to dr.FieldCount-1 If i...
  7. dawtes

    eliminate error msg

    ..._ "Data Source=c:\Inetpub\wwwroot\Dorknozzle\Database\" & _ "Dorknozzle.mdb") filename="products.csv" cmd = New OleDbCommand("Select * from Employees", cn) cmd.Connection.open() dr = cmd.ExecuteReader(CommandBehavior.CloseConnection) sb= New System.Text.StringBuilder 'for field name For...
  8. dawtes

    How to use shell script in visual basic

    It is a program created by the third party for our bidding process.what is does is when i run it create a file we use for our online bidding.I was hoping to write a simple script to copy this file from server and run it and generate those files
  9. dawtes

    How to use shell script in visual basic

    I did just use that but I do not seem to have a luck with it.It works fine when i use other executable files like notepad.exe , However For this GEN.EXE file to be executed I do need to to make a double click on it for me to get the result.I am not sure how i am able to do that inside the...
  10. dawtes

    How to use shell script in visual basic

    I have a .EXE file that i would like to run in visual basic.I did try to use shell script but it does not give me the result i am expecting to get. I need to double click for the exe file to be executed and i do not really know if i can do this inside the visula basic code. Private Sub...
  11. dawtes

    Copy and Convert

    now it works fine thank you johnwm. My next question is after I run this sub routine i would like to invoke an excutable file "Gen.exe" inorder for me to create the final out put. I am just wondering if i just add the executable file before the End Sub.Thank you guys for the help Private Sub...
  12. dawtes

    Copy and Convert

    sorry when I past it, it takes off the highlighted part.. Copy "J:\IO\qebsfnam\pass2ebs pass2ebs.txt" Rem Open "J:\IO\qebsfnam\pass2ebs" For Input As #1 If Dir(pass2ebs.txt")<>"" then Open "pass2ebs.txt" For Input As #1 Else Message = "File not found
  13. dawtes

    Copy and Convert

    I am trying to copy the file I need from the server in this case the location of my server is J:\IO\qebsfnam\pass2ebs and convert this file to pass2ebs.txt and test it if this file exit or not. Can someone take a look at this code and advise me where i made a mistake.I highlighted part of...
  14. dawtes

    Insert point in a text file

    What I am looking or hoping for is a simple routine/program to manipulate line text. For this particular text file, the intent is to add a period 4 digits before a "/" and skip adding a period if it already exists. The text file could be very large so it is impractical to consider adding a...
  15. dawtes

    Slow Query

    I am trying to use this query to create a view and use it in crystal report. However, this query is considerably slow. I am wondering if there is a way to make this query run faster. Thanks SELECT DISTINCT G.CSECNUM,E.IPLINENO, LL.LETTING, E.EIITEM, I.IDESCR, P.CONTID...
  16. dawtes

    Record Formating

    Hi, I have a report which has one group and about 25 records in the detail section from one field. Is there anyway to break the report when it reaches the 5th record and to start a new column. Thanks Example Group A Field A 1 2 3 4 5 6 7 8 9 10 . . . Change to Group A A A A...
  17. dawtes

    How to sumthe value of rows

    create a formula and add the rows Row1 + Row2 + Row3 and place the formula in the report under total1
  18. dawtes

    Grand Total

    Thank you, I got it working
  19. dawtes

    Grand Total

    Hi, Can you help me out on how to find the Grand total of this formula. if GroupName ({table_name.field_name}) = 'A' then (67.7 * Count ({table_name.field_name}, {table_name.field_name}))/100 else if GroupName ({table_name.field_name}) = 'B' then (37.8 * Count ({table_name.field_name}...
  20. dawtes

    Disable view Sub Reports

    Hi, The Problem is I want to display the data from the subreport on the main report. Thanks

Part and Inventory Search

Back
Top