Recent content by Lucas79

Hi there, I have almost the same problem, only my counter shows 57 records and only 50 are showing. Other views are working just fine. If anyone has a solution, would be much appreciated. Thanks in advance, Lucas

Hello, I have build an Access Web App within Office 365 for documenting our customers system configuration (Servers, Storage, ISP, etc). Within SharePoint I have a couple lists with information I want to use in my Access Web App as a source like: - Customers (400ish) - Employees (45) Instead...

Dear Paul, Thank you for your help! My own small update got me thinking in the right direction and I have fixed it. It was a bit more complex then I first thought, but when looking back is actually quite logical. (as always :) ) The solution is to create a DataMacro to get the values from the...

Small update: This problem seems to occur only when the Combobox (or AutoLookUp) is bound to a different table then where the form is based on. If I use a MessageBox to display the value of a ComboBox with a number of fixed values in it, the original code works and returns the value, instead of...

Hi Paul, Thanks again for your fast reply. Yes it is a Macro the runs when the focus from the form changes to another record. I had already tried without 'me' and got the same error. To make it a bit easier, I put a text label on my form and change the caption after updating the ComboBox...

Dear Paul, Thank you for your quick reply. Sadly it didn't work. It gives an error, something like "invalid use of control" (can't be more specific, cause my error messages are in Dutch. :( ) There is quite a difference it seems in working with controls on forms with O365 Access Web app as...

Using the value from a Combo Box or Auto Complete field in Access Web App. Hi All, I'm using the Office 365 Access Web App to create a nice documentation system. Mostly I have it running the way I want, but I'm banging my head on something very simple, I just don't see it. :banghead: On my...

Never mind, the solution, as most of the times, was very easy. It appears you can just drag the needed control form other related tables. In my case the Checkbox. It is 'greyed out' in the Web App so you can't edit it on the form where you dragged it too, but in this case all I need is to check...

Hi Ranman256, Thank you for your quick reply. Your solution looks logical, but doesn't seem to work in Access Web App on Office 365, or I'm doing something wrong. When I use the "!" after 'forms' Access gives the following error: "The expression you entered uses a function that is not valid...

Hi All, I'm using Access Web App within Office 365 and I'm trying to check if a checkbox is selected when a specific customer is selected on a form. Here's my situation: Table1: Basic customer info, including a checkbox if the customer is 'blocked' or not. Table2: Different locations for...

Hi Jdraw, You are the greatest! That was exactly what I was looking for. The reason I couldn't find it in Access was that it only works on a combobox, not a search field. In my case a combobox works just as fine as a searchfield. I don't know how I could have missed that one. Guess I didn't use...

Dear jdraw, Thank you for replying. I had seen a similar instruction on how to use cascading comboboxes, but these were a bit clearer and I do understand them a bit better now. Unfortunately, it didn’t bring me closer to my goal, because Access Web App in Office 365 doesn’t seem to support...

Hi All, I'm making an Access Web App in Office 365, which will be used to store technical documentation about our customers. My challenge is that I want to use data from multiple databases to narrow down a lookup field. For example: I have a table with Customer information. (CustomerName...

Hi Everyone, My name is Lucas and I’m from the Netherlands. I’m not a complete newbie to Access, but definitely not an expert. I have quite some experience in Excel en VBA, but we are moving to Office 365 and want to start making use of the features of Office 365 SharePoint and Access 2013 Web...