Search results for query: *

Not sure I can do this, but worth a try. I want to be able to use the TransferDatabase command after creating an access object. Then save through a browse window (I can handle that part) to a user chosen directory. If I have to copy/paste the database, I don't know how to code that. All of...

Thanks Tom. I'll take a look. In regards to the code looking odd, I agree. I have also tried the simplest method of all - TransferSpreadsheet. I can get this to work in a simple spreadsheet file. However, the file(s) that I need to get to are about 3.2Mb with macros and about 20 worksheets...

I'm still lost on this problem, if anyone has an idea. I looked through a post on Recordset Connection (I am running Access 2000) and used the udl wizard idea - which was cool by the way. Still having problems. Now I get a error which states "Syntax error in FROM clause" and...

I tried the ADO function example in the provided link, but it gives me an error on the open recordset line. Code on this line is below (part of the published function) rs.Open sql, "Driver={Microsoft Access Driver (*.mdb)};Dbq=" & CurrentDb.Name & ";", adOpenForwardOnly...

I'm new to VBA coding so bear with me. I have a table that needs to get into Excel. The worksheet is important, but not necessarily the range. I would like to export using a recordset and have the user able to select the excel file (which is a template of sorts). I got a lot of help from...