Search results for query: *

Hi all, Every time I run a VBA macro from Access, it makes my computer super slow and sometimes it even freezes until the code finishes running. Is there a command to make the code execture in the background without affecting my computer performance too much?

Hi all, I am using the following syntax in Excel's VBA: xlWBMe.Sheets(sheetname).range(startletter & startline).Select where xlWBMe = ActiveWorkbook The same exact syntax works in another workbook. When I copied it into my current workbook, the 'r' in range became small and Excel gives me the...

Thank you all for your great comments. I decided to break it down into sub union queries and append them to each other at the end. Can I write an append query that will take more than 2 queries?

I don't think I can post any sql (company regulations and such) but when i split it into two queries, both queries worked. So the syntax is correct.

Our analysts update ClientIDs in Excel and Access links to the Excel table. Pivot wouldn't work - too much data (too long for Excel)

I have Access 2000. I did exactly what you stated above, but the query appears to be too complex.

Hi all, I am not sure if what I am trying to do is possible at all but I thought I'd post it here to find out. In a nutshell, I am trying to join column values in a table to headers of another table's columns. Here is an example: Table1: Client DB ClientID FundsAtYearStart 1001...