Search results

yes, the child link field is linked to a field on main form

Hi, I am struggling to solve this. I have a main form with a filter on in the form OnLoad event. Filtering works fine. However i can not get the subform filter appropriately. The two is linked together. Without filtering everything works fine. I have tried to requery the subform in several...

One more question, concerning ribbon...if i may, Is it possible to have classic menu instead of the ribbon? Tabs with text and by clicking only the narrow part shows up. If i click on tab of the ribbon the whole ribbon shows up with lots of empty places

ah sorry, it was a pop up form with the wrong size, now it works as expected though i have not idea why the scroll bar was extended. thanks

Thanks for all the help, it works fine now. Changed to Continous Form. Even better. However i have one more issue. The vertical scroll bar extends into form header that looks not so goot. Is there any work around to keep the vertical scroll bar out of the form heading area?

sure i understand, but i would like is that i would be immediatly enter data without taking care of an other click. Is it possible? Setfocus selects the control.

I use setfocus as you have described me.controlname.setfocus. So the focus moved to the appropriate control but the cursor is not there. I need to click on the control in order to enter data.

Thank you i will give it a try. Another question: How do i use setfocus in a way that the cursor also shows up in the control?

Hi, I have a form with datasheet view. When i move the curser to a field and it gets focus there is a red border line around despite the fact that i set it to transparent. Is there anyway to get rid of any formatting while getting the focus? thanks

it does not, two click is necessary to run btn_click event. It should open a form.

Hi, I am trying to solve the following problem: Object is a form/subform one. The header of the form has command button. If the focus is on the subform for entering data and i want to click the command button in the parent form, i need to click twice. I suppose once to move the focus from...

thanks for the inputs. Unfortunately the table has had it incorrect too. However i ve gotten it working. I have deleted the date delimiter in the value section of the sql statement. It is correct now. I will keep testing and report back. Thanks a lot!

arrayx is the array to take entries for the sql. yes d is formated but it mixes day and month if day is higher then 12

z = Forms!fsubMain1.Form.txtID d = Format([DOV], "\#dd\/mm\/yyyy#\") xx="test" For i = 0 To rs.RecordCount - 1 xx = arrayx(0, i) strX = "INSERT INTO tbDiagServMat(TM_Date,HorseID,DiagServiceMaterial) " & _ "VALUES (#" & d & "#,'" & z & "','" & xx & "');" DoCmd.SetWarnings...

Hi, I have just run into the classic date format problem and do find the solution that i used to have found. Entering data with sql into table. When default date field is =Date(), the format of the date is correct as it is set by w10 (UK) When i choose the date from the date picker the format...

THANKS A LOT!!! Works like charm.

That is the name of the subform name. txPartner = Forms!frmMassInput.fsubMassInput2.Form.CustomerID works fine

I wrote this but does not work With Forms(frmMassInput) txPartner = .Controls(fsubMassInput2).Form.CustomerID txAmount = .Controls(fsubMassInput2).Form.Total txCurrency = .Controls(fsubMassInput2).Form.currencyX txDescription = .Controls(fsubMassInput2).Form.TreatmentID End With

And for the first method? Sorry for it but i would really like to understand the syntax.

by the first or second method you have suggested? With... or the Set?