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!

Search results for query: *

  1. MicroZealous

    Convert text to number

    We use Key 4 to define "employee size". Some imported records have numbers that are stored as text. We want to convert these strings to number format and populate another user defined field. How can this be done within GM, or if not, with an external SQL query? GMPE 8.03.80716 SQL Server...
  2. MicroZealous

    variable to update table

    I just learned how to use DLOOKUP to set a public variable. Now I want to write that variables value back into the table. I have looked in help files, but don't know the words I'm searching for! Just a hint or a simple example. TIA.
  3. MicroZealous

    Summing or grouping

    I have a simple Budget database, with expense line items that relate to Organization Units. The Organization Units are in a tree structure, with each Unit relating to one Unit that is higher up the tree. Currently, there are three levels, but I need to provide for four or five in the future...
  4. MicroZealous

    Retrieve Word properties into Excel?

    Good Evening; I have about 250 Word documents, and have created an Excel sheet as an index. One row per Word doc, with a hyperlink to the actual document. Now: How can I retrieve Word doc Properties (Title, Subject, Keywords, number of pages, last saved date etc) into cells in the spreadsheet...
  5. MicroZealous

    Retrieve Word properties into Excel?

    Hi Kids! (Using Word/Excel 2002) I have about 250 Word documents, and have created an Excel sheet as an index. One row per Word doc, with a hyperlink to the actual document. Now: How can I retrieve the Word doc Properties (Title, Subject, Keywords, number of pages, last saved date etc) into...
  6. MicroZealous

    Potential client needs reference account.

    Are you: running MAS 90/200? Multiple locations? Work Orders, Bill of Materials, etc, typical discrete manufacturing? User client has MAS accounting now, wants to implement mfg over multiple locations. No local reference accounts. Thanks.
  7. MicroZealous

    Export update then import ship codes shipping rate

    I want to export my shipping rate file (SO.SHPRATE) to a csv, add some detail lines and reimport. the detail lines are for ZIP code and weight combinations. I could just key them in, but I've got 180 ZIP codes times four codes. There are some fields whose meaning is unclear. Has anyone ever...
  8. MicroZealous

    ZIP+4

    Boss says he wants to do 'ZIP+4' processing on our Goldmine SQL database of 600k businesses and organizations. What does this do? Do I send it out to a service bureau, or get software and do it in-house? Any experiences out there...?
  9. MicroZealous

    Cannot delete an active warehouse

    I want to delete unused warehouse codes, but MAS200 says "Cannot Delete Active Warehouse". There are no Open POs or SOs or items with qtys on hand in that Warehouse, so what makes a warehouse code "Active"?
  10. MicroZealous

    gmlink to Word wants to save merged document before closing.

    Some users on some machines always get the Word prompt to save the merged document, which we do not want. Others do not have this problem. This has been a problem for some time, have researched and searched forums but can't find any references to similiar problem. Changing the macro security...
  11. MicroZealous

    Show tasks - Task window not appearing

    I have a MAS200 user who cannot get the Task Windows to appear. Checking and unchecking the View - Show Tasks box doe snot make the Tasks Window appear. His WS is W2K, fresh install with fresh wksetup install. WTHIGO? Thanks, Mike Roselius MAS200 3.71
  12. MicroZealous

    copy move records process hangs

    If I am moving or copying a group of records from database a to database b, the process hangs at the step "Scanning ContGrps" with 0 records and 0 updates. I can move or copy the 'current record' just fine. Whazzup? Mike R GM CE 6.7
  13. MicroZealous

    Crystal with Report Center

    I have successfuly setup and run Crystal Reports from the Goldmine 6.7 Reports Center on several of our PCs. Except on this one evil PC. The option for Crystal Reports just won't appear in the Reports tree! Yes, I have CR installed on the PC. I've been over the online Help, and followed the...
  14. MicroZealous

    What is file activate.pvx?

    My backup software job log started complaining that this file cannot be verified. File size is 1kb, dated 1/12/2002. I could just delete it, and see if Western civilization collapses . . . or ask you experts. GIA.
  15. MicroZealous

    CCR tree path to hunt group

    I've programmed my MICS 5 CCR tree so that a caller hears the Home Menu, then pressing 1 (path 1) Transfers to Hunt Group 710, 2 to HG 711, 3 to HG 712, 4 to 713. Overflow on all Hunt Groups is to 249, (general voice mail). This works great during the day mode. Problem: at night, option 1...
  16. MicroZealous

    Using VI to update records

    I need to update a Y/N field in AR1_CustomerMaster for many hundreds of records. I tried an update query using Linked table in Access, but my ODBC drive is read only. (And I'm stumped installing the newer R/W ODBC driver, so...) I have used VI to export records. Now, can I use VI to update a...
  17. MicroZealous

    Deleting Inventory Item Master Records

    I have about 2,000 (yes, two thousand!) inventory item numbers that are inactive. Life is too short to go thru the inventory maintenance screen and delete them one at a time. I can generate a file with the item numbers to be deleted. Now I need a method to take the list and delete the...
  18. MicroZealous

    Seek Goldmine 5 file layout

    I need a file layout for Goldmine dBase 5.5 showing field names and indexes. My previous link to the Prior Analytics web site is now invalid. Also, anyone know what happened to the Contact Review Forum on Goldmine? TIA everyone....
  19. MicroZealous

    GM 5.5 and Exchange 5.5

    We have GM 5.50, and an in-house Exchange 5.5 server. GM email has never been setup correctly. When I open the Email Center, and send an email to a valid internet address, it appears sent from GM. In my Outlook, I get a message back from the Exchange server "The following recipient(s) could...
  20. MicroZealous

    SQL or dBase guidance

    Hello all. Here's our situation: We are running Goldmine version 5.50 using dBase. We have 15 users now, may have 20 by year end. We have over 800,000 records, and plan to get to 1 million soon. Are there technical reasons why we should upgrade to the SQL version? I'm new to Goldmine and...

Part and Inventory Search

Back
Top