An error number : 424 problem

  • Thread starter Thread starter ericb
  • Start date Start date
E

ericb

I'm having trouble with an attachment field.

On a report I can see the picture and the filename of the selected attachent
properly.

Now in a SQL UPDATE string that i'm making I always get the error 424 Object
required.

Here is the line where it happens :

'mySQL = mySQL + ", scan_g = " & prn_du_pied_g.FileName

scan_g is a Text field
prn_du_pied_g is an attachment

All I want to do is to use the filename of the attchment.

How do I solve this

Thank you for the help
 
ericb said:
I'm having trouble with an attachment field.

On a report I can see the picture and the filename of the selected
attachent
properly.

Now in a SQL UPDATE string that i'm making I always get the error 424
Object
required.

Here is the line where it happens :

'mySQL = mySQL + ", scan_g = " & prn_du_pied_g.FileName

scan_g is a Text field
prn_du_pied_g is an attachment

All I want to do is to use the filename of the attchment.

How do I solve this

Thank you for the help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compile error 424 4
Run time error 424 0
Changing the default theme 1
Runtime error 424 in Windows 8 environment 15
Access for MySQL data reports only 5
A string problem 6
Error number: 3326 1
Run Time Error 424 2

Back
Top