Search results

Hi, I don't know why you were getting compatibility errors after creating your lookup fields for your web tables in this database. I deleted your four existing fields identified above, and re-created four lookup fields with the same field names. They were perfectly fine and pass the...

Hi, Thanks for the unpublished copy; that's helpful. I took a quick look at your web database. Before we worry about the combo box controls on the web form, it seems to me like you need the base fields listed in your previous post to be Lookup fields. Is there some reason why you have the...

Hi, No one will be able to open and use your attached published web database because they don't have permissions to your SharePoint site where you published it. If you want people to look at your database, you'll have to create a backup unpublished copy and attach that instead. Perhaps some...

Hi, So you want this macro to run in the AfterUpdate event for the ControlCloseDate control on the form? See the attached screenshot of the macro design window which will do this. I think, however, this might be better in a data macro since this sounds like a data rule you want always...

Hi Jon, Great, thanks for adding this new forum. I would assume if people have questions about Access 2010 web databases (SharePoint lists backend) and/or Access 2013 web apps (SQL backend), this would be the best place to post them, correct? -------------------- Jeff Conrad - Access Junkie -...

Hi, From the looks of things, the issue is that you are needing to enable a navigation button which is on the navigation form itself and not on your login form. The login form is displayed within a subform control on the navigation form so using Me syntax is telling Access to find the...

Hi, Since you are trying to capture three different types of responses, I would change your macro logic to first capture their response from the MsgBox to a temporary variable and then test the value of the temporary variable in the If block. See my attached screenshot of example logic which...

Hi, CurrentWebUser() is a UI level expression/function and cannot be used in data macros. This is because of the separation from the data layer and UI layer. See my reply to your other post in this forum for more details on that. If someone built a tool that dynamically updated values in your...

You're welcome, glad we could help. Good luck with your project. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus SDET II - Access Test Team - Microsoft Corporation Author - Microsoft Access 2013 Inside Out (coming soon) Author - Microsoft Access 2010 Inside Out Co-author -...

Hi, Not directly because this goes against the fundamental nature of data macros in Access 2010 and Access 2013. Data macros are designed to attach to table events and are supposed to fire whenever data is inserted, updated, or deleted. They are supposed to fire no matter how that data is...

Hi, I assume you meant field names correct? Not field values? If so, I would not name a field Date as that is a reserved word in Access. It's better to use a field name like LoginDate. Have you published this web database to a SharePoint Server running Access Services yet? If not, the...

Hi, You actually have several options available to you. To start though I need you to back up first. I might have assumed incorrectly in my first assesment based on what you provided that this web database has already been published to a SharePoint server. You said this is a web database that...

Hi, Searchable is a calculated column in the query that serves as the record source for the form in question. If you open up that query you'll see a column called Searchable. That column uses an expression to concatenate the values of many fields in the underlying table. If you open that query...

Hi, That's nice to hear you have your problem solved. Glad we could help. Good luck with your project. If you don't mind me asking, what type of web database are you building/modifying here? What are you tracking in the database? How many users are using the web database (or plan to use)? Are...

Hi Sean, No trouble at all, glad I could help answer some questions about Access 2013 web apps. If you have additional questions, feel free to start a new thread and I'll try to answer them. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus SDET II - Access Test Team - Microsoft...

Hi Sean, Thanks for the information about your 2010 web database on Office 365. It sounds very interesting. Your approach of using a hybrid type of application using both client and web object within the database is very typical. I think that's one of the big strengths of utilizing Access 2010...

Hi, Ok, thanks for the information. My vote then would be to create an Access 2013 web app instead of a 2010 style web database because all of the data would be in SQL Server and you'll have extra features available at the data layer as opposed to using a 2010 style web database. Your IT...

Hi, The only way to change the enabled state of a navigation button in a web form is using the SetProperty action as you have done. However, based on your screenshots, it appears you are trying to change the state of a navigation button from within a subform which you cannot do. The...

Hi, You can use the SetProperty macro action to enable a navigation button. Enter the navigation button control name for the Control Name argument. Enter Enabled for the Property argument. Enter True for the Value argument. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus SDET II...

Hi Alex, Before we go any further, it's critical to find out from your IT collegues what exactly is your server setup. You'll need to ask them the following questions: 1. Are you using SharePoint 2010 or SharePoint 2013? 2. Do you have the appropriate licenses and is Access Services installed...