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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tjonessi

  1. tjonessi

    Remove table ?

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

    Remove table ?

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

    Remove table ?

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

    Code128 in Crystal Report XI

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

    Code128 Number to String ?

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

    Code128 Number to String ?

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

    Worksheet_change not working?

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

    Worksheet_change not working?

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

    Worksheet_change not working?

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

    Worksheet_change not working?

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

    Macro adding quotation mark unwanted

    That works. thanks so much
  12. tjonessi

    Macro adding quotation mark unwanted

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

    Getting #REF when delete paste link

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

    Getting #REF when delete paste link

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

Part and Inventory Search

Back
Top