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

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

    Code Error - Header sequence must be positive.

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

    Importing Transfers - Handle Error and go on to the Next One

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

    Reset Back Orders - Is this Macro Inefficient

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

    Check reconciliation macro

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

    Error opening macro: "%1 could not be found"

    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)
  6. JoeAtWork

    VB.NET to C# Conversion - Late binding

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

    VB.NET to C# conversion question

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

    Two devices listening to same serial port

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

    Web Service Proxy Generator - in Web Developer Express?

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

    Report parameters set in code, but pop-up appears anyways

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

    Write macro in 5.3A, deploy on 5.5

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

    AccPac 4.1A / Pervasive error

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

    MVP - can a View initialize it's own MVP Triad

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

    Model View Presenter - use data binding?

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

    Using New but not set to an instance?

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

    Multiple Product tables

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

    SiteMap - Show Root and First Level At Same Level

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

    Access 2000 - FindFirst moves to wrong record

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

    Backups and shrinking the log file

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

    Inventory Tracking Program - Best Practices

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

Part and Inventory Search

Back
Top