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 TouchToneTommy 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: VKZIMM
  • Content: Threads
  • Order by date
  1. VKZIMM

    Script to Pop-up existing Mas90 window

    I have a client that wants the Inventory screen open to the Quantity tab for which I already have a working script, but when that window is open, they also want to see the History tab information. If they click on that tab, it closes the Quantity tab, so I would like a button to open the History...
  2. VKZIMM

    Need Ideas to have Multiple Users view only their data

    We have a simple Access database and are using Crystal reports 10. So far we add the data and print the reports for the users, but one report will be a status report and we want each user to only view their data and not be able to make changes to the crystal report. I know we could run the...
  3. VKZIMM

    Insert giving an extra record

    I have one table with 5 fields Store, Year, Month, Acct#, Amount Main form has Store, Year and Month Sub form has Acct# and Amount Everything displays fine. If the subform is blank, I added a button with the following code to add the records. There are suppose to be 5 records and I get...
  4. VKZIMM

    Create records when they do not exist

    I am trying to create a budget type database. When they enter the Fiscal Year / Month, I would like to create a record for a group of accounts in a table so they can enter just the Budget amounts for each account. If the records exist, I would just like to display them so they can make...
  5. VKZIMM

    Open Excel specific Sheets

    I have the following script I use to open and excel spreadsheet from within Mas90. The client has now asked if I can only open specific tabs (Sheets) like 3 to 5. Is this possible? Thank you in advance. Dim fs Dim ss Set fs = CreateObject("Scripting.FileSystemObject") If fs.FileExists("C:\\"...
  6. VKZIMM

    Crystal 10 Export to Excel - Extra blank lines

    I have a crystal report that I want to export the details to Excel. All the headings line up with the data, but after each detail line I get exactly 4 blank lines. I have changed all the font sizes to Times New Roman 10 from Arial 8, made sure they were all the same height, not have Can Grow...
  7. VKZIMM

    DAP Find record

    I copied some code from a previous post. I have a combo box to find the client. It shows names and I have LstBoundfield to Clientnbr and the client number changes to the record it selects, but I want all the fields to be based on the record it selects. This is the code I am using. ClientLookup...
  8. VKZIMM

    Crystal Renderer component

    Crystal Reports verion 10 Select the crystal report to Export to HTML, it asks for directory, gives message that it will replace existing files and then "Failed to export the report. Could not create HTML Renderer component" It does work Crystal 8.5
  9. VKZIMM

    Error 42 _WINPROC.DRG

    Version 4.2 Mas90 and I even tried the SVC PK 17. Extended solution SO-1068 Explode Kits. When entering a Sales Order, somewhere over 200 lines the client gets this error. I have had an open case with Tech support for months and they do not have a solution. Error 42 Subscript out of range -...
  10. VKZIMM

    Peachtree Crystal Report - Landscape

    I have written some Crystal report for Peachtree. When running in Crystal reports, they are set to landscape and print fine. When running from inside Peachtree Quantum 2008, they do not print landscape and therefore truncate the right side of the report. Even if you display the report and...
  11. VKZIMM

    Peachtree GL Trxns - Reference

    I have linked the JRNLROW and JRNHDR. I have the trxns I want, but I want the Reference that shows in Peachtree in General Ledger. I cannot seem to find the file or field that this information is saved in. Thank you,
  12. VKZIMM

    Peachtree Employee Wages Hours Crystal Rpt

    Has anyone created a report with Wages and Hours MTD and YTD with Crystal Reports 9 and Peachtree Quantum 2008? Any help would be greatly appreciated. I have written Crystal reports with Mas90 and Great Plains Dynamics, so I need the Peachtree data information. Their Employee Layout and other...
  13. VKZIMM

    Peachtree Crystal Report

    I need to create a report that shows Hours worked per month and Gross Wages per month and Hours YTD and Gross Wages YTD. Does anyone have any idea if this is possible or where I could find the data. Tech support was not helpful. I am having problems just listing the fields from the Employee...

Part and Inventory Search

Back
Top