ACCESS FEED: Juni 2022

Kamis, 30 Juni 2022

Re: [MSAccessProfessionals] Textbox is populated with the "#NAME?" error code. after upgrading computers

The path to the BE has not changed. the '#name?' error happens in text boxes where the data is a combination of multiple fields: EG Last Name&","&First Name. Or City&state&zip. Maybe the length of the combined text is a problem?

How do I compile the database in the environment with the issue, if that envrionment only has access run time?

Sarah

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] Textbox is populated with the "#NAME?" error code. after upgrading computers

hi Sarah,

if the tables are linked, try opening a few of them in Datasheet view. Perhaps the path to the BE has changed? Or the mapping is different. If not, still a good idea.

Another option is to compile the database in the environment with the issue.

good luck

kind regards,
crystal

On 6/30/2022 4:32 PM, novice012000 wrote:

One of my users upgraded computers, they have ms access run time only. they installed ms access 2016 runtime.
After the upgrade, many report textboxes are populated with the "#NAME?" error code.

These reports were working fine before the upgrade.

we tried downgrading to ms access 2013 32 bit, but we still get the same error.

this is a split database , the backend (tables) are in ms access 2003.

All help is appreciated.

Thank you

Sarah

[MSAccessProfessionals] Textbox is populated with the "#NAME?" error code. after upgrading computers

One of my users upgraded computers, they have ms access run time only. they installed ms access 2016 runtime.
After the upgrade, many report textboxes are populated with the "#NAME?" error code.

These reports were working fine before the upgrade.

we tried downgrading to ms access 2013 32 bit, but we still get the same error.

this is a split database , the backend (tables) are in ms access 2003.

All help is appreciated.

Thank you

Sarah

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Senin, 13 Juni 2022

Re: [MSAccessProfessionals] drawing with Access

ps, Graham, your engineering drawings with Access sound impressive! The major shape missing is a triangle. It would also be nice to be able to supply a set of points to create a closed shape connected by lines (even straight ones) so it can have a fill (drawing filled raindrops for my unit circle video was pretty difficult!) ~ crystal

On 6/14/2022 12:50 AM, crystal (strive4peace) via groups.io wrote:

thank you, Graham! Download is updated. On number of neutrons, wowza, you're right, many of them are really different! I made an update query for neutrons as you suggested (put you in the description) and also made q_Element_compare_Neutrons_Protons.

Good link, thanks. I could get lost modifying this database. Instead, I decided to just keep track of how many electrons are in each of the 7 possible shells for each element.

kind regards,
crystal

On 6/12/2022 7:26 PM, Graham Mandeno via groups.io wrote:

That was a fantastic presentation, Crystal – thank you!! I also appreciate all the hard work and research you put into the reference page. I'm sure that will be a very useful resource for many, no matter what their level of expertise.

I really dived deep into report drawing about 20 years ago when I wrote a database app for a client that used engineering tables to design steel buildings based on customer parameters. The design part (e.g. choosing the appropriate gauge of beam depending on the span) was difficult enough, but then they decided they wanted scale drawings to be produced of the building plan and all the elevations. How on earth was I going to do that in little ol' Access??? Anyway, I finished up producing very satisfactory drawings using all the tools you described in your presentation.

You said you would welcome some feedback. I have just a couple of suggestions stemming from some points raised in the Q&A – both to do with chemistry rather than Access:

As was pointed out, the number of neutrons in the nucleus is often not the same as the number of protons (the atomic number). In fact, the atomic weight is the average total of protons plus neutrons across all isotopes. Therefore you can get an average number of neutrons from:
CInt(AtomicWeight) - AtomicNumber

Someone (I think his name was Paul) was asking about how you filled the orbitals (shells) for transition elements. There is a very good page here that might help you to represent it more realistically:
https://chem.libretexts.org/Bookshelves/Inorganic_Chemistry/Supplemental_Modules_and_Websites_(Inorganic_Chemistry)/Descriptive_Chemistry/Elements_Organized_by_Block/3_d-Block_Elements/1b_Properties_of_Transition_Metals/Electron_Configuration_of_Transition_Metals

Thank you once again – I love your work! 😊

Cheers,
Graham

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Sunday, 12 June 2022 08:56
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] drawing with Access

in case you want to learn about drawing with Access, or get a refresher, here's the link to the presentation about that for George Hepworth's last Access Pacific meeting

AP: Drawing Shapes in an Access Report - Elements and Atoms (1:20:28) by crystal (strive4peace)
https://youtu.be/FVJx2BGrKu8

The sample data is basic chemistry -- the elements that compose all matter. It doesn't matter what the data is -- Access is great at managing any kind of information!

Access draws

    The Periodic Table of the Elements (standard data set or a specialized one) -- Line and Print
    Atoms with a set number of protons and neutrons in the nucleaus and electrons orbiting around -- Circle and Print
    several reports showing examples of how to use the LINE and CIRCLE methods (filter Navigation Pane for Line or Circle -- more sample in the download than at the time of this presentation) and the effects of various property settings like FillStyle, DrawStyle, and DrawWidth.

You can download the ACCDB here:

http://msaccessgurus.com/VBA/ReportDraw_Reference.htm

Near the top is Downloads and Documents where you can get the ACCDB database and see examples of things Access drew in various images and documents.

This web page has my rewritten and simplified explanation* of syntax for drawing methods such as Line, Circle, and Print. It might seem like you can't do much with just a few methods --- oh but you can!

* please, if you notice where something is said wrong or should be clarified, let me know.

There is information for other drawing methods such as points (PSet), and using TextWidth and TextHeight so you can calculate, for instance, where the middle of text will be so you can position CurrentX and CurrentY to its beginning location for Print.

There is information for several properties you can read and write when drawing, useful functions, order of events, about syntax used, units of measure, and more.

Please comments and share your ideas, thanks

kind regards,
crystal

On 6/2/2022 7:09 PM, crystal (strive4peace) via groups.io wrote:

hi Bill,

thanks for your kind reply. It will be recorded! And free for all to watch on YouTube.

AD has a beautiful soul, and posted many awesome things for Access. I'm certainly humbled to be compared with him in some way ~

kind regards,
crystal

On 6/2/2022 6:08 PM, Bill Mosca wrote:

Hi Crystal

I saw your announcement in LinkedIn. What a cool presentation this is going to be! I've done some interesting things with reports using VBA. AD Tejpal (http://www.rogersaccesslibrary.com/forum/tejpal-a-d_forum45.html ) Showed us quite a lot of ways to push Access reports. Your presentation certainly will rank right up there with his work, I have no doubt.

Unfortunately, I won't be able to attend. Any chance of this being recorded for our members?

Regards,

Bill Mosca

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Thursday, June 2, 2022 3:23 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] free in a few hours? Want to learn about drawing with Access?

hi everyone,

I'm giving a presentation tonight on drawing with Access on reports.

meeting link:

https://accessusergroups.org/pacific/event/257-2022-06-02/

Access Pacific online user group

DATE: 2 June 2022, Thursday (today!) -- Friday for those down-under

TIME: 6:30 pm Pacific, 7:30 pm Mountain, 8:30 pm Central, 9:30 pm Eastern, middle of the night for Europeans, ...

Drawing an Access Report

You're probably familiar with reports that use controls to contain text and other objects such as lines and boxes, but how do you create a report on a blank canvas with no controls?

Learn how to create an Access report where everything is drawn and written using VBA.

Use the Line Method to draw lines and rectangles, which can be filled with any color, and have any color for the border.

Use the Circle method to draw circles, ellipses, and arcs (open and closed). Like Line, any color can be used to fill closed shapes.

Use the Print method to write text. Do you want to add a shadow? Simply print the shadow text, then offset the starting coordinate and print the main text.

Hope you can make it!

Everyone is welcome.

kind regards,
crystal

Re: [MSAccessProfessionals] drawing with Access

thank you, Graham! Download is updated. On number of neutrons, wowza, you're right, many of them are really different! I made an update query for neutrons as you suggested (put you in the description) and also made q_Element_compare_Neutrons_Protons.

Good link, thanks. I could get lost modifying this database. Instead, I decided to just keep track of how many electrons are in each of the 7 possible shells for each element.

kind regards,
crystal

On 6/12/2022 7:26 PM, Graham Mandeno via groups.io wrote:

That was a fantastic presentation, Crystal – thank you!! I also appreciate all the hard work and research you put into the reference page. I'm sure that will be a very useful resource for many, no matter what their level of expertise.

I really dived deep into report drawing about 20 years ago when I wrote a database app for a client that used engineering tables to design steel buildings based on customer parameters. The design part (e.g. choosing the appropriate gauge of beam depending on the span) was difficult enough, but then they decided they wanted scale drawings to be produced of the building plan and all the elevations. How on earth was I going to do that in little ol' Access??? Anyway, I finished up producing very satisfactory drawings using all the tools you described in your presentation.

You said you would welcome some feedback. I have just a couple of suggestions stemming from some points raised in the Q&A – both to do with chemistry rather than Access:

As was pointed out, the number of neutrons in the nucleus is often not the same as the number of protons (the atomic number). In fact, the atomic weight is the average total of protons plus neutrons across all isotopes. Therefore you can get an average number of neutrons from:
CInt(AtomicWeight) - AtomicNumber

Someone (I think his name was Paul) was asking about how you filled the orbitals (shells) for transition elements. There is a very good page here that might help you to represent it more realistically:
https://chem.libretexts.org/Bookshelves/Inorganic_Chemistry/Supplemental_Modules_and_Websites_(Inorganic_Chemistry)/Descriptive_Chemistry/Elements_Organized_by_Block/3_d-Block_Elements/1b_Properties_of_Transition_Metals/Electron_Configuration_of_Transition_Metals

Thank you once again – I love your work! 😊

Cheers,
Graham

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Sunday, 12 June 2022 08:56
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] drawing with Access

in case you want to learn about drawing with Access, or get a refresher, here's the link to the presentation about that for George Hepworth's last Access Pacific meeting

AP: Drawing Shapes in an Access Report - Elements and Atoms (1:20:28) by crystal (strive4peace)
https://youtu.be/FVJx2BGrKu8

The sample data is basic chemistry -- the elements that compose all matter. It doesn't matter what the data is -- Access is great at managing any kind of information!

Access draws

    The Periodic Table of the Elements (standard data set or a specialized one) -- Line and Print
    Atoms with a set number of protons and neutrons in the nucleaus and electrons orbiting around -- Circle and Print
    several reports showing examples of how to use the LINE and CIRCLE methods (filter Navigation Pane for Line or Circle -- more sample in the download than at the time of this presentation) and the effects of various property settings like FillStyle, DrawStyle, and DrawWidth.

You can download the ACCDB here:

http://msaccessgurus.com/VBA/ReportDraw_Reference.htm

Near the top is Downloads and Documents where you can get the ACCDB database and see examples of things Access drew in various images and documents.

This web page has my rewritten and simplified explanation* of syntax for drawing methods such as Line, Circle, and Print. It might seem like you can't do much with just a few methods --- oh but you can!

* please, if you notice where something is said wrong or should be clarified, let me know.

There is information for other drawing methods such as points (PSet), and using TextWidth and TextHeight so you can calculate, for instance, where the middle of text will be so you can position CurrentX and CurrentY to its beginning location for Print.

There is information for several properties you can read and write when drawing, useful functions, order of events, about syntax used, units of measure, and more.

Please comments and share your ideas, thanks

kind regards,
crystal

On 6/2/2022 7:09 PM, crystal (strive4peace) via groups.io wrote:

hi Bill,

thanks for your kind reply. It will be recorded! And free for all to watch on YouTube.

AD has a beautiful soul, and posted many awesome things for Access. I'm certainly humbled to be compared with him in some way ~

kind regards,
crystal

On 6/2/2022 6:08 PM, Bill Mosca wrote:

Hi Crystal

I saw your announcement in LinkedIn. What a cool presentation this is going to be! I've done some interesting things with reports using VBA. AD Tejpal (http://www.rogersaccesslibrary.com/forum/tejpal-a-d_forum45.html ) Showed us quite a lot of ways to push Access reports. Your presentation certainly will rank right up there with his work, I have no doubt.

Unfortunately, I won't be able to attend. Any chance of this being recorded for our members?

Regards,

Bill Mosca

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Thursday, June 2, 2022 3:23 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] free in a few hours? Want to learn about drawing with Access?

hi everyone,

I'm giving a presentation tonight on drawing with Access on reports.

meeting link:

https://accessusergroups.org/pacific/event/257-2022-06-02/

Access Pacific online user group

DATE: 2 June 2022, Thursday (today!) -- Friday for those down-under

TIME: 6:30 pm Pacific, 7:30 pm Mountain, 8:30 pm Central, 9:30 pm Eastern, middle of the night for Europeans, ...

Drawing an Access Report

You're probably familiar with reports that use controls to contain text and other objects such as lines and boxes, but how do you create a report on a blank canvas with no controls?

Learn how to create an Access report where everything is drawn and written using VBA.

Use the Line Method to draw lines and rectangles, which can be filled with any color, and have any color for the border.

Use the Circle method to draw circles, ellipses, and arcs (open and closed). Like Line, any color can be used to fill closed shapes.

Use the Print method to write text. Do you want to add a shadow? Simply print the shadow text, then offset the starting coordinate and print the main text.

Hope you can make it!

Everyone is welcome.

kind regards,
crystal

Minggu, 12 Juni 2022

Re: [MSAccessProfessionals] drawing with Access

That was a fantastic presentation, Crystal – thank you!! I also appreciate all the hard work and research you put into the reference page. I'm sure that will be a very useful resource for many, no matter what their level of expertise.

I really dived deep into report drawing about 20 years ago when I wrote a database app for a client that used engineering tables to design steel buildings based on customer parameters. The design part (e.g. choosing the appropriate gauge of beam depending on the span) was difficult enough, but then they decided they wanted scale drawings to be produced of the building plan and all the elevations. How on earth was I going to do that in little ol' Access??? Anyway, I finished up producing very satisfactory drawings using all the tools you described in your presentation.

You said you would welcome some feedback. I have just a couple of suggestions stemming from some points raised in the Q&A – both to do with chemistry rather than Access:

As was pointed out, the number of neutrons in the nucleus is often not the same as the number of protons (the atomic number). In fact, the atomic weight is the average total of protons plus neutrons across all isotopes. Therefore you can get an average number of neutrons from:
CInt(AtomicWeight) - AtomicNumber
Someone (I think his name was Paul) was asking about how you filled the orbitals (shells) for transition elements. There is a very good page here that might help you to represent it more realistically:
https://chem.libretexts.org/Bookshelves/Inorganic_Chemistry/Supplemental_Modules_and_Websites_(Inorganic_Chemistry)/Descriptive_Chemistry/Elements_Organized_by_Block/3_d-Block_Elements/1b_Properties_of_Transition_Metals/Electron_Configuration_of_Transition_Metals

Thank you once again – I love your work! 😊

Cheers,
Graham

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Sunday, 12 June 2022 08:56
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] drawing with Access

in case you want to learn about drawing with Access, or get a refresher, here's the link to the presentation about that for George Hepworth's last Access Pacific meeting

AP: Drawing Shapes in an Access Report - Elements and Atoms (1:20:28) by crystal (strive4peace)
https://youtu.be/FVJx2BGrKu8

The sample data is basic chemistry -- the elements that compose all matter. It doesn't matter what the data is -- Access is great at managing any kind of information!

Access draws

    The Periodic Table of the Elements (standard data set or a specialized one) -- Line and Print
    Atoms with a set number of protons and neutrons in the nucleaus and electrons orbiting around -- Circle and Print
    several reports showing examples of how to use the LINE and CIRCLE methods (filter Navigation Pane for Line or Circle -- more sample in the download than at the time of this presentation) and the effects of various property settings like FillStyle, DrawStyle, and DrawWidth.

You can download the ACCDB here:

http://msaccessgurus.com/VBA/ReportDraw_Reference.htm

Near the top is Downloads and Documents where you can get the ACCDB database and see examples of things Access drew in various images and documents.

This web page has my rewritten and simplified explanation* of syntax for drawing methods such as Line, Circle, and Print. It might seem like you can't do much with just a few methods --- oh but you can!

* please, if you notice where something is said wrong or should be clarified, let me know.

There is information for other drawing methods such as points (PSet), and using TextWidth and TextHeight so you can calculate, for instance, where the middle of text will be so you can position CurrentX and CurrentY to its beginning location for Print.

There is information for several properties you can read and write when drawing, useful functions, order of events, about syntax used, units of measure, and more.

Please comments and share your ideas, thanks

kind regards,
crystal

On 6/2/2022 7:09 PM, crystal (strive4peace) via groups.io wrote:

hi Bill,
thanks for your kind reply. It will be recorded! And free for all to watch on YouTube.
AD has a beautiful soul, and posted many awesome things for Access. I'm certainly humbled to be compared with him in some way ~
kind regards,
crystal
On 6/2/2022 6:08 PM, Bill Mosca wrote:
Hi Crystal

I saw your announcement in LinkedIn. What a cool presentation this is going to be! I've done some interesting things with reports using VBA. AD Tejpal (http://www.rogersaccesslibrary.com/forum/tejpal-a-d_forum45.html ) Showed us quite a lot of ways to push Access reports. Your presentation certainly will rank right up there with his work, I have no doubt.

Unfortunately, I won't be able to attend. Any chance of this being recorded for our members?

Regards,
Bill Mosca

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Thursday, June 2, 2022 3:23 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] free in a few hours? Want to learn about drawing with Access?

hi everyone,
I'm giving a presentation tonight on drawing with Access on reports.
meeting link:
https://accessusergroups.org/pacific/event/257-2022-06-02/
Access Pacific online user group
DATE: 2 June 2022, Thursday (today!) -- Friday for those down-under
TIME: 6:30 pm Pacific, 7:30 pm Mountain, 8:30 pm Central, 9:30 pm Eastern, middle of the night for Europeans, ...
Drawing an Access Report
You're probably familiar with reports that use controls to contain text and other objects such as lines and boxes, but how do you create a report on a blank canvas with no controls?
Learn how to create an Access report where everything is drawn and written using VBA.
Use the Line Method to draw lines and rectangles, which can be filled with any color, and have any color for the border.
Use the Circle method to draw circles, ellipses, and arcs (open and closed). Like Line, any color can be used to fill closed shapes.
Use the Print method to write text. Do you want to add a shadow? Simply print the shadow text, then offset the starting coordinate and print the main text.
Hope you can make it!
Everyone is welcome.
kind regards,
crystal

Sabtu, 11 Juni 2022

Re: [MSAccessProfessionals] drawing with Access

Thanks Crystal.

Once again, I am sorry I missed your presentation.

David

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of crystal (strive4peace) via groups.io <strive4peace2008=yahoo.com@groups.io>
Sent: Saturday, June 11, 2022 2:55 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] drawing with Access

in case you want to learn about drawing with Access, or get a refresher, here's the link to the presentation about that for George Hepworth's last Access Pacific meeting

AP: Drawing Shapes in an Access Report - Elements and Atoms (1:20:28) by crystal (strive4peace)
https://youtu.be/FVJx2BGrKu8

Please comments and share your ideas, thanks

kind regards,
crystal

On 6/2/2022 7:09 PM, crystal (strive4peace) via groups.io wrote:

hi Bill,

thanks for your kind reply. It will be recorded! And free for all to watch on YouTube.

AD has a beautiful soul, and posted many awesome things for Access. I'm certainly humbled to be compared with him in some way ~

kind regards,
crystal

On 6/2/2022 6:08 PM, Bill Mosca wrote:

Hi Crystal

I saw your announcement in LinkedIn. What a cool presentation this is going to be! I've done some interesting things with reports using VBA. AD Tejpal (http://www.rogersaccesslibrary.com/forum/tejpal-a-d_forum45.html ) Showed us quite a lot of ways to push Access reports. Your presentation certainly will rank right up there with his work, I have no doubt.

Unfortunately, I won't be able to attend. Any chance of this being recorded for our members?

Regards,

Bill Mosca

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Thursday, June 2, 2022 3:23 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] free in a few hours? Want to learn about drawing with Access?

hi everyone,

I'm giving a presentation tonight on drawing with Access on reports.

meeting link:

https://accessusergroups.org/pacific/event/257-2022-06-02/

Access Pacific online user group

DATE: 2 June 2022, Thursday (today!) -- Friday for those down-under

TIME: 6:30 pm Pacific, 7:30 pm Mountain, 8:30 pm Central, 9:30 pm Eastern, middle of the night for Europeans, ...

Drawing an Access Report

You're probably familiar with reports that use controls to contain text and other objects such as lines and boxes, but how do you create a report on a blank canvas with no controls?

Learn how to create an Access report where everything is drawn and written using VBA.

Use the Line Method to draw lines and rectangles, which can be filled with any color, and have any color for the border.

Use the Circle method to draw circles, ellipses, and arcs (open and closed). Like Line, any color can be used to fill closed shapes.

Use the Print method to write text. Do you want to add a shadow? Simply print the shadow text, then offset the starting coordinate and print the main text.

Hope you can make it!

Everyone is welcome.

kind regards,
crystal

[MSAccessProfessionals] drawing with Access

in case you want to learn about drawing with Access, or get a refresher, here's the link to the presentation about that for George Hepworth's last Access Pacific meeting

AP: Drawing Shapes in an Access Report - Elements and Atoms (1:20:28) by crystal (strive4peace)
https://youtu.be/FVJx2BGrKu8

Please comments and share your ideas, thanks

kind regards,
crystal

On 6/2/2022 7:09 PM, crystal (strive4peace) via groups.io wrote:

hi Bill,

thanks for your kind reply. It will be recorded! And free for all to watch on YouTube.

AD has a beautiful soul, and posted many awesome things for Access. I'm certainly humbled to be compared with him in some way ~

kind regards,
crystal

On 6/2/2022 6:08 PM, Bill Mosca wrote:

Hi Crystal

I saw your announcement in LinkedIn. What a cool presentation this is going to be! I've done some interesting things with reports using VBA. AD Tejpal (http://www.rogersaccesslibrary.com/forum/tejpal-a-d_forum45.html ) Showed us quite a lot of ways to push Access reports. Your presentation certainly will rank right up there with his work, I have no doubt.

Unfortunately, I won't be able to attend. Any chance of this being recorded for our members?

Regards,

Bill Mosca

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Thursday, June 2, 2022 3:23 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] free in a few hours? Want to learn about drawing with Access?

hi everyone,

I'm giving a presentation tonight on drawing with Access on reports.

meeting link:

https://accessusergroups.org/pacific/event/257-2022-06-02/

Access Pacific online user group

DATE: 2 June 2022, Thursday (today!) -- Friday for those down-under

TIME: 6:30 pm Pacific, 7:30 pm Mountain, 8:30 pm Central, 9:30 pm Eastern, middle of the night for Europeans, ...

Drawing an Access Report

You're probably familiar with reports that use controls to contain text and other objects such as lines and boxes, but how do you create a report on a blank canvas with no controls?

Learn how to create an Access report where everything is drawn and written using VBA.

Use the Line Method to draw lines and rectangles, which can be filled with any color, and have any color for the border.

Use the Circle method to draw circles, ellipses, and arcs (open and closed). Like Line, any color can be used to fill closed shapes.

Use the Print method to write text. Do you want to add a shadow? Simply print the shadow text, then offset the starting coordinate and print the main text.

Hope you can make it!

Everyone is welcome.

kind regards,
crystal

Kamis, 02 Juni 2022

Re: [MSAccessProfessionals] free in a few hours? Want to learn about drawing with Access?

hi Bill,

thanks for your kind reply. It will be recorded! And free for all to watch on YouTube.

AD has a beautiful soul, and posted many awesome things for Access. I'm certainly humbled to be compared with him in some way ~

kind regards,
crystal

On 6/2/2022 6:08 PM, Bill Mosca wrote:

Hi Crystal

I saw your announcement in LinkedIn. What a cool presentation this is going to be! I've done some interesting things with reports using VBA. AD Tejpal (http://www.rogersaccesslibrary.com/forum/tejpal-a-d_forum45.html ) Showed us quite a lot of ways to push Access reports. Your presentation certainly will rank right up there with his work, I have no doubt.

Unfortunately, I won't be able to attend. Any chance of this being recorded for our members?

Regards,

Bill Mosca

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Thursday, June 2, 2022 3:23 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] free in a few hours? Want to learn about drawing with Access?

hi everyone,

I'm giving a presentation tonight on drawing with Access on reports.

meeting link:

https://accessusergroups.org/pacific/event/257-2022-06-02/

Access Pacific online user group

DATE: 2 June 2022, Thursday (today!) -- Friday for those down-under

TIME: 6:30 pm Pacific, 7:30 pm Mountain, 8:30 pm Central, 9:30 pm Eastern, middle of the night for Europeans, ...

Drawing an Access Report

You're probably familiar with reports that use controls to contain text and other objects such as lines and boxes, but how do you create a report on a blank canvas with no controls?

Learn how to create an Access report where everything is drawn and written using VBA.

Use the Line Method to draw lines and rectangles, which can be filled with any color, and have any color for the border.

Use the Circle method to draw circles, ellipses, and arcs (open and closed). Like Line, any color can be used to fill closed shapes.

Use the Print method to write text. Do you want to add a shadow? Simply print the shadow text, then offset the starting coordinate and print the main text.

Hope you can make it!

Everyone is welcome.

kind regards,
crystal

Re: [MSAccessProfessionals] Connection to SQL with saved User and Password

Create a backup of your db first.

Delete all Link table and create new link table.

Pay attention on the wizard because at the end it will ask if you want to save the password. You answer Yes.

On Fri, Jun 3, 2022, 3:34 AM Doyce Winberry <doyce.winberry@xpo.com> wrote:

Hey I think I have solved this one. I found a video that showed how to create a file DSN and then edit the file and add a line at the bottom that says PWD = password. I did that and then relinked my tables using the file and so far it is working great. Thanks for your response Duane and Paul.

Doyce Winberry

Manufacturing

Manager Systems

XPOLogistics

2001 Benton Street

Searcy, AR 72143 USA

O: +1 501-207-5973   M: +1 501-207-2269

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Thursday, June 2, 2022 12:57 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Connection to SQL with saved User and Password

Here is a blog post from Ben Clothier (one of the smartest developers I know) http://accessblog.net/2012/04/make-sql-server-linked-table-more.html?m=1 Sent from my mobile On Jun 2, 2022, at 11:22 AM, Doyce Winberry <doyce.winberry@xpo.com>

ZjQcmQRYFpfptBannerStart

This Message Is From an External Sender

This message came from outside your organization.

ZjQcmQRYFpfptBannerEnd

Here is a blog post from Ben Clothier (one of the smartest developers I know) http://accessblog.net/2012/04/make-sql-server-linked-table-more.html?m=1

Sent from my mobile

On Jun 2, 2022, at 11:22 AM, Doyce Winberry <doyce.winberry@xpo.com> wrote:

Basically, if I link to the tables and use the service account, I have read/write access. If I use the normal windows account I get only read access under their new rules. So I need to connect to the SQL Server using the service account login ID and password. But they don't want the users to know the password so I need to put it in the connection string. I'm trying to figure out how to do that.

Doyce Winberry

Manufacturing

Manager Systems

XPOLogistics

2001 Benton Street

Searcy, AR 72143 USA

O: +1 501-207-5973   M: +1 501-207-2269

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Thursday, June 2, 2022 11:08 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Connection to SQL with saved User and Password

I am not that familiar with Sarbanes Oxley but I would expect the actual account making changes or accessing the data would be critical. I'm not sure if that is baked into a service account. Duane From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>

ZjQcmQRYFpfptBannerStart

This Message Is From an External Sender

This message came from outside your organization.

ZjQcmQRYFpfptBannerEnd

I am not that familiar with Sarbanes Oxley but I would expect the actual account making changes or accessing the data would be critical. I'm not sure if that is baked into a service account.

Duane

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Doyce Winberry <doyce.winberry@xpo.com>
Sent: Thursday, June 2, 2022 10:43 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Connection to SQL with saved User and Password

Duane,

I can't answer that question because it doesn't make sense to me either. We have been using an AD group but they say it is not in compliance with Sarbanes Oxley.

Doyce Winberry

Manufacturing

Manager Systems

XPOLogistics

2001 Benton Street

Searcy, AR 72143 USA

O: +1 501-207-5973   M: +1 501-207-2269

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Thursday, June 2, 2022 10:28 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Connection to SQL with saved User and Password

Hi Doyce, I'm confused why a "service" account would be used. I have typically seen service accounts used when one system needs to connect to another such as cross SQL Server or some software collecting data that needs automation

ZjQcmQRYFpfptBannerStart

This Message Is From an External Sender

This message came from outside your organization.

ZjQcmQRYFpfptBannerEnd

Hi Doyce,

I'm confused why a "service" account would be used. I have typically seen service accounts used when one system needs to connect to another such as cross SQL Server or some software collecting data that needs automation to connect to SQL Server. Our SQL admins have always encouraged us to create (or request creation) of AD security groups and adding individuals to the groups. The AD group is then granted specific rights within the SQL database.

Regards,

Duane

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Doyce Winberry <doyce.winberry@xpo.com>
Sent: Thursday, June 2, 2022 7:48 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Connection to SQL with saved User and Password

Hello everyone. I'm using Access 2016 and have a DB that connects to some SQL server tables. Lately my corporate DB team has said we are not Sarbanes Oxley compliant because individual users have write rights to the SQL tables so they propose that we use a "service account" to connect to the SQL tables instead of individual accounts. When they remove the write rights from my individual accounts the DB breaks because it needs to write to the SQL tables. I'm using an ODBC connection setup as a system DSN to connect to the SQL tables. When I change the DSN to use the service account they want me to use, it does not remember the password. I'm not supposed to share the password with the users. So how can I connect to the SQL tables with the service account and password and have the DB "remember" the password. I've found examples of connection strings with userID and passwords but don't know where to put them in the DB.
Thanks in advance.
Doyce Winberry

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_