Search results for query: *

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...

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...

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

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

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...

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...

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...

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...

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"...

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

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...

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

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...

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...

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

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...

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...

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...

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...

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