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 Chriss Miller 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: RevenueSwede
- Content: Threads
- Order by date
-
Create worksheet in Excel from Access
Hi! I have a working function that produces a graph on one worksheet and the data is placed on another worksheet. Now I want to add a third worksheet. I'm confused by the syntax.. I have a workbookobject called xlWrkbk and I have put a Dim xlWks as Excel.Worksheet on the top Set xlWks =...- RevenueSwede
- Thread
- Replies: 9
- Forum: Microsoft: Access Modules (VBA Coding)
-
Select range in Excel from Access
Hi! I create an Excelfile from Access, no problem. My knowledge about Excelprogramming isn't the best. I have a starting cell, column 4 (D) and starting row 7. I want to select d7 to j7 and make it green. I have quite many columns from D to DG. I have found that I can use...- RevenueSwede
- Thread
- Replies: 12
- Forum: Microsoft: Access Other topics
-
Date comparison
Hi! I'm stuck. Short description of project. I have a table with filled with batallions (yep Army stuff) and their educational periods. Example: Name StartDate EndDate Bat1 1/1/2008 12/31/2008 Bat2 1/1/2007 6/30/2008 Bat3 7/1/2008 1/1/2009 Now I want to search between 1/1/2008 and...- RevenueSwede
- Thread
- Replies: 7
- Forum: Microsoft: Access Other topics
