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 derfloh 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: *

  1. pd2004

    Joins Issues

    Hello Andy, Thank you for your quick reply. As far as I know, MS Access won't allow me to just insert the trim function into the SQL join. I need to do that in a sub-query first. I understand that this is a way to handle the problem, but I am really interested in why MS Access handles the...
  2. pd2004

    Joins Issues

    Hello, I am trying to join our REPORT_MM_RECEIPTS table to our MV_ITEMMAST table. I am joining on the ITEM field. The issue is that in the REPORT_MM_RECEIPTS table, the field is trimmed. In the other table, it has the 32 characters of the field filled with blanks. Anyway, although aside...
  3. pd2004

    Pivot Table Fail in VBA

    You're the best Skip! I appreciate your help always. Thank you again. Pat
  4. pd2004

    Pivot Table Fail in VBA

    Thank you, Skip. I really appreciate all of your help! Pat
  5. pd2004

    Pivot Table Fail in VBA

    Hi Skip, It kind of seems like you are unhappy with my efforts. I totally understand what you are saying. I was onto that very early on. The problem is, you have the two in reverse order. First, my code fails trying to make Pivottable1. Then, on the same sheet, I record the macro to make...
  6. pd2004

    Pivot Table Fail in VBA

    Hi Skip, I thought that was the problem initially as well. However, I do not think so. the same code fails in my module. then on the same page I can record the exact same macro, and it runs. I understand your point about adding the same pivot more than once, but I don't think that is...
  7. pd2004

    Pivot Table Fail in VBA

    Hello Skip, That is likely the case. A while ago, when I was using windows XP and likely an older version of Excel, I was working a lot more with pivot tables and trying to automate some reporting that uses them. Normally I do most of that work in Excel, but sometimes it is better for our...
  8. pd2004

    Pivot Table Fail in VBA

    Hi Skip, Nice to hear from you again. I hope all is well. I copied this code from a module that I had made previously. I also recorded it. I have been working with it for a while, and I am really confused as to why it doesn't work. I sense that you know the answer. If the code is really...
  9. pd2004

    Pivot Table Fail in VBA

    Hello, Can anyone tell me why this code doesn't run: ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "Data_All_Items_Added!R3C1:R13174C8", Version:=xlPivotTableVersion10). _ CreatePivotTable TableDestination:="PVT_Items_Added!R3C1"...
  10. pd2004

    Access Linked Table Setup using VBA

    I wanted to post a thank you for all of the help I have received. I really appreciate it. Thank you, Pat
  11. pd2004

    Access Linked Table Setup using VBA

    hello, I would like to use VBA to set up the linked tables in my database when it opens. I have searched, and there are related topics, but I think I need a little help. I am doing this because some users have their drives mapped differently, and I need to use the base server instead of the...
  12. pd2004

    Error #91 Object Variable or Block Variable not set

    Could you tell me the proper way I should be killing the instances of the excel and word apps? I think that is where part of my problem lies. Thank you, Pat
  13. pd2004

    Error #91 Object Variable or Block Variable not set

    Hello and thank you for all of your help, everyone! Please see below: Explicit References: I always want to use explicit references, but in this case, I am looping through columns on the spreadsheet, so the cell changes each iteration. I know there are ways to handle, but this seemed the most...
  14. pd2004

    Error #91 Object Variable or Block Variable not set

    Hello, I am using VBA from MS Access to create an instance of Excel and of Word, and then to copy and paste from Excel into Word. When I execute, the first time it runs properly, the second time I get this error message: Run Time Error #91 Object Variable or With Block Variable not Set. here...
  15. pd2004

    OnTime Method

    I really want to thank you guys. I appreciate all of your thoughts and direction. I think the template idea might be more stable. I will work on that. Thank you, Pat
  16. pd2004

    OnTime Method

    Skip, It was probably a backwards way of thinking of things, but I am pretty sure it would exit the loop for line 200 if the querytable refreshes successfully. Regardless, it doesn't do what I want (to exit if it hangs indefinitely), because nothing is evaluated until the querytable...
  17. pd2004

    OnTime Method

    Hi Skip, The idea was that if it loops once successfully, it exits the loop and moves on. If it hangs up in the loop for longer than the time allotted, then it exits the loop too. Either way, I don't think it works because it doesn't do anything until the querytable refreshes (as long as that...
  18. pd2004

    OnTime Method

    Hi Gruuuu, Thanks for your input and help. Again, though, I thing that if the hang up takes place during the "'stuff" above, the next line of your code is not evaluated, and Excel will hang indefinitely. I am not a professional programmer, so let me know if I am really missing it here. Thank...
  19. pd2004

    OnTime Method

    Hi Skip, Thanks for looking at this. I appreciate it. The problem is that if the code hangs while doing "yer stuff" above, the loop is never evaluated. This is happening to me when I try to Querytable.Add in my Excel VBA. If the connection to the web hangs up, for example, Excel will wait...
  20. pd2004

    OnTime Method

    Hello, I am interested in finding a method like the OnTime method, except that I want the method to interrupt the code that is running. The idea is to give the VBA code a limited time to either complete the task, or move on. OnTime only runs when the current procedure completes. Thank you, Pat

Part and Inventory Search

Back
Top