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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bradmathews

  1. bradmathews

    Append query from Access Table to Linked SQL Server Table Failing

    I got it figured out. Apparently a bit field in SQL server can be Null!?!?!? There are two additional fields in the SQL version of the table. The NVarChar field I had set to allow nulls. I never bothered with the Bit field. When I checked Allow Nulls on the bit field and re-linked, my query...
  2. bradmathews

    Append query from Access Table to Linked SQL Server Table Failing

    Thanks for your quick reply! I tried your suggestion but I get a message that there is no such index. I also tried the individual field indexes (Colors_Access has a compound index) and it didn't like those either. I had already tried adding an index to the SQL table and re-linking. I also...
  3. bradmathews

    Append query from Access Table to Linked SQL Server Table Failing

    Strange one here - I hope there are some SQL Server gurus around as well. Access is telling me it can't append any of the records due to a key violation. The query: INSERT INTO dbo_Colors ( NameColorID, Application, Red, Green, Blue ) SELECT Colors_Access.NameColorID...
  4. bradmathews

    Topic: Dynamic Explorer context menus - problem

    Solved! Right click in Windows Explorer and uFlags passes CMF_EXPLORE as expected. Right click in My Computer and uFlags passes CMF_NORMAL which is what you would expect for a right click drag! Even more interesting, when I do try a right-click drag, uFlags does not pass CMF_NORMAL. Not that I...
  5. bradmathews

    Topic: Dynamic Explorer context menus - problem

    Howdy all, I have written an app that dynamically modifies the windows explorer context menu. It works on all files as I put my GUID into HKCR\* (and HKCR\AllFileSystemObject and HKCR\Folder while attempting to debug this issue). The problem is it doesn't work in My Computer, only Windows...

Part and Inventory Search

Back
Top