oleronesoftwares
Passionate Learner
- Local time
- Today, 08:14
- Joined
- Sep 22, 2014
- Messages
- 1,098
I have joined the group, looking forward to a from of informal adult education.
want to come to an online user group meeting?
- Thread starter strive4peace
- Start date
strive4peace
AWF VIP
- Local time
- Today, 10:14
- Joined
- Apr 3, 2020
- Messages
- 1,056
My next presentation will be for Access Europe on Wednesday, May 4 -- Colin's group @isladogs -- free! Hope to see you!
Charting in Access doesn't have a great reputation, but there's certainly a lot you can do! Join us to find out more!
https://accessusergroups.org/europe/event/access-europe-2022-05-04/
Wednesday, May 4, 2022
18:00 London, 12 noon central, 10 am Pacific
Charting in Access doesn't have a great reputation, but there's certainly a lot you can do! Join us to find out more!
Access Europe (hosted by Colin Riddington & Alessandro Grimaldi) – Classic vs Modern Charts in Access
how to create classic and modern charts, compare their capabilities and ease of use, and how to do simple bar charts in a queryhttps://accessusergroups.org/europe/event/access-europe-2022-05-04/
Wednesday, May 4, 2022
18:00 London, 12 noon central, 10 am Pacific
strive4peace
AWF VIP
- Local time
- Today, 10:14
- Joined
- Apr 3, 2020
- Messages
- 1,056
who's coming?
NauticalGent
Ignore List Poster Boy
- Local time
- Today, 11:14
- Joined
- Apr 27, 2015
- Messages
- 6,873
Wouldn't miss it for the world, count me in!
strive4peace
AWF VIP
- Local time
- Today, 10:14
- Joined
- Apr 3, 2020
- Messages
- 1,056
- Local time
- Today, 08:14
- Joined
- Oct 29, 2018
- Messages
- 22,777
May the fourth be with you. I'll be there...
strive4peace
AWF VIP
- Local time
- Today, 10:14
- Joined
- Apr 3, 2020
- Messages
- 1,056
fot those of you with an older version of Access ... classic charts have been in Access since Access 97, or maybe even before -- and they are quite powerful, as you will see ...
and you CAN make them look very nice!
and you CAN make them look very nice!
Last edited:
strive4peace
AWF VIP
- Local time
- Today, 10:14
- Joined
- Apr 3, 2020
- Messages
- 1,056
EDIT -- Premiere over -- thanks to all who came!
YouTube video from the Access Europe meeting to compare Classic and Modern charts in Access
If you missed the meeting and the premiere, you can click on the link and watch when it's convenient. There is a LOT you can do with charts and visualization. Hope this gives you some good ideas
I couldn't sleep the night before the presentation and neglected to show some important things! They've since been added -- thanks Colin!
Look in the video description (on YouTube) for links to download files
@jdraw @Uncle Gizmo @NauticalGent @theDBguy @Isaac @Gasman @isladogs @Minty @Gasman @CJ_London @GPGeorge @oleronesoftwares
YouTube video from the Access Europe meeting to compare Classic and Modern charts in Access
If you missed the meeting and the premiere, you can click on the link and watch when it's convenient. There is a LOT you can do with charts and visualization. Hope this gives you some good ideas
I couldn't sleep the night before the presentation and neglected to show some important things! They've since been added -- thanks Colin!
Look in the video description (on YouTube) for links to download files
@jdraw @Uncle Gizmo @NauticalGent @theDBguy @Isaac @Gasman @isladogs @Minty @Gasman @CJ_London @GPGeorge @oleronesoftwares
Last edited:
strive4peace
AWF VIP
- Local time
- Today, 10:14
- Joined
- Apr 3, 2020
- Messages
- 1,056
You're invited to a user group meeting!
My next presentation will be for Access Lunchtime (more like dinner time) for those in the UK. All are welcome.
time: 12 noon Central, 18:00 London
this is the link to join -- hope you'll be there!
https://accessusergroups.org/lunch/event/access-lunchtime-4-2022-05-31/
Create professional Word documents from scratch using Word Automation. This is a deep dive into code to write data and text, format, save, and open the finished document with VBA.
We often want to make datasheets look nicer and have many of them in one report. A great way to do this is by creating a Word document with lots of pages and tables.
For each Word table, open a recordset in Access, determine how many rows and columns it has, and create a table in Word that size, with an extra row to be a shaded heading row. Set column widths depending on the table type.
Loop through the recordset and write information to cells, one record and field at a time. Reference any cell in the table by row and column. Format all or any text according to where or what it is.
Learn what objects are handy to dimension and set. While developing, use early-binding and reference the Microsoft Word #.# Object Library. As you write VBA and have advantage of Intellisense, comment and convert constants to values, and write and comment late-binding object declarations to use for deployment.
Write and format text in paragraphs, tables, headers, bookmarks, captions, and hyperlinks. Put tables in cells of tables. Insert and position images.
Create and use paragraph and character styles. Use wildcards in Find/Replace to replace phrases that match a pattern such as being enclosed with parentheses with a particular character style to make many changes at once.
In a sense, we are always working with a range of the document -- whether it's the whole document or just part of it like a table, a cell, a paragraph, some text in the middle of something, .... Learn how to use and set ranges.
For internal links within a document, set bookmarks to reference from somewhere else. Add a hyperlink that goes to a bookmark in the document and set the text to display.
Create lists such as a List of Tables with hyperlinks showing table number, caption, and page number.
Create a Table of Contents with hyperlinks using built-in Heading style references such as Heading 1, Heading 2, and Heading 3.
Define a header that will show at the top of every page. To make the content dynamic, insert text from styles such as Heading 1 and Heading 2, and fields such as date, page number and number of pages.
Use the PageSetup object to set margins. Optionally, set other properties like orientation, gutters, designate odd and even pages, and paper size.
When all is done, save the document, clean up object variables, and open a folder to files or the new document itself.
Get a sample Access database with VBA to create Word documents that enumerate Fonts installed in Windows, Word's built-in Styles, and create documents with information from tables, and insert images from path\files stored in Access.
Here is a very simplified object model for Word:
My next presentation will be for Access Lunchtime (more like dinner time) for those in the UK. All are welcome.
Access Lunchtime (hosted by Maria Barnes) - Deep Dive into Word Automation using VBA and Access
date: Tuesday, May 31time: 12 noon Central, 18:00 London
this is the link to join -- hope you'll be there!
https://accessusergroups.org/lunch/event/access-lunchtime-4-2022-05-31/
Create professional Word documents from scratch using Word Automation. This is a deep dive into code to write data and text, format, save, and open the finished document with VBA.
We often want to make datasheets look nicer and have many of them in one report. A great way to do this is by creating a Word document with lots of pages and tables.
For each Word table, open a recordset in Access, determine how many rows and columns it has, and create a table in Word that size, with an extra row to be a shaded heading row. Set column widths depending on the table type.
Loop through the recordset and write information to cells, one record and field at a time. Reference any cell in the table by row and column. Format all or any text according to where or what it is.
Learn what objects are handy to dimension and set. While developing, use early-binding and reference the Microsoft Word #.# Object Library. As you write VBA and have advantage of Intellisense, comment and convert constants to values, and write and comment late-binding object declarations to use for deployment.
Write and format text in paragraphs, tables, headers, bookmarks, captions, and hyperlinks. Put tables in cells of tables. Insert and position images.
Create and use paragraph and character styles. Use wildcards in Find/Replace to replace phrases that match a pattern such as being enclosed with parentheses with a particular character style to make many changes at once.
In a sense, we are always working with a range of the document -- whether it's the whole document or just part of it like a table, a cell, a paragraph, some text in the middle of something, .... Learn how to use and set ranges.
For internal links within a document, set bookmarks to reference from somewhere else. Add a hyperlink that goes to a bookmark in the document and set the text to display.
Create lists such as a List of Tables with hyperlinks showing table number, caption, and page number.
Create a Table of Contents with hyperlinks using built-in Heading style references such as Heading 1, Heading 2, and Heading 3.
Define a header that will show at the top of every page. To make the content dynamic, insert text from styles such as Heading 1 and Heading 2, and fields such as date, page number and number of pages.
Use the PageSetup object to set margins. Optionally, set other properties like orientation, gutters, designate odd and even pages, and paper size.
When all is done, save the document, clean up object variables, and open a folder to files or the new document itself.
Get a sample Access database with VBA to create Word documents that enumerate Fonts installed in Windows, Word's built-in Styles, and create documents with information from tables, and insert images from path\files stored in Access.
Here is a very simplified object model for Word:
Last edited:
AccessBlaster
Be careful what you wish for
- Local time
- Today, 08:14
- Joined
- May 22, 2010
- Messages
- 7,576
Yes, that was a pleasant surprise.You have a great singing voice
strive4peace
AWF VIP
- Local time
- Today, 10:14
- Joined
- Apr 3, 2020
- Messages
- 1,056
@Pat Hartman thanks! I'm glad you figured out the sound problem! The song for my chemistry presentation on Thursday June 2 (although Access does the drawing, it's just as much about chemistry) is "It's just matter to me", parady of a Bread song 
The songs are as much fun as the rest. I'm so excited about chemistry, I've been pulling all-nighters reading and watching videos about it! I took a lot of chemistry in college, but that was before I saw any practical applications for it, and there was a lot to memorize. Now I even want to learn quantum mechanics! Anyhow, here's a report that Access drew! Can you believe it? I'm going to add a legend ... after I learn more about particle physics, lol
You might notice that the arrangment of the periodic table has changed ... this is the latest!
The songs are as much fun as the rest. I'm so excited about chemistry, I've been pulling all-nighters reading and watching videos about it! I took a lot of chemistry in college, but that was before I saw any practical applications for it, and there was a lot to memorize. Now I even want to learn quantum mechanics! Anyhow, here's a report that Access drew! Can you believe it? I'm going to add a legend ... after I learn more about particle physics, lol
You might notice that the arrangment of the periodic table has changed ... this is the latest!
Last edited:
strive4peace
AWF VIP
- Local time
- Today, 10:14
- Joined
- Apr 3, 2020
- Messages
- 1,056
btw, here's the design view of the report ... no controls!
I might change the big character bracket over columns 8 through 10 to a drawing too
I might change the big character bracket over columns 8 through 10 to a drawing too
Last edited:
strive4peace
AWF VIP
- Local time
- Today, 10:14
- Joined
- Apr 3, 2020
- Messages
- 1,056
strive4peace
AWF VIP
- Local time
- Today, 10:14
- Joined
- Apr 3, 2020
- Messages
- 1,056
strive4peace
AWF VIP
- Local time
- Today, 10:14
- Joined
- Apr 3, 2020
- Messages
- 1,056
You're invited to a user group meeting! Drawing with Access!
My next presentation will be for Access Pacific (late, late night) for those in the UK. It's on Thursday, June 2 (in America anyway). All are welcome.
https://accessusergroups.org/pacific/event/257-2022-06-02/
Thursday June 2, 2022
6:30 pm Pacific (PDT), 8:30 pm central, and in the wee hour of the night/early Friday morning for the UK and Europe!
... and a comfy mid-day for Australia and New Zealand!
The topic is drawing! ... and chemistry Can you believe Access did all this?
biggest element -- who knows the name of this? And what exactly is this a drawing of?
how about the smallest, lightest element:
and a favorite of humans ...
They're all arranged on a clever diagram called the Periodic Table
which can be printed just for specific types of elements -- and easy to change color schemes
hope you can make it!
My next presentation will be for Access Pacific (late, late night) for those in the UK. It's on Thursday, June 2 (in America anyway). All are welcome.
Access Pacific (hosted by George Hepworth) - Drawing an Access Report
how to draw and write on an Access report without using controls. Example is the Periodic Table of Chemical Elements. There will be a sample database with reports so you can see code for the periodic table as well as other examples with lines, rectangels, circles, elipses, arcs, text, and morehttps://accessusergroups.org/pacific/event/257-2022-06-02/
Thursday June 2, 2022
6:30 pm Pacific (PDT), 8:30 pm central, and in the wee hour of the night/early Friday morning for the UK and Europe!
... and a comfy mid-day for Australia and New Zealand!
The topic is drawing! ... and chemistry
Can you believe Access did all this?biggest element -- who knows the name of this? And what exactly is this a drawing of?
how about the smallest, lightest element:
and a favorite of humans ...
They're all arranged on a clever diagram called the Periodic Table
which can be printed just for specific types of elements -- and easy to change color schemes
hope you can make it!
Last edited:
Similar threads
