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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by kwomack
-
Access ADP Stopped Working
After searching for 2 weeks to find the solution, I post here and 10 minutes later find a solution. To fix the issue, run msaccess in /decompile mode and then open the Visual Basic editor and compile the code from the debug menu. I found several procedures that were left over from prior updates...- kwomack
- Post #2
- Forum: Microsoft: Access Project (ADP)
-
Access ADP Stopped Working
I have an Access ADP project that was created in Access 2003. Recently we upgraded to Access 2010. The APD connects to an SQL 2000 database. The ADP works fine until I try to make changes. After making changes and reopening the project, the project crashes shortly after I open it. It happens...- kwomack
- Thread
- Replies: 1
- Forum: Microsoft: Access Project (ADP)
-
Copy to excel and merge with word from access
The code below will automate Excel but you may want to consider bypassing Excel and use the database as your merge source. Private Sub cmdReportExcel_Click() Dim xlApp As Excel.Application Dim xlWB As Excel.Workbook Dim xlWS As Excel.Worksheet Dim strFileName As String Dim rs As...- kwomack
- Post #2
- Forum: Microsoft: Access Project (ADP)
