First-timer needs a hand

[RyanPriceDotCa]

Hello,

I'm trying to automate a data entry process at my office. Every once in a while we receive an excel sheet with a bunch of records that need to be updated in our database.

Having never used AutoIt before I was hoping someone here can help me get started. My first problem lies in the fact that the window I want to detect lies within another window. Here is a pic:

The main window, and the window detected by the Window Info tool, is titled "Research Database". The window I want to detect is the "Main Search Screen".

How do I go about detecting it? The information seen in the picture above shows the window info information while my mouse and cursor are over the "Selection Criteria" search box.

The only place I see the window I'm after is in the "Visible Text" section. Is that I would use?

Thanks in advace. I know this is a noob question but any help is appreciated.

[Kiti]

For begining, try just:

WinActivate("MAIN SEARCH SCREEN")

If it works properly, your editor will switch to that box. See if it works

[TehWhale]

Else,

GUICtrlSetState($Control, $GUI_FOCUS)

[PsaltyDS]

Hello,

I'm trying to automate a data entry process at my office. Every once in a while we receive an excel sheet with a bunch of records that need to be updated in our database.

Having never used AutoIt before I was hoping someone here can help me get started. My first problem lies in the fact that the window I want to detect lies within another window. Here is a pic:

The main window, and the window detected by the Window Info tool, is titled "Research Database". The window I want to detect is the "Main Search Screen".

How do I go about detecting it? The information seen in the picture above shows the window info information while my mouse and cursor are over the "Selection Criteria" search box.

The only place I see the window I'm after is in the "Visible Text" section. Is that I would use?

Thanks in advace. I know this is a noob question but any help is appreciated.

You should be fine with just title and text, for example:

WinActivate("Research Database", "Main Search Screen")
ControlSetText("Research Database", "Main Search Screen", "Edit1", "R2839")

[RyanPriceDotCa]

Thanks to all. I'm understanding more how this works and have made quite a bit of progress with these little tips.

Thank you.