Jumat, 22 Desember 2023

Biodynamic Gardening Guide: Definition, Key Principles, Best Practices, Benefits, Tools and Preparations

Biodynamic gardening offers a profound approach to cultivating the earth, resonating with ancient wisdom and modern ecological consciousness. It transcends conventional organic practices by fostering a holistic understanding of the garden as a living organism, intertwined with the rhythms of nature and the cosmos. Embracing this philosophy nurtures vibrant, nutrient-rich produce while promoting a deeper connection to the natural world.

Key Principles of Biodynamic Gardening

1. Understanding the Farm as a Living Organism:

  • Biodynamics views the farm or garden as an interconnected entity, where soil, plants, animals, and cosmic forces collaborate in a delicate dance of life.
  • Nurturing this interconnectedness is paramount, ensuring a synergistic balance that promotes vitality and resilience.

2. Strengthening the Soil:

  • Biodynamic preparations, meticulously crafted from natural substances, act as catalysts for soil health.
  • These preparations invigorate microbial life, enhance fertility, and promote a thriving soil ecosystem—the foundation for robust plant growth.

3. Aligning with Cosmic Rhythms:

  • Biodynamics recognizes the profound influence of celestial rhythms on plant growth.
  • Planting, cultivating, and harvesting in harmony with lunar cycles, planetary alignments, and seasonal transitions optimizes plant vitality and yields.

4. Embracing Biodiversity:

  • Biodynamic gardens embrace diversity, fostering a tapestry of plant species, insect life, and beneficial organisms.
  • This biodiversity fosters resilience, thwarts pests, and creates a harmonious ecosystem where each element contributes to the garden's overall health.

Essential Practices for Biodynamic Gardening Success

1. Composting: The Heart of Soil Fertility

  • Biodynamic composting is a meticulous art, transforming organic matter into a nutrient-rich elixir for the soil.
  • Specific preparations, such as BD500 and BD502, enhance compost vitality, accelerating decomposition and enriching the soil's microbial life.

2. Planting by the Moon and Stars:

  • Biodynamic planting calendars guide gardeners to align sowing and harvesting with auspicious cosmic rhythms.
  • This practice is believed to optimize plant growth, nutrient uptake, and flavor development.

3. Fostering Biodiversity:

  • Intercropping, companion planting, and cultivating a diversity of species create a vibrant ecosystem that benefits all inhabitants.
  • Beneficial insects thrive, pests are kept in check, and the garden becomes a resilient, self-sustaining microcosm.

4. Honoring Animals and Their Role:

  • Biodynamic farms often integrate livestock, recognizing their crucial role in nutrient cycling, soil fertility, and overall farm health.
  • Animals contribute manure for compost, grazing for weed control, and their unique energy to the farm's ecosystem.

The Rewards of Biodynamic Gardening

1. Nutrient-Rich, Flavorful Produce:

  • Biodynamic practices yield produce that is not only free of chemicals but also brimming with vitality and flavor.
  • The heightened nutrient density and vibrant energy of biodynamically grown food are often palpable to those who consume it.

2. Deeper Connection to Nature:

  • Biodynamic gardening cultivates a profound sense of connection to the natural world, fostering respect for the delicate balance of life forces that sustain us.
  • This intimate relationship with nature enriches both the gardener and the garden, fostering a sense of stewardship and gratitude.

3. A Path to Regeneration:

  • Biodynamic principles offer a roadmap for healing the Earth and restoring vitality to our food systems.
  • By nourishing the soil, honoring biodiversity, and embracing cosmic rhythms, we can participate in a movement that nurtures life and promotes a thriving planet for generations to come.

Delving Deeper into the Cosmos: Advanced Biodynamic Techniques

We've established the core principles and practices of biodynamic gardening, but the journey doesn't end there. For those seeking to truly connect with the cosmic rhythms and unlock the full potential of their gardens, several advanced techniques await exploration.

Honing Your Sensitivity to Cosmic Forces

1. Observing the Subtle: Planetary Influences

Each planet in our solar system exerts a unique influence on plant growth. For example:

  • Mars: Associated with vitality and action, Mars days are ideal for seeding fast-growing plants like lettuce and radishes.
  • Venus: Ruling over love and beauty, Venus days favor planting flowering ornamentals and nurturing delicate fruits.
  • Saturn: Known for structure and boundaries, Saturn days are well-suited for tasks like transplanting seedlings and pruning woody plants.

By keeping a keen eye on planetary movements and aligning your gardening activities accordingly, you can tap into these subtle cosmic forces and potentially enhance your yields and harvest quality.

2. Harnessing the Moon's Cycles: The Biodynamic Sowing Calendar

The moon's waxing and waning phases have long been recognized as potent influences on plant growth. Biodynamic sowing calendars, meticulously crafted to correspond with these lunar cycles, offer detailed guidance for optimal planting times.

  • Root Days: During the waning moon, focus on planting root vegetables like carrots, potatoes, and beets. The downward pull of the moon's gravity is believed to encourage vigorous root development.
  • Leaf Days: Under the waxing moon, prioritize leafy greens like lettuce, spinach, and kale. The moon's upward pull is thought to stimulate lush foliage growth.
  • Flower Days: The days surrounding the full moon are auspicious for sowing flowering plants, fruit trees, and herbs. The moon's heightened energy is believed to promote vibrant blooms and bountiful harvests.

3. Rhythms of the Zodiac: A Deeper Dive

For the truly dedicated biodynamic gardener, delving into the specific influences of the zodiacal constellations can add another layer of complexity and potential benefit. Each constellation is associated with different plant parts and qualities, offering further guidance for aligning your gardening activities with cosmic rhythms.

For instance, planting tomatoes under the sign of Leo (associated with fire and fruit) or sowing leafy greens under Libra (linked to air and balance) might be seen as particularly auspicious choices. However, mastering this level of astrological integration requires dedication and ongoing study.

Tools and Preparations for the Advanced Biodynamic Gardener

1. The Seven Preparations: Catalysts for Life

Biodynamic preparations are potent natural concoctions crafted from specific plant and animal materials. These preparations, numbered BD500 through BD507, each address different aspects of soil health and plant vitality.

  • BD500 (Horn manure): Enhances soil fertility and humus formation.
  • BD501 (Horn silica): Strengthens plant stems and resistance to disease.
  • BD502 (Cow manure): Stimulates composting and microbial activity.
  • BD503 (Chamomile): Promotes flower formation and fruit quality.
  • BD504 (Nettle): Enhances leaf growth and chlorophyll production.
  • BD505 (Oak bark): Strengthens root systems and resistance to pests.
  • BD506 (Dandelion): Balances soil moisture and nutrient uptake.

Mastering the application and timing of these preparations takes time and experience, but their potential to invigorate your garden and elevate your biodynamic practice is significant.

2. The Dowsing Rod: Intuition Meets Practicality

The dowsing rod, a simple Y-shaped tool, can be used to intuitively locate underground water sources, ley lines (energetic lines in the Earth), and even compost piles with optimal activity. While its scientific validity is debated, many biodynamic gardeners swear by the dowsing rod as a valuable tool for connecting with the subtle energies of the land.

Conclusion: A Lifelong Journey with Biodynamic Gardening

Biodynamic gardening is not merely a set of techniques; it's a lifelong journey of observation, experimentation, and deepening connection with the natural world. As you delve deeper into its principles and practices, you'll witness firsthand the vibrant life force coursing through your garden, responding to your care and resonating with the rhythms of the cosmos.

--
You received this message because you are subscribed to the Google Groups "Broadcaster" group.
To unsubscribe from this group and stop receiving emails from it, send an email to broadcaster-news+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/broadcaster-news/a59c6fa9-0bb9-42af-a418-4e4b64ecd723n%40googlegroups.com.

Rabu, 20 Desember 2023

Re: [MSAccessProfessionals] Experiment with Timer & VBS

Thanks Paul - that's of great help.
Thanks Crystal - Actually the calling application is not MS Access, its a VBS.

Best,
~ozair


On Mon, Dec 18, 2023 at 11:32 PM, crystal (strive4peace) wrote:

hi Ozair,

if you have something you want to schedule that runs from another database, one way to do it may be to link the the same tables that your application uses -- and import any queries or other code you might need.

kind regards,
crystal

On 12/18/2023 2:28 PM, Paul Baldy wrote:
Completely untested, but you can try GetObject instead of CreateObject, or perhaps the method Daniel shows at the top here:
 
 
Paul
 
------ Original Message ------
From: "ozair" <ozairkhalid@hotmail.com>
Sent: 12/18/2023 9:25:07 AM
Subject: [MSAccessProfessionals] Experiment with Timer & VBS
 
Hi,
 
This is an experimental task.
I wanted to call MS Access file's function from, from a VBS file.
It works good but when I again run the VBS, it opens ANOTHER instance of MS Access. (this is undesirable).

It should call the function without opening another MS Access file.
All subsequent calls to the function must be answered from the file already opened.
 
Idea's background;
The original idea is to avoid using TIMER inside MS Access file. Instead create a VBS that calls MS Access file's function.
That VBS is then added to Windows Task Scheduler. I hope this would help MS Access file remain stable.
 
TIA
~ozair 
 
 
'Code in the VBS file 
Set accessApp = CreateObject("Access.Application")
accessApp.OpenCurrentDataBase "C:\Users\ozair\Desktop\DB1.accdb"
accessApp.UserControl = true
accessApp.Run "HelloMsg"
 
 
'Function in MS Access file [Module]
Public Function HelloMsg()
    MsgBox "Hello World!", vbExclamation
End Function
 
_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116509) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Senin, 18 Desember 2023

Re: [MSAccessProfessionals] Experiment with Timer & VBS

hi Ozair,

if you have something you want to schedule that runs from another database, one way to do it may be to link the the same tables that your application uses -- and import any queries or other code you might need.

kind regards,
crystal

On 12/18/2023 2:28 PM, Paul Baldy wrote:
Completely untested, but you can try GetObject instead of CreateObject, or perhaps the method Daniel shows at the top here:


Paul

------ Original Message ------
From: "ozair" <ozairkhalid@hotmail.com>
Sent: 12/18/2023 9:25:07 AM
Subject: [MSAccessProfessionals] Experiment with Timer & VBS

Hi,
 
This is an experimental task.
I wanted to call MS Access file's function from, from a VBS file.
It works good but when I again run the VBS, it opens ANOTHER instance of MS Access. (this is undesirable).

It should call the function without opening another MS Access file.
All subsequent calls to the function must be answered from the file already opened.
 
Idea's background;
The original idea is to avoid using TIMER inside MS Access file. Instead create a VBS that calls MS Access file's function.
That VBS is then added to Windows Task Scheduler. I hope this would help MS Access file remain stable.
 
TIA
~ozair 
 
 
'Code in the VBS file 
Set accessApp = CreateObject("Access.Application")
accessApp.OpenCurrentDataBase "C:\Users\ozair\Desktop\DB1.accdb"
accessApp.UserControl = true
accessApp.Run "HelloMsg"
 
 
'Function in MS Access file [Module]
Public Function HelloMsg()
    MsgBox "Hello World!", vbExclamation
End Function
 

Re: [MSAccessProfessionals] Experiment with Timer & VBS

Completely untested, but you can try GetObject instead of CreateObject, or perhaps the method Daniel shows at the top here:


Paul

------ Original Message ------
From: "ozair" <ozairkhalid@hotmail.com>
Sent: 12/18/2023 9:25:07 AM
Subject: [MSAccessProfessionals] Experiment with Timer & VBS

Hi,
 
This is an experimental task.
I wanted to call MS Access file's function from, from a VBS file.
It works good but when I again run the VBS, it opens ANOTHER instance of MS Access. (this is undesirable).

It should call the function without opening another MS Access file.
All subsequent calls to the function must be answered from the file already opened.
 
Idea's background;
The original idea is to avoid using TIMER inside MS Access file. Instead create a VBS that calls MS Access file's function.
That VBS is then added to Windows Task Scheduler. I hope this would help MS Access file remain stable.
 
TIA
~ozair 
 
 
'Code in the VBS file 
Set accessApp = CreateObject("Access.Application")
accessApp.OpenCurrentDataBase "C:\Users\ozair\Desktop\DB1.accdb"
accessApp.UserControl = true
accessApp.Run "HelloMsg"
 
 
'Function in MS Access file [Module]
Public Function HelloMsg()
    MsgBox "Hello World!", vbExclamation
End Function
 

Re: [MSAccessProfessionals] Combining reports

Duane,

I Tried this option first and with a bit of formatting it worked. 

 

I was concerned because the reports do not pull information using the same ID number. 

 

But it worked.

 

Thanks,

 

 

 

Bill

 

Bill Singer

Group Benefits Consultant

Phone: 763-754-8898

Fax: 763-754-8496

Toll Free: 877-902-8898

Bill.Singer@at-group.net

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Thursday, December 14, 2023 4:22 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Combining reports

 

Hi Bill,

Have you considered placing the one page report into the report footer of the other report?

 

Duane

Sent from my mobile



On Dec 14, 2023, at 10:00 AM, Bill Singer <Bill.Singer@at-group.net> wrote:



I have a report due periodically.

In Access it is a combination of 2 reports.

  1. r_HealthPremiumCollectionFormAgeBandPost2024
  2. r_HealthPlanCobraPremiumSheet

 

The reports are completely different.  The date source is two different queries.  They are also formatted completely different.

Report 1 is a one page bunch of company information such as address, state, number of employees, benefit plan name, etc.

Report 2 is a one page of columns listed by age band.

 

Currently I run each report, convert them into a pdf and then combine the pages in a pdf program, save them and send them off.  It is a slow cumbersome process, especially when I have to do a lot of them.

 

Questions

Is it possible to combine these reports? The first on page 1 and the 2nd on page 2?

Is it possible to incorporate an automatic export to a pdf?

 

Anything to reduce a few steps.

 

Thanks for your help.

 

Bill

 

Bill Singer

Bill.Singer@at-group.net

 

 

 

[MSAccessProfessionals] Experiment with Timer & VBS

Hi,
 
This is an experimental task.
I wanted to call MS Access file's function from, from a VBS file.
It works good but when I again run the VBS, it opens ANOTHER instance of MS Access. (this is undesirable).

It should call the function without opening another MS Access file.
All subsequent calls to the function must be answered from the file already opened.
 
Idea's background;
The original idea is to avoid using TIMER inside MS Access file. Instead create a VBS that calls MS Access file's function.
That VBS is then added to Windows Task Scheduler. I hope this would help MS Access file remain stable.
 
TIA
~ozair 
 
 
'Code in the VBS file 
Set accessApp = CreateObject("Access.Application")
accessApp.OpenCurrentDataBase "C:\Users\ozair\Desktop\DB1.accdb"
accessApp.UserControl = true
accessApp.Run "HelloMsg"
 
 
'Function in MS Access file [Module]
Public Function HelloMsg()
    MsgBox "Hello World!", vbExclamation
End Function
 
_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116505) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Something strange - a hidden macro?!

Usually a ~ at the start of a file name is a temporary file created by the program that did not get deleted when there was an abrupt ending to a program.

On 12/17/2023 6:57 PM, Barry White via groups.io wrote:
I realize it's not helpful, but its TPS reports NOT EPS (earnings per share), there Mr. Burns....in homage to Homer Simpson's evil boss from none other than The Simpsons.

On Sunday, December 17, 2023 at 05:45:03 PM EST, Lists <peleg@pstrauss.net> wrote:


Perhaps try toggling Hidden Objects and Show System Objects.

Minggu, 17 Desember 2023

Re: [MSAccessProfessionals] Something strange - a hidden macro?!

I realize it's not helpful, but its TPS reports NOT EPS (earnings per share), there Mr. Burns....in homage to Homer Simpson's evil boss from none other than The Simpsons.

On Sunday, December 17, 2023 at 05:45:03 PM EST, Lists <peleg@pstrauss.net> wrote:


Perhaps try toggling Hidden Objects and Show System Objects.

Re: [MSAccessProfessionals] Something strange - a hidden macro?!

Perhaps try toggling Hidden Objects and Show System Objects.
_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116502) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Jumat, 15 Desember 2023

Re: [MSAccessProfessionals] Combo Box

hi Bill,

here's an article about the bug on accessforever.org dated Nov 25

https://www.accessforever.org/post/combo-box-auto-expand-may-not-work-correctly-in-windows-11

kind regards,
crystal


On 12/15/2023 4:59 PM, Bill Singer wrote:

Paco,

Is there a solution yet?

 

Bill

 

Bill Singer

 

Bill.Singer@at-group.net

 

 

 

From: MSAccessProfessionals@groups.io On Behalf Of paco@cellarinfo.com
Sent: Friday, December 15, 2023 4:02 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Combo Box

 

This is a known bug related (I think) to Windows 11. It has happened to some, but not all, of my combo boxes.

 

Paco

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Singer
Sent: Friday, December 15, 2023 2:29 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Combo Box

 

I have a combo box on a form that looks up my customers.

 

As I type, the combo box sorts the names and when I finally get the correct name I hit enter and the form move to the correct record…

 

Until today.  Now when I type the combo box does nothing most of the time.  When I type into the box it does not sort…with the exception of very few customers that have names that start with letters that are in the early part of the alphabet.

If I click the drop down button and type in the box, it sort correctly and will select the correct record. 

 

I have deleted and re-created the combo box multiple times.  Each time it acts the same.

I have even gone copied a combo box off of an old form that worked correctly, and it still acts the same. 

 

I even pulled a complete form from an old backup database and the Combo box still does not work.

 

The event is a Embedded Macro in AFTER UPDATE

Here is the Row Source  ..   SELECT [q_MainCustomerInput].[OrganizationName], [q_MainCustomerInput].[CustomersID] FROM q_MainCustomerInput;

 

Any thoughts?

 

Bill

 

Bill Singer

Bill.Singer@at-group.net

 

 

Re: [MSAccessProfessionals] Combo Box

Paco,

Is there a solution yet?

 

Bill

 

Bill Singer

 

Bill.Singer@at-group.net

 

 

 

From: MSAccessProfessionals@groups.io On Behalf Of paco@cellarinfo.com
Sent: Friday, December 15, 2023 4:02 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Combo Box

 

This is a known bug related (I think) to Windows 11. It has happened to some, but not all, of my combo boxes.

 

Paco

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Singer
Sent: Friday, December 15, 2023 2:29 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Combo Box

 

I have a combo box on a form that looks up my customers.

 

As I type, the combo box sorts the names and when I finally get the correct name I hit enter and the form move to the correct record…

 

Until today.  Now when I type the combo box does nothing most of the time.  When I type into the box it does not sort…with the exception of very few customers that have names that start with letters that are in the early part of the alphabet.

If I click the drop down button and type in the box, it sort correctly and will select the correct record. 

 

I have deleted and re-created the combo box multiple times.  Each time it acts the same.

I have even gone copied a combo box off of an old form that worked correctly, and it still acts the same. 

 

I even pulled a complete form from an old backup database and the Combo box still does not work.

 

The event is a Embedded Macro in AFTER UPDATE

Here is the Row Source  ..   SELECT [q_MainCustomerInput].[OrganizationName], [q_MainCustomerInput].[CustomersID] FROM q_MainCustomerInput;

 

Any thoughts?

 

Bill

 

Bill Singer

Bill.Singer@at-group.net

 

 

Re: [MSAccessProfessionals] Combo Box

This is a known bug related (I think) to Windows 11. It has happened to some, but not all, of my combo boxes.

 

Paco

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Singer
Sent: Friday, December 15, 2023 2:29 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Combo Box

 

I have a combo box on a form that looks up my customers.

 

As I type, the combo box sorts the names and when I finally get the correct name I hit enter and the form move to the correct record…

 

Until today.  Now when I type the combo box does nothing most of the time.  When I type into the box it does not sort…with the exception of very few customers that have names that start with letters that are in the early part of the alphabet.

If I click the drop down button and type in the box, it sort correctly and will select the correct record. 

 

I have deleted and re-created the combo box multiple times.  Each time it acts the same.

I have even gone copied a combo box off of an old form that worked correctly, and it still acts the same. 

 

I even pulled a complete form from an old backup database and the Combo box still does not work.

 

The event is a Embedded Macro in AFTER UPDATE

Here is the Row Source  ..   SELECT [q_MainCustomerInput].[OrganizationName], [q_MainCustomerInput].[CustomersID] FROM q_MainCustomerInput;

 

Any thoughts?

 

Bill

 

Bill Singer

Bill.Singer@at-group.net

 

 

[MSAccessProfessionals] Combo Box

I have a combo box on a form that looks up my customers.

 

As I type, the combo box sorts the names and when I finally get the correct name I hit enter and the form move to the correct record…

 

Until today.  Now when I type the combo box does nothing most of the time.  When I type into the box it does not sort…with the exception of very few customers that have names that start with letters that are in the early part of the alphabet.

If I click the drop down button and type in the box, it sort correctly and will select the correct record. 

 

I have deleted and re-created the combo box multiple times.  Each time it acts the same.

I have even gone copied a combo box off of an old form that worked correctly, and it still acts the same. 

 

I even pulled a complete form from an old backup database and the Combo box still does not work.

 

The event is a Embedded Macro in AFTER UPDATE

Here is the Row Source  ..   SELECT [q_MainCustomerInput].[OrganizationName], [q_MainCustomerInput].[CustomersID] FROM q_MainCustomerInput;

 

Any thoughts?

 

Bill

 

Bill Singer

Bill.Singer@at-group.net

 

 

Kamis, 14 Desember 2023

Re: [MSAccessProfessionals] Combining reports

as suggested, create a new report and put (drag) the two separate reports as sub-report.
if each separate reports are but 1 page long, you can separate them on each by adding a Page Break Control
between them on the new report.

On Fri, Dec 15, 2023 at 12:00 AM Bill Singer <Bill.Singer@at-group.net> wrote:

I have a report due periodically.

In Access it is a combination of 2 reports.

  1. r_HealthPremiumCollectionFormAgeBandPost2024
  2. r_HealthPlanCobraPremiumSheet

 

The reports are completely different.  The date source is two different queries.  They are also formatted completely different.

Report 1 is a one page bunch of company information such as address, state, number of employees, benefit plan name, etc.

Report 2 is a one page of columns listed by age band.

 

Currently I run each report, convert them into a pdf and then combine the pages in a pdf program, save them and send them off.  It is a slow cumbersome process, especially when I have to do a lot of them.

 

Questions

Is it possible to combine these reports? The first on page 1 and the 2nd on page 2?

Is it possible to incorporate an automatic export to a pdf?

 

Anything to reduce a few steps.

 

Thanks for your help.

 

Bill

 

Bill Singer

Bill.Singer@at-group.net

 

 

 



--
Arnelito G. Puzon


_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116497) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Combining reports

Hi Bill,
Have you considered placing the one page report into the report footer of the other report?

Duane

Sent from my mobile

On Dec 14, 2023, at 10:00 AM, Bill Singer <Bill.Singer@at-group.net> wrote:



I have a report due periodically.

In Access it is a combination of 2 reports.

  1. r_HealthPremiumCollectionFormAgeBandPost2024
  2. r_HealthPlanCobraPremiumSheet

 

The reports are completely different.  The date source is two different queries.  They are also formatted completely different.

Report 1 is a one page bunch of company information such as address, state, number of employees, benefit plan name, etc.

Report 2 is a one page of columns listed by age band.

 

Currently I run each report, convert them into a pdf and then combine the pages in a pdf program, save them and send them off.  It is a slow cumbersome process, especially when I have to do a lot of them.

 

Questions

Is it possible to combine these reports? The first on page 1 and the 2nd on page 2?

Is it possible to incorporate an automatic export to a pdf?

 

Anything to reduce a few steps.

 

Thanks for your help.

 

Bill

 

Bill Singer

Bill.Singer@at-group.net

 

 

 

[MSAccessProfessionals] Something strange - a hidden macro?!

All,
 
I'm working in Access 2016/365.
In an older (.mdb) database we're converting to newer versions, I found an object that exists in the database, but that is both invisible to the UI, and also Un-openable in any macro editor UI.
 
This Hidden Macro CAN be run (select the [Run Macro] Ribbon UI icon and overtype the macro name with the name of this hidden macro - and it indeed tries to run - but it errors out due to a bad pathname for some import step...and hence the need to edit and fix it.)
 
The macro is named with a leading ~ (tilde) character like the "hidden" queries embedded in forms/reports/control properties. So, Macro name is like: ~TmpEPSMacro   -  (in homage to those wonderful EPS reports from OfficeSpace)
 
I can only find it in the MSysObjects table data - but can't even force a name change through that (read-only data table).
 
An thoughts/suggestions as to how to deal with this...wonderful...ly....challenging macro!?

Re: [MSAccessProfessionals] Combining reports

You should be able to add report 2 as a sub report in report 1.

 

To automate an export VBA code like this should work:

DoCmd.OutputTo acOutputReport, " r_HealthPremiumCollectionFormAgeBandPost2024", "PDFFormat(*.pdf)", "Your path and report name.pdf", False, "", 0

 

 

Doyce Winberry

Manufacturing

Manager Systems

 

XPO

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 Bill Singer
Sent: Thursday, December 14, 2023 10:01 AM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Combining reports

 

I have a report due periodically. In Access it is a combination of 2 reports. r_HealthPremiumCollectionFormAgeBandPost2024 r_HealthPlanCobraPremiumSheet The reports are completely different.   The date source is two different queries.   They

ZjQcmQRYFpfptBannerStart

This Message Is From an External Sender

This message came from outside your organization.

ZjQcmQRYFpfptBannerEnd

I have a report due periodically.

In Access it is a combination of 2 reports.

  1. r_HealthPremiumCollectionFormAgeBandPost2024
  2. r_HealthPlanCobraPremiumSheet

 

The reports are completely different.  The date source is two different queries.  They are also formatted completely different.

Report 1 is a one page bunch of company information such as address, state, number of employees, benefit plan name, etc.

Report 2 is a one page of columns listed by age band.

 

Currently I run each report, convert them into a pdf and then combine the pages in a pdf program, save them and send them off.  It is a slow cumbersome process, especially when I have to do a lot of them.

 

Questions

Is it possible to combine these reports? The first on page 1 and the 2nd on page 2?

Is it possible to incorporate an automatic export to a pdf?

 

Anything to reduce a few steps.

 

Thanks for your help.

 

Bill

 

Bill Singer

Bill.Singer@at-group.net

 

 

 

[MSAccessProfessionals] Combining reports

I have a report due periodically.

In Access it is a combination of 2 reports.

  1. r_HealthPremiumCollectionFormAgeBandPost2024
  2. r_HealthPlanCobraPremiumSheet

 

The reports are completely different.  The date source is two different queries.  They are also formatted completely different.

Report 1 is a one page bunch of company information such as address, state, number of employees, benefit plan name, etc.

Report 2 is a one page of columns listed by age band.

 

Currently I run each report, convert them into a pdf and then combine the pages in a pdf program, save them and send them off.  It is a slow cumbersome process, especially when I have to do a lot of them.

 

Questions

Is it possible to combine these reports? The first on page 1 and the 2nd on page 2?

Is it possible to incorporate an automatic export to a pdf?

 

Anything to reduce a few steps.

 

Thanks for your help.

 

Bill

 

Bill Singer

Bill.Singer@at-group.net

 

 

 

Selasa, 12 Desember 2023

Titans Stage Miraculous Comeback to Stun Dolphins on Monday Night Football

In one of the most incredible comebacks of the NFL season, the Tennessee Titans stunned the Miami Dolphins 28-27 on Monday Night Football. With less than three minutes remaining in the game and trailing by 14 points, the Titans unleashed a furious rally that culminated in a game-winning touchdown with just seconds left on the clock.

The victory was a monumental one for the Titans, who improved to 5-8 on the season and kept their playoff hopes alive. It also dealt a major blow to the Dolphins, who had been riding high atop the AFC East and were considered one of the favorites to reach the Super Bowl.

Dolphins Dominate Early

The Dolphins seemed poised to cruise to victory early on. Quarterback Tua Tagovailoa was sharp, completing 20 of his 25 passes for 267 yards and two touchdowns. Running back Jeff Wilson Jr. also had a strong performance, rushing for 112 yards and a touchdown.

The Titans, on the other hand, struggled offensively for much of the game. Rookie quarterback Will Levis looked shaky at times, completing only 15 of his 30 passes for 187 yards. The Titans also committed several costly penalties, which helped the Dolphins maintain momentum.

Titans Mount Improbable Comeback

With the Dolphins leading 27-13 late in the fourth quarter, it appeared that the Titans were headed for defeat. However, Levis led the Titans on a pair of remarkable touchdown drives in the final minutes of the game.

The first scoring drive was capped off by a 15-yard touchdown pass from Levis to wide receiver Treylon Burks with 1:50 remaining. On the ensuing two-point conversion attempt, Levis found tight end Austin Hooper for the score, cutting the Dolphins' lead to 27-21.

Following a Miami punt, Levis and the Titans offense went back to work. Levis completed passes of 19 and 15 yards to move the ball into Dolphins territory. With just seconds remaining on the clock, Levis delivered a strike to wide receiver Nick Westbrook-Ikhine in the end zone for the game-winning touchdown.

Levis Shines in the Spotlight

Levis, who was making just his third career start, was the hero of the game for the Titans. He finished with 327 passing yards and two touchdowns, displaying a poise and clutchness that belied his rookie status.

"I'm just so proud of our guys," Levis said after the game. "We never gave up, even when things looked bleak. We just kept fighting, and it paid off in the end."

Dolphins Left to Rue Missed Opportunities

The Dolphins were left to rue their missed opportunities after the game. They had several chances to put the game away in the fourth quarter, but they were unable to capitalize.

"We just made too many mistakes," Dolphins coach Mike McDaniel said. "We had a chance to win this game, but we didn't take advantage of it. We need to learn from our mistakes and move on."

What's Next for Both Teams?

The Titans will look to build on their momentum when they host the Jacksonville Jaguars on Sunday. The Dolphins, meanwhile, will try to get back on track when they travel to face the Buffalo Bills.

Historic Comeback

The Titans' comeback was one of the most memorable in recent NFL history. It was the first time since 2003 that a team had overcome a 14-point deficit in the final three minutes of a game and won in regulation.

The victory also proved that the Titans are a team that can never be counted out. Despite their up-and-down season, they remain in the thick of the AFC playoff race.

Conclusion

The Titans' thrilling comeback victory over the Dolphins was a testament to the power of perseverance and never giving up. It was a game that will be remembered for years to come, and it served as a reminder that anything is possible in the NFL.

Key Statistics:

  • Titans: 327 passing yards, 2 touchdowns
  • Dolphins: 267 passing yards, 2 touchdowns, 112 rushing yards, 1 touchdown
  • Titans: 5-8 record
  • Dolphins: 9-5 record

Additional Notes:

  • The Titans were without star running back Derrick Henry for the second straight game.
  • The Dolphins were also without several key players, including wide receiver Jaylen Waddle and safety Jevon Holland.
  • The game was played at Hard Rock Stadium in Miami Gardens, Florida.
  • The attendance was 75,417.
 

--
You received this message because you are subscribed to the Google Groups "Broadcaster" group.
To unsubscribe from this group and stop receiving emails from it, send an email to broadcaster-news+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/broadcaster-news/f35d98ca-2075-4993-8f9d-e71145a3fe73n%40googlegroups.com.

Minggu, 10 Desember 2023

Electroculture Antenna: A Guide to Everything You Need to Know

Electroculture is a fascinating and growing field of agriculture that uses electric fields to stimulate plant growth. One of the key components of an electroculture system is the electroculture antenna. In this article, we will discuss everything you need to know about electroculture antennas, including what they are, how they work, and how to build your own.

References:


What is an electroculture antenna?

An electroculture antenna is a device that is used to create an electric field in the air. This electric field can then be used to stimulate the growth of plants. Electroculture antennas can be made from a variety of materials, including copper wire, aluminum foil, and even cardboard.

How do electroculture antennas work?

When an electric current is passed through an electroculture antenna, it creates an electric field around the antenna. This electric field can then be used to stimulate the growth of plants in a number of ways.

  • Increased cell division: The electric field can cause plant cells to divide more rapidly, which can lead to faster growth.
  • Improved nutrient uptake: The electric field can also help plants to absorb nutrients from the soil more efficiently.
  • Increased chlorophyll production: Chlorophyll is the pigment that gives plants their green color. The electric field can help plants to produce more chlorophyll, which can lead to increased photosynthesis and growth.
  • Enhanced disease resistance: The electric field can help plants to resist diseases by activating their immune systems.

How to build your own electroculture antenna

There are many different ways to build an electroculture antenna. One simple method is to use copper wire to create a spiral coil. The coil should be about 1 foot in diameter and 6 inches tall. The coil can then be mounted on a wooden stake and placed in the ground near your plants.

Benefits of using electroculture antennas

There are many benefits to using electroculture antennas. Some of the most common benefits include:

  • Increased yields: Studies have shown that electroculture antennas can increase yields by up to 30%.
  • Improved crop quality: Electroculture antennas can help to improve the quality of crops by making them more resistant to pests and diseases.
  • Reduced need for pesticides: Electroculture antennas can help to reduce the need for pesticides by making plants more resistant to pests.
  • More sustainable agriculture: Electroculture is a more sustainable form of agriculture than traditional methods because it does not rely on the use of chemicals.

Here are some additional tips for using electroculture antennas:

  • The best time to use electroculture antennas is during the growing season.
  • The antennas should be placed near the plants, but not so close that they touch the leaves.
  • The antennas should be turned on for at least 8 hours per day.
  • It is important to experiment with different antenna designs and configurations to find what works best for your specific plants and growing conditions.

Conclusion

Electroculture antennas are a simple and effective way to improve the growth of your plants. If you are looking for a way to increase your yields and improve the quality of your crops, then electroculture may be a good option for you.

--
You received this message because you are subscribed to the Google Groups "Broadcaster" group.
To unsubscribe from this group and stop receiving emails from it, send an email to broadcaster-news+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/broadcaster-news/bb9a9054-b8bf-42cc-b489-73415fa4e515n%40googlegroups.com.

Kamis, 30 November 2023

Re: [MSAccessProfessionals] Change background color

No problem!



Paul
Sent via mobile device


-------- Original message --------
From: Bill Singer <Bill.Singer@at-group.net>
Date: 11/30/23 12:13 PM (GMT-08:00)
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Change background color

Bingo,  good idea.  I forgot that was there.

 

Thanks,

 

Bill

 

Bill Singer

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Paul Baldy
Sent: Thursday, November 30, 2023 11:58 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Change background color

 

You can use Conditional Formatting with "Expression Is" testing the combo, or code in the format event of the section containing the textbox.

 

Paul

 

------ Original Message ------

From: "Bill Singer" <Bill.Singer@at-group.net>

Sent: 11/30/2023 9:39:53 AM

Subject: Re: [MSAccessProfessionals] Change background color

 

 

 

I am using equation this in the source field to change a text box on a Report based on a selection in a previous form

 

=IIf([Forms]![f_PremCollFormSetup]![cboNewPlan]=1,"X","")

 

It work fine, but rather than an X in the text box, I would rather turn the background of the box black so it stand out more.

 

I have not been able to figure out how to change the background property of a text box.

 

Any help would be appreciated.

 

Thanks,

 

 

Bill

 

Bill Singer

 

Re: [MSAccessProfessionals] Change background color

Bingo,  good idea.  I forgot that was there.

 

Thanks,

 

Bill

 

Bill Singer

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Paul Baldy
Sent: Thursday, November 30, 2023 11:58 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Change background color

 

You can use Conditional Formatting with "Expression Is" testing the combo, or code in the format event of the section containing the textbox.

 

Paul

 

------ Original Message ------

From: "Bill Singer" <Bill.Singer@at-group.net>

Sent: 11/30/2023 9:39:53 AM

Subject: Re: [MSAccessProfessionals] Change background color

 

 

 

I am using equation this in the source field to change a text box on a Report based on a selection in a previous form

 

=IIf([Forms]![f_PremCollFormSetup]![cboNewPlan]=1,"X","")

 

It work fine, but rather than an X in the text box, I would rather turn the background of the box black so it stand out more.

 

I have not been able to figure out how to change the background property of a text box.

 

Any help would be appreciated.

 

Thanks,

 

 

Bill

 

Bill Singer

 

Re: [MSAccessProfessionals] Change background color

You can use Conditional Formatting with "Expression Is" testing the combo, or code in the format event of the section containing the textbox.

Paul

------ Original Message ------
From: "Bill Singer" <Bill.Singer@at-group.net>
Sent: 11/30/2023 9:39:53 AM
Subject: Re: [MSAccessProfessionals] Change background color

 

 

I am using equation this in the source field to change a text box on a Report based on a selection in a previous form

 

=IIf([Forms]![f_PremCollFormSetup]![cboNewPlan]=1,"X","")

 

It work fine, but rather than an X in the text box, I would rather turn the background of the box black so it stand out more.

 

I have not been able to figure out how to change the background property of a text box.

 

Any help would be appreciated.

 

Thanks,

 

 

Bill

 

Bill Singer

 

Re: [MSAccessProfessionals] Change background color

 

 

I am using equation this in the source field to change a text box on a Report based on a selection in a previous form

 

=IIf([Forms]![f_PremCollFormSetup]![cboNewPlan]=1,"X","")

 

It work fine, but rather than an X in the text box, I would rather turn the background of the box black so it stand out more.

 

I have not been able to figure out how to change the background property of a text box.

 

Any help would be appreciated.

 

Thanks,

 

 

Bill

 

Bill Singer

 

Senin, 27 November 2023

Re: [MSAccessProfessionals] Change Value based on another value

Happy to help Bill!



Paul
Sent via mobile device


-------- Original message --------
From: Bill Singer <Bill.Singer@at-group.net>
Date: 11/27/23 9:13 AM (GMT-05:00)
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Change Value based on another value

Paul,

This worked perfectly.

Thanks

 

 

Bill

 

Bill Singer

 

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Paul Baldy
Sent: Wednesday, November 22, 2023 2:43 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Change Value based on another value

 

Something along the lines of:

 

Me.CTICRUHealth  = IIf(Me.CTICOBRACount > 19, 1, 2)

 

In the after update event of CTICOBRACount.  It could also be done with an If/Then block, as you prefer. 

 

Paul

 

 

------ Original Message ------

From "Bill Singer" <Bill.Singer@at-group.net>

Date 11/22/2023 10:22:41 AM

Subject [MSAccessProfessionals] Change Value based on another value

 

I am having a hard time figuring out best way to change the value of 3 fields on a form, based on the initial input in another field.

 

I have a form named         f_PremCollFormSetup

I have a field in that form called     CTICOBRACount

 

When a person enters a value into  CTICOBRACount and if that value is over 19 I want to set/change the value in the fields called  CTICRUHealth  and CTICRUDental to a value of 1

 

And if the value of CTICOBRACount is not over 19 I want to set/change the value to 2.

 

I am having a hard time figuring out where the best place to put this.  I am guessing in the AFTER UPDATE property of the CTICOBRACount field.

 

Do I use iff or If then… 

 

It has been a while since I had to add programming.

 

Thanks for your help.

 

Bill

 

Bill Singer

Bill.Singer@at-group.net