User Profile

Collapse

Profile Sidebar

Collapse
Brad Nerbovig
Brad Nerbovig
Last Activity: Sep 18 '12, 08:18 PM
Joined: Nov 29 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Brad Nerbovig
    started a topic AutoFilter method of Range class failed setting criteria in VBA
    in Access

    AutoFilter method of Range class failed setting criteria in VBA

    Greetings-

    I have AutoFilter turned on in my spreadsheet and am trying to set the criteria through VBA, but I'm continuing to get a method error. Here's the snippet of code:

    Code:
    Do While varUnit <> ""
     pvtResults.PivotFields("Unit Name").CurrentPage = varUnit
     shtPivot.ShowAllData
     shtPivot.Range("B12:I352").AutoFilter Field:=8, Criteria1:="<>0"
    ...
    See more | Go to post
    • Brad Nerbovig
      replied to Why am I getting an error 91 - Object variable or With block variable not set
      in Access
      I would, except the error occurs at line 65. If it gets past that line, which it does after it has errored out the first time, then everything is groovy. Inserting the line of code you have above returns the "Recordset exists" msgbox the second time I run the routine. It never gets there on the first run.

      For some reason, it is not recognizing the connection to the Excel file when I run through it the first time. I'm...
      See more | Go to post

        Leave a comment:

      • Brad Nerbovig
        started a topic Why am I getting an error 91 - Object variable or With block variable not set
        in Access

        Why am I getting an error 91 - Object variable or With block variable not set

        I am getting this error when connecting to an Excel file from Access 2010. The weird thing is, if I click on okay when the routing fails, and then run it again it works just fine. In fact, if I run it again anytime after I have gotten this error it works just fine. The only time the error crops up is the first time I run the routine after opening up the database. There's a lot of code in this routine which I'll post, but the error occurs at line...
        See more | Go to post
        • Brad Nerbovig
          replied to How to lookup either value in a two column combo box?
          in Access
          I figured as much, but it was worth a shot. I'll just but a text box next to the combo box with something like "Or enter any portion of the item description:". Thanks for the quick response!
          See more | Go to post

            Leave a comment:

          • Brad Nerbovig
            started a topic How to lookup either value in a two column combo box?
            in Access

            How to lookup either value in a two column combo box?

            Greetings-

            I can't seem to find an answer on this one. Is it possible to lookup values in either of two columns in a combo box in Access?

            The idea is this: I have a combo box that displays an item number and an item description from an items table in the database. I'd like to give the user the option to type in a value from either one of these and go to the correct entry in the combo box. So, if they know a portion...
            See more | Go to post
            No activity results to display
            Show More
            Working...