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!

Register Log in
  • Congratulations derfloh 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
  • Order by date
  1. troyddaniels

    Using Xapi to load financial reporter?

    I'm using 5.3a. I've also come to your conclusion that XAPI won't support FR. I eventually got it to load but I had to use COMAPI.
  2. troyddaniels

    Determine lanpack status through vb

    Just an FYI, We've been having the license problem as well (we're sharing 5 lanpaks between 10 users). I've been using VB programs that utilize the XAPI commands to import and post information to accpac. It's a good way around the lanpak issue, if you've got IAP licenses.
  3. troyddaniels

    Return path where macro is stored

    I'm not a pro, but it seems like when I write my VBA macro's if I want it to open a file in the same directory I just tell it to open the file without a path to it. Then it goes to the directory that the macro was launched from. But that is VBA for MS office. I don't know if that is any help...
  4. 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...
  5. troyddaniels

    XAPI journal entry posting

    Thanks guys, I ran the accpac macro again then copied it straight over and converted it to xapi rather than writing the xapi and then copying the code over. I must've missed something the first time I copied it over because now it works fine. Thank for your time and help.
  6. troyddaniels

    XAPI journal entry posting

    I tried setting it to a string, same error. If I take off the accpac error handling I get an error message "run time error '-2147467259 (80004005)': view call failed". If I include the error handler I get a 'the "session" object was not opened.' error. You know what the worst part of this is...
  7. 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...
  8. troyddaniels

    manual change current fiscal year

    Thanks a ton, I'll do that.
  9. troyddaniels

    manual change current fiscal year

    Unfortunately back up isn't an option. Yeah I know, don't say it.
  10. 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...
  11. troyddaniels

    MSOWC.dll not registered error on other computers

    The setup ran into an error around the end, but the program will run now, looks like it got everything it needed. And that's something I can live with. Thanks a ton.
  12. 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...
  13. troyddaniels

    How to print an embedded spreadsheet?

    When I add a watch to the object it says "object out of context", and that it's type is "empty". That's if I add the .printout command to it. If I add a legit command it tells me that it is a variant/object/spreadsheet.
  14. troyddaniels

    How to print an embedded spreadsheet?

    Thanks, but I tried that already and it gives me the "object doesn't support that method." error. The PrintOut command doesn't even come up in my object explorer. I can print out the window and the spreadsheet with the form.printform command but that's as far as I can get it. Am I missing a...
  15. 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
  16. troyddaniels

    Sample XAPI script

    Another XAPI question... Like I said, XAPI is completely new to me and I don't have much reference material, I searched the forums but didn't find anything that really helped. Basically my code is as follows for opening a session (and maybe I'm going about this whole thing wronge, feel free to...
  17. troyddaniels

    Sample XAPI script

    Gotcha. Thanks.
  18. 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...
  19. troyddaniels

    Get Parameters for Crystal Reports

    Gotcha, thanks.
  20. 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...

Part and Inventory Search

Back
Top