Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 278
Search took 0.02 seconds.
Search: Posts Made By: AccessJunkie
Forum: General 12-03-2019, 04:49 PM
Replies: 38
Views: 752
Posted By AccessJunkie
Re: Useful links

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...
Forum: General 08-15-2018, 11:53 AM
Replies: 7
Views: 1,230
Posted By AccessJunkie
Re: Updated Linked Table Manager

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:
...
Forum: General 04-30-2018, 12:21 PM
Replies: 10
Views: 1,161
Posted By AccessJunkie
Re: CPearson.com

I'm sorry to be the bearer of very tragic news; Chip has passed away.

Here is his obituary:
...
Forum: General 11-15-2017, 11:30 AM
Replies: 9
Views: 799
Posted By AccessJunkie
Re: New features in Access 2016 version 1710

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....
Forum: General 11-15-2017, 08:57 AM
Replies: 9
Views: 799
Posted By AccessJunkie
Re: New features in Access 2016 version 1710

Hi,

That 'Learn More' link takes you to our 'What's new in Access' article here:
...
Forum: General 10-06-2017, 08:37 AM
Replies: 11
Views: 1,074
Posted By AccessJunkie
Re: Who originally designed MS Access and What happened to the initial core team?

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.
...
Forum: General 10-06-2017, 08:34 AM
Replies: 11
Views: 1,074
Posted By AccessJunkie
Re: Who originally designed MS Access and What happened to the initial core team?

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...
Forum: General 10-05-2017, 12:36 PM
Replies: 11
Views: 1,074
Posted By AccessJunkie
Re: Who originally designed MS Access and What happened to the initial core team?

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...
Forum: General 09-22-2017, 09:44 AM
Replies: 8
Views: 949
Posted By AccessJunkie
Re: Access help system in 2010 version

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...
Forum: Access Web 03-26-2016, 11:51 AM
Replies: 1
Views: 3,541
Posted By AccessJunkie
Re: Parameter query as a Record Source fed with parameters from data macro?

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...
Forum: Access Web 02-01-2016, 10:54 AM
Replies: 5
Views: 2,205
Posted By AccessJunkie
Re: Web forms can use VBA forms?

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...
Forum: Access Web 01-31-2016, 09:14 PM
Replies: 5
Views: 2,205
Posted By AccessJunkie
Re: Web forms can use VBA forms?

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...
Forum: Access Web 10-30-2015, 09:13 AM
Replies: 5
Views: 1,809
Posted By AccessJunkie
Re: Access Web App on SharePoint - Auditing

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...
Forum: Access Web 07-14-2015, 01:44 PM
Replies: 9
Views: 2,988
Posted By AccessJunkie
Re: Using a date expression in query

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:...
Forum: Access Web 07-08-2015, 11:31 AM
Replies: 12
Views: 2,639
Posted By AccessJunkie
Re: Variables not showing as expected in controls (Access Web App)

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...
Forum: Access Web 07-07-2015, 08:20 AM
Replies: 12
Views: 2,639
Posted By AccessJunkie
Re: Variables not showing as expected in controls (Access Web App)

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...
Forum: Access Web 06-09-2015, 09:01 AM
Replies: 3
Views: 971
Posted By AccessJunkie
Re: how to publish a web site in sharepoint

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...
Forum: General 06-08-2015, 10:44 AM
Replies: 1
Views: 434
Posted By AccessJunkie
Re: Re-order my records in a Sharepoint Access database

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...
Forum: Access Web 06-08-2015, 10:42 AM
Replies: 3
Views: 971
Posted By AccessJunkie
Re: how to publish a web site in sharepoint

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...
Forum: Access Web 06-08-2015, 10:37 AM
Replies: 5
Views: 7,785
Posted By AccessJunkie
Re: 2013 Web App Data Macro to Append

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...
Forum: Access Web 05-19-2015, 09:44 AM
Replies: 9
Views: 2,988
Posted By AccessJunkie
Re: Using a date expression in query

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...
Forum: Access Web 05-08-2015, 10:53 AM
Replies: 8
Views: 1,724
Posted By AccessJunkie
Re: Hiding a column on a sub-form

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...
Forum: Access Web 05-08-2015, 09:46 AM
Replies: 8
Views: 1,724
Posted By AccessJunkie
Re: Hiding a column on a sub-form

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...
Forum: Macros 03-18-2015, 09:16 AM
Replies: 5
Views: 3,381
Posted By AccessJunkie
Re: Web App Data Macro Issue

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 ...
Forum: Macros 03-12-2015, 08:50 AM
Replies: 5
Views: 3,381
Posted By AccessJunkie
Re: Web App Data Macro Issue

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....
Showing results 1 to 25 of 278

 
Forum Jump



All times are GMT -8. The time now is 09:10 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World