Search results

Hi, Yes, the scenario you describe of capturing changes to just specific fields is entirely possible using data macro logic in Access 2013 web apps. By using the Update function you can determine if that specific field was updated during the table's On Update event and write the old and new...

Hi William, Excellent, I'm pleased to hear the macro logic I provided fits your specific need. Be sure to study the macro logic to understand what I did so you can apply similar techniques in other scenarios for your Access web apps. Feel free to post additional questions about Access web apps...

Hi William, Thanks for the screenshots, that is very helpful. Follow these steps: 1. Close all open objects 2. Open the Quote Requests table in Design view 3. Click the On Update Ribbon button to open this event 4. Delete everything you have in there already. All of it; all the logic you...

Hi William, Could you attach the following to a new post here: 1. A screenshot of the Quote Requests table in design view (so I can see the field names and data types). 2. A screenshot of your audit trail in design view as well (so I can see the field names here too) Attach a screenshot of...

Hi William, Ok, glad you're making progress. We need to add one more field to the audit trail table which will be a lookup field to the ID value of the first table. We will use this to relate all changes made back to its original record. So if your first table has ID as the primary key...

Hi William, Thank you for the additional information, that was just what I needed. Your scenario is exactly something I needed to implement just recently in a web app I created for use by the Windows division. I'll walk you through the steps you should take to implement this using a generic...

Hi William, Sure, I can help you with us. Before we get started, can you describe a little bit more about your scenario? Explain the scenario without control names. The reason I ask is that depending on your scenario this might be something you should do at the data layer using data macros or...

Hi William, Thanks for trying out our Access 2013 web apps. Were you able to find a solution to your issue? In general, yes you can record all data changes made to the tables if you'd like in an Access web app using data macros. You could, for example, catalog all of those changes to an audit...

Hi Khalid, Yes, you can use a bar code scanner to easily enter bar code numbers into your web app view controls. On our team blog, you can see a blog post of an Access web app we created for McKinstry to track their tools. In the video that accompanies the blog post, you can see an example...

Hi Jane, Apologies for not getting back to you sooner (been very busy with work recently getting ready for the SharePoint Conference). It sounds like you've already come up with a solution to your issue, correct? Depending upon exactly your goal here, there are a few different possibilities...

Hi Jane, it looks like you've already solved your issue but just to confirm, yes you need to install that SQL Server 2012 Native Client driver on your machine in order to use the Create Reports functionality. Access uses that driver to make the connections to the SQL Azure tables for your...

Hi Grant, There have been good posts on this topic in the UtterAccess forum so rather than repeat everything here in this post, I'll provide some links to the topic which should get you going. The first link I would look at though is this recent blog post by one of our Access MVPs. It has a...

Hi Grant, Ok, thanks for the clarification. One last note - Access 2013 can be used to create/edit both 2010 style web databases and 2013 style web apps. That's why I wanted to be sure what you were trying to do. I believe you are right on the correct path with a hybrid approach. When creating...

Hi Grant, I think there is some confusion here. When you create an Access 2013 web app, the data is all stored within a SQL database - *not* in SharePoint lists. If you are using Office 365, the data is stored within a SQL Azure database. If you are using an on-premise server, the data is...

Hi Jane, In order to fulfill your scenario of allowing the user to provide a value on a view in the web browser and then see records confined to that criteria, you need to do the following (in general terms here): - Create a parameterized query that includes the fields you want. You must also...

Hi Jane, Let's tackle the DateDiff question first. Your syntax for that expression is correct if you were using a desktop database within Access, but since you are using an Access web app, the expression syntax will be a little bit different. To achieve your goal, I believe your syntax needs...

Hi Jane, Looks like you beat me to it on a reply. Yes, you can add extra tabs to the related items control to display data from other related tables. A quick note. If you had not previously modified that list view in any way, Access would have automatically added the extra tab for you after...

Hi Jane, Apologies myself as well for the delay in checking back. I'm pleased to hear you've made progress on adding more elements to your app. Let me first get back to some of the earlier elements. 1. I think it might be good to change the Total Cost field in the Orders table to be a...

Hi everyone, Thanks for the additional information on the issues you are facing here and the expanded repro steps. With the additional information I can also repro the issue on my test machines now. In the backspace scenario that is indeed very odd. It's almost like a magic eraser - removes...

Hi, I'm trying to repro the issue you are seeing on my own test machines. I've tried your steps on Access 2010 with an MDB file on Windows 7 and I'm still able to edit the text in this scenario. Can you provide some more detail on what issues you are encountering here? If there is a bug here...