Draw the Moon on Access Reports using VBA
HTML-код
- Опубликовано: 7 сен 2024
- Draw the moon on Access reports using VBA in any phase, any position, any color, any size! VBA code that's easy to call from your reports. Access is only limited by your imagination.
Send the report object, coordinate for the center and radius for the Moon. Optionally, you can choose colors, fraction covered in light, and waxing or waning.
The code that does the drawing is all in one module that you can easily import into your projects. The Moon uses the Circle method.
Get the VBA code and download sample database:
msaccessgurus....
Thanks to Juanjo Luna for helping with the Spanish captions.
Contact me for training ... Access, Excel, Word, PowerPoint ... and drawing with VBA
kind regards,
crystal
Let's connect and team-develop your application together. I teach you how to do it yourself.
msaccessgurus.com
======================
Spanish translation by Juanjo Luna Aleixos
¡Dibuje la luna en los informes de Access usando VBA en cualquier fase, cualquier posición, cualquier color, cualquier tamaño! Código VBA que es fácil de llamar desde sus informes. El acceso solo está limitado por tu imaginación.
Envíe el objeto del informe, las coordenadas del centro y el radio de la Luna. Opcionalmente, puede elegir colores, fracción cubierta de luz y creciente o menguante.
El código que hace el dibujo está todo en un módulo que puede importar fácilmente a sus proyectos. La Luna usa el método del Círculo.
Obtenga el código VBA y descargue la base de datos de muestra:
msaccessgurus....
Contáctame para capacitaciones... Access, Excel, Word, PowerPoint... y dibujo con VBA
atentamente,
cristal
Conectémonos y desarrollemos en equipo su aplicación juntos. Te enseño a hacerlo tú mismo.
msaccessgurus.com
"Access is only limited by your imagination" Very true and yours, like your Access skills, know NO limits. Very Impressive Crystal!
thanks, John! The moon has been keeping me up at night. And I've been researching it lots. Wanted to write an equation to calculate it's position but not so easy since the moon revolves around Earth, which revolves around the sun, which revolves around the big black hole in the Milky Way! It takes 27.3 actual days for the moon to orbit Earth, but because of the changing positions, it appears to be, on average, about 29.5 days for us, an observer on Earth, from one new moon to the next ... so I loaded 200 years of official moon data as I'm planning to hook it up to my CalendarMaker ... sometime!
ps, John, analyzing the moon data, the time from one new moon to the next ranges from 29.27 days to 29.83 days -- so using an average wasn't working good enough for me. Time between primary phases ranges even more ... 7.4 days ± 19 hours (6.58-8.24 days)