Search results for query: *

Sage Accpac 500 ERP (Version 5.3B) I am trying to programmatically create Invoices from multiple PO Receipts (i.e. "Invoice Entry" icon from the "P/O Transactions"). As usual, my code is derived from a macro I recorded. I am looping through invoices for a vendor. On the first iteration of...

Sage Accpac 500 ERP (Version 5.5A) I have a macro that is used to import IC Transfers. If the data I give it is valid, everything is fine. It will loop through multiple transfers, importing each in turn. I would like that if an error occurs for one of the transfers, it just logs the error...

Sage Accpac 500 ERP (Version 5.5A) SQL Server 2005 I created a macro that is supposed to cancel any back orders. The client tells me it takes 35 minutes for the macro to run through one day's worth of back orders (manually it takes them 2.5 hours). If I test with only 5 back orders, they get...

Sage Accpac 500 ERP (Version 5.3B) I'm a programmer who occasionally does work for an AccPac consultant. Usually he provides me with a recorded macro to use as a template, but I don't have one this time. Basically, I need to reconcile checks that have been cleared by the bank. He told me I...

I was asked to look at a macro to see if I could make a minor modification. When I try to open it (Macro -> Edit... -> browse to AVB file) I get an error message "1% could not be found". Does anybody know what this means and what is wrong? AccPac 500 ERP (Version 5.3B)

I had one issue with VB.NET to C# conversion that I couldn’t solve. There’s a method passing in a parameter like this: public FormErrorCode SetFormProperties(object oFormPropCol) later on it does something like this: pFormProps.PropertiesUpdate(0, 0, pForm.ID, oFormPropCol(1).Name, 0...

I'm converting a VB.NET project to C#. The VB.NET project has a module with a number of global variables that are used in different classes. For example, g_UserID is used in 3 different classes. I am using an online converter to create the C# code. Of course, the global variables do not...

I'm trying to support a customer but I'm a programmer and this is a hardware issue. It's probably very self-evident for some of you. He has a lab instrument that is sending data via RS232. He has two physical devices that need to pick up the data at the same time: 1. A serial printer that...

I read a somewhat dated article that you could create a web service proxy source file using ASP.NET Web Matrix's "Service Proxy Generator". I'm wondering if this is available in Visual Web Developer 2008 Express - I couldn't find it? I was able to create my source file with wsdl.exe, so it's...

The company that uses AccPac 5.3A got a macro from another company that uses 5.4. The macro has a user form for entering parameters for a custom invoice report. The parameters are a start and end date, and a comma delimited list of ROUTES (Order Optional Field). Even though these parameters...

I need to write a macro to import invoices. I have done this a couple of times with the COM API. I only have version 5.3A (SP3) of ACCPAC Advantage Series Enterprise, my client has 5.5. Can I write a macro, which will include at least a couple of forms, in my version and deploy on theirs? I...

My client has an ancient system (runs on Windows 98) with AccPac 4.1A. When trying to open their company database in AccPac, I get the following error: I was able to open one of the Sample company databases. The database is Pervasive, in the About box in the GUI tool the version information...

I am in a little debate with another programmer about this. The issue is - can a View create it's own MVP (Model View Presenter) triad? The other programmer thinks this is permissable. He would put the code to initialize the Model and Presenter in the View's constructor, then inject the Model...

I'm currently researching the Model View Presenter design. I am working with .NET C#. In some of the articles I have read, they give examples of the Presenter setting properties of the View, then in turn the View updates it's controls. For example in the Presenter you might have the...

I’m studying an example of MVP code, the following looks wrong to me (although it works fine): PuzzleForm view = new PuzzleForm(); IPuzzleModel model = new PuzzleModel(loadImageModel, imageCutter); new PuzzlePresenter(model, view); On the third line, why isn’t it creating...

I'm currently starting a rewrite of an inventory system. One of the challenges is that about 50% of the products are of a particular category, that has many properties that don't apply to the other products. Some example properties that only apply to the first 50% are Width, Height, Die Lot...

I am building a simple company website, at first it will just be a few pages. Over time I plan to add more complexity with added sections and subgroups. Therefore I want to use a SiteMap to take advantage of the automatic creation of a side menu. Right now it is just a very simple menu that...

Wondering if anybody has seen a similar error. I upsized an Access2000 database to an SQL Server Express backend, tables in the front-end have an ODBC link. There is code in the search screen to move to a particular record on the main screen: On Error Resume Next Dim Findval As String Findval...

There have been a number of times I have come across SQL Server databases where the transaction log files have become enormous (many times the size of the actual MDF file). The last one I dealt with grew to 50GB. I have been reading a number of articles about truncating and shrinking, but I'm...

This isn't really a VB question, more of a programming techniques type question (i.e. could apply in any language). To explain, I am in the early stages of doing a rewrite of an awful Access POS/Inventory program into .NET/SQL 2005. The program keeps track of stock with updates like the...