<div>
Have you put the file in one of the Trusted Locations to have VBA enabled ?
</div>


Have you put the file in one of the Trusted Locations to have VBA enabled ?

IT Technical

HKFuey

<div>
You can also use the utility from here : <a href="https://www.accessribbon.de/en/?Trust_Center:Trusted_Locations" rel="ugc">https://www.accessribbon.de/en/?Trust_Center:Trusted_Locations</a><br />
to set the Trusted Locations
</div>


You can also use the utility from here : https://www.accessribbon.de/en/?Trust_Center:Trusted_Locations [https://www.accessribbon.de/en/?Trust_Center:Trusted_Locations]
to set the Trusted Locations

<div>
I would guess there was some error in your function/sub &quot;CheckAndOpen&quot;. are you able to debug the codes or show out the error description?
</div>


I would guess there was some error in your function/sub "CheckAndOpen". are you able to debug the codes or show out the error description?

Volunteer

Jim Dettman (EE MVE)

<div>
What does the macro look like?
</div>


<div>
<div class="content wysiwyg-content">
Access runtime error 3270<br />
<br />
Trying to open Access from another App with parameters.<br />
<br />
This normally works:<br />
&quot;C:\Program Files\DBName\MyDb.accde&quot; /CMD S%key<br />
<br />
It sends a parameter to the DB and the DB opens with a query on that parameter. On one client I'm getting a box &quot;Macro Single Step&quot; (See<a href="https://filedb.experts-exchange.com/incoming/2020/01_w02/1440333/Capture.JPG" target="_blank" title="Screenshot (24 KB)"><img alt="Screenshot" class="file-block lazyload" style="max-width: 473px;" data-src="https://filedb.experts-exchange.com/incoming/2020/01_w02/1440333/Capture.JPG" /></a> Pic)<br />
<br />
PC is Win 10, it has Office 365 installed, I'm running Access from runtime version 2013.<br />
<br />
Anyone know how to fix this?
</div>
</div>


Capture.JPG

Access runtime error 3270

Trying to open Access from another App with parameters.

This normally works:
"C:\Program Files\DBName\MyDb.accde" /CMD S%key

It sends a parameter to the DB and the DB opens with a query on that parameter. On one client I'm getting a box "Macro Single Step" (See Pic)

PC is Win 10, it has Office 365 installed, I'm running Access from runtime version 2013.

Anyone know how to fix this?

Access runtime error 3270 on AutoExec macro

Office 365 is a group of software plus services subscriptions that provides productivity software and related services to its subscribers. Office 365 allows the use of Microsoft Office apps on Windows and OS X, provides storage space on Microsoft's cloud storage service OneDrive, and grants 60 Skype minutes per month. Office 365 includes e-mail and social networking services through hosted versions of Exchange Server, Skype for Business Server, SharePoint and Office Online, integration with Yammer, as well as access to the Office software. All of Office 365's components can be managed and configured through an online portal; users can be added manually, imported from a CSV file, or Office 365 can be set up for single sign-on with a local Active Directory using Active Directory Federation Services.

Microsoft 365

Access Macro

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.