Sign in to follow this  
Followers 0

Refresh GUI

7 posts in this topic

#1 ·  Posted

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 ;)

Share this post


Link to post
Share on other sites



#2 ·  Posted

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._______My UDFs:

ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert - Easily convert date/time formats, including the language used
ExtMsgBox ------------- A highly customisable replacement for MsgBox
GUIExtender ----------- Extend and retract multiple sections within a GUI
GUIFrame -------------- Subdivide GUIs into many adjustable frames
GUIListViewEx -------- Insert, delete, move, drag, sort and edit ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ---------------- Scrolling tickertape GUIs
NoFocusLines --------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify -------------------- Small notifications on the edge of the display
Scrollbars -------------- Automatically sized scrollbars with a single command
StringSize -------------- Automatically size controls to fit text
Toast -------------------- Small GUIs which pop out of the notification area

Share this post


Link to post
Share on other sites

#3 ·  Posted

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.

Share this post


Link to post
Share on other sites

#4 ·  Posted

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

Hi 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..? :evil:

Share this post


Link to post
Share on other sites

#5 ·  Posted

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?

Share this post


Link to post
Share on other sites

#6 ·  Posted

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.

Share this post


Link to post
Share on other sites

#7 ·  Posted

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!!!

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0