Recent content by aussieTrev

Fixed it myself. I needed to use the oleObject.Object property to access the checkbox value. Like this: varControls(3, n) = .object.Value

Hi all, I have a legacy Excel template which multiple users complete. On completing the form a copy is saved into a network folder. I then have a form created in Access which currently I type in all the data on the form, audit the report and it is then entered into the corresponding...

Hi folks, I'm new to this forum. I've been working with an Access database for the last 4 years, with various modules written in VBA within Access and also within several excel workbooks to automatically extract data to produce regular and ad-hoc reports. I live in Adelaide (South...