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 Mike Lewis 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. JeffOrtho

    Insert/Update Statement

    I am using the SQL import wizard to create my table with the data i want to then import into my table needing the updated info. This is the table i want to update. Some of the items are not in that table yet, will an insert have to be done in order to then do an update? ITEMNMBR RBI_Kit_Type...
  2. JeffOrtho

    SQL Update Statement for ~20,000 items - LxWxH

    Yes item number is unique. there is only one item number with its own information.
  3. JeffOrtho

    Insert/Update Statement

    I have a table with 20 rows. I want to import 10k+ rows from an Excel. Do i have to have every column on the excel to match the table in SQL, not just the ones i want to insert? I'm just confused why i cannot get this to import. I want to be able to just say insert these items into this table...
  4. JeffOrtho

    SQL Update Statement for ~20,000 items - LxWxH

    I have a test database to fool around in for things. So no worry there. The information in the NEW table is just the item number, length, width, height, so nothing else would match as another column although i guess i could create a column with 1,2,3,4 as the value to separate this into batches...
  5. JeffOrtho

    SQL Update Statement for ~20,000 items - LxWxH

    I use Microsoft Dynamics GP 10. I need to update all dimensions of all items. I know SQL and have googled around to see how to do a very large update on 3 columns for 20000+ rows but can't find anything that really looks like the best way possible without locking up my server. How would I be...
  6. JeffOrtho

    Price Code Maintenance (Could not load objects because they are not available on this machine)

    References is greyed out and I am unable to click to find out if anything is missing.
  7. JeffOrtho

    Price Code Maintenance (Could not load objects because they are not available on this machine)

    How would i find the filename? When the VB opens to debug, a Compile Error pops up stating Method or data member not found and highlights the .MacSearch2.Enabled = True
  8. JeffOrtho

    Price Code Maintenance (Could not load objects because they are not available on this machine)

    When the VB script opens .MacSearch2.Enabled = True is highlight and under tools, references is greyed out. We have it installed on some machines working fine but its been a while since we have installed it and can't figure this error out. Any ideas?
  9. JeffOrtho

    Flexibility Screen Error (Microsoft Forms-Objects Could Not Load)

    Appreciate the thought but i have installed this on a 32bit XP machine and i'm getting this error.
  10. JeffOrtho

    Flexibility Screen Error (Microsoft Forms-Objects Could Not Load)

    I have a Flexibility Screen trying to load and I'm getting the Microsoft Forms error, "Could not load objects because they are not available on this machine." Is there an OCX or DLL needing to be registered. This only happens on new installs. Macola 9.5
  11. JeffOrtho

    Price Code Maintenance (Could not load objects because they are not available on this machine)

    This price code maintenance screen is a Flexibility Screen trying to load and I'm getting the Microsoft Forms error, "Could not load objects because they are not available on this machine.
  12. JeffOrtho

    Price Code Maintenance (Could not load objects because they are not available on this machine)

    Under OE & RMA and Price Codes when trying to launch Price Code Maintenance, i receive the error Could not load objects because they are not available on this machine. How can I resolve this issue. It does this on any new install on Win7, WinXP, x86, and x64.

Part and Inventory Search

Back
Top