Search results

Almost there Ridders! I created a script and am using the fHandleFile to open the script in SQL. The problem is that SQL opens the script, but doesn't run it. Is there some setting that I need to change. Please keep in mind that I am experienced in Access, but very much a novice when it...

Thank you for the response Ridders. I'm still running into issues, but am slogging through the muck to figure it out. Wish me luck :)

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.

Thank you Paul. I tried your suggestion and I come up with the error ":Runtime error 438. Object doesn't support this property or method" when attempting to do the saveas2. WooHoo! Just tried it changing the SaveAs2 to SaveAs and it worked! Thank you very much. I'm going out to...

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"...

Thank you Rx... Let me try to play with this. Great idea on the variable holding the password.

I've been using this apiShellExecute function with great success. Now I've come across a new dilema... The word document that I am opening is password protected. I want to be able to pass the password through using the apiShellExecute function. I've done some research out on the World Wide...

Amazing how such a little nuance can cause such a big problem. Thanks Bob. What a wonderful article. I'm making the suggested changes right now. I hope you know how much a lot of us appreciate your guidance....

Just solved it.... I simply took out the line that was erroring out. The word document is still formatting correctly. Doh! That's what I get for just copying the Word logic from the Macro and not making sure of what each step did. Still not sure why it bombed out on that line during the...

Just trying to revive this in case someone has been off the board. In doing a little more testing. If I remove all references to Word, it works perfectly. It must be something in my Word logic?

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...

Wow! That worked beautifully! Thank you so much for your help. Such a clean solution!

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...

Thank you for the reply Bob. I was afraid you were going to say something like that. I guess I will update each of the databases I touch. In the long run it will save me time. Have a great day!

Hi Bob... I was doing a search on the forum regarding modifying a label on a form in another database and I came across this post. I used the sample logic you have shown above to actually open the other database. Now I'm at a point where I can't find anything that will allow me to change the...

That's great Michael! Now I have to go and play with it again just to see if I can get it to work... Thanks a lot!!! :)

I couldn't get it to work. Had problems with the real names to use within the DSN file, as well as the actual connection string. I did speak with the AS400 lead, and he helped me set up the connections so that we didn't need to use a connection string. Thank you for your time Michael. I...

Thank you Michael! Let me give that a try today. Standby.....

Thank you Michael... Can you use the FileDSN to create linked tables, or do you just use pass through queries with it?

Thank you for replying mdlueck! Shown below is what I'm using to test using with SQL. I'd like to do the same thing but using AS400 data. I apologize for not knowing the proper definition of what I'm trying to do :(. I want to be able to link to the AS400 table(s) programatically and not have...