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 Mike Lewis 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. VKZIMM

    Incorrect A/P remittance advice

    If you are version v4.1 or below, you may have garbage in your crystal work files for check printing. Always do a backup first, but you may want to initialize when you do not have a check run in process. Also, verify that the other checks posted correctly. Reinitialize the following files...
  2. 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...
  3. VKZIMM

    How to run VB Script from VI Perform Logic

    Did you ever get your vbscript to work? I would like my first VI job to prompt for a value and write it to a text file so the other VI jobs can read this value. I can read the value if I manually create the text file, but I cannot get the write in the first vi job to execute. If I run the...
  4. VKZIMM

    Bottom Aligning a text object

    Well I tried with Crystal 11 and still no problem, so I would do the Copy of the good field and paste and edit the value. Sorry, since I cannot replicate the problem, that is all I can do.
  5. VKZIMM

    Bottom Aligning a text object

    I created 2 simple text objects and exported to Excel and I do not see a problem. What version of Crystal? I used 10 for the test, but I also have 11 and 8.5. Sometimes it just best to delete the incorrect field and re-add it to the report. Also if it is text, delete the bad one, copy the...
  6. VKZIMM

    Bottom Aligning a text object

    Make sure they are both formatted the same with the same font size and no borders, ect. Also make sure the field is wide enough and not wrapping around to a second line or unselect the can grow box.
  7. VKZIMM

    Bottom Aligning a text object

    Highlight both the item out of alignment and the one in alignment by holding the Shift key down and clicking on the item. Right-click on the correct item. Click on Align Click on Bottoms
  8. VKZIMM

    Formula to force a details section to print at end

    If you only want one detail line, why don't you suppress all the detail information and just print your information in the report footer? You can have multiple report footers. Or maybe you need to have one big group and use a group footer with the information.
  9. VKZIMM

    Need Ideas to have Multiple Users view only their data

    I downloaded the first viewer and maybe I am not using it correctly, but is seems someone must run the report and save the data so the person with access to the viewer can see it. Is there a way that the user can run a report to update the data? Thank you for your help.
  10. 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...
  11. VKZIMM

    Report selection parameters with multiple values in 1 field CR XI

    If you enter "JOHN" as a parameter Parameter [1] in textfield means that if "JOHN" is anywhere in whatever field you have defined as the textfield if will be selected Parameter [1] in TrxnDesc The "LIKE" example works similar. So if you enter multiple parameters "JOHN" "MARY" JOHN is...
  12. VKZIMM

    Report selection parameters with multiple values in 1 field CR XI

    Allow the multiple values in the parameter and allow custom values. When reading your records Numbervar Paramcnt; Paramcnt := Count(Parameterfield) The above will tell you how many values were entered. You will then have to check Parameterfield [1] in Textfield or Paramcnt >=2 and...
  13. VKZIMM

    First Record in group

    I usually use a Numbervar and add 1 when printing the detail and clear the numbervar on Group change. If you do have a field that indicate the first you could try Datefield <> Previous(datefield) then "*
  14. VKZIMM

    Getting last4weeks data

    Try Auditstamp in DateAdd("ww", -4, currentdate) to currentdate Four weeks prior from today's date.
  15. VKZIMM

    Help!! Mas 90 won't release from memory after closed

    Have you checked permissions from this machine to the directory above the Mas90 on the Server?
  16. VKZIMM

    Financial Reports - Change Margins

    What version of Mas90 are you running? Are you doing the Balance Sheet from the Reports...Financial Reports Menu? Do you uncheck Print Footnotes when you print? Have you tried changing Printer options with the SETUP button? Sorry so many questions, but maybe they will help.
  17. 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...
  18. VKZIMM

    Create records when they do not exist

    Thank you for your response, but I am not an access guru by any means. I have a form with the Month and Year, and a subform for the account and amount. What or where do I need to insert the code you gave me? Thank you in advance.
  19. 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...
  20. VKZIMM

    Sorting based on selection criteria

    Have you tried creating a Cross tab report? I have done this using the wizard. Your Columns would be base on the date (Monthly)

Part and Inventory Search

Back
Top