Some advice needed please about Access transfer to a new computer

[Welshgasman]

Well she will not be doing anything she was not doing before?
We are not introducing any security issues, but both trust center and macros must be set for the code to run.

[June7]

I run my database on a couple of laptops. Don't think I've ever modified Trusted Locations. Here is image showing setting:


I simply Enable All Macros.

I had no problem downloading your db and opening.

[Welshgasman]

I put all DBs I download into a temp folder \temp\DB, so I needed to add that when I started doing that.
As I placed that DB inside that folder as the zip file had it's own folder, it ran without any issues.

No harm in the O/P trying just macros first?

[davegri]

Email works fine, including the pdf attachments, on my computer: (I didn't complete the send action to confuse poor limpiezaslanzabrit@gmail.com).
Do you have a working email client on the target laptop?
Is email working on that laptop? Will it send email manually?

[davegri]

TJ's Shortcuts. I don't know why this has not been included in the DB copy process. It's not too hard to recreate it in the target DB. Here's a response for instructions from CoPilot. I've edited it for your particular case, and edited out some of CoPilot's zany/confusing/incomplete suggestions. I've included an image to show areas of interest in the Custom Ribbon Interface.
Oh, and this is just a guess as to what TJ's Shortcuts are!

Certainly! When you right-click on a top tab like “HELP” in the Access ribbon and select “Customize Ribbon” from the context menu, you can proceed with the following steps to customize your ribbon:
Access the Customize Ribbon Interface:
After selecting “Customize Ribbon,” the Access Options dialog box will open, displaying the Customize Ribbon category.
Choose Tabs to Customize: Main Tabs
Click New Tab:
To add a new main tab, click the New Tab button below the list of main tabs.
A new tab, along with a new group within that tab, will be created.
Rename the New Tab and Group:
Right-click the new tab or group to rename it. Choose “Rename” and enter the desired name for your tab or group. ("TJs Shortcuts" for tab and "Run Macro" for group)
Add or Remove Commands:
On the left side, you’ll find a dropdown named Choose Commands From. In the dropdown,
choose Macros.
Select a macro name and use the Add or Remove buttons to place it in your custom group or remove it from an existing group. One macro at a time.
Organize Commands Within Groups:
Click the up or down arrows to arrange sequence of the macro list.
Save Your Customizations:
Once you’re satisfied with your customizations, click OK to save and apply the changes to your ribbon.



This type of customization is seldom used because it will include the custom ribbon on EVERY database file on your computer, both old and new.
Then if you try and use the menu items in another DB, it will error because the macros are not present. Why on earth would they be? They wouldn't necessarily apply to every database.
I've found no way to restrict it to the current database only, but then again, I've seldom found it necessary to customize the ribbon in this way.

And here's the result:

[tbjmobile@gmail.com]

Hello again and thanks again WGM. Laura would not do anything to the database, she's too frightened of breaking it ! Here are my current settings. Should I have used a differerent location that I'd made and then placed Access there rather than the other way around?

[tbjmobile@gmail.com]

Hi again and thanks again, Laura wouldn't do anything different without asking me, she's very aware of how things can be broken !

[Welshgasman]

So it is now working?

[tbjmobile@gmail.com]

Thanks, davegri, thanks for not confusing LanzaBrit ! What you've screenshot is exactly what should happen and yes I do have an email client on this machine. I have no idea either why these items don't work on a copy db on another computer OR on Laura's subscription Office, when all the data is there and all the filters rpts, frms etc. do work.

Thanks also for that excellent descrption of what to do, I'm sure I'll be o.k. with that shortcut process. It is only so she can bring up the MainScreen, regardless of what she's already using and I'm sure you're correct there would be other ways to achieve the same thing. Does F11 bring up the Nav pane for you?

[tbjmobile@gmail.com]

Thanks, June7. I think that's exactly what I've got now.
I've posted about a dozen screenshots of what I've got. Whatever I did, I had to close out of the forum, not realising that it had accepted the images before it froze on me !!!

[tbjmobile@gmail.com]

No, the only difference that anything has made is putting the Pdfs folder in the C:\ drive as davegri suggested, I had forgotten that. Now at least the 'All Accnt Reports' creates all the client's accounts as pdfs and stores them in that folder. Then it errors 'There was an error sending the reports! Contact your administrator.'

The emails to LanzaBrit that davegri sent the screenshot of, is correct on his machine, I have just tried mine again and I get the error 'The command or action 'SendObject' isn't available now (macro name Eml:OnClick:Embedded Macro).'

It looks to me as if the SendObject, TJs shortcuts and the F11 for Nav pane just haven't copied accross with all the rest of Access, why is of course still a mystery. BUT, when I was there yesterday I made another copy because I had seen a YouTube video on how to do it 'properly' and it's exactly the same.

BTW, what's an O/P ?

[Micron]

Original Post, or Original Poster as the case may be.

[davegri]

I think the op is using gmail, and that needs to be the default email app on the new laptop. I don't use gmail, I have Thunderbird. Can one of you responders that use gmail take a look at your settings to advise the OP?
Can the OP verify his email client for us?
As an example, here's my Thunderbird settings:

[Welshgasman]

I use Outlook and I now use an app generated pw for gmail as Outlook is not 2 step verification.
Just where is the email option? I need step by step instructions if I am to try and test it, sorry.

[tbjmobile@gmail.com]

I expect that if davegri's system opened the Thunderbird client without problem, themn Access may just choose what is avaialble. I was using Mailspring, but I just shut that down and opened New Outlook but it didn't change anything !