Search results for query: *

Is there a way to pull ADS info and set them to variables in a vbscript????? All i need is the connection syntax and the syntax to pull the data or setup a recordset. (I plan to then open a SQL connection and add them to a table)

I may have a really really stupid question here. I have a sql table that contains information about users in the system (about 400-500 users), and I would like to pull hte data from ADS. Does anyone know how I can accomplish this? My Director mentioned something about LDAP, but I don't know...

I have a really really stupid question here. I have a sql table that contains information about users in the system (about 400-500 users), and I would like to pull hte data from ADS. Does anyone know how I can accomplish this? My Director mentioned something about LDAP, but I don't know if he...

I have a webpage, that on load establishes an adodb connection. the problem is, if i close the page then reopen it, it will not connect. i am guessing that it leaves it open. i put a myConn.close in the code, and it does not seem to make a difference. i am tired of restarting my PC. please...

I have a from where the user types a number into an input box, then makes selections on comboboxes (drop downs) and clicks submit. when they click submit, i want to save in a table the number they entered, and their selections. first, is there any other combobox property other than...

Ok...I have been searching for answers for 2 days. Forgive me if this is a dumb question, i think i killed my brain. What i am trying to do is this: i need a webpage that is a performance survey. It has several text fields and combo boxes. I am trying to create a vbscript that will save the...

Can anyone tell me how to write a conenction to sql? I am trying to perform a mail send based on values in a sql table. i need to change the value after the action is perfomred also. I think i have the mailing part down, just the conenction to sql. i have searched the posts, and am reading...

Please forgive me, i am new to vbscript, so if i say anything stupid, feel free to laugh at me as i probably won't hear it. I need a server to fire off emails based on a value in my sql server database. the emails need to have data from another table, and fire automatically. i was told that...

Hi all, I have a table structed like this fld1 fld2 fld3 fld4 1234 bbbb cccc 1111 1235 bbbb cccc 1111 1236 bbbb dddd 2222 1237 eeee dddd 2222 1238 eeee dddd 2222 what i want to do is list in the query, data that is not a duplicate of fields 2,3, and 4. so if those three fields are duplicated...

i need to cut a string of length 10 down to length 6, cutting off the last 4 characters. any idea how to do this? will trim work on something other than whitespace??? help me please!!!

does anyone know code to generate a random integer for a variable??? i want to have an if statement execute 20% of the time, I figure that if i can get a variable to take an integer from 1-100 and if that number is 1-20 then execute. anyone know how i can do this?

I am trying to make a mcaro for outlook 2002 using vba. I have it set so that it will open a new email message, but I'd like to to be able to put in text in the body of the email as well as a subject line. I write an email that is the same with the exception of recipient and one or two words...

I have a form that generates a report dynamically, but i need it to calculate from the first tuesday after the first monday in a month to the next month's first monday (hope that makes sense). How can I do this? any ideas? hayt

I am trying to build a search function into a form where the user inputs a string, and then a query is built to find a record where the chosen field has that string in it. I would like to open a form based on that criteria that opens the records one at a time. So i need to know how to filter...

does anyone know a way to make an int field an autonumb field with code or anything? anyway that works i am happy with! hayt

i have a primary key that is identical in two tables. I have a form that populates table2, but i need to check to make sure that the primary key (order_number) isn't already present in table2. is there a way to write some code that will check this, and then generate a dialog box informing the...

I have a form that lists two tables, and pulls data from a third. What i want to do is this, i want to add a record to the third table, inputing variables from my form into the fields. i just need to know how to add the data to the fields. any help would be appreciated! hayt

I have a form that lists two tables, and pulls data from a third. What i want to do is this, i want to add a record to the third table, inputing variables from my form into the fields. i just need to know how to add the data to the fields. any help would be appreciated! hayt

i am a bit new at this, so i am sorry for what i am sure is probably really easy to you all, but i need to set a few variables to be the result of a query. can anyone help? hayt

I have a form where the user selects criteria, and i wish for a subform (looks like subdatasheet) below that i wish to display records based on that criteria when the user presses the "list" button. I know the sql, and have it all setup, but how do i actually get the subform to update...