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!

Register Log in
  • Congratulations strongm 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: Vack58
  • Content: Threads
  • Order by date
  1. Vack58

    Won't save Landscape setting

    Crystal XI Have a report set to print in landscape. After I select Print and send it to the printer it switches to Portrait. The only way I can get it to stay in landscape when I print is to go to Page Setup and check "No Printer (optimize for screen display)" But this option does not stay...
  2. Vack58

    Problem creating a Sales Goal Chart in Crystal

    In my details section I have Order Number, Item Number, Extended Price, product Category. I'm grouping by Product Category. I have a running total that is calculating Sales YTD. I want to create a chart that looks at a Sales Goal and compares it to my YTD running Total.
  3. Vack58

    Type Mismatch Validate data on Input box

    If I accidently input a character in my input box I get a type mismatch Because I am trying to add leading zeros. Is there any way to force the user to enter a numeric value? Dim intRCCount1, objRS1, result Do intRCCount1 = 0 PO = InputBox(Message, Title, "00", 5000, 4000) if PO = ""...
  4. Vack58

    Cancel button

    How to I quit the program if the user hits cancel? Dim intRCCount, objRS Do intRCCount = 0 ShipTo = InputBox(Message2, Title2, "",100, 100) strSQL10 = "Select ship_to_cd from POSHPFIL_SQL where ship_to_cd = '" & ShipTo & "'" Call GetShipToRecordSetCount(strSQL10, intRCCount, objRS)...
  5. Vack58

    Problem with Loop

    I have the following piece of code. I am prompting the user for a Ship to code, then checking the code to make sure it is in the POSHPFIL_SQL. If the no records are returned I want a message to dispay "Ship To Not On file" and keep prompting the user. I realize I need some sort of loop but I am...
  6. Vack58

    How to update SQL table using variable

    Have the following code which prompts the user for a PO number and a ship to code. I want to take the values they enter and update the ship to code in the POORDHDR_SQL table. When I run the script below it says ShipTo is not a valid field. How to I update the SQL table with the value of my...
  7. Vack58

    Adding a field and subtracting the value from another

    Have a table with the following data. Table1 Ord_no inv_no amt Account freefield3 25 125 100.00 1444 25 125 10.00 3555 Rebate 25 125 10.00 3555 Rebate After the records are inserted I need to add the amt's where...
  8. Vack58

    update a field being inserted by another record in the same table

    Using trigger want to update a field being inserted from another record in the same table. the record being inserted I want to pull the bkjrcode from another record where the account = 1040 that also has the same ord# and inv# as the record being inserted. Here is what I've tried with no...

Part and Inventory Search

Back
Top