Alupis Posted April 13, 2011 Share Posted April 13, 2011 I'm trying to write a script that will run a pre-setup query in Access and then read the output data... remember that data, and then use the data to run an access report and print the file. I've worked with autoit before... but have not really set much up as for as interacting with access. I dont need it to manipulate the data in any way... just plain run and read and run. Can someone help me at least get started in the right direction? so like this: Autoit runs Query01 -- reads a few of the columns in the output (i guess create an array from the data) -- and then runs report01 entering that data -- then finally printing the report. I'm pretty good at working with arrays and what-not... just unsure how to get data from access. i have attached Query01's data output so you can see the data i'm trying to work with... Using Access 2003. Link to comment Share on other sites More sharing options...
spudw2k Posted April 13, 2011 Share Posted April 13, 2011 You could use ADODB and interface with the data directly instead of manipulating the Access GUI or using COM. That'd be my recommendation if the desired end result is simply retrieving data. Check out my example or search the forums for ADODB. Spoiler Things I've Made: Always On Top Tool ◊ AU History ◊ Deck of Cards ◊ HideIt ◊ ICU ◊ Icon Freezer ◊ Ipod Ejector ◊ Junos Configuration Explorer ◊ Link Downloader ◊ MD5 Folder Enumerator ◊ PassGen ◊ Ping Tool ◊ Quick NIC ◊ Read OCR ◊ RemoteIT ◊ SchTasksGui ◊ SpyCam ◊ System Scan Report Tool ◊ System UpTime ◊ Transparency Machine ◊ VMWare ESX BuilderMisc Code Snippets: ADODB Example ◊ CheckHover ◊ Detect SafeMode ◊ DynEnumArray ◊ GetNetStatData ◊ HashArray ◊ IsBetweenDates ◊ Local Admins ◊ Make Choice ◊ Recursive File List ◊ Remove Sizebox Style ◊ Retrieve PNPDeviceID ◊ Retreive SysListView32 Contents ◊ Set IE Homepage ◊ Tickle Expired Password ◊ Transpose ArrayProjects: Drive Space Usage GUI ◊ LEDkIT ◊ Plasma_kIt ◊ Scan Engine Builder ◊ SpeeDBurner ◊ SubnetCalcCool Stuff: AutoItObject UDF ◊ Extract Icon From Proc ◊ GuiCtrlFontRotate ◊ Hex Edit Funcs ◊ Run binary ◊ Service_UDF Link to comment Share on other sites More sharing options...
Alupis Posted April 14, 2011 Author Share Posted April 14, 2011 Hello spudw2k! thanks for the quick reply! I've taken a loot at your code and done quite a bit of searching, but am still lost as to where to even begin! I'm not quite up to par on my scripting skills to be able to fully understand what yours is doing. Most of the posts and google searches i've done all start by using some code the article writer has come up with and assume i already have an understanding of how to get to that point... which i dont. can you point me in the direction of a good ADODB article that applies to autoit and access, or a good walkthrough to help me build my script? thanks a ton! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now