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 dencom 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: *

  • Users: troyddaniels
  • Content: Threads
  • Order by date
  1. troyddaniels

    Using Xapi to load financial reporter?

    I've printed the macro in Accpac, but the code isn't 100% compatible with the Xapi format. Is it possible to load accpac's financial reporter outside of accpac? Also I've noticed that if I include the reference "Financial Reporter COM Addin" I eliminate some of the errors in the script. But...
  2. troyddaniels

    XAPI journal entry posting

    I'm writing a program that will create journal entries from a spreadsheet embedded in a VB6 application. Here is the code I've pretty much copied as verbatum as possible from a macro I recorded in Accpac. But it get's hung up when calling up GLbatchDetailFields("ACCTID") = xxxxx. I get a...
  3. troyddaniels

    manual change current fiscal year

    We had an issue where someone tried to convert an old DB into an established one. Well it didn't convert of course, but it did reset the fiscal year to 2005. If I run "create new fiscal year" it will give me an error and jump up to 2006. however if I run it again it's a no go. Is there...
  4. troyddaniels

    MSOWC.dll not registered error on other computers

    I have compiled a program with an embedded spreadsheet in it. However when I try to run the program on anyone elses computer in the office I get the "component msowc.dll or one of its dependencies not correctly registered" error. I ran the command line regsvr32 "C:\Program Files\Microsoft...
  5. troyddaniels

    How to print an embedded spreadsheet?

    This might be an easy one, but I have an embedded excel spreadsheet that I dump data in from a database. I'm wondering how to print that worksheet out without having to export it to the actual excel application. Can anyone help me with this? Thanks
  6. troyddaniels

    Sample XAPI script

    I am looking into writing some VB programs that will do some routine functions in order to save us some lanpak licenses. We have 5 IAP licenses that are just sitting dormant. I have no clue how to use XAPI. Can anyone supply me with some sample script of a program that opens a session...
  7. troyddaniels

    Get Parameters for Crystal Reports

    I am wondering how you get parameters for an accpac report (e.g. from acct x to acct y). If I take a form and copy it, change it, and then save it and try to run it from the report section under a different name I get a long list of variables and a window asking for the paramter value. How do...
  8. troyddaniels

    Problem with Crystal Reports and Printing Checks

    I have customized a form to print out checks. The problem is that it only works (prints out an actual check) in one database under the admin login other wise I get no information printed into the field boxes. Can anyone help? I'm not sure if it's a crystal reports problem or an accpac issue.
  9. troyddaniels

    Another accpac/crystal ?. Turn 32 into 00000032?

    I hope I don't come off as stupid as my last one. I've got a field {BKFROM.CK}, if it equals 32, in crystal reports it prints out as 32. But I need it to be formated that if it equals 32 it prints out as 000032, or if it equals 1006 then it prints out as 001006. Any help would be very much...
  10. troyddaniels

    Accpac/Crystal Report - make $10.31 into 1031

    I am not having much luck with figuring out the syntax of crystal reports. I have {BKREG.SISSUED} from accpac ERP, I want to make a forumla that will basically do this. Say {BKREG.SISSUED} = 100.00 well I want to take the decimal out, so it says 10000. I'm used to VB so I'm not sure how to...
  11. troyddaniels

    Using VBA to change from one company to another

    I am trying to figure out the VBA script needed to switch from one database to another in Accpac ERP. Right now I am just looking at a basic switch where I will start in company 1 run the macro and end up in company 2. I have the basic code from the document: Set Session =...

Part and Inventory Search

Back
Top