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