Recent content by Kstruth

Yes, please tell me how to do that because it worked long before coming on board - but I have never seen it work since I've been here.

SELECT [PjM Presentation Order].[Presentation Order], [eQuad - PMR Ready].[PMR Ready?], [eQuad - PMR Ready].[TO Status], [PjM Presentation Order].[PjM FirstName LastName], [eQuad - PMR Ready].Notes, [eQuad - PMR Ready].[Is this to be briefed at next PMR?] AS Expr1, * FROM (SELECT DISTINCTROW...

OK. So the button in particular is returning the correct user, however the one parameter I don't know how to program is only show if "Ready for Meeting" field is checked YES. What is the syntax for that? I should add the user name is coming from an unbound list of personnel the user selects...

Hi there - so a bit simplistic - no code. Report Selection: Command12 On Click OpenReport Report Name: View:Print Preview Filter Name: Where Condition: Window Mode:Normal Otherwise not sure how to see the code. It is not Visual Basic as of now. it looks like a wizard action.

I have a SharePoint list attached to Access to that feeds all fields in a beautiful Access report. Currently, a macro currently in the form created prior to my arrival. One complete report with all personnel's reports and one specifically for each personnel to view their own reports to check...

Worked like a charm! Thank you so very much!

Howdy to SunnySandyEggo Property Sheet: Column Count:1 Column Width: Column Heads: No Bound Column:1 Is it possible with it set to 1 - thats why its only reading first column? If yes, how to resolve, let me know if I am going down the wrong branch on that one.

I have a SharePoint 2013 list that is connected to Access 2016 db that consists of over 700 projects. Access is mostly used to display the SharePoint list items in a report view. Recently the one of the fields in SharePoint list, "Project Customer" was changed from a drop-down list to a People...

Howdy, I'm a junir SharePoint admin and I'm trying to learn all that I can about Access and it works with SharePoint. From Virginia, US and enjoy problem solving, but need some help to understand the foundational things - some advanced and some tricky. Thank you all in advance.