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: *

  • Users: macr0
  • Order by date
  1. macr0

    Access autonumber update.

    Thanks a bunch dave, That's what I needed.
  2. macr0

    Access autonumber update.

    No, This page is called "CreateList.asp" Self submiting form page.
  3. macr0

    Access autonumber update.

    Do you mean the ListID? Yeah, it does automatiically assign it. That is why I need to get it after I update the record ;) Jeremy Lowery
  4. macr0

    Access autonumber update.

    What's wrong with this code? objRS.Open "InvLists", objConn, adOpenStatic, adLockOptimistic, adCmdTable With objRS .AddNew .Fields("Name") = strName .Fields("DateAdded") = Now .Update End With iListID = objRS("ListID") ListID is an autoNumer field in...
  5. macr0

    Format time to milliseconds?

    I don't believe that there is anyway to do this specifically, a component could do this easily though. If by any chance you are trying to benchmark to get an accurate time, I'd recommend Microsoft's Web Application Stress Tool that is a free download from microsoft.com Jeremy Lowery
  6. macr0

    Component Constants Accessed by ASP

    Does anyone know how to expose component constants written in VB6 so they can be used by ASP Pages? Mainly, like msado15.dll that can be used in a <!--METADATA--> tag. I read somewhere that you could add a module to your VB component and add &quot;Public Const&quot; declarations and they would...
  7. macr0

    Can you help me with free hosting (with ASP)

    I'm currently hosted on http://www.brinkster.com/ . They have free general memberships, which includes ASP, SSI, and Microsoft Access Database support. For free you don't get to use Global.asa or any components, and you have to use web based file upload. But, for 10$ a month you get Global.asa...
  8. macr0

    I have a table in Access, and I want to figure out how I could in VBsc

    the reason you get the subscript out of range error is because you have your subscripts out of order. I personal use constants for the column names so I don't have to remember numbers and such. <br><br>const strcolumnname = 1<br><br>For rowcounter = 0 to Ubound(AryData,2)<br>Resoponse.Write...
  9. macr0

    I have a table in Access, and I want to figure out how I could in VBsc

    As palbano said, your Conn variable is null unless you have a definition for it elsewhere. It's the connection string that's either a DSN, Driver UID Pwd, or Provider UID Pwd.<br>Another small problem I see comes right after the Open Method call.<br>if RSKid.EOF...
  10. macr0

    I have a table in Access, and I want to figure out how I could in VBsc

    I wrote a message board that used the same kind of technique your describing. in a Hierarchal structure display. basically what you can do is put your recordset into a 2 dimensional array using objRs.getrows for speed. I used two functions, both of them looped through the array. the first...
  11. macr0

    Tree structured Web Site

    Does anyone know the best way to create a tree like web site? For exampe: Amazon.com Like<br><br>Books &gt; Horror &gt; Authors, A-Z &gt; ( K ) &gt; King, Stephen &gt; Riding the Bullet <br><br>and being able to click the subheadings back up to the main page? <br><br>I have been able to create...
  12. macr0

    Cache problem

    Anyone know why I get this error? (IIS 5, win2k)<br><br>ADODB.Recordset error '800a0cb3'<br>Object or provider is not capable of performing requested operation.<br><br>from the following snip:<br><br>iPageNum = 1<br><br>objRs.AbsolutePage = iPageNum<br><br><br><br>and also, I can only set...
  13. macr0

    ASP Development Program Suggestions?

    I personally agree with jaspr, HomeSite is a wonderful ASP development program if you like work from the code up. It's color coding is good and you can easily make your own wizards to do common tasks (like making DNS or DNSless ADODB connections and recordsets for example.) <br><br><br>Jeremy Lowery
  14. macr0

    Must use an updateable query

    I'm not sure. I just got win2k the other day, and I&quot;m still learning it. I think that is User Access to the database (like people that login to the computer). For what I'm talking about, you can do it two ways. Goto control panel, admin tools &gt;&gt; Internet Services manager or goto the...
  15. macr0

    How to I kill a session when a browser window is closed using X

    I have had a similar problem and the easiest (probably not the most efficient) way to solve the problem is to have another seperate window that's sole purpose is to end the session (because there is no Client&gt;&gt;Server mechanism in ASP, only Server&gt;&gt;Client). use onunload event handler...
  16. macr0

    Must use an updateable query

    Elab on Write Permissions<br><br>If you are using winnt/2k use the MMC IIS snap in to set the permission for your database folder. Just right click&gt;&gt;properties and the options will be right there. If you're on a Win 98 system using PWS Click the Advanced button, select your database folder...
  17. macr0

    Getting started with ASP

    As far as links go, there are plenty of them here! If you want to get some hardcopy material, Wrox has put out some excellent ASP books. <br><br>Beginning Active Server Pages 3.0 (Professional too)<br>&nbsp;&nbsp;ISBN# 1-861003-38-2<br><br>Beginning Components for Active Server...
  18. macr0

    Function Overloading

    Is there a way to overload a VBScript function? Take the following example:<br><br>definition:<br><br>Function MakeConn(strSql, x, y)<br>Dim ConnTemp, RsTemp<br><br>Set ConnTemp = Server.CreateObject(&quot;ADODB.Connection&quot;)<br>Set RsTemp =...
  19. macr0

    problems with variable scope

    I am not sure what &quot;usertype&quot; is, if it is a form field. then you can do what you want without ASP, just ole JavaScript. Just Make the Form have no ACTION attrib.<br>like &lt;form name='myform' method='POST' onSubmit='pagesender()'&gt;<br><br>and then javascript like...
  20. macr0

    ASP Tips

    Don't forget <br><br><A HREF="http://www.4guysfromrolla.com" TARGET="_new">http://www.4guysfromrolla.com</A><br><br>Very deep site

Part and Inventory Search

Back
Top