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 SkipVought 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. zKaleb

    Mixing Javascript with ASP?

    I think your problem is not on the name of the variable, it's on your JavaScript code, it will be wise if you use this on your form: <form action=&quot;SetupPassword3.asp&quot; name&quot;frmProcess1&quot; method=&quot;post&quot; onSubmit = &quot;return Verify();&quot;> and in your function...
  2. zKaleb

    How do I post data in an XL spread sheet?

    Are you sure u are using a Datagrid? And in the references, what version of ADO are you using?
  3. zKaleb

    How do I post data in an XL spread sheet?

    I know u are new to VB so: 1. Make a new project 2. Put a references to Microsoft Excel and to Activex Data Objects 3. Put a Datagrid Control named Datagrid1 4. Put a Command Button named Command1 5. Open the Code window and paste this code Dim rs As New ADODB.Recordset Private Sub...
  4. zKaleb

    How do I post data in an XL spread sheet?

    If you need help let me know and i will email you an example
  5. zKaleb

    How do I post data in an XL spread sheet?

    If you are using Excel 2000 or newer, there is a easy way to do that if you use ADO. If you get your information on an ADODB.Recordset (ie: named rs) and if you get and object making a reference for a Worksheet in Excel (ie: named excSheet) all you have to do is...
  6. zKaleb

    Using Union within a Subquery

    You are getting error because you need to put an alias to the subquery: SELECT * FROM (SELECT Date, Thing='Thing' FROM tblBalancesAsAt WHERE Date='4 June 2002' UNION SELECT Date, Thing='Thing' FROM tblBalancesAsAt WHERE Date='6 May 2002') atable and it should do the job.
  7. zKaleb

    Access from 2 different SQL servers

    Just add one of the SQL Servers in the linked servers area of the one who is going to execute the Statement. Beware that this method is kinda slow when there is a slow network between them, but otherwise, it rules!!
  8. zKaleb

    CDONTS where??

    You can add it too from the Visual Interdev Server located in cd#2 of Visual Studio
  9. zKaleb

    Recordset.RecordCount

    If you use it in ASP, for better perfomance use adOpenStatic and if you are not going to change the data, make it ReadOnly in your LockType, your cursor location got nothing to do. Believe me, is the better performance you will get besides a Firehose (ForwardOnly and ReadOnly)
  10. zKaleb

    Execute a program client side

    sjravee is right, is a major security hazard when you execute progrmas (not pass the documents from the server to the client like the example of goatstudio) but if you really need to do it, by default IIS doesn't allow you to execute an Application. You have to fix a key in the registry to do...
  11. zKaleb

    redirect to default.asp not frameset

    Dont't use the onclick event of the &quot;<tr>&quot; <tr>ONCLICK=&quot;location.href='ActionUpdatePayee.asp?Val=SomeVars</tr> You better put a formal link: <tr><a target='someframe' href='ActionUpdatePayee.asp?Val=SomeVars'>Some Text</a></tr> and in the target attribute put the name of the...

Part and Inventory Search

Back
Top