add attachment with file dialog from command button

[ck4794]

debug.assert in the addattachment error handler. since it says "always stop here when debugging", i tried deleting it and all i get is the error, no debug.

[June7]

Did you run Debug > Compile from the VBA editor menu?

Need to disable the error handler for debugging purposes. It's there for the benefit of users so they don't get caught in an infinite loop or some other critical error but error handlers really get in the way for debugging. Comment out the On Error GoTo line until everything is working.

Set a breakpoint in your code and step through.

Review link at bottom of my post for guidelines on debugging techniques.

The code worked perfectly for me.

[ck4794]

Set fldAttach = rstChild.Fields(m_strFieldFileData)

here's the line throwing the "item is not in this collection" error

[June7]

Did you put the 3 Const declaration lines in the module header? Those 3 variables shown at the beginning of the code sample in article go in the header because they are refrenced by multiple procedures. If you don't want the other procedures, can put those declarations within the AddAttachment procedure.

[ck4794]

damn didn't even notice those were there haha. new error: fldAttach.LoadFromFile strFilePath "invalid argument"
it's only one line, but hey it's progress haha.

i know about some troubleshooting and debugging, but this subject matter is above my head. again, thank you june for all your time and patience.

[June7]

Well, I did make note of them in post 15.

Don't know what else I can do. The code works for me in Access 2010. Can't replicate the error.

Don't even know if I could run your db under 2010. Are there any 2013 features used? Want to provide it?