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 Chriss Miller 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. toccata

    Executing MAS 90 Program from VBA

    Does anyone have a code snippet to call or execute a MAS 90 program, e.g. GL Transaction Register, from VBA or a batch file? I can successfully execute VB Imports but not other MAS 90 functions.
  2. toccata

    Multiple Databases

    I will have multple clients setup on the same database using structurally identical tables. I'd like to select the database to use from a menu. I want to maintain separate database folders containing only the client tables. I'll be using a 3 character client code that I'd like to incorporate in...
  3. toccata

    Streaming Zip File into XML

    Here is the sample IRS SOAP envelope: MIME-Version: 1.0 Content-Type: multipart/related; boundary="MIMEBoundary"; type="text/xml" Content-Description: Transmission File Containing one Submission. X-eFileRoutingCode: MEF --MIMEBoundary Content-Type: text/xml Content-Transfer-Encoding: 8bit...
  4. toccata

    Streaming Zip File into XML

    I'm writing an Access application that prepares submission files for the IRS. I create the data file without difficulty and zip it to the specified folder. The zipped data file is then to be imbedded in an XML file that I create. The IRS documentation and tech support states that the .zip file...
  5. toccata

    Excel Validation

    The event generating the default value is the cell to the left not null or <>"". The list contains 12 elements.
  6. toccata

    Excel Validation

    Data validatio list
  7. toccata

    Excel Validation

    Is there a method, function, setting to set a default value in a dropdown?
  8. toccata

    Adding Contacts

    How do I get new contact city, state, zip to default or auto fill to company city, state zip in Act 2007?
  9. toccata

    ODBC Driver Distribution

    How do I distribute my Access ODBC driver and implement it with my compiled application? Is there a Microsoft technical reference?
  10. toccata

    Check Box Label Highlight

    When a check box gets focus, the attached label is sometimes highlighted by a box, other times not. What causes this? I'd like the label consistently highlighted so my users know what control has focus.
  11. toccata

    rebuild application files

    I recommend rebuilding keys, rebuilding sort files and relinking line files monthly. I also recommend as a minimum: Daily incremental backup Weekly and monthly FULL backup And if you haven't, test the restore function on some non-critical files to be sure it will work - too many don't...
  12. toccata

    UDF fields and their tables

    The udf files are named: "Application"_9#"CompanyID".soa where "Application"=Ar, SO, IM, etc. e.g. IM_90ABC.soa Open a blank Crystal report, connect to SOTAMAS90 odbc and you'll see the udf files in the list.
  13. toccata

    rebuild application files

    It's safe to rebuild application key files any number of times. I've never had it CAUSE a problem in 18 years and 300 installations. Your symptom sounds more like a network problem - either a bad network card or wiring troubles.
  14. toccata

    enter 1 entry gl posts 2

    Sounds like she entered a Reversing Date in General Journal Entry (This is most often used for accrual entries that are to be automatically reversed in a subsequent fiscal period)- this creates a second identical but reversed entry dated on the Reversing Date.
  15. toccata

    Can you enter...

    First, you must log on as a user with supervisor rights. Enter the trans in GJ entry, out of balance. Accept the entry. You'll be prompted "One". Select "One", print journal and update.
  16. toccata

    Modifying Crystal report

    This will require some Crystal expertise... Edit (Design) the custom report and create a group for the Product Line - it's in the IM1 Item Master File. If you need the Product Line Description, you'll have to link the Product Line file. You can also add the Vendor P/N... Insert - Field Object...
  17. toccata

    Can you enter...

    You're probably missimg an account number in AP Setup. Ceck division and setup files.
  18. toccata

    A/P Invoice Reversal

    Yes... Then run the invoice register and update.
  19. toccata

    A/P Invoice Reversal

    1. Use Invoice Data Entry 2. Enter Vendor and the Invoice you wish to reverse 3. You will be prompted to Adjust Invoice 4. Enter adjustment amount NEGATIVE 5. Distribute and update as usual
  20. toccata

    UDF will not work in Cystal Reports after Mas200 4.0 upgrade

    I'm told version 4.05, shipping soon, resolves UDF problems.

Part and Inventory Search

Back
Top