Working with MSAccess

[rick207]

Hi.

I've got a Access DB, and want to automate filling data in form. Form has listview where I can choose an item. After choosing, other controls update with related data. What is the best way to pick up an item from this listview ? I've tried to send text to it (with success) and send {ENTER}, but didn't work.

Any ideas

Rick

[FuryCell]

Take a look at ControlListView(). It should give you pretty comprehensive control of the listview. However I'm not sure if it is compatible with MSAccess listviews as I don't have Acesss installed on this workstation.

[rick207]

Thanks for clue, but isn't working. "GetItemCount" returns 0, "Select" sets @error=1

[dabus]

MSOffice is a bunch of custom controls/toolbars. Most of the better/more complex automation functions will not work. Send works if you slow down the delay. Maybe you can find a way to open a "normal" box/dialog-window that can be controlled/works for you. Good luck.

Edited October 21, 2006 by dabus

[rick207]

It's not good news

One question. Where exactly func "Send" sends data ? When I have active window with some controls, it's sent to that one which has focus ?

[randallc]

Hi,

Is it a complex database, or can you do it with com commands (see udf from my sig)?

Randall

[rick207]

Thank you Randall, but I'm afraid your script isn't usefull for me. I can only work with GUI, have no access to tables

[rick207]

Problem solved with "setfocus", "sleep" and send"{ENTER}". But the next problem arose. How to retrieve information from subform where data is in rows and columns (every row represents one record) ?