Search results

I've spent the better part of today researching how to create a table in a SQL database via Access VBA. I can run a create table pass through query using the query tools, but when I convert it to code I get a "Data Type Conversion Error". Any and all help is appreciated.

I've been researching this for quite a while and can't find a solution. I'm opening a password protected word document and trying to save it in a pdf format. I can do this easily on a non-password protected document: Dim objWord As Word.Document Set objWord = GetObject("c:\temp\test.doc"...

Hi Everybody, I am having a problem when formatting Excel and Word documents utilizing VBA. Everything works great for the first go round. For the second run of the process I get a run time error 462 "The remote server or machine is not available or does not exist". I have stepped through...

I have an application that creates and formats an Excel spreadsheet, then saves it and closes down Excel. It's been working fine. Now, I have been asked to keep the Excel file open after the application has ran. While this is sloppy, I can easily do this by not closing out my reference to...

Hi everyone! Our Access databases currently use the windows Data Sources ODBC connection to link to AS400 tables. I am running into a problem where my modules are using a few of these tables and the module will prompt the user for a login and password. While it's fine to have this pop up...