Recent content by cparralesl

MajP, I can't see it means, that i try to use that variable to change it value, but it doesn't appears initializaed, as it never were declared. To check if the variable is initialized, i create a fresh new form and use the click event of a button that i added in that form. I can view the value...

Hi everyone: In a module, Module1, I declared a public booelan variable. Later in form and its subform i can not see it. Module1 Option Compare Database Option Explicit Public ServicioActivado As Boolean In the load event of my form I do the test: MsgBox "My Boolean value is: " &...

What happen after hit down arrow is that combobox takes the first item of the filter list as the new filter criteria, so the new list filtered has one record only. Cesar Humberto Parrales Application Support

So what happens if you keep "using directionals keys (Up, Down)" ? What happens is that Combobox selects the fisrt item of the filtered list always, then the filter is based on that selection. The behavior i desire is that Combobox should let me moves through the filtered list, until i press...

Hi everyone, This thread thread702-1228727 has been very useful for me, it works great; But i don't know how to control a behavior. When it displays the filtered list, the user is not able to select an ítem from that list, because combobox takes the first ítem and close the dropdown as soon as...

Hello guys, Trying to retreive some user information, but I have problems when retreive Date or Boolean fields. If I incluide Date Fields, the query does not return records. Taking off that date field of the command it does returns records. I've tried to format or convertig the field using...

Guys, In the subform as is a make some validations and calculations for the required fields. Bacause of that, apparently the code validations in the sub form are the lastone to be performed, so that it got the focus. Do I need to perform the validations in the main form? Any ideas? I really...

Hi guys: May be someone got this easy, but I spend some days around it and I already looked it up in this forum with no luck. My purpose is to record the invoices and products the company has bought. I have created a form with subform that save that information. If the subform has no record...

Hello: Ineed to know if its possible to use the group/ungroup command in a protected sheet of MS Excel. I tried but an error message come up saying that i have to unprotect the sheet first to do that. I made a little search on the forum before create this post, but no luck. Helps about it...

Hi again: Basically I need the PivotChart SubForm changes based on the seleccion the user make in a Listview. The list view has a list of places like States, Departaments. For example: If the user selects the state of Texas then the PicvotChart Shows how many mans and womans it has. Help woul...

Thanks for your response lameid, Basecally I need a dinamic chart, thats why I use a SubForm having PivotChart as a default view. This Subform use a query that I built and save it before, than i assign it to the PivotChart Subform. My question is how can i make this subform dimanic? Thanks in...

Hello Guys, I created a subform with chart purposes, so I change the "Allow PivotChart view" Property to yes, the others remains No. The Default view I set it as PivotChart. I set the subform chart I save it and I test it. It shows data in bar chart type. But, when I insert it and link it to...

Hello guys, I solve the problem. I use the name of the field of the subform instead of the name of the control. I didn't know that, but certainly I spent three day to find out. :( But also appreciate your help about it. I just wanted to manipulate the subform using a Main form without a...

The listbox is not multi-select. The value select for the item in the listbox, is passed to label control. From there the subform takes the LinkMasterFields. I do not know how to tell the sub form that the LinkChildFields is the ID_DEPARTAMENTO field which is in the subform. As you can see in...

Ui guys, I have had hard tme with a subform placed in a tab. I've spend two day woith no luck. Here is the issue: The main form doesn't have a recordSource. There is a tab control and in each page i have a ListBox on wich I load records using code. I also created a sub form that I want to tie...