Search results for query: *

bummer. Thanks!

I'm having a similar problem with an Excel 2000 cell that contains lengthy text data. It should import into a memo datatype field but access will not allow be to adjust the datatype for that column when importing. Is there any way to adjust the datatype (other than the dummy record)? I will...

I need to be able to tell if the system_user is a member of a certain role (db_owner). So I set up a stored procedure that returns me a boolean indicating if he is in the role: CREATE Procedure roleGrabber @systemUser varchar(200), @roleName varchar(200), @isMember bit out as SET @isMember =...

I would like to be able to detect any database object that has been modified since a certain date. Is there a way I can accomplish this. It would help a lot with moving schema changes from development to test environment. I see a crdate and a refdate but the values seem to be the same in...

I'm trying to detect a whether a field is nullable from an ASP page using an ADODB recordset field. I'm getting an error because the ASP doesn't recognize the constant. Is there a value I can use instead? Thanks.

Thanks everyone for your help. I've been successful in determining if I have multiple recordsets. There doesn't seem to be a property that can be called, however, the error trapping ideas provided allow me to count the occurrences while suppressing the error. Thanks again!

Thanks for trying but this is basically what I've already tried except to add: On Error Resume 0 at the end to turn off error trapping. The result is the same. Regardless of why the password can't be updated the error is trapped but no information is provided as to the reason. I can give...

Shaddow, Don't suppose you have time to look at this post of mine: thread333-714340 has to do with ADSI.changePassword You are good so I thought I'd ask. Thanks again for the solution on this one! Terry

OK, this time I get the following error: 1!record record record record record record record record record 2!record record record record record record record record record 3! Microsoft VBScript runtime error '800a01a8' Object required /list/sortList.asp...

George, that is close to what I need but I'm getting an error no matter how many recordsets I have. Here's my test code: dim intRecordsetCount intRecordsetCount =0 ' ASP did not recognize adStateClosed variable While Not rst.State = 0 intRecordsetCount = intRecordsetCount + 1...

I have a stored procedure that returns multiple recordsets for example: select employeeId from employee select termID from term The number of records can vary depending on which stored procedure is called (sp name is passed as a parameter into the ASP page). In my ASP page I would like to...

I'm using the ASP script below to change a user's password by calling ADSI. This works fine as long as the user follows all the enforced rules for password creation. If they don't I get a very general error that I'm displaying with err.description. The error states: 450, Microsoft VBScript...

var a = this.getField("fieldName"); // create your own color by getting true RGB values and dividing each number by 255 color.myColor = new Array("RGB",1,1,.62); a.fillColor = color.myColor; // you can also use standard colors like this a.fillColor = color.red Hope that...

If you are talking about using JavaScript in an Acrobat PDF form to find out which version of Acrobat the user has this would be how: if (typeof(app.viewerType) != "undefined") { app.alert(app.viewerType); app.alert(app.viewerVersion); } Good Luck!

I have a table with 5 columns that each contain a value from 1-13. I want to find those records where the same value occurs in more than one of the 5 columns. Is there a function that will handle this? So far I have this idea but am looking for an easier/faster way: select fooID from foo...

With the form open there is a right error in the upper right corner. Click it and select Preferences. Then click Accessibility. There is a section for Color Scheme - if you select "Custom Color Scheme" you can select your form background and text color for the entire form. You...

You can put the javascript function at the document level by going to following in the menu options: Tools > Javascripts > Document Javascripts These functions can then be called from anywhere in the current form. There may be a way to put them at a higher level (template level?) but I'm not...

You can also make your own custom colors by using the following code: color.myColor = new Array("RGB",1,1,.62); [VAR NAME].fillColor = color.myColor; [VAR NAME].required = true; - makes the field required Note that in the creation of the color array above, you take the true RGB...

I've accomplished something similar by having two fields - the drop down list with one name and a separate read-only text field with the name of the code I want to obtain. Whenever the user selects something from the drop down I programatically fill in the text box. If this will work for you...

I found out how to empty out the setting and it's pretty simple - just use: fieldToHide.value = ""; Also, FYI - you can create document level functions to call from any trigger from any field in your form. I noticed that a standard Reset button does not reset some things that I...