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 Mike Lewis 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: quesnelljc
- Order by date
-
ActiveX component cannot create object "Access.Application"
Thanks, That is what I have got. Just forgot to put the quotes in here. Still having the same error returned??? It is a real mystery to me!- quesnelljc
- Post #5
- Forum: Microsoft: Access Other topics
-
ActiveX component cannot create object "Access.Application"
No. Not sure why it has put this in. My code is; Dim objAcc Set objAcc = CreateObject("Access.Application") objAcc.Visible = False path = c:\working from home\test db connection.mdb" objAcc.OpenCurrentDatabase path objAcc.DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "table1"...- quesnelljc
- Post #3
- Forum: Microsoft: Access Other topics
-
ActiveX component cannot create object "Access.Application"
I am trying to write some code into a data access page which will export data from an access database. I am gettinging the error "ActiveX component cannot create object Access.Application" when running the following code: Dim objAcc Set objAcc = CreateObject("Access.Application")...- quesnelljc
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
-
ADODb connection failing
Having done some research on the error received, what I dont understand is why the error is returned when I have not deployed the DAP onto a web server. I am simply running the DAp from a network locvation and connecting to a database in the same location (just one directory up) According to...- quesnelljc
- Post #3
- Forum: Microsoft: Access Other topics
-
ADODb connection failing
Please help!! I have created a data access page for users to enter data into an access database. I would also like the users to be able to export data to an excel file so am working on some code within the DAP (VB Code) to enable the user to do so. Having searched high and low on the net, I...- quesnelljc
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
Object Required error in access db sub procedure
I am having some difficulty with the above error "object required" being returned when running a sub procedure in an access database. Quite simply I would like the on click command to return a message box if a particular condition is met. Here is my code: Private Sub Command130_Click() Dim...- quesnelljc
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
