Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Format "1" as "01"

    I would probably write an INSERT/UPDATE trigger that would update the field to '0' + field if LEN(field) = 1.

  • RE: How to store Images (.jpg, .bmp) in DB?

    Check this on support.microsoft.com

    Microsoft Knowledge Base Article - Q258038

    HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO Stream Object

  • RE: Using image files in SQL

    Steve,

    I found this MS example of using the ADO stream with VB. Support.microsoft.com

    Microsoft Knowledge Base Article - Q258038

    HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO...

  • RE: Excel querydef with Activex Controls

    You should set the Range object to the location of the starting cell.

    Example: Range("A2").Select

    I would suggest that you record macros and perform certain tasks, then stop the macro and look...

Viewing 4 posts - 1 through 4 (of 4 total)