Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tklear

    Query sysObject to find last modified date

    bummer. Thanks!
  2. tklear

    import spreadsheet problem

    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...
  3. tklear

    using sp_helprolemember to determine user role

    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 =...
  4. tklear

    Query sysObject to find last modified date

    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...
  5. tklear

    Document SQL db

    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.
  6. tklear

    Multiple Recordsets Possible - Count How Many Exist

    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!
  7. tklear

    ADSI usr.ChangePassword error

    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...
  8. tklear

    Multiple Recordsets Possible - Count How Many Exist

    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
  9. tklear

    Multiple Recordsets Possible - Count How Many Exist

    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...
  10. tklear

    Multiple Recordsets Possible - Count How Many Exist

    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...
  11. tklear

    Multiple Recordsets Possible - Count How Many Exist

    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...
  12. tklear

    ADSI usr.ChangePassword error

    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...
  13. tklear

    On Focus FIELDS COLOR

    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...
  14. tklear

    Acobat version On clinet Machine

    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!
  15. tklear

    Identify Records with Same Values in Multiple Columns

    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...
  16. tklear

    Background Colors

    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...
  17. tklear

    How to make a callout within a PDF doc to a .js file?

    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...
  18. tklear

    making a field highlighted before entry and un-highlighted after entry

    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...
  19. tklear

    FORM FIELD: How to expand/contract list view

    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...
  20. tklear

    show/hide fields problem

    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...

Part and Inventory Search

Back
Top