Recent content by pd2004

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