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 bkrike 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: tjonessi
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...

Part and Inventory Search

Back
Top