accessing active control in Base

lm · Posted: Tue Oct 03, 2006 5:33 am Post subject: accessing active control in Base

Hi everyone!

Does anybody know how to access the currently active control (textbox in my case) in Base?

Thanks
lm

DrewJensen · Posted: Tue Oct 03, 2006 9:25 am Post subject:

This a control on a form then?

Not in a dataview or queryview component right?

Not that I have an answer for this, but I might know another way of doing what you want - depending on what that is? As for finding the active control on a form, there must be someway...perhaps view the currentcontroller on the text document or using AWT toolkit.

lm · Posted: Tue Oct 03, 2006 11:02 am Post subject:

Yes, this is a control on a form. I'm building a database to keep track of work orders and packing slips, and I want to copy a value from one form (work order) to another (packing slip). I suppose I shouldn't really be doing this with macros, but I'm much more comfortable working with macros than with Base itself.

I'll keep searching the documentation myself, but any help is appreciated.

lm

lm · Posted: Thu Oct 05, 2006 8:05 am Post subject:

I think getCurrentControl() is what I need, but I get errors with it. Anybody got some working code with this function?

lm

DrewJensen · Posted: Thu Oct 05, 2006 8:42 am Post subject:

you can get a control by its name, it that would help

EDIT-

This is what I mean,

I suppose you are opening both forms. If this is true then you have a variable, or should, to both data entry forms.

Using these variable you can access any control on either form, by name. So the act of transfering data is fairly simple.

Another thing that you can do is to use a hidden control on a form. Then lets say on your order form you have a button that opens your second form. Well, in the macro that does this you can copy the data into this hidden control, then in the second form you can use this hidden controls data for your purposes.

lm · Posted: Fri Oct 06, 2006 8:02 am Post subject:

I know how to access the controls on the form by name, but what I'm after is to find out which control on the open form has the focus when my macro is called.

DrewJensen · Posted: Fri Oct 06, 2006 9:48 am Post subject:

I have been trying to figure that out since reading your post. So far I am up against a wall, I will post the question to the mail list at dba@openoffice.org and see if one of the developers can help with this.

I saw your post regarding getCurrentControl which works for a XTabbController and have looked at the documentation regarding it - but so far that has proven to be a dead end also. There is an example of using the function in the code snippet section on the main OOo web site, but it is in a different context. I have not been able to convert that working code to work with a Base form.

When I hear from the developers as I am sure I will I will post the reply up here. EDIT - as I hope I will... Confused

- END EDIT

Rocketman@JSC · Newbie Joined: 07 Oct 2006 Posts: 3 Location: Houston, TX

Rocketman@JSC · Newbie Joined: 07 Oct 2006 Posts: 3 Location: Houston, TX

Well I found out how. Many thanks to Andrew Pitonyak.

See section 10.3.2 of http://www.pitonyak.org/AndrewMacro.pdf

It works!!!! But if someone could explain how the macro knows what to put in as x--or is this like Python where the first arg is self?

lm · Posted: Tue Oct 10, 2006 8:12 am Post subject:

Scott,

I think what you are doing is not quite what I need to do. Your code accesses the button that was clicked to launch the macro, right? What I need is to access the textbox that had the focus BEFORE the button is clicked. Any thoughts on that ?

Thanks,
lm

Rocketman@JSC · Newbie Joined: 07 Oct 2006 Posts: 3 Location: Houston, TX