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!

  • Congratulations strongm 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: *

  1. michaelcoleman

    ActiveX control in Access

    Dude, Can you browse manually to the control location? Sometimes you need to run the control or reboot for it to automatically work
  2. michaelcoleman

    Length of byte array

    Try using an error handler public sub whatever() Dim Buffer() As Byte Dim FileNumber As Integer on error goto errorhandler FileNumber = FreeFile() Open URL(some URL) For Binary Access Read Write As #FileNumber Buffer = Inet1.OpenURL(URL, icByteArray) 'this uses INET control to get the...
  3. michaelcoleman

    Building Logic into a Form

    Dude, Start with http://www.w3schools.com and do the javascript and vbscript tutorials. See which one you like better. MJC
  4. michaelcoleman

    left, mid, right function question

    dude, Try the split command. If the format is first_name middle_name last_name do this: dim strSplit() as string dim strStuff as string strStuff = "John Q Public" strsplit() = split(strstuff," ") strsplit(0) = firstname strsplit(1) = middlename strsplit(2) = lastname MJC
  5. michaelcoleman

    ADO - Operation is not allowed when object is closed

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adosql/adoprg01_0ahx.asp is where it said about not allowing multiple connections.
  6. michaelcoleman

    ADO - Operation is not allowed when object is closed

    I'm trying to connect to SQL server: Set mvarOCN = New ADODB.Connection mvarOCN.Open "Driver={SQL SERVER};Server=" & mvarserver & ";database=" & mvardatabase & ";Trusted_Connection=yes;" Set mvarRS = mvarOCN.Execute(sqlStatement) when my sqlStatement...
  7. michaelcoleman

    multiple connections with same username

    I have more than one application that uses MS SQL Server. It seems that when I try to utilize more than one connections via different software apps, it often times out until one is complete. App 1 is an inserter....inserts test records into db. App 2..3..4 is a query tool..used to get test...
  8. michaelcoleman

    ActiveX can't create object

    I'm trying to dynamically instantiate class modules based on file input so in my project i have a class module called: myClass.cls I would like to do: dim O as object Set O = CreateObject("myProject.myClass") ...but it errors out with "ActiveX can't create object You may be...
  9. michaelcoleman

    Text Direction / Angle in a table

    Hey, I'm looking for a way to display the column names of a table at an angle. I found the command "writing-mode: tb-rl;" for a CSS which puts text in at 90 degree angle but it's at an angle that people aren't used to viewing (opposite). Is there a way to specify the angle of the...
  10. michaelcoleman

    How to make onChange event to send data to another URL

    Thanks dude, you rock...I spent a lot of time trying to figure that out.
  11. michaelcoleman

    How to make onChange event to send data to another URL

    An Exerpt of my code looks like: <form action=&quot;Exec.asp?prj=webSPC&cls=Report&quot; method=&quot;post&quot; > TesterType: <select name=&quot;testertype&quot; onChange=&quot;location='Exec.asp?prj=webSPC&cls=View2'&quot; > <option value=Chassis>Chassis</option><option...
  12. michaelcoleman

    using ado recordset and the getstring method

    you got it dude...with the link Response.Write(oADORecordset.GetString(,,&quot;,&quot;,chr(13)&chr(10),&quot;(NULL)&quot;)) works while Response.Write(oADORecordset.GetStringad(ClipString, -1, &quot;,&quot;, &quot;,&quot;, &quot;(NULL)&quot;)) Thanks,
  13. michaelcoleman

    using ado recordset and the getstring method

    Please assume that open db works but here is opendbconnection function openDBConnection() 'This line creates an ADO Connection object dim oADOConnection On Error Resume Next Set oADOConnection = Server.CreateObject(&quot;ADODB.Connection&quot;) 'We can then open a connection Database...
  14. michaelcoleman

    using ado recordset and the getstring method

    Hello, I'm having trouble getting the getstring method to work in vbscript over asp. set oADOConnection = openDBConnection() Set oADORecordset = oADOConnection.Execute(buildsql(report_type)) '''call function in sqlUtility.asp and get data...
  15. michaelcoleman

    using adodb.recordset getString method

    Hello, I'm having trouble getting the getstring method to work in vbscript over asp. set oADOConnection = openDBConnection() Set oADORecordset = oADOConnection.Execute(buildsql(report_type)) '''call function in sqlUtility.asp and get data...
  16. michaelcoleman

    using adobc.recordset getstring method

    Hello, I'm having trouble getting the getstring method to work in vbscript over asp. set oADOConnection = openDBConnection() Set oADORecordset = oADOConnection.Execute(buildsql(report_type)) '''call function in sqlUtility.asp and get data...
  17. michaelcoleman

    Display of Variant hosed

    All, nm, there is probably a better way but i decided to do a convert function to a view i created for this report. convert(FLOAT,a.ResultValue)'ResultValue' MJC
  18. michaelcoleman

    Display of Variant hosed

    I having an interesting problem. I have sql query which gets data and one of the fields is a variant. The variant field displays fine on cyrstal reports and also on my sql client. When I publish the report on a website, the value for these fields are displayed in ascii hex format...
  19. michaelcoleman

    Can we pass parameters to a crystal report

    Dude, This is all my code for that part Dim yldReport As Yield Dim db As TPDatabase Dim rs As ADODB.Recordset Dim crParameters As craxdrt.ParameterFieldDefinitions Dim crParameter As craxdrt.ParameterFieldDefinition ''''set the design object called yield Set yldReport = New Yield ''''set...
  20. michaelcoleman

    Can we pass parameters to a crystal report

    Dude, This works in vb...shouldn't be hard to figure out in asp Dim crParameters As craxdrt.ParameterFieldDefinitions Dim crParameter As craxdrt.ParameterFieldDefinition Set crParameters = yldReport.ParameterFields Set crParameter = crParameters.Item(1)...

Part and Inventory Search

Back
Top