misterDee Posted December 22, 2009 Posted December 22, 2009 Hi, I have a GUI with a working Access database, the GUI gets his information from the database but when im add some text into the database i must restart the GUI to see it, its not LIVE up2date.. is there a command of trick to give a 'refresh' to the GUI?. just like in Internet Explorer (F5)? Thnx a lot
Moderators Melba23 Posted December 22, 2009 Moderators Posted December 22, 2009 misterDee,I have never worked with AutoIt and Access, so please take this as a helpful suggestion and not a guaranteed solution. To change the data in AutoIt ususally requires the use of GUICtrlSetData to change the content of a control. So I suggest that you put the whatever code you need to read the data from Access into a loop and then use GUICtrlSetData to update the Autoit control if it alters. I can well imagine that the implementation may be somewhat more complex than that simple statement, but I think it is worth a try unless you get a better idea from someone with Access experience.Good luck - and do come back if you run into problems.M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area
martin Posted December 22, 2009 Posted December 22, 2009 Hi,I have a GUI with a working Access database, the GUI gets his information from the database but when im add some text into the database i must restart the GUI to see it, its not LIVE up2date.. is there a command of trick to give a 'refresh' to the GUI?. just like in Internet Explorer (F5)?Thnx a lot It might be that what you need is _WinAPI_InvalidateRect. Serial port communications UDF Includes functions for binary transmission and reception.printing UDF Useful for graphs, forms, labels, reports etc.Add User Call Tips to SciTE for functions in UDFs not included with AutoIt and for your own scripts.Functions with parameters in OnEvent mode and for Hot Keys One function replaces GuiSetOnEvent, GuiCtrlSetOnEvent and HotKeySet.UDF IsConnected2 for notification of status of connected state of many urls or IPs, without slowing the script.
misterDee Posted December 22, 2009 Author Posted December 22, 2009 misterDee,I have never worked with AutoIt and Access, so please take this as a helpful suggestion and not a guaranteed solution. To change the data in AutoIt ususally requires the use of GUICtrlSetData to change the content of a control. So I suggest that you put the whatever code you need to read the data from Access into a loop and then use GUICtrlSetData to update the Autoit control if it alters. I can well imagine that the implementation may be somewhat more complex than that simple statement, but I think it is worth a try unless you get a better idea from someone with Access experience.Good luck - and do come back if you run into problems.M23Hi Melba, thnx for your replay.. its simple.. its just a label in the GUI thats takes text from a database that need a live-changing when its changed in the database.. i dont think your command is working for this..?
misterDee Posted December 22, 2009 Author Posted December 22, 2009 It might be that what you need is _WinAPI_InvalidateRect.Hmm.. i think your closer.. i see the GUI refreshin', but the label doesnt change $gui=guicreate_WinAPI_InvalidateRect($gui) that is what you mean?
martin Posted December 23, 2009 Posted December 23, 2009 Hmm.. i think your closer.. i see the GUI refreshin', but the label doesnt change $gui=guicreate_WinAPI_InvalidateRect($gui) that is what you mean?Yes, but if the gui is one you created with AutoIt and you have a label which shows the data then what Melba23 said is corrcet. You need GuiCtrlSetData($label, $newtext) Serial port communications UDF Includes functions for binary transmission and reception.printing UDF Useful for graphs, forms, labels, reports etc.Add User Call Tips to SciTE for functions in UDFs not included with AutoIt and for your own scripts.Functions with parameters in OnEvent mode and for Hot Keys One function replaces GuiSetOnEvent, GuiCtrlSetOnEvent and HotKeySet.UDF IsConnected2 for notification of status of connected state of many urls or IPs, without slowing the script.
misterDee Posted December 23, 2009 Author Posted December 23, 2009 Yes, but if the gui is one you created with AutoIt and you have a label which shows the data then what Melba23 said is corrcet. You need GuiCtrlSetData($label, $newtext)Thanks it works, i get the code, easy does it and thnx to Melba23!!!
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