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!
-
Congratulations TouchToneTommy 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: *
- Users: actuaryinworks
- Content: Threads
- Order by date
-
Making code run in the background
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?- actuaryinworks
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Excel : Select method or Range class failed
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...- actuaryinworks
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Joining column values in Table1 to column headers in Table2
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...- actuaryinworks
- Thread
- Replies: 12
- Forum: Microsoft: Access Queries and JET SQL
