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!

  • Congratulations IamaSherpa 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. dobrowski

    Different Desktop Versions

    "Your desktop version is newer than the APS(SERVERNAME) version. Contact your system administrator." How does this happen? What do I need to change? When can I find help on this topic?
  2. dobrowski

    SQL Agent - getsetting not working in exe

    I have an .exe that runs as step one in my SQL Server Agent job. The .exe uses getsetting to set username, servername, and ... It is not bringing back anything from the registry, why?
  3. dobrowski

    Passing form values/text

    I have a drop down box and instead of passing the "value" i need to pass the "text" of the option that was selected to the next form. Currently using, form.request("selOption").
  4. dobrowski

    Access - Display a picture on a report...

    It doesn't seem to work the same way. Do you have any other suggestions?
  5. dobrowski

    Access - Display a picture on a report...

    I need to display a different picture for each detail line of the report. The name of the .jpg is in the database. The .jpg is on the system. I tried to use the bound image but can't get past displaying the .jpg name.
  6. dobrowski

    ERROR 2147217913/conversion char to datetime/out of range

    No. I am thinking it is a machine error. NT error. We are reinstalling SQL on the machine now with sp1 and then sp2. Any other ideas would be helpful.
  7. dobrowski

    ERROR 2147217913/conversion char to datetime/out of range

    I checked the values of the parms .Parameters("@LicenseYear") = 2001 .Parameters("@LicenseIssueDate") = 6/1/2001
  8. dobrowski

    ERROR 2147217913/conversion char to datetime/out of range

    @LicenseYear int, @LicenseIssueDate datetime, .Parameters("@LicenseYear") = CInt(Format(Now, "YYYY")) .Parameters("@LicenseIssueDate") = Format(Now, "MM/DD/YYYY")
  9. dobrowski

    ERROR 2147217913/conversion char to datetime/out of range

    The following proc is producing the runtime error 2147217913 - the conversion of char data type to a datetime data type resulted in an out of range datetime value. if @LicenseIssueDate > convert(datetime,'11/30/' + convert(char(4),@LicenseYear)) Hardware: NT.40 sp6a server software: ms sql 7.0...

Part and Inventory Search

Back
Top