Really basic help or direction needed

[jasonphillipstx]

I have a batch file that is scheduled to run each day. it opens and Access database and print out some reports. I really want to learn how to do this in a vbs file. Everything I find in searching seems much more complex than what I need. Can someone point in the write direction? Maybe a little code even?

Thanks in advance.

 

[dm4ever]

If the batch works, then why change it? On the other hand, if you want to learn how to work with an access db using vbscript, do a search for "ADO" and "RecordSet".

take a look at these links:

http://www.microsoft.com/technet/scriptcenter/scripts/misc/database/default.mspx

http://www.microsoft.com/technet/scriptcenter/resources/qanda/oct06/hey1020.mspx

http://www.w3schools.com/ado/default.asp

(tailored to web page, but it still uses vbscript)

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid

 

[barny2006]

what does your batch file do?
can you post it?

 

[markdmac]

Assuming that your access database has an Autoexec macro in it that will print out your reports right away and close the database, you would only need a two line script.

Set WSHShell = CreateObject("Wscript.Shell")
WSHShell.Run "MSACCESS.EXE databaseName.mdb"

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript