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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
HOt to let the user specify the location of an Excel file output from
I found this free code, which works fine: Private Sub ExportOneTable() 'EXPORTS TABLE IN ACCESS DATABASE TO EXCEL 'REFERENCE TO DAO IS REQUIRED Dim strExcelFile As String Dim strWorksheet As String Dim strDB As String Dim strTable As String Dim objDB As Database 'Change Based on your needs...- gurbaitis
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How can I copy the value of a cell from Table2 into Table1
Hello - A quick overview: I have a Table1 which reports on accounts that had a varrience. I have a Table2 which reports on accounts that managed their account online. I want to add a column to Table1 called eCommerce, and if they exist in Table2, put "Online" in that field in Table1...- gurbaitis
- Thread
- Replies: 8
- Forum: Visual Basic (Classic)
-
How to have 1 Sub call a 2nd Sub after closing a query
I have a number of queries that I'm trying to automate. The stickler is that one of the queries, a check of duplicates, opens so that the duplicates are displayed and can be deleted. What I want to happen is that once that query is closed, it procedes with the rest of them. How do I do...- gurbaitis
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
