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

  1. jmainland

    Crystal Reports XI R2 SP6 ODBC Issue

    When creating new ODBC connections only User DSNs are available. None of my System DSNs are showing. Any ideas? CR XI R2 SP6 Windows 7 Pro 64bit
  2. jmainland

    Word mail merge through Acpac CRM

    Yes you can. What version of CRM? If you have version 6 chapter 8 of the user guide outlines how to do it.
  3. jmainland

    4240n Tray Setup

    We have an HP4240n with multiple trays. I want to set up one printer that prints just to trays 1 & 2. I also want to set up another printer that prints to tray 3 only. Is that possible?
  4. jmainland

    COM class factory failed due to the following error: 80040154 :|

    I had a similar type error on a program I wrote once. It turned out that it was the clients anti virus causing the problems. Its kind of a shot in the dark. Good luck!
  5. jmainland

    Print Server software

    We have several different HP Network printers on our office network. Is there any Print Server Software to manage these printers. I want to be able to view and change IP addresses and stuff like that. Thanks, Jeff
  6. jmainland

    Getting Oustanding A/R Balance

    From the customer view AR0024(ARCUS Table) grab the AMTBALDUEH field to give you the current AR Balance for a customer.
  7. jmainland

    Getting Oustanding A/R Balance

    I assume you are refering to the AccpacCOMAPI. You can use the Fetch method. There are samples on how to do that on this forum. Or you can use ADO if you are just grabing information.
  8. jmainland

    Accpac Runtime Error 13 Type Mismatch

    I copy and pasted your code and it works. Not to sure what it could be. Maybe trying it in a new project.
  9. jmainland

    Accpac Runtime Error 13 Type Mismatch

    Your code is fine. Did you put the AccpacOE1100UICtrl on a form or are you calling it at run time?
  10. jmainland

    How to Update PSQL data table from Excel file.

    If you already have the ITEMNO, LOCATION, and LASTRCPTDT in excel just import it through IC Location Detials. Just make sure you just select those 3 Fields when importing. DO AN EXPORT FIRST of those 3 fields just to make sure you have the correct formating, column names ect. and copy your data...
  11. jmainland

    Load Library

    I'm going to assume you are VPNing on to the clients network then TSing on to one of the PCs. If that is the case try copying the Crystal folder from C:\Windows to C:\Windows\System32. This usually resolves the Load Library issue.
  12. jmainland

    Have Accpac Macros appears in the Taskbar

    This code will make the vba form appear in the task bar. It also gives it a minimize button as well. 'GENERAL DECLARATIONS 'API Private Declare Function SendMessage Lib "user32" _ Alias "SendMessageA" _ (ByVal hWnd As...
  13. jmainland

    Accpac 5.4 on Windows Server 2003

    SeisaT, do you have IE6 or IE7 installed?
  14. jmainland

    Have Accpac Macros appears in the Taskbar

    It is possible to have Accpac Macros appear in the taskbar but it requires several API functions and adds a bit of overhead to your code. Using VB6 is the ideal solutions for this issue. If you still really want to have your VBA macros show up in the task bar let me know and I'll post the code.
  15. jmainland

    FEC not visible on VB.NET Form

    Hello, I've added a Field Edit Control to a VB.NET Form. When I run the app the FEC doesn't appear visible on the form. I've set the DataSourceName on the FEC and run the following code; Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim Session...

Part and Inventory Search

Back
Top