cool, i'll give a try, Thanks! ~Timothy T. Rymer

that is true.. but i'm not exactly sure where to look truthfully. i'm running around with my head cut off, because i've given up on the WebService, and just wrote a ActiveX DLL in VB6 to work in ASP - it worked when i ran the webpage on the local machine, but not when i called it from another website. I did set specifically IUSR_ServerName and ASPNET Users to Full Control. Let me explain exactly what i'm doing just for the heck of it: *I have created a ActiveX DLL, which has a function to create a mailbox using Vircom's VOP Mail (location: 'c:\vopmail') *When calling CreateEmail('email', 'alias', 'password'), I call the Shell() command which calls a batch file located in 'c:\program files\webservice' *this batch file basically has 3 command lines: 'c:\vopmail\mailbox.exe -create %1' 'c:\vopmail\mailalias.exe %1 %2' 'c:\vopmail\mailbox.exe -pass %1 %3' i've set IUSR_ServerName and ASPNET to full control on both of those folders and full control on the mailbox and mailalias EXE's. any other advise? because the shell() command returns with a return value and nothing is crashing as far as syntax errors in asp go. *sigh* so i'm kinda depressed about the whole thing because i'm not that great (obviously) with permissions. Thanks in advance if you can help me ~Timothy T. Rymer

Hey i'm trying to execute a program that is basically located in "C:\EXEFolder" and i'm trying to make a Web Service w/VB.NET to execute that program (inside one of the Web Service's WebMethods) I've tried creating a New System.Diagnostics.Process() and then calling it's Start method, but all i get is an ERROR# 5: Access denied. Obviously it's a permissions thing but I cant figure out what i holding me back from it. I've tried setting the ASPNET User to Full Control on the file but to no avail. Any advice, please? p.s. if i'm in the wrong forum... tell me where to go!!! ~Timothy T. Rymer

Well, first of all the control doesn't do anything but take in the name and password(it basically looks like a login box), and it's used for more important things. So when they click "OK" or whatever, an event is sent called "Sub Control_Verify()" and that "has to be"(so far) in Client-Side VBScript, so when that happens, can i "fake" a form and submit it automatically (inside of this event)? (which sounds like what you're trying to say....) ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com

We have this this ActiveX OCX that we have to use for Username/Password, I can recieve the event that is called when you click submit in the ocx using VBScript. Now, the thing that i want to do is store the user name and password in a session variable in ASP. Is that possible? Again, I have to use the OCX and it seems that the only way to get the Event is to use VBScript. Any Ideas? ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com

SELECT DISTINCT CustomerName, ID, Checked, FoundWith, URL So you're saying that I will get every Record with a distinct URL with this statement? If so will the fact that it has checked(which may all be false at the beginning), or foundwith(which will more than likely have other urls to have the same FoundWith = # with them) so if i state all of those as having to be DISTINCT, does that mean it checks all before adding them? Because basically if there's a statement that says this: SELECT DISTINCT URL, Checked FROM Emails WHERE Checked = False Isnt that going to cause problems? because say they're all false, does that mean i'm to get only 1 urls back no matter what the difference in URLs? And this statement, DanielO wrote: you could try the following SELECT DISTINCT CUSTOMER_NAME ID CHECKED FOUNDWITH FROM Emails WHERE checked = False ORDER BY foundwith for all fields except url I'm just trying to get one url that isnt checked, that's all. The only reason why i'm doing that is so that I dont have to open up another recordset and look for all Customers from that URL, then see if they've been checked or not, and if they've all been checked, then goto the next url. This is all really just fickle, I just wanted to know if there was a way to get all the fields from a Record, where i had a DISTINCT Field that had to be different, then if i have that first distinct record, i could see if it had been checked, and if not then move onto the next one. *shrug* Thanks guys. ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com

I believe so, but I've had to put that on the backburner for now, i'll be sure to reply here if I start working on it again (which should be soon, i'm finishing up a more important project right now, so i'm sure i'll be stuck in asp.net land soon enough.) ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com

Ok, everyone always sees tutorials on how to use "SELECT DISTINCT field" and then they name their field on which they want each record to have a different value in that field. So when you use just that statement, all you get is: CUSTOMER_NAME ----------------- Jimmy Steve Guido Barry Cloud Kefka Jonny ----------------- I'm wondering how i can setup my Sql statement so that i can get the rest of that information with it, in vb6/access 2000. "SELECT * DISTINCT url FROM Emails WHERE checked = False ORDER BY foundwith" Passing this into a data object doesnt work, i want to be able get this in a recordset: CUSTOMER_NAME | ID | CHECKED | FOUNDWITH | URL ------------------------------------------------ Jimmy | 45 | False | 4 | "http://www.web.com" Cloud | 46 | False | 1 | "http://www.howdy.com" Kefka | 47 | False | 1 | "http://www.studmuffin.com" ------------------------------------------------ So as long as everyone has been "CHECKED" from that url, then i dont want to look at that "URL". Hope that explains my problem. Read my example above, does that look like it should work to you? i get RunTimeError 3075: Missing operator in query expression (* DISTINCT url) any reason why? thanks in advance. ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com

Hey, is there any way when you select a distinct field, to get the rest of the fields in the table? Something like this is what i'm "wanting it to do": aka: SELECT * DISTINCT myfield FROM MyTable WHERE isFunky = True so is there any work around? i mean anything that you can do in vb6/access 2000? I dont know much about sql, just the basics, so if i can do anything obvious let me know, cuz truth is i probably dont know how to do it or wouldnt think of it. ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com

Hey, in the Microsoft.Web.UI.WebControls.TreeView Control (which i had to d/l from MSDN), i'm having trouble with the SelectedIndexChanged event which is supposed to go off when a new node is selected. Here's what i've read so far: Dynamically added nodes in Page_Load() won't have events, so just to be safe i create all nodes in the Page_Init(). Any advice other than this will be helpful! ~Timothy T. Rymer

If so, any fixes? ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com

Thanks... ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com

????? :zzz: ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com

hey, I have a ms access file that stores when an entry was made. if that date field is today, i want to store it in a recordset object. how do i query that? "SELECT CheckDate WHERE Checkdate = ???? TO ???? " how would that work??? Please help! Thanks a bunch! ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com

Cool, well at least that all makes sense now! Thanks Michael! ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com

and to no avail... I cant even see what executable the shortcut is calling to try and do some funky hack job in the registry! and just so you know i've installed msdn onto my computer from our dev server, so when i run anything from MSDN (samples, etc) it accesses the file from the server, but i still dont know what the executable is... i believe the old one is just using "hh.exe" and then the path of the collection (*.col) right after.. but 2002 has a bit of a change (file types, etc) and i cannot find the executable... any suggestions are invaluable, but i'm moving on, i'm not fooling with it unless you guys have a suggestion... *sigh* i'm gonna try to contact microsoft, i checked their site, there was some things that were close, but not good enough, (mostly bugs in installing msdn w/ DVD) thanks guy(s?) for your help, i appreciate it immensely!! ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com

But i'm gonna do some more searching in the registry... i think all i searched for before was "MSDN" so i'm gonna look through "VS" and "Visual Studio" searches... *SIGH* ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com

It seems like it'll work, but i had reinstalled VS Enterprise Edition w/o MSDN, so i just installed the msdn 6.0a that comes with the subscription, but i had already installed Jan 2002, so i'm uninstalling that, and reinstalling it now... but that doesnt work. It doesnt show up in the list to choose which version of MSDN that i would like to use... Hmm... suuuuuuper strange. ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com

Hi, i'm trying to install the newest MSDN CD's to a computer that has Microsoft Visual Studio Enterprise Edition - which has it's own MSDN cd's in MSDN Subscription, and when i update it, and hit F1, it doesnt open up the newest MSDN, it opens up the old one!!! How do I fix it? I even tried to uninstall VSEE and reinstall it, and then install msdn when it asked for it, but it's looking for the Cd's that came with the subscription! I am screwed. How can I "unscrew" myself? I tried looking through the registry a little bit... any ideas? ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com

I have a data control and I need to pass in a Data object in a function's parameter. I'm the one making the function, so I can change it to a recordset, which is "ok" but it just doesnt make a whole lot of sense to do 1/2 of what i want to do outside of a function, and the rest inside of a function! (if i would pass a recordset) So any suggestions? my boss remembers doing it but he forgot how. (uhh huh, yeah ok) I believe it can be done, but all i want is a Data object, because that's the only thing i've really messed with in messing with Databases (i'm pretty new to VB but a veteran to C++) Ok, thanks in advance! ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com