Search results for query: *

Thank you SO MUCH Dilettante. I got the script from that link you sent, modified it with pieces of my own script and it's working exactly as I wanted. I can't begin to thank you enough!

Wow, that's really neat. Thanks so much. I did not know about that. Please forgive my ignorance. But how still do I process the rest of my code? Do I put it inside the script tags, database connection and all? Many many thanks for your help.

Thanks. No, I'm not passing these values to or from an asp page. I'm passing them to a vbs script file via a simple html form. To further explain, we are extracting system data with wmi from all of our computers via a script. But instead of doing it for ALL of the computers we would like to...

Hi there, I've searched but do not know how to do this. and I'm sure it's elementary but I'm not that familiar with wscript and the syntax. I have a simple html form: <form name=frmTest action=test.vbs> <select name=location> <option value=1>Front Desk <option value=2>Yard <option...

Awesome, Lothario. Works perfectly. Great site, too. Many thanks for your help.

Hi there, I have a small access 2000 database with a handful of records. I want to display these records one at a time in an asp with next previous buttons at the bottom. I've searched paging tutorials, etc. but they seem overkill for what I'm doing. I just want to display a record and click...

It makes PERFECT sense, and it worked like a charm. Many, many thanks!!

Thanks again. Yes, I doublechecked to make sure it allowed nulls and it does. Here's how I'm doing the code: if isdate(last_serviced) then last_serviced=last_serviced else last_serviced=null end if I tried it with last_serviced="" but that isn't working either. Is there a better way to...

Thanks for the reply. I already did that and it still inserts the default sql date 1/1/1900. I even set the default value for the field in the SQL table itself to null. Neither one of those things work. I made sure it was working period by entering a valid date. It is so I'm still lost...

Hello, I have a SQL2000 database with datetime fields in some of the tables. Users have asp forms they add data to the tables with. If the user leaves a date field blank, it defaults to 1/1/1900. Is there a way to not have it automatically enter that date and just leave it null? Thanks.

Outstanding Robert. You always come through. Thanks so much for your helped. It worked like a champ!

Hi there, didn't know quite how to search for this. I'm pulling in file names from fso and would like them to display 6 across, unlimited down. I know how to do that with a recordset but I'm not smart enough to how do I do it using objFile in a for next loop?

Many thanks xlbo and ape. I'll give these a try and don't worry you'll hear from me if I slip and fall. Thanks again!!

Thanks xlbo. I'm so ignorant with Excel I wouldn't even know how to use that code. looks complicated. how would I get it into those VLOOKUP statements? It's amazing I got the above suggestions to work as it is. But many thanks anyway.

Outstanding you guys. Many thanks for that. It's working superbly. Two more questions, though. I need to make some tweaks to the formula. There is a column called "remove from list". If the value is null, the randomization needs to be run. If not, then it needs to skip it. How would I...

Greetings, I found this thread but cannot figure out how to use the vba code. thread707-97374 I have an employee spreadsheet and the boss wants to randomly choose two employees per month for drug testing. Column C has their names, and if they've left, column F has a date so somehow I need to...

The data is already being stored in a database. The lines are numbered by the line_no field, so they are in line_no order in my query. That's the only relationship I have, so whatever falls under the V in line_no order is what gets totalled. I've checked it in Excel though and it's adding up...

I understand. I figured it out. It isn't very pretty, kind of clunky (my norm) but I stuck with it and it's working for me: set rsPB=objConn.execute("SELECT SUM(extension) as ordertotal,SUM(pcs) as totalitems,item_no,lc,description FROM est2 where (estno=2968) GROUP BY...

Thanks Drexor. I understand. Not used to such curt responses, at least not in this forum. I was trying to keep the example simple. The item descriptions are more like this: 1X4-14' ROUGH SAWN SPF S1S2E. Thanks again.

Not hardly. Pretty elementary to you, I guess. I've received so much helpful information from this site by reading posts and posting myself and actually helping others when I can (imagine that) but never had anybody ask me if this is a homework assignment. Sometimes I take the "long way home"...