Add a document/image in an updated client form

[mike60smart]

Hi Kelly



Is the attached what you are aiming for?

The Green Coloured button on the Subform allows you to Navigate to the File Location and the Path to that Folder is displayed in the Doc Path Control.

[MustbeAweful]

Hi Kelly. Is the attached what you are aiming for?

Unfortunately, I keep getting a Compile Error. Is there something I need to do before viewing it?

[June7]

I click green button with + sign and code works just fine, no error message.

[mike60smart]

Hi Kelly
You may be missing a Reference.

To check hold down the Ctrl + G Keys to open the VB Window

Select Tools - References

Make sure that Microsoft Office 16.0 Object Library is selected

[MustbeAweful]

Hi Kelly
Make sure that Microsoft Office 16.0 Object Library is selected

Heyo Mike,

I did what you said. "Microsoft Office 16.0 Object Library" is selected.

Here is the error in full:


I hope this helps.

[mike60smart]

My PC Uses Office 365 32 Bit with Windows 11

If you can it would be best to uninstall Office 365 and then download and Install the 32 Bit Version.

[moke123]

The other option other than installing 32 bit is to use 64 bit compatible Api's.

[mike60smart]

Hi Everyone
The OP contacted me by PM and it would appear that the database was on One Drive.

I pointed out that this was a No No

[Welshgasman]

Hi Everyone
The OP contacted me by PM and it would appear that the database was on One Drive.

I pointed out that this was a No No

Bitness still applies.