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

    Do until loop not working

    HI Andy, I changed your code to this, but that did the trick. Thanks. ' Select cell A22, *first line of data*. Range("A22").Select If Range("B4") = "802" Then ' Set Do loop to stop when an empty cell is reached. Dim inrR As Integer intR = 22 'Start at row 2 Do While Range("A" & intR).Value...
  2. Sardamil

    Do until loop not working

    I'm sorry if I confused you. Here's a part of the spreadsheet. The client number is in column B. All other values are in column A. client 68294 client 68294 klant 68294 VERWERKTE AANTALLEN/BEDRAGEN I want to replace the cells in...
  3. Sardamil

    Do until loop not working

    Hi Skip, thanks for your elaborate reply. I tried using your code, but it doesn't work yet. The loop doesn't end when it reaches a cell with value ABC. When I use your code, every cell in the range gets replaced by value XYZ, until an empty cell is reached. I would like to make it stop when it...
  4. Sardamil

    Do until loop not working

    I'm creating a macro in excel. One of the tasks of the macro is to replace the value in a cell, until it reaches a cell with a certain value. I keep getting this message however: "Run-time error '1004' : Method 'Range' of object'_Global' failed" ' Select cell A22, *first line of data*...
  5. Sardamil

    Running a module from a button in a form

    I'm not sure if I posted this in the correct forum. Could somebody please move it to the correct forum? Thanks.
  6. Sardamil

    Running a module from a button in a form

    I'm making a small database to help a friend. In this database he needs to track customers and their appointments. For this I created a form to enter custumerdetails and appointments. Both are added to their respective tables using a macro. The customernumber is an automatic number of the table...
  7. Sardamil

    update not working

    Just set the USESLIDERS to false and now even IE is working perfectly. Window to my world
  8. Sardamil

    update not working

    Working perfectly in firefox, but IE is have probs. Trying to figure that out. Window to my world
  9. Sardamil

    update not working

    For some reason I kept getting the incorrect login message. I replaced the login script with the old one and now everything is working perfectly. Thanks a lot for your patience and time. Window to my world
  10. Sardamil

    update not working

    I think it should be something like this. Haven't tried it yet though. Will do when I get home. function checkLogin(){ if (!empty($_POST['login'])){ if (empty($_POST['user']) || empty($_POST['wachtwoord'])){ //data not provided displayLoginForm('You must...
  11. Sardamil

    update not working

    if (!$isValid){ displayLoginForm('Either your username or password is incorrect'); Is this correct? Now I always get the message. Sorry, I know you said that was your last post. Window to my world
  12. Sardamil

    update not working

    this is what I was looking for. Of course I never thought of a slider, but that's ok. Window to my world
  13. Sardamil

    update not working

    Sorry, couldn't help myself (being a tester). If you login with a different name, the script will still log you in. It just will not show you anything. It will not give you an error message. I logged in with peterx/test and I got in. That's what I did wrong earlier. Window to my world
  14. Sardamil

    update not working

    working now Window to my world
  15. Sardamil

    update not working

    it's not working. It looks like what I got before I changed this in login.php sql = "select * from " . USERTABLE .' where naam=%s'; into sql = "select * from " . USERTABLE .' where user=%s'; no names are shown now and no detailrecords. Window to my world
  16. Sardamil

    update not working

    One thing though, is it possible to replace the slider by a checkbox or the radiobuttons. I'm not sure if people will understand the slider. If not, that's ok. I'll just have to explain clearly what they need to do. Window to my world
  17. Sardamil

    update not working

    that should work. I cannot see if it updates the database though. I didn't see the slider, but I still get the radiobuttons for some reason. Window to my world
  18. Sardamil

    update not working

    From firebug's net panel. When I change a radiobutton nothing happens in firebug. GET ui.slider.js http://jquery-ui.googlecode.com/svn/tags/latest/ui/ui.slider.js 304 Not Modified jquery-ui.googlecode.com 14 KB 379ms ParamsHeadersPostPutResponseCacheHTML Response Headers Date Sun, 30...
  19. Sardamil

    update not working

    In login.php I changed sql = "select * from " . USERTABLE .' where naam=%s'; into sql = "select * from " . USERTABLE .' where user=%s'; That fixed the problem. Still no update though. Checking firebug now. Can't get firebug to work properly. Keeps asking me to reload. As aanwezigheid is a...
  20. Sardamil

    update not working

    I gave you an export of the tables, so you should have had the correct db schema. Will empty the browser cache and have another look at it. Window to my world

Part and Inventory Search

Back
Top