Page 4 of 4 FirstFirst 1234
Results 46 to 53 of 53
  1. #46
    kdtrimble is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2015
    Posts
    41

    I was running the form. I just used notepad to see if the instance of HDPO was in there, and it was. Now I have to find it or start over. But that may work better.

  2. #47
    kdtrimble is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2015
    Posts
    41
    Does this shot give us a clue?
    Attached Thumbnails Attached Thumbnails Screenshot 2015-05-15 11.10.39.png  

  3. #48
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    It's saying there was an issue using ODBC when using combo11 in form_PO_Receipt_label.

    Perhaps there is a missing reference, or something is misspelled....???

  4. #49
    kdtrimble is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2015
    Posts
    41
    PO_Receipt_Label is a label report, not Form.

  5. #50
    kdtrimble is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2015
    Posts
    41
    Should this have said "90 MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure Combo11_AfterUpdate of VBA Document Form_PONUM"?

  6. #51
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Access is just saying it's a document (form or report) but it is naming the item in question as form_PO_Receipt_label

  7. #52
    kdtrimble is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2015
    Posts
    41
    Thank you again. I believe I have it working now. I will now move this to the production machine and see if I can get the report label to print out..... Keeping fingers crossed.

  8. #53
    kdtrimble is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2015
    Posts
    41
    Hello. I need HHDESC to show along with HHPO. How can I do this? Thanks.

    Private Sub Combo11_AfterUpdate()
    Dim myFilter As String
    10 On Error GoTo Combo11_AfterUpdate_Error

    20 On Error GoTo Combo11_AfterUpdate_Error

    30 Debug.Print "MyFilter is " & myFilter
    '
    ' Line 20 tells Access to use the selection in Combo11
    'to identify the single record of interest (to be printed)
    '
    'The debug.print lines are for debugging
    40 myFilter = "HHPO =" & = "HHDESC =" & Me.Combo11 'which Purchase Order to show NOTE This is numeric so no quotes required
    50 Debug.Print "MyFilter is " & myFilter
    60 DoCmd.OpenReport "PO_Receipt_Label", acViewPreview, , myFilter
    70 On Error GoTo 0
    80 Exit Sub

Page 4 of 4 FirstFirst 1234
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 02-21-2015, 11:35 PM
  2. Replies: 2
    Last Post: 02-07-2015, 04:30 PM
  3. Replies: 14
    Last Post: 01-08-2015, 04:50 PM
  4. Print single label
    By Voodeux2014 in forum Access
    Replies: 2
    Last Post: 11-12-2014, 01:52 PM
  5. Print Label when certian condition is met.
    By talktime in forum Reports
    Replies: 3
    Last Post: 12-15-2012, 03:26 AM

Tags for this Thread

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