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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by macr0

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

Part and Inventory Search

Back
Top