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

  1. lazytrucker

    OnUnload Event problems

    Hi all, I am using a script not unlike this below to open a new page when the client closes the browser: <body onLoad="closing=true" onUnload="if (closing) window.open('thanksForVisiting.html');"> The below code has been added to links to ensure the window does not open when navigating. <a...
  2. lazytrucker

    Simulteaneous request issue??

    Hi all, I am getting an error when users execute the exact request at the exact same time: Run-time error -2147024864 The process cannot access the file because it is being used by another process. The function being used in the dll makes, saves, sends, recieves and then saves an xml object...
  3. lazytrucker

    Run Time ERROR -2147024864

    Hi all, I have a site that heavily processes XML in conjunction with a DLL which in turn comunicates with an external server. Process: The .asp web page builds an xml, sends it to the DLL function which then runs through a connection process and building of several xmls (all xmls are created in...
  4. lazytrucker

    IIS Load Issues

    Hi all, I am running a test server on xp pro with iis 5.1 and MYSQL Server, and have come across several issues. 1.)When logging in with 8 users simulteanously not all are granted acces. Is this due to lack of proxy, Or a load issue, or something else? 2.)The server runs a dll which...
  5. lazytrucker

    RoundUp to 5

    This seems to work funny result for value 0.01 though as it is always rounded down hence the extra statement. Function RoundUpTo5(NumIn) If NumIn = 0.01 then NumIn = 5 else NumIn = round(NumIn + 0.49) If NumIn Mod 5 > 0 Then NumIn = 5 *...
  6. lazytrucker

    RoundUp to 5

    Thanks for all the replies but none of these soloutins work with decimal places. It is £'s and pence Im working with here so no negatives and always two decimal places. I am trying to alter genimuse's script but maths was never my strong point. Any suggestions very welcome. Cheers lazytrucker.
  7. lazytrucker

    RoundUp to 5

    + 234.00 rounds to 240 and 189.00 rounds to 195
  8. lazytrucker

    RoundUp to 5

    That looks fair enough but if the number is is 3.00 then it rounds to 10 I have a string manip func that works but it is messy. :: a = 435.00 b = 433.00 a= cstr(formatnumber(a)) b= cstr(formatnumber(b)) function roundUp(cost) if formatnumber(right(cost, 4)) <> 0 then...
  9. lazytrucker

    RoundUp to 5

    Hi all just wondering if anyone has a script which will round up a number to the nearest 5 eg: 123.15 >> 125.00 128.72 >> 130.00 Any suggestions will be appreciated Cheers Lazytrucker
  10. lazytrucker

    Dynamic Locks

    After recently changing from MSSQL to MYSQL I have encountered a couple of problems. Here is an sql statement used in a Dll which connects to MYSQL database. The query seems to fall down at the point of rs1.UPDATE does MYSQL not support this sort of structure, syntax? I dont think it is to do...
  11. lazytrucker

    MULTIPLE INSERTS

    Is it possible to simultaneously insert a row into different tables using different column names in each table and different/similar values. EG: INSERT INTO table1 (col1, col2, col3) values (val1,val2,val3) INSERT INTO table2 (col5, col6, col7 ,col8) value(val1,val2,val6,val8) (BOTH above...
  12. lazytrucker

    GOOD TABLE STRUCTURE?

    I have looked at primary and foreign keys, and it is NOT an option, normalization is not possible for my application. I have heard MYSQL can handle (Supposedly) over 1,000 columns and over 1,000,000 rows of data what I need to know is what is the performance issues related to having more columns...
  13. lazytrucker

    GOOD TABLE STRUCTURE?

    Quick question to see if any one can point me to some articles or something. I am redesigning some of the larger tables in my "mysql" database, I want to create a new table with somewhere between 25-30 columns and 1000's of rows. This will be getting queryed alot and query caching is not an...
  14. lazytrucker

    CONVERT STRING TO OBJECT

    Hi all, is there a stored procedure or method for converting a string to an object?? The context in which I am trying to do this is as follows: For i = 1 To 3 "UserForm1.TextBox" & i & ".Visible" = False Next UserForm1.Show This obviously doesnt work but is...
  15. lazytrucker

    DYNAMICALLY CREATE FORM

    Hi Tony I see what your getting at here, and thanks for not telling me it simply wasnt possible, but when I try to run the sub I get an error: Run-Time Error'1004: Programmatic access to visual basic project is not trusted. This occurs on the first line of code: Set frm =...
See more

Part and Inventory Search

Back
Top