Search results

Hi Guus2005, You're correct that my 'Access Junkie' site is no longer active. Since I'm in the content organization for Microsoft, Access being one of the applications in my team's space, it really didn't make sense to have my public site anymore. The content on my own site could compete for...

Hi, Indeed, a new and improved Linked table Manager dialog is rolling out to O365 subscribers. We have published a new help article about it here: https://support.office.com/article/1d9346d6-953d-4f85-a9ce-4caec2262797 I believe the product team tried to incorporate a lot of customer requests...

I'm sorry to be the bearer of very tragic news; Chip has passed away. Here is his obituary: http://www.legacy.com/obituaries/kansascity/obituary.aspx?n=charles-h-pearson-chip&pid=188846047&f=portal -------------------- Jeff Conrad - Access Junkie - MVP Alumnus Senior Content Publishing...

Hi Colin, There have been instances where the items displayed in the 'What's new' dialog have been off a bit and at least internally here I've even seen them display features from a different app. That's definitely not good nor by design. I do know that the team working on that interface is...

Hi, That 'Learn More' link takes you to our 'What's new in Access' article here: https://support.office.com/en-us/article/What-s-new-in-Access-2016-76454345-f85d-47af-ace1-98a456cb3496?ui=en-US&rs=en-US&ad=US Scroll down a bit and expand the June, 2017 section. You'll see more detailed...

Hi Lightwave, Yes, Shane is the one still on the team. He's a walking encyclopedia of knowledge. I'd love to hook up a CAT-5 line from his brain to my brain and do a data transfer. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus Senior Content Publishing Manager - Modern...

Hi Pat, Access help, just like the other Office applications, has separations of ownership based on different areas. All developer focused content that is part of the VBE window is hosted on MSDN and owned by the Dev Docs team. I don’t have any control over that content. Our MAX group owns and...

Hi, Very interesting question. I believe some stayed with Access for many years, some moved to different teams over the years, some went on to different companies, some retired, etc. That was a very long time ago so a lot can happen in 25 years. However, one of the original developers is...

Hi, I think I can help with this one (pun intended). My team oversees all of the end user Help content for Access - content published on support.office.com that is surfaced within the main app help viewers and in the browser. Are you talking about the Developer Documentation shown within the...

Hi, Yes your scenario sounds achievable in Access web apps, assuming of course I've understood your scenario correctly. You can create a parameterized query that serves as the record source for a view (form) in an Access web app. You can use a UI macro to grab values from controls on the view...

Hi, Ok, let's tackle that question then in more detail: >> The web based forms will not allow VBA to be used, but they can open/use forms that are VBA forms. I'm assuming again here that we are talking only about Access 2010 style web databases and web forms. Access 2013/2016 style web apps...

Hi Uncle Gizmo, Which specific question were you wanting answered? Your subject line question is "Web forms can use VBA forms?" I assume here this is concerning Access 2010 style web databases. The answer to that question is no, Access 2010 style web forms can't use VBA. You can only use web...

Hi, When you create and use Access 2010 style web databases, the data is all stored in SharePoint tables. Because of this, you automatically would get system fields such as Created By, Modified By, etc. Those system fields would automatically be filled in by the SharePoint authentication...

Hi, Since you are using an Access 2013 web app, here is the syntax you would need for some various query syntax scenarios using your current field name. Current quarter: Year([DateAdded])=Year(Now()) And DatePart(Quarter,[DateAdded])=DatePart(Quarter,Now()) Previous quarter...

Hi Aubrey, Thanks for the nice comments on my book. For your macro variable question the answer depends on the context. In Access 2013 web apps, if you define a variable in a UI macro at the view level using the SetVariable macro action, the value will live on for the entire time you are...

Hi, I recognize that On Start macro sample as well as the sample app name you are looking at - RestaurantSampleChapter8. I hope you are enjoying my book and the sample files. It looks like you already figured out why Access was displaying the literal values you typed into the Message argument...

Hi, That's not the link I wanted you to try based on your screenshot. I wanted you to enter this URL into the Server URL box: http://k2.fi.local/sites/svaportal/teamsite And enter EPM into the Site Name box. But let's take Access out of the equation for the moment and try to make sure you...

Hi Matt, Is this an Access 2010 style web database or an Access 2013 web app? The two are very different so I just want to be clear on what type of web app you are working with here. Also, are you using Office 365 to host your database/app or an internal site hosted on your organization's...

Hi, Based on your provided screenshot, could you try using this URL instead: http://k2.fi.local/sites/svaportal/teamsite -------------------- Jeff Conrad - Access Junkie - MVP Alumnus Senior Content Developer - Modern Assistance and Support Experience - Microsoft Corporation Author -...

Hi, Good question. Your scenario is definitely possible in Access 2013 web apps using data macros. I've done this many times myself for similar scenarios in my apps. There are probably a couple of different ways you could design the macro logic for this, but here is one way to accomplish your...