Home

Access

31 Conversations

Latest Activity

Custom List Message Item

I have a current Access Web App that I'm working to recreate in either Access desktop (with the file saved on SharePoint) or in PowerApps. I'm still not sure what is the best solution. However, I would like test the eexport feature of AWA. My question is,

... Read More
132 Views
4 Replies

I have the same question and am somewhat surprised to see that a presumably simple yes or no question is yet to be answered by a Microsoft rep..?

 

Despite having observed

... Read More

Today for the first time when I open anything from my main menu I cannot scroll down the page / screen.

I can page up and page down, I can use the arrows, but if I try to scroll or use the side bar the screen dosesnt follow

If I open tables from the navigat

... Read More
77 Views
0 Reply

How can I create a query in Access Web Services where to columns in on field. Like I have the 2 columns “Street” and “Number” and I like to show on column “Street Number”.

 

Thanks for your help

Stefan

 

 

Read More
42 Views
1 Reply
I need this because I can only show 4 columns on my view.

Users are experiencing errors when trying to enter data and run queries. Database has been running for months with no issues.

 

access_issue.png

Read More
57 Views
0 Reply

One of my teams is experiencing an issue where a particular form is not loading after a long wait period. The following screen is displayed. Not very helpful as I AM the app creator...

 

awa_fail.JPG

Read More
59 Views
0 Reply

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
49 Views
0 Reply

Hi all 

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

 

165 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
50 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
286 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
67 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
100 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
121 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
60 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
153 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
48 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
52 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
68 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
61 Views
0 Reply
How to convert 32 Database created with Access 2007 32 bit to Access 2016 64 bit? Manoj Kumar
2,516 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
251 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
142 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,082 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
1,006 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
477 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