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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to connect to a remote MS Access database using ASP
This is what I use and it always works. The key thing is setting up your ODBC/DSN connection string on the server, then using the ASP to call that string. Dim myConn Dim strNaDB Set myFSO=CreateObject("Scripting.FileSystemObject") Const ForReading = 1, ForWriting = 2, ForAppending =...- Preston5
- Post #2
- Forum: Microsoft: ASP (Active Server Pages)
-
Export chart works in Access97--not in Access 2000. Why?
The portion of code below uses data in Access to automatically build and format a chart in Excel. strSourceName = "tblAccessTable" strFileName = "c:\ExportedChart.xls" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, _ strSourceName, strFileName, False This...- Preston5
- Thread
- Replies: 0
- Forum: Microsoft: Access Other topics
-
Change Colors in Excel Pie Chart Programmatically
I'm trying to change the colors in an Excel pie chart from an Access form. I can build it OK, but the pie slices have to be a specific color. Here's the code I'm trying and it doesn't work at all. I've also tried the MarkerBackgroundColorIndex, but I think it doesn't work with pie charts. Any...- Preston5
- Thread
- Replies: 0
- Forum: Microsoft: Access Modules (VBA Coding)
-
Launch Excel from Access Module
I've read what has been archived about this topic and am trying this line of code: Call Shell("C:\Win32App\MSOffice\Office\EXCEL.EXE" & Chr(34) & "c:\DeleteMe\" & strComboClient & "_Chart.xls") The "strComboClient" is a variable passed from a combo box...- Preston5
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
