Search results

I didn't think about it as I don't have any experience with subreports really. But it is some idea worth digging around, thanks!

You are missing closing bracket, this line should look like: strPath = Trim(fDialog.SelectedItems(1)) I know, it wasn't in code I pasted, I just cut off too much ;)

No, you don't. Look again on the name of this library: Microsoft Office 14.0 Object Library and you have: Microsoft Access 14.0 Object Library

Hi All, In my project I got report that I would like to resize depending on sizes of some elements. Because one picture is worth more than 1000 words, here's the picture: Selected textbox PONumber can contain just one 7-character PO number or 10 of them. Its Can Grow property is set to Yes...

Something I use in my current project (mind it's not my own procedure, I found it somewhere): Private Sub btAddPhoto_Click() Dim fDialog As Office.FileDialog Dim varFile As Variant Dim strPath As String On Error GoTo errHandler ' Set up the File Dialog. Set fDialog =...

I think he actually needs Format([YourDateField],"ddmmyy") So calculation will look like: [field1] & Format([YourDateField],"ddmmyy") & [field3] & [field4] & [field5]