Search results

i did, but it still changes all the fields in the column.

Thank you for the detailed input. I am going to build in a message box with conformation message with default cancel button.

I have done it but in the column all have it. My aim is to have only if a certain text is the textbox.

Because it is a subform in datasheet view. So i would iike to have in certain controls

Hi, I have a field in a form with conditional formatting (blue color with underline). It is not a hyperlink but i would like to have to behave like that (hand as cursor). Can not get it worked. Is there a solution for this? thank you

seems like syntax error accmdDeleteRecord..... sorry about that, it works now without the 's'

Hi, I want to delete a record in a subform by clicking a command button on the mainform. I made a public function in subform Public function DelRec() docmd.runcommand accmdDeleteRecords end function Then onClick of the button Public sub CMD1_Click() Forms!frmMain.fsub.form.DelRec end...

Thank you, i have of course done that, and i use a custome ribbon. I just ran into a commandbar vba, and i want to understand it correctly, but has not found the correct resources.

Hi, I am looking for some resources on the use of commandbar in ms access 365. Can some suggest one?

So it means the software update has made the change?

Hi, Until just recently, my access has had the "classical" white, red theme. Navigation pane and workplace white. However after a recent restart all of a sudden white background has changed to gray. Why? I played around the with Option/General/Office Backround and Office Theme but i can not...

thanks for all help

You wont beleive: just recreated the subform recordset i.e. I have deleted the recordsource line and re-entered the same... It works now...

That might be indeed a problem. The marking changes the recordsource table records, since i have added yes/no fields into that table: tbBasic

how do i do it?

sorry, i have tried it without passing and directly define it in the VBA window of the form

Actually the filter parameters are passed from on form by marking the records and then the array created from the marked records, HorseID then used. Maybe this passing causes the problem? Instead of onLoad onOpen?

i have tried refresh/requery on current afterupdate on load even command button to apply these but non of these worked.

I did think so however it did not work.

The method applied to the subform now works. So applied the same filter rule to the child link field: Me.Form.Filter = "HorseID In(" & y & ")" Me.Form.FilterOn = True Me.fsubMainTM.Form.Filter = "HorseID In(" & y & ")" Me.fsubMainTM.Form.FilterOn = True where y is the taken from...