Search results for query: *

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...

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.

Can you give me a little more info? I am a beginner at VB, I don't understand your last post.

The if not isnumeric lets me enter 4000 but when I enter 45dk I still get a type mismatch error. Doesn't go to my msgbox "PO must be numeric" Dim intRCCount1, objRS1, result Do intRCCount1 = 0 PO = InputBox(Message, Title, "00", 5000, 4000) if PO = "" then 'A wscript.quit(9)...

I tried that. If I enter a 4000 I receive a message PO must be numeric. If I enter DDD I get the type mismatch error. Dim intRCCount1, objRS1, result Do intRCCount1 = 0 PO = InputBox(Message, Title, "00", 5000, 4000) if PO = "" then 'A wscript.quit(9) else if...

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 = ""...

I think I figured it out. Do intRCCount1 = 0 PO = InputBox(Message, Title, "00", 100, 100) if PO = "" then wscript.quit(9) else PO = (right(PO + 100000000,8)) strSQL11 = "Select ord_no from POORDHDR_SQL where ord_no='" & PO & "'" Call GetPORecordSetCount(strSQL11, intRCCount1...

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)...

Thanks a lot mrmovie, you are the man.

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...

that did the trick. Thanks a lot

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...

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...

actually it looks like the Select Distinct did the trick. But now I have another issue. with the rebate_amt I'm inserting I need to sum those and subtract from another amt in the gbkmut table. ord_no inv_no amt Account freefield3 25 335 100.00 1444 25 335 10.00...

gbkmut is the table I want to insert into orderrebatehistory is the table i'm pulling data from. When records get written to the orderrebatehistory I need to insert the same number of records into the gbkmut table. The only two fields that link the two tables together are: gbkmut.bstnr_sub =...

That doesn't quite work. It is inserting too many rows. There are two rows in the orderrebatehistory that I need to move to the gbkmut. The GBkmut already has 5 existing records in it. When I run the above it insertes 10 records instead of 2.

Here is a sample of the table I'm inserting into. Table gbkmut bkjrcode reknr datum ord_no inv_no 2008 1040 05/29/2008 39 246 2008 2030 05/29/2008 39 246 Above are the existing records I want to pull data from. I'm inserting data from...

How would the insert work? Looks like I would still run into the same problem wanting to update a field in the inserted record during the insert.

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...