Search results

Hi, This expression should work fine for you in your Access web app context; it worked OK in my test to return the records in the current quarter. Just put this expression in the Criteria line under the DateAdded field in your query: Year([DateAdded])=Year(Now()) And...

Hi CJ, The poster is using an Access 2013 web app which is much different than Access desktop databases. Continuous forms do not exist in Access 2013 web apps. In that environment you only have four view types - List, Datasheet, Blank, and Summary. The poster is using a datasheet view in their...

Hi, Since you posted your question into the Access web forum and your screenshot confirms that you are using an Access 2013 web app, the other suggestions offered by the other responders will not work at all. Access 2013 web apps are much different than Access desktop databases. The short...

Hi, Thanks for the extra screenshots, that was very helpful. I think I see the problem now. The issue is this SetLocalVar action inside the LookUpRecord action: SetLocalVar Name varTargetDate Expression =[Tasks].[Target Completion Date] The reason for the error here is that you...

Hi, Could you perhaps post a screenshot of the macro window showing what you have currently that is not working? Or perhaps writing out exactly the logic you have tried in the other table events. That would help us figure out what the potential resolution is. Thanks, --------------------...

You're welcome. Glad I could help answer your question. Good luck with your continued progress on your Access web app projects. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus Senior Content Developer - Modern Assistance and Support Experience - Microsoft Corporation Author -...

Hi, First, let me address the other people commenting on the thread for their own information and learning. The person posting the question is using an Access 2013 web app which is why they posted their question in the Access web forum. Access 2013 web apps are much different than Access...

Hi, Thanks for the nice comments on my book. I hope you have found it useful in your study of Access 2013 web apps and desktop applications. Good luck with your continued studies and your web app projects. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus Senior Content Developer...

You're very welcome, glad I could help with your question. Good luck with your Access web app project. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus Senior Content Developer - Modern Assistance and Support Experience - Microsoft Corporation Author - Microsoft Access 2013...

Hi, I don't think it is possible to set default values for controls dynamically on views within Access 2013 web apps. You can set the value with macros, but not default values for new records only. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus Senior Content Developer - Modern...

Hi, The short answer to your question is no, it is not possible to use RequeryRecords macro action in the On Load event of a summay view in an Access 2013 web app. Now let me explain why. Imagine in a list or blank view you use the RequeryRecords macro action to requery the records and return...

Hi Mandeep, I'm pleased to hear you worked through the issue. If the view you are trying to open using OpenPopup macro action has a query as it's record source, then you must use the query name like this: [FieldNameHere]=[NameOfQueryHere].[FieldNameInThatQuery] If you are using a table name...

Hi, This is just a educated guess at the moment, but you mentioned your table names are Tasks (with an s at the end) and Employee. Your UI macro shows that you are using Task (no s) in the Where clause. Is that the issue here? If your table name is indeed Tasks, you need to use Tasks in the...

Hi, Are the email addresses you are trying to send to outside the existing Office 365 organization? Essentially, have those email addresses been invited as users in the SharePoint site? With the new Send Email data macro in Access 2013 web apps, the email addresses used must be within the same...

Hi, For the benefit of others reading this thread, I should point out that the person who posted the question is using an Access web app. In Access web apps, you cannot switch to SQL view for queries as you can with desktop applications. So there is not a way for the person to post the SQL of...

Hi Richard, There is a distinct difference between macro actions available at the UI layer and at the data layer. The reason for this is that actions performed in the data macro context need to be able to execute without any knowledge of the UI layer. Let me give you an example. Data macros in...

Hi, You should be able to set fields in records being "looked up" through the Look Up Record data action. You just have to remember that in order to use a Set Field action, it has to be wrapped inside an EditRecord data block first. Is this not working for you? -------------------- Jeff...

Hi, The following link I posted previously gives a real nice walk-through on how to take an Access desktop application and link it up to the tables in an Access 2013 web app (the tables are actually SQL tables behind the scenes). Here it is again...

Hi, In order to make this work, you need to make the following changes: 1. The second combo box must use a saved query object as it data source and that query must reference the first (parent) combo box control in the Criteria line. 2. You must adjust the data sources and column widths of both...

Hi, Unfortunately, yes you have to check field by field because there is no way currently in the data macro logic with Access web apps to generically test which fields were updated. My suggestion then would be to simply record the old and new values for all fields in the AfterUpdate event...