Stack Overflow
Stack Overflow

Questions tagged [ms-access-web-app]

Microsoft Access apps or "web apps" are database applications with a reduced set of features that can be designed and modified in Microsoft Access 2013 and be used in a standard web browser.

24 questions
4
votes
2 answers

How to use PHP's dblib PDO driver with long usernames? / SQLSTATE[HY000] Name too long for LOGINREC field (severity 2)

I'm trying to connect to a Microsoft SQL Server / Microsoft Azure database with PHP's PDO:
Hauke P.
  • 2,695
  • 1
  • 20
  • 43
2
votes
2 answers

MS Access: How to add 15 days to date (data type) in Access Web App

My question is simple, How do I add 15 days to a "Field with Data type (Date/Time)" in Access Web App. There is a Field called Revenue Plan which is a 'Date/Time' Data Type. and in Billing Due I selected data type 'Calculated' and typed formula…
Satish
  • 23
  • 7
1
vote
0 answers

How to capture a AppMonitoringChart static link in Access Web app?

For access web apps launched into a SharePoint site, clicking on "details" provides a page which has the following chart: When I check the source of that "image", The link looks like…
Amit Kohli
  • 2,860
  • 2
  • 24
  • 44
1
vote
1 answer

Can't install SQL Server Native Client 11 on Windows 10?

I need to install SQL Server Native Client 11 on my computer so I can access an Azure SQL Database (according to the instructions I am following) which is behind my Access Web App. But Native Client 11 will not install - I am getting the message…
Brad Mathews
  • 1,567
  • 2
  • 23
  • 45
1
vote
1 answer

Access 2013 Web App Filter Combo box value based on other field

I am modifying an Access 2013 web app. I have a combobox (lookup field with user entered list) in List form view. Now I need to filter values in this combobox based on other field. The other field is in the same table as text field. I need to filter…
Mike
  • 36
  • 8
1
vote
2 answers

Access Web App 2013 Subview - multiple child fields?

I'm not sure if there is a way to get this to work, but I've got my fingers crossed: I have a database which is keeping track of Inventory for a school district. Part of what is being tracked is the special (non image) software that is installed on…
SetsunaMH
  • 23
  • 7
1
vote
2 answers

Access Web App - How to update UI after changing data through data macro?

Let's assume I have an Access Web App with three tables: Group, Person and Task that would roughly look like this if using a normal Access client database: In this app, data macros are run whenever the Task table is changed. If for example a new…
Hauke P.
  • 2,695
  • 1
  • 20
  • 43
1
vote
1 answer

How to retrieve data from Access Web App running in Office 365 Sharepoint 2013

I have created an Access Web App that resides in an Office 365 Sharepoint 2013 site. This site is hosted by microsoft (user@domain.onmicrosoft.com). The Access Web App uses an in-house SQL Server database for the data source. The problem is that…
Dave.Gugg
  • 6,561
  • 3
  • 24
  • 43
1
vote
2 answers

How can I edit the CSS on an Access Custom Web App hosted on Sharepoint Online?

I want to hide the filter-box div on a List View in an Access 2013 Custom Web App, but do not know how I can get to the css files on the server. I can't seem to find them on Sharepoint Designer, and am wondering if they are within Azure? Could I…
Michael Blaustein
  • 901
  • 6
  • 24
1
vote
1 answer

Effecient way to migrate related tables from one Microsoft Access Web App to another?

I have two Microsoft Access 2013 Web Apps, hosted in SharePoint 2013 as part of Microsoft Office365. Both databases contain roughly the same tables and structure (with some minor tweaks). We have two databases because our particular SharePoint…
Giffyguy
  • 20,378
  • 34
  • 97
  • 168
0
votes
0 answers

making macros in ms access

There is a Store list forms which contains Open Date, Store Number. After the Open Date is updated, I want to open popups like below. And If I click yes, I want to update the target date which has the same store number as in the Store list. But I…
Scarlett
  • 173
  • 12
0
votes
1 answer

Use access 2013 macro to show all records in web database

I created a search box on an access 2013 web form to search records. Once I search/filter the record, I have a button to clear/show all records. I am having trouble using a web macro to show all the records. How do I remove the filter using a…
user7841010
0
votes
0 answers

Access Web App - Macro to populate field based on another field

I'm building my first Access Web App using Access 2016. I'm looking for guidance on how to populate two fields based on the value selected in another. Here's what I have. The source data…
Stacey
  • 1
0
votes
1 answer

Another user than me is displayed with pop up error message: "An error has occured." "Error: Invalid control reference

When I click on: "Macro detail" on that same pop up window another pop up window displays and says... Action Failed Macro Name: Home : Home Condition: True: [GlobalUserId] Is Null Action Name: null Arguments: null Error Number: 2055 Namely when I…
Hankman3000
  • 115
  • 10
0
votes
1 answer

Add Records to Access Web App from Excel via VBA

I have an Excel Macro which extracts data from another file, then reformats said data, and finally adds said data to an Access database file as new records. My script works perfectly with regards to a traditional desktop .accdb Access database file,…
margentieri
  • 31
  • 1
  • 1
  • 4
1
2