Home

Access

26 Conversations

Latest Activity

Custom List Message Item

The windows API call AllocConsole no longer seems to work in VBA Access 2016 on Windows 10.

 

It functions correctly on Windows 7 with Access 2016 and I've been googling for the past few days tring to find an answer. The code is a follows...

 

Private Declare

... Read More
13 Views
0 Reply

Hi all 

when i trying to upgrade from Access 2010 to 365 the buttons of my equations not return any value ??

 

147 Views
5 Replies
Thank you
rat huu ich
my last update is Access 2000
Did you make sure to enable or set a trusted location?

Navigation Pane Hidden.pngFor some odd reason, when I drag to re-scale the Navigation Pane in Microsoft Access 2016, the pane becomes minuscule and I am unable to view anything. It makes sense to be able to hide the Navigation Pane by clicking the arrow to hide/show the pane (and

... Read More
31 Views
0 Reply

Hi.

 

From an AWB App, online, if you click the gear botton (top right) , there is a new command "Export to SharePoint Lists"

 AWA 1.png

 

 

this creates a subside with the name as in App name, creates tables with relashionships as in AWA App, and copies (i think copies

... Read More
229 Views
5 Replies

I already tried what happens when you choose to run that function:

It created a subsite and exported all the data into lists.

Thats it.

If you had a rich AWA where you put a

... Read More

As it looks like Access Web Apps support is not enough for many use cases: You can keep your Access Web App tables or views (based on SQL Azure) connected and in sync (on

... Read More
I did this now my access web app database is stuck in read only mode. Has anyone else had this problem?

Yes, yes, I know AWA is going away--but until I'm able to develop a PowerApp, I'm stuck using this for the next 12 months.

 

With that said, I'm trying to find a way to count the total number of records and the total number of records with a checkbox checke

... Read More
52 Views
0 Reply

Join NetCom Learning for a complimentary interactive webinar on "A Brief on MS-Access 2016 and its Integration".

 

MS-Access is not a topic of fearing from. This webinar will throw the light on the usage and working of this office tool and its integration w

... Read More
83 Views
0 Reply

Since transferring my Office Home & Student 2013 to a new laptop, the excel file when clicked to open, does not open. Instead only Excel program opens. Then I have go through File -> Open , then either Recent Workbook or Computer -> Documents.

 

Kindly help

... Read More
103 Views
1 Reply
This is a group for answering Microsoft Access (the database) questions. It would seem this question should be in the Excel group or Office group. But maybe someone here ... Read More

Hello,

 

This afternoon I went to submit feedback, but noticed that there is an extra 'Feedback' button that does not start any action:

 

feedbackfeedback.PNG

 

Read More
51 Views
0 Reply
[This is an excellent 33-page paper on the subject.]
 
The purpose of this white paper is to demonstrate that Microsoft PowerApps is an alternative tool to Access web apps and worthy of consideration for an Access power user and developer.
 
Ben Clothier, And
... Read More
109 Views
0 Reply

I'm having a terrible time figuring this out.  Im trying to call Excel's function.ets function from an ms-access module.  I can call other functions without a problem.  I've got the arrays filled up and I've tried it a million ways, always with the same a

... Read More
37 Views
0 Reply

You don't have to change anything. Just run an additional Windows Service to connect your local Access database queries to native SharePoint lists (and other data sources) and keep it sync two-way in background. You can also notify Office Groups or Micros

... Read More
40 Views
0 Reply

There is a situation where I am trying to find a count of how many unique values are associated with an item on a related table. How can I find this?

 

Here's the scenario

 

Business Opportunities

1 ACME Widgets

 

Quotes Generated

1 Quote 1 for ACME Widgets by Pa

... Read More
60 Views
0 Reply
thanks for sharing the links
Step by step guides. Use your Office 365 credentials to sign in https://dpsupportweb20160618054131.azurewebsites.net/QuickReferenceGuides Read More

Thanks for sharing Luc! 

Hello Folks,

 

Microsoft Acess with the integration that ir provides with SharePOint can be used to provide quite a lot of solutions to business problems.

I have used this in the past to SYNC 2 sharepoint lists and to generate reports.

I was wondering if ther

... Read More
48 Views
0 Reply
How to convert 32 Database created with Access 2007 32 bit to Access 2016 64 bit? Manoj Kumar
858 Views
3 Replies
hi,

First, let me make clear what I'm saying.  Usually an ACCDE is created to protect the design of forms, reports, and VBA codein a database application.  The ACCDE may o

... Read More

Access Web Apps has been introduced in 2013 and we are nearly 4 years later without further developments, I only can count one or 2, and anyhow they are 2 years old.

 

Microsoft Access (Desktop) has been preferred for small businesses since ages and the Acc

... Read More
239 Views
0 Reply

Learn how to create an Access 2013 database in just minutes by using a template. Access gives you templates that run on your computer or in the cloud.

 

Watch here

  

Read More
130 Views
0 Reply

As businesses of all sizes come to realize the value of data analytics to inform decision-making, many are also discovering the need for database solutions like Microsoft Access to help collect, organize and share data, as well as create reports that deli

... Read More
1,035 Views
0 Reply

I want to read the username of the current logged in Office account in MS Access 2016 with VBA  (not Windows or network username). The logged in user appears indeed in the Office2016 applications respectively in the title bar at the top right. Environ (),

... Read More
773 Views
7 Replies

I use the System.DirectoryServices.AccountManagement object to get user information on my apps.

 

In VB (I don't use VBA but very simliar syntax) the UserContext object giv

... Read More

Good question ... could be helpfull in an application ...

Unfortunately I have not solution for this yet ... :-( ... I'll keep on searching ...

Hi - There are times at our institution where we may need to get snapshot of users files for legal reasons.  I can export the content of OD4B using Sharegate, but it doesn't export content stored in an Access Web App.  When I connect to the web database u

... Read More
425 Views
5 Replies

I created a step by step instruction for you to connect to your database using SQL Server management studio as Frank suggested.

 

You can also find these instructions (and

... Read More
Best Response

Greg,

 

content of an Access Web App is stored in a SQL Azure database. You can use SQL Server DBA tools to connect and create snapshots. You can also sync SQL Azure conten

... Read More

Hi there Access Network!  I have a client that is wanting to know if they can keep Access 2010 installed on their current machines and to install Office Pro Plus (to include Access 2016). Access 2010 is 32-bit and they want to install Access 2016 64-bit a

... Read More
245 Views
1 Reply
Hi there Dwayne,

As far as I know newer and older versions of office can run side by side but only if the newer version is running in the "Click2Run" format and the older ... Read More

One of the leading requests in UserVoice was to see renewed support for dBASE (.dbf), and quite a few of you—particularly those in the Geographic Information System (GIS) community—made a compelling case to do so.

 

Today, the Access Team is re-introducin

... Read More
341 Views
0 Reply

“Send Email” is available to all of our customers using Office 365 with Access Services. Now you can send emails from your Access 2013 web apps to other members of your organization! Look for this feature in your web apps soon and try it out.

 

In order t

... Read More
102 Views
0 Reply

For any ideas of Access use the website https://access.uservoice.com/

"We love hearing from our customers. To help us continue our investment in Access , we have partnered with UserVoice, a third-party service, to create this site to hear your ideas and su

... Read More
100 Views
0 Reply