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...
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...
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...
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*...
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...
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
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...
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
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
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
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
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
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...
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.