Search results for query: *

That didn't work. I saved it and it still keep asking me whether to remove table or not. Any other suggestions to try? Thx. Tina

We use SQLBase engine for Visual Manufacturing db, which the tables are already in there. We use same ODBC, DSN name to call up the table.field in CR then save it. When refreshing that is when we run into problem. The other pc, do not give this error message, so I am assuming somewhere in CR...

I have CR XI and I am connected to db using ODBC with no problem. I created a file with one table, saved it then when I refreshed the screen, it gives me message saying "The database table <table> cannot be found. Proceed to remove this table from the report?" I click No button and I see the...

I need to combine two fields with slash in between using Barcode 128 fonts, but I cannot get it to scan. This works with Code128Wide font BarcodeC128A({INVENTORY_TRANS_1.WORKORDER_BASE_ID)} and this works as well BarcodeC128A({INVENTORY_TRANS_1.WORKORDER_LOT_ID}) How do I combine these two to...

Changing the font from Code128 to Code128Wide solved this. Thanks.

Hello, I am not an expert in this 128 barcode, but we had this consultant who is supposely fix this problem, is no longer available. We have program created to input information to Access db and Crystal Report XI to print out label. I have formula for primary barcode, it starts with H (for...

Just so everyone knows, I've learned this worked great for me. =INDIRECT("'M32#1'!A2") Thanks so much for everyone's help.

FR33dan - I still don't understand why my if statement is not working. I copied your code and it still does not work? Is it because the if statement is still not correct? VRoscioli - thanks, I tried a simple code and it worked. Unfortuntely, I still can't get what I need to work. This may be...

I was told to insert module (new) in Visual Basic Editor then put the macro in there and save it. I copied the macro and it still did not update it. Did I put it in the wrong place? This "Worksheet_change" automatically update whenever there is a changes, correct? TIA

I created this macro by using recorder and modified it alittle bit, but the update is not working automatically when deleting a row from worksheet2 to update worksheet1. All I want it to see when #REF appear in one cell then update the remaining cells. What am I doing wrong? TIA. Sub...

That works. thanks so much

I have this macro Sub test1() Sheets("M32#1").Select Rows("2:2").Select Selection.Delete Shift:=xlUp Sheets("Efficiency").Select Range("B3").Select ActiveCell.FormulaR1C1 = "=+'M32#1'!A2" End Sub and this is the result I get: #NAME? and the formula is this...

What you suggested works, regarding changing sequence in sheet 2, but they are not in order for any reason, except the author's preference to put in order, so that will not work. is there a way to use macro to tell it that everytime this row gets deleted on sheet2 to update info on sheet1...

I don't know how to explain this, but I'll try: In Excel worksheet1, on first row, we have paste link from worksheet2 of first row, and on second row of worksheet1, we have paste link from worksheet3 on first row, etc. on worksheet2, we have 4 rows of data, yet only first row is ALWAYS linked...