Changing to Office 365 (1 Viewer)

[Pat Hartman]

Great. Thanks. The scope of the changes wasn't specified on the web pages.

 

[petko]

Do you use Hungarian characters in your VBA code when referencing the headers or footers?

You can use a tool like our Find and Replace to replace all these names. - As there are only a few isolated properties affected, you could also write some VBA code to replace these names.

I would use vba codes for renaming the headers and footers. Mostly becase I found out that - where these characters are present - after having them replaced to a correct character, the RecordSource of the Form has to be deleted and re-given again, otherwise the error message comes up.

Can you help with the following keypoints:
- how could I make a cycle that runs through all of my forms?
- how can I refer to the form’s name if it is a variable? For renaming I would use this code: Forms!FormName.Section(acHeader).Name = "NewName" However FormName would be always the actual form's name, beenig renamed in the cycle and I don't kow how to refer to it.

Thanks in advance

petko

 

[GPGeorge]

Dim frm as Access.Form

For Each frm In Application.Forms
Debug.Print frm.Name
'-----Do your thing here with frm.Name

Next frm