Search results for query: *

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.

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.

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...

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...

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.

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...

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...

Thanks a ton, I'll do that.

Unfortunately back up isn't an option. Yeah I know, don't say it.

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...

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.

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...

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.

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...

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

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...

Gotcha. Thanks.

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...

Gotcha, thanks.

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...