Change the order of the Manage Import tasks window

[isladogs]

I'm not sure why but every notification email from your posts includes a long section of raw text indicating you have attempted to paste an image into your answer. That doesn't work for this forum
So I don't know whether I've seen all the screenshots you meant to include

As already stated I've tested my app more than one in Access 2007 and don't get the 31602 error with the correct reference added. As I'm unable to replicate it, I can't fix it
I can fix the error 2164 that occurs in A2007 only. But there's no point unless the other issue is solvable

Can I check. Do you get error 31602 with my example database or just when you import items into your own database?

Are you able to upload a cut down version of your database with just the items need to text this and all confidential data either removed or altered.


If so, please do that, compact & zip then upload to here - click the Go Advanced button and follow the instructions.
Or you can zip & email it to me using the link in my signature line

[Welshgasman]

Whilst this site allows you to paste an image into a thread, it is not saved. You need to use the Attach button.
Even then, you might not be able to upload a file.

I can no longer do it here using Chrome, and have to use Firefox, if I need to upload a file of any description be it pic or db.

See https://www.accessforums.net/showthread.php?t=70301

[chiefweigum]

I have been pasting images in here so I guess I won't do that again.

I did try renaming one of your tasks in your database with your form and I did get the 31602 error.

I can mock up a smaller database and send it to you and I will do that in the next day or so, although if you don't get the 31602 error with yours then you probably will not get it with a DB I send you. Worth a try though.

Thanks again

[isladogs]

I agree. Definitely worth a try.
When you do email it to me, include a few of the missing screenshots!

[CJ_London]

Whilst this site allows you to paste an image into a thread, it is not saved. You need to use the Attach button.

I use the insert image button


then select the from computer tab>choose file


if you've used the snipping tool, it should be on the clipboard on the left




Finally click upload file

[Welshgasman]

That actually works in Chrome as well.
Thank you CJ_London.

I had been using the attachments button, which up until a few weeks ago, still worked, but now after selecting the file, it does not.
Your method works for me as well.

[CJ_London]

nice thing is, you don't need to save the image to a file first

[Welshgasman]

nice thing is, you don't need to save the image to a file first

Ooh, I did not notice that.

That is because I only get File Explorer?
However, now I do not need to use Firefox.

[CJ_London]

I use Opera as my main browser

[isladogs]

Received your email and have just sent this reply:

You sent the database but not the 5 spreadsheets so I can’t test it on your files.
Please forward the spreadsheets as well

Also why are you using an A2003 MDB file instead of an ACCDB file?
That MAY well make a difference.
Indeed when I tried converting my original ACCDB file to A2003 MDB format, I got this error



--------------------------------------------------------
@CJ_London
Using the Insert Image only works for me if I save to a file first.
Quicker than going through the Advanced menu but I still can't paste an image from the clipboard using that method

[isladogs]

Thanks for the files. Tested & replied by email.