Results 1 to 10 of 10
  1. #1
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954

    Next meeting for Access User Groups - Europe

    The next Access Europe meeting will be on Wednesday 1 Feb 2023 starting at 18:00 (6PM) and finishing at about 19:30 (7.30PM) UK time (UTC)



    The start time is equivalent to 19:00 (7PM) in Central Europe / CET (UTC+1) and 10AM in Seattle / PDT (UTC-8)

    For local times, please check https://www.worldtimebuddy.com/

    I am very pleased to announce that Thomas Möller (Access MVP 2007-2016) will be leading a presentation called State-of-the-art charts in Access with chart.js

    I have seen this in action and it is VERY impressive.

    There are countless JavaScript libraries available on the internet that can be used to create cool charts. Some charts even allow user interaction. The really good news is that these features can also be used in Access.

    Thomas will use this presentation to demonstrate:

    • How to get state-of-the-art charts (based on chart.js) running in Access
    • What are the external dependencies and how can they be resolved?
    • How do we program the whole thing elegantly and clearly?

    NOTE: There is a lot to cover in this session and it is likely to last about 75 minutes (followed by a question and answer session).

    For more details, see: https://accessusergroups.org/europe/...pe-2023-02-01/

    The meeting will again be held on Zoom. When the time comes, you can connect using: Join Zoom Meeting.
    I hope you will join us as it promises to be a really outstanding session.

    As always, the session will be recorded and the video uploaded to YouTube after the event.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    The video of Thomas Moller's excellent presentation to Access Europe is now available on YouTube: https://www.youtube.com/watch?v=GlmWWmgSQo8
    The files associated with the session can be downloaded fromhttps://www.isladogs.co.uk/aeu-12/index.html
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    The next Access Europe meeting will be on Wednesday 1 March 2023 starting at 18:00 (6PM) and finishing at about 19:15 (7.15PM) UK time (UTC)
    The start time is equivalent to 19:00 (7PM) in Central Europe / CET (UTC+1) and 10AM in Seattle / PDT (UTC-8)
    For local times, please check https://www.worldtimebuddy.com/

    I am pleased to announce that fellow Access MVP Maria Barnes will be leading a presentation called Optimizing Queries in SQL Server.

    Maria will demonstrate how to optimize queries in SQL Server using the various tools provided:


    • - How to decide which SQL queries need to be optimized?
    • - How to Use the Activity Monitor in SSMS
    • - An Introduction to the Performance Dashboard for SSMS 17.2 and above
    • - Query Simplification Basics
    • - Displaying the Estimated Execution Plan in SSMS
    • - A brief mention of the Query Store and what this is

    For more details, see: https://accessusergroups.org/europe/...pe-2023-03-01/

    The meeting will again be held on Zoom. When the time comes, you can connect using: Join Zoom Meeting.
    I hope you will join us for what should be a very informative session.

    As always, the session will be recorded and the video uploaded to YouTube after the event



    Also, early notice that on Wed 5 April, Duane Hookom will be leading a session called Creating calendar format reports
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #4
    writeprivate is offline Advanced Access Coder
    Windows 10 Access 2021
    Join Date
    Feb 2023
    Posts
    42
    This is amazing Colin. Thanks to Thomas. What a great community.

    Other projects for Thomas:
    An ODBC connector with suite on connections like Google Sheets, Xero etc. (commercial options are completely unaffordable)
    Mobile App to at least have a table connection
    Anything cloud plug&play.

  5. #5
    writeprivate is offline Advanced Access Coder
    Windows 10 Access 2021
    Join Date
    Feb 2023
    Posts
    42
    Hi Colin

    I have integrated the Better Access Charts code into a sample database and got it working just as per Thomas's video. So a fresh form with a new datasource and using the code in the video eg:

    Private Sub Command8_Click()
    Dim myChart As BAC_Chart
    Set myChart = BAC.Chart(Me.ctlWebbrowser)
    myChart.ChartType = Line
    With myChart.DataSource
    .ObjectName = "Balances_COA"
    .LabelFieldName = "account_name"
    .DataFieldNames = Array("Balance")
    myChart.Title.Show = True
    myChart.Title.Text = "Hello"
    myChart.Legend.Show = True
    myChart.Legend.Position = posBottom
    'myChart.YAxis.Show = True
    'myChart.YAxis.beginAtZero = True
    'myChart.XAxis.TicksMin = "Feb"
    End With


    myChart.CreateChart


    End Sub


    I wondered if there was a way to use the Demo Configurator to configure the chart and then it produces the code to then paste into the click event of the target form's button. It looks like this is the intention with "Datasource tab".
    It would be an amazing extra feature as it is hard to a) know all the options in code and also b) much easier to set up the chart as you want it using the configurator.

    Thanks for any assistance.

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    @writeprivate
    I agree that Thomas Moeller's code is amazing but he is much better placed to answer your questions than myself.

    AFAIK he doesn't have an account at this forum so I suggest you contact him using one of the methods in the links pages of his presentation
    https://www.youtube.com/watch?v=GlmWWmgSQo8&t=1070s

    You could also pass on your suggestions for keeping him busy into the future!

    Or if preferred, send me a PM or email (see link below) with your email address & the comments from the last two posts & I will forward them to him

    I also recommend you leave a comment on the YouTube video

    Hope that helps
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    @writeprivate
    I alerted Thomas and he has asked me to post the following on his behalf:

    ================================================== =======================

    I agree that there is always room for improvement in any solution. To become familiar with the object model of Better Access Chart you can have a look at the documentation in the wiki:
    https://github.com/team-moeller/bett.../documentation
    I put lots of effort in there.

    Another way to get familiar with the necessary code fragments is to investigate the sample database a lot more. Have a closer look at the Private Sub ConfigChart in the form frm_Demo. There you will find the code to be written to implement the chart in a way you just configurated.

    Sure, a feature to put in the necessary code directly into your form would be very nice. I have this on my agenda. But at the moment there is no timeframe to implement this. I am currently waiting for the new Edge web browser control to be published (hopefully at the end of March). Then I have to investigate how I have to change my code to make Better Access Charts work with the new control. After that I will have to look, how to change the code to make Better Access Charts work with Chart.js Version 3.0.2 or higher. After that there may be some space for an automatic code generation as you mentioned.

    I would like to point out, that this is a public project, published on GitHub. So, if you like, you can fork the code into your own branch, do the necessary coding and at the end send me a pull request to incorporate your efforts into Better Access Charts. I would really appreciate this.

    Best Regards
    Thomas

    ================================================== =====================

    I would encourage you to take up Thomas on his suggestions.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  8. #8
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    The video of Maria Barnes' Optimizing Queries in SQL Server presentation to Access Europe on Wed 1 March is now available on YouTube: https://youtu.be/aOd0G9uIfvo
    A PDF of the presentation used in the session can be downloaded from https://www.isladogs.co.uk/aeu-13/
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  9. #9
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    The next Access Europemeeting will be on Wednesday 5 Apr 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM)

    The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST

    Please note that the UK is now on Summer Time (UTC+1). For local times, please check https://www.worldtimebuddy.com/

    I am pleased to announce that ex-MVP Duane Hookom will be leading a presentation called Creating calendar format reports

    Duane’s presentation will demonstrate techniques for data reporting in calendar formats. The same, simple method could be used to print seating charts and other spatial data.


    • Quick demo of reports
    • Requirements
    • Data structure
    • “Tricks” used to achieve
    • Code review
    • Limitations and opportunities
    • Discussion

    For more details, see: https://accessusergroups.org/europe/...-2-2023-04-05/

    The meeting will again be held on Zoom. When the time comes, you can connect using: Join Zoom Meeting.
    I hope you will join us for what should be a very interesting session.

    As always, the session will be recorded and the video uploaded to YouTube after the event
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  10. #10
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    The video of Duane Hookom's Creating calendar format reports presentation to Access Europe is now available on YouTube: https://youtu.be/M6vsACrw_dI

    A PDF of the presentation used in the session and the example database can be downloaded from https://www.isladogs.co.uk/aeu-14/
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. NEW – Access User Group – Europe
    By isladogs in forum Access
    Replies: 20
    Last Post: 01-07-2023, 07:04 AM
  2. Access User Group Meeting - Fri 17 Dec 2021
    By isladogs in forum Access
    Replies: 20
    Last Post: 12-28-2022, 05:31 AM
  3. Replies: 1
    Last Post: 05-28-2020, 05:06 PM
  4. Replies: 3
    Last Post: 08-04-2017, 03:55 PM
  5. Replies: 10
    Last Post: 02-28-2017, 01:42 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums