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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ehran

  1. ehran

    Passing parameters to CR v6.0 using macros and vba?

    DjangMan, Good News!!! It works... I embedded a CRYSTAL.OCX onto the form and everything was a breeze from there... Now I gotta figure out how to implement fax capabilities... Anyways, thanks for all your help in the past. Ehran
  2. ehran

    Passing parameters to CR v6.0 using macros and vba?

    Hi DjangMan, Long time no chat... Anyways, finally figured out what I was doing wrong with the automation process. Turns out I was mixing the methods between the crystal API and OCX. Got it automated this morning just by using the CRYSTL32.OCX Now I have a problem that relating to ACCPAC. I...
  3. ehran

    Passing parameters to CR v6.0 using macros and vba?

    Djangman, Here's the bit of code snippet that I'm trying to have automated. Originally when I intended to use macros in ACCPAC, I did the following: For OrderNumberSelected = SrtFrom To SrtTo - 1 rptObj.Select Session, "OECONF01[ACKNOWL.RPT]", "" rptObj.SetParam...
  4. ehran

    Passing parameters to CR v6.0 using macros and vba?

    Djangman, Here's the bit of code snippet that I'm trying to have automated. Originally when I intended to use macros in ACCPAC, I did the following: For OrderNumberSelected = SrtFrom To SrtTo - 1 rptObj.Select Session, "OECONF01[ACKNOWL.RPT]", "" rptObj.SetParam...
  5. ehran

    Passing parameters to CR v6.0 using macros and vba?

    Actually that's what I planned to do after I found out the macros in ACCPAC are very limited and does not offer automation. So I've opted to automating the Crystal Reports directly with VB code. I have access to both Crystal 6 and 8 on my work system. If you can drop me the code snippet...
  6. ehran

    Passing parameters to CR v6.0 using macros and vba?

    DjangMan, Thanks for the info. However I was looking at a way of automating the process with the least amount of user interaction. Taking the example you provided, say I wanted to export to email. The syntax would be: rptObj.PrintDestination = PD_EMAIL Problem with this is that a dialog...
  7. ehran

    Passing parameters to CR v6.0 using macros and vba?

    Hello All, I'm currently working on a project to create an automated batch processing for order confirmations under ACCPAC using macros, VBA, OutLook 2000 and Crystal Reports 6.0 However, I don't quite seem to know how to pass parameters from ACCPAC to my custom report using Macros/VBA. I...

Part and Inventory Search

Back
Top