martinus Posted September 14, 2016 Share Posted September 14, 2016 Hello everyone, I'm new to autoit so forgive me when i start to ask stupid questions. Here is what i'm trying to do: I have in ms access 2007 a form with on that form a empty field, now i would like to let autoit fill this fiield with a value. So i tried to look with autoitinfo.exe to look for the class but it only shows the complete form. Anyone has a idea how to solve this many thanks for your answers en help Link to comment Share on other sites More sharing options...
spudw2k Posted September 14, 2016 Share Posted September 14, 2016 This did the trick for me--assumes Access with desired DB is open. Warning, no error checking. _AccessDBTest() Func _AccessDBTest() $oAccess = ObjGet("", "Access.Application") If Not IsObj($oAccess) Then Exit $oAccess.DoCmd.OpenForm("Form1") $oForm = $oAccess.Forms("Form1") $oForm.Controls("Text0").value = "Test" EndFunc 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...
martinus Posted September 15, 2016 Author Share Posted September 15, 2016 17 hours ago, spudw2k said: This did the trick for me--assumes Access with desired DB is open. Warning, no error checking. _AccessDBTest() Func _AccessDBTest() $oAccess = ObjGet("", "Access.Application") If Not IsObj($oAccess) Then Exit $oAccess.DoCmd.OpenForm("Form1") $oForm = $oAccess.Forms("Form1") $oForm.Controls("Text0").value = "Test" EndFunc Hello Spudw2k, Thanks for your reply, this did the trick for me 2. Again thank you very much Greets Martinus 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