Search results

Yes i did. I do not see of the option ctr.TypeName. It gives an error.

did that, does not work

I am the only one using that DB. But i am testing your solutions. Thank you so much!

Hi, I can not figure out how to loop through the controls in a form. The tutorials seems not working with MS Access 365. Dim ctr As Controls For Each ctr in me.controls if ctr.TypeName=acTextBox then msgbox ctr.name end if next ctr This is just the testing example...

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