SOLVED opening form and at specific record from subform

KCPhoto · Last edited by KCPhoto on Mon Sep 06, 2010 5:20 pm; edited 1 time in total

I posted part of this in the thread where I found this code, but want to clarify what I need. Sorry for the duplication.

I need help determining why I can't find a column in a subform record in this macro.
I am calling the macro from within the subform with a mouse click.

RPG · Posted: Sun Sep 05, 2010 9:06 am Post subject:

Hello

Use the base tools.

Her is an explanation
http://user.services.openoffice.org/en/forum/viewtopic.php?f=20&t=31801&p=145187#p145187

Romke

KCPhoto · Posted: Sun Sep 05, 2010 3:34 pm Post subject:

Thank you for the reply.
Kenny

KCPhoto

I have been able to retrieve the field I need to filter the called form. However, I now have a problem with my filter line of code.

KCPhoto · Posted: Mon Sep 06, 2010 7:43 am Post subject: Still struggling

By declaring my variable oMyID alternatively as an Integer and then a String variable, I have determined that the line
oMyID=otblctrl.getByName("ShootID")
is returning an an Object and cannot be a string or an integer.

How do I incorporate this into a filter command?

oform2.filter =("ShootID = " & oMyID) does not work, I assume, because oMyID is not a string value as required by the filter.

How do I get the value from the oMyID Object and convert it to a string in the filter?

I know I am rambling here, but I am hoping someone will see I am making some progress and step in to help.

Thanks,
Kenny

KCPhoto · Posted: Mon Sep 06, 2010 8:33 am Post subject:

Well, I got the filter to work using CurrentValue on the object variable. Now...

The filter is running on the original form "Clients" instead of the form I have just opened. How do I set the focus to the new form before executing the filter and reload?

RPG · Posted: Mon Sep 06, 2010 10:45 am Post subject:

Hello

First it is real nice you succeed in making a working macro. I knew it is real difficult to set the first steps. Be happy with your code and do not forget to study also the Basetools. You can find all information in the thread I did point to. In the code in that link there is also a link where you can find the basetools.

Romke

KCPhoto · Posted: Mon Sep 06, 2010 10:54 am Post subject:

I have searched and used trial and error on this all day. I wislh there was more documentation available somewhere.

I wish to make the latter part of this macro execute on the newly opened form "Shoot". Can anyone please tell me what to put after this line

oDoc2 = oDataBase.FormDocuments.GetByName("Shoot")

to let the filter run on the form I have just opened.

KCPhoto · Posted: Mon Sep 06, 2010 10:58 am Post subject:

Romke,

Sorry, I was posting at the same time you did.

Before starting on a new set of tools, I want to get this basic macro working. I need this database for my business to replace one I wrote years ago in MS Access. I'm not a programmer, I'm a photographer.

I know you want me to use those tools because they eliminate many of the lines of code required. I will install them when I have more time to refine my database.

Thanks,
Kenny

RPG · Posted: Mon Sep 06, 2010 11:02 am Post subject:

Hello

First learn how to activate a filter for a form as document in which you work.
When you knew that then it is easy to do it in a just open form. A just open form returns a object what is the same as thiscomponent for the new document.

I think that you must better read the links you have found there all information is in the links you have already found so study them.

Romke

KCPhoto · Posted: Mon Sep 06, 2010 11:07 am Post subject:

Well, the code would not work when using thiscomponent after opening the new form. This filter actually applied to the form from which I executed the macro. I tend to believe the errors are on my part and not a bug in the application.

Thanks,
Kenny

KCPhoto · Posted: Mon Sep 06, 2010 11:13 am Post subject:

I tried repeatedly to filter the form in design mode.

In the form properties box for the "Shoot" form I selected FIlter.

Then I entered:ClientID = then typed Client.CustomerID trying to refer to Client form that is open, but that didn't work.

All other efforts to filter from another form resulted in basing the form on a Query which prevented data entry and update.
For these reasons, I am trying to filter my form with a macro.

Thanks,
Kenny

KCPhoto · Posted: Mon Sep 06, 2010 11:25 am Post subject:

For the moment, I have abandoned my macro. I am using it to open the "Shoot" form only. I have gone into design mode of the shoot form and entered a filter in the form properties. Here is what I entered.

( "Shoot"."ClientID" = "Clients"."CustomerID" )

This will not work. The form opens but not to the current (or any) record and the record navigator shows no records. Can anyone help me with this form of filtering?

Kenny

RPG · Posted: Mon Sep 06, 2010 1:22 pm Post subject:

Hello

Make first a filter in a normal way. Then try what you see.

Romke

dacm · Super User Joined: 07 Jan 2010 Posts: 734

See if this helps sort things out.
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Migrating 'Embedded databases'