misterDee Posted December 22, 2009 Share 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 Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted December 22, 2009 Moderators Share 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 Link to comment Share on other sites More sharing options...
martin Posted December 22, 2009 Share 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. Link to comment Share on other sites More sharing options...
misterDee Posted December 22, 2009 Author Share 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..? Link to comment Share on other sites More sharing options...
misterDee Posted December 22, 2009 Author Share 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? Link to comment Share on other sites More sharing options...
martin Posted December 23, 2009 Share 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. Link to comment Share on other sites More sharing options...
misterDee Posted December 23, 2009 Author Share 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!!! 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