Some advice needed please about Access transfer to a new computer

[davegri]

Here's how to find default settings for email:

[Welshgasman]

Dave,
I know how to find default settings.
I meant sending an email from the DB, to see if that worked for me in my environment.

[davegri]

Dave,
I know how to find default settings.
I meant sending an email from the DB, to see if that worked for me in my environment.

Of course. Post was to prompt anyone using gmail or any client other than Thunderbird.

[davegri]

Dave,
I know how to find default settings.
I meant sending an email from the DB, to see if that worked for me in my environment.

Reviewing things, I see now what you meant by Step-by-Step.
On the main screen, top row right, click on Cambios button.
That should bring up rptCambios with an Email button.

[tbjmobile@gmail.com]

Hi again, WGM. Unless I've missed something, I sent the answer about sending an email a couple of days ago, also take a look at the images and the VBA text doc..
For now though, get to the Main Screen and choose e.g. Cambios (all but the blue button on the top line should give the same results for our purposes). Once you've opened it you will see a button that says 'Email', press that and Access should create an email ready to send and you just need to press Send - don't do that though because it will confuse the recipients. IF you get what davegri got which is how it should be, then - caramba ! That means that the embedded macro that I sent an image of has found the SendObject. Otherwise, like me you will get an error about the SendObject not being available, I have also sent a screenshot of this.
Laura's working machine has Mailbird and mine has Mailspring and I have tried New Outlook, I would have thought that if it will work, it will work with Outlook but I think Access will use whatever email client in installed on the host computer.
I am convinced that the Access that I downloaded from my Microsoft account OR something else, has caused the machine not to have downloaded the SendObject. You may remember that earlier on in the thread I said that M/S gave me 4 options to download from, I downloaded the 'Access 2016 32bit' but maybe I should have gone for 'Default', I don't know. Anyway, now you know exactly what you're looking for.
The button under the Account heading is a different matter, it isn't an embedded macro, it's VBA which I also just sent a screenshot of. It loops through all the accounts (about 35 of them and sends them one at a time. It first stores the pdfs in a folder in C:\pdfs which it needs to work as Micrron reminded me. It does this on my machine but when it would start to actually send the emails I again get a SendObject error.

[Welshgasman]

I can confirm that the email was created with my default email account.
In the account option I created 23 emails.

I do not know what that 'sit back and relax' is for, as I had to press send 23 times and as my spell checker was kicking in, another 46 mouse clicks.

I would uninstall Office, or try a repair if you are given that option.
If you have to reinstall, install as 32bit.

[tbjmobile@gmail.com]

Sit back and relax is because it should send them all on its own. Sorry about the spelling mistakes WGM but thanks for trying and sending the results, much appreciated. That aside, it's very interesting that yours and davegri's function properly, however it is a step forward, so am I correct in thinking that the db is working properly as we all three have the same, but my freshly downloaded Access 2016 is corrupt at worse, or missing things at best? Did you read my post about the 4 options offered by Microsoft to download, if not my question was do you think 'default' might be better than the 32 bit that I downloaded. I suppose you did and that is why you say 'If you have to reinstall, install as 32bit.'. I don't have Office, just Access 2016 but I don't think that matters. The image is what I'm offered, I downloaded the 32 bit last time, I know thw 64 bit is no good, and I suppose 'Offline Installer' will just be the .exe file ? So is it the 32 bit one again please ?

[Welshgasman]

Well not knowing what the default is (but I am led to believe it is 64 bit from other posts), I would select 32bit TBH.
You could even try the runtime on it? Not something I have ever had to use, but we are just testing here.

Did you post your references here at any time?

[tbjmobile@gmail.com]

Thanks, I'll try uninstall of what I have and get 32 Bit. References? Sorry never heard of that with respect to the forum but the memory isn't what it was.

[Welshgasman]

Go into the VBA window (Alt+F11) and then select Tools/References.
Make sure none are showing as missing.

BTW the spelling issue was just the text in the email which an English version will not recognise.
TBH I am not sure you need to create the PDF files, as you are sending the report as pdf in the next line?

See if MS supply some sort of program that removes all mention of Office before installing again.

[tbjmobile@gmail.com]

I did that with the vba, the only things ticked are the first 5 lines, i.e. Visual basic for applications, Microsoft Access 16.0 Object Library, OLE automation, Microsoft office 16 Access database engine Object Library, Microsoft ActiveX data Objects 6.1 Library.
After that about 200 unticked lines.

[tbjmobile@gmail.com]

Hello again,
I looked through all of the vba list as WGM suggested and I couldn't find anything that looked like DOCMD.SendObject and only the first 5 lines were ticked. I can't download another version of Access, until 90 days has passed. I Googled "Access says SendObject isn't available" but I got bogged down with it offering different code and I always come back to the fact that it STILL works (for the moment) on Laura's machine and if it ain't broken, don't try to fix it right? So I think it's the end of the road and I have to buy a new version of Access, should I stick to Access 2016 or get 2019 do you think? Of course I will have to buy a new laptop to put it on first, and then hope that it works as it does with you guys..
I thank all of you that tried to help.

[Welshgasman]

I think we have established that the DB is working fine? It works on mine and Davegri's computers?

[tbjmobile@gmail.com]

I think we have established that the DB is working fine? It works on mine and Davegri's computers?

I agree, it just has to be something between making a backup on Laura's computer and opening that on my Access on a different machine. Maybe deliberate by Microsoft to stop people doing just that. I hope a newly purchased Access 2016 will be kinder to us !

[Welshgasman]

Well that would not be the case, else we would not be able to open it?
Are we working on that actual backup or another file?