Results 1 to 4 of 4
  1. #1
    JellyBean is offline Novice
    Windows XP Office 365
    Join Date
    Aug 2023
    Posts
    1

    Editing Access for Bartender label


    Hello, I'm new to Access (and my job!)
    I edited a field in Access to add a word to a label to be printed on Bartender.
    Our IT guy told me it could be 12 hrs before it 'went live'.
    Well, it's been over a week and the label still isn't updated.
    I'm guessing there is a simple step I'm missing? But I don't know what it is.
    What do I need to do, after editing a label field on Access, then print it?

    Thanks!

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    Did you check if your edit was saved? You're editing what - a table field that contains the text for the label? Not familiar with Bartender but can't imagine where the 12 hour bottleneck is. Doesn't make sense.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    Are you running an accde, and the accdb has not been re reated as an accde?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    do you use vb code to print?
    did you assign the DATA field name on the tag template?
    (here it is FIELD1)

    the data is in access form field: me.txtBox1

    Code:
    dim btFormat, btApp
    
    
    Set btApp = New BarTender.Application
    Set btFormat = New BarTender.Format
    Set btFormat = btApp.Formats.Open(CurrentTagPath, True, "")
    
    
     'set the field name
    btFormat.SetNamedSubStringValue "Field1", me.txtBox1
    
    
      'print lbl
    btFormat.PrintOut False, False
    
        btFormat.Close (BarTender.BtSaveOptions.btDoNotSaveChanges)
        btApp.Quit
        Set btApp = Nothing

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 10-10-2017, 03:01 AM
  2. Replies: 1
    Last Post: 04-25-2014, 11:41 AM
  3. Replies: 3
    Last Post: 10-19-2013, 10:21 AM
  4. Access Editing
    By Brian Gregg in forum Access
    Replies: 8
    Last Post: 06-11-2011, 04:21 AM
  5. access will not allow editing
    By wthoffman in forum Access
    Replies: 3
    Last Post: 12-18-2010, 02:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums