Hi Jane
It sounds like they are blowing smoke. I'd give them an empty database and let them enter their own test data which is exactly what you've done. Keep us posted as to the outcome.
Regards,
Bill Mosca
Jumat, 26 April 2024
Re: [MSAccessProfessionals] HELLO AND HELP!
Hey Jane,
Thank-you very much for your reply!
Fingers-crossed...
Phil
Re: [MSAccessProfessionals] Sandbox environment
Thanks Bill.
It seems the company doing the asking don't really know what they're doing! They just wanted a copy of the database set up so they could play & not risk altering real data. So I've done that. They were throwing around a lot of terminology which meant nothing to me - trying to show off/bamboozle bosses, I suspect :-(
Groups.io Links:
It seems the company doing the asking don't really know what they're doing! They just wanted a copy of the database set up so they could play & not risk altering real data. So I've done that. They were throwing around a lot of terminology which meant nothing to me - trying to show off/bamboozle bosses, I suspect :-(
_._,_._,_
Groups.io Links:
You receive all messages sent to this group.
View/Reply Online (#116621) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]
_._,_._,_
Re: [MSAccessProfessionals] HELLO AND HELP!
Hi Phil
When you have the report open in design view, you should see 'Group & sort' on the ribbon, or if not, you can right click into a blank area of the report & you should get the right click menu items 'Sort & Group'. Then beneath your report you'll see <Add a Group> or <Add a Sort>. Click the <Add a Sort> & then select which fields you want sorted (Title) & in which order (probably A-Z ).
Best regards
Jane
Groups.io Links:
When you have the report open in design view, you should see 'Group & sort' on the ribbon, or if not, you can right click into a blank area of the report & you should get the right click menu items 'Sort & Group'. Then beneath your report you'll see <Add a Group> or <Add a Sort>. Click the <Add a Sort> & then select which fields you want sorted (Title) & in which order (probably A-Z ).
Best regards
Jane
_._,_._,_
Groups.io Links:
You receive all messages sent to this group.
View/Reply Online (#116620) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]
_._,_._,_
Kamis, 25 April 2024
[MSAccessProfessionals] HELLO AND HELP!
Gday to all,
MicroSoft often leaves me with the words of Mark Twain:
UNDER CERTAIN CIRCUMSTANCES, PROFANITY PROVIDES A RELIEF DENIED IN PRAYER
So it is, yet again. Im running WIN11 with Office 365, ACCESS ver. 2007-2016 [paid for by the year]
I know how to get a REPORT started... all I need to die happy is, learn how to make a REPORT, "report" my data in alphabetical order — as it appears in the table — HOW ACCESS decides on the order of each record, slays me — and how to make the Report Wizard NOT include "TITLE", each time a record is printed. I tried & errored myself into figuring column width, number of columns, etc.
I want to print-out a list of movie titles, in what MS used to call snaking columns, having finally caught-on-to the new nomenclature "Columnar" despite the "look" of TABULAR, in the wizard, representing what I want.
My ACCESS Dummies book has been less than useful, especially since, ripping-out pages in wild, maniacal frenzy, then hurtling the book against a wall. As Woody Leonhard — beta tester since 1.1 — has assured us, the best we can do, is think of ourselves as victims.
Thanks for all your time & guidance.
Phil
Selasa, 23 April 2024
Essential Guide To Safe Well Water Maintenance
If your home relies on well water, ensuring its safety and quality is your direct responsibility. Contaminated well water can harbor harmful bacteria, viruses, and chemicals that pose serious health risks. This comprehensive guide will arm you with the knowledge and best practices to maintain your well and ensure your family's drinking water is safe.
Why Well Water Maintenance Matters
- Health Protection: Well water must be free from contaminants that can cause illness, particularly for vulnerable populations like infants, the elderly, or those with compromised immune systems.
- Long-Term Well Functionality: Preventative maintenance prolongs the life of your well system, reducing costly repairs and replacements.
- Peace of Mind: Staying on top of well inspection and management allows you to trust the water you drink and use.
Key Steps for Maintaining Your Well
1. Well Construction and Location
- Professional Installation: Hire licensed well drillers to ensure proper construction, preventing surface water contamination.
- Safe Site: The well should be situated away from potential contamination sources like livestock areas, septic systems, or chemical storage.
- Uphill Placement: Wells installed on a slope should be uphill from contamination sources.
2. Regular Well Inspections
- Annual Checkups: Schedule yearly inspections with a qualified well contractor to assess your system's overall condition.
- Look for Changes: Monitor your well for any signs of damage, including cracks in the casing, a damaged or missing well cap, or pooling water near the wellhead.
- Professional Assistance: If you detect any issues, contact a well professional immediately for repair.
3. Water Testing
- Annual Testing (Minimum): Test your water for bacteria and nitrates at least once a year with a certified lab.
- Contamination Suspicions: Immediately test your water if you notice changes in taste, odor, or color.
- Nearby Activities: Test more frequently if activities near your well increase the risk of contamination (e.g., agriculture, new construction).
4. Maintaining the Wellhead
- Secure and Sanitary Well Cap: Ensure your well cap is tightly sealed and free of cracks. It should have a vermin-proof screen over the vent.
- Ground Slope: The ground around the well should slope away to prevent water pooling.
- Keep it Clear: Maintain a clutter-free area around the well to limit pest habitats and simplify inspection.
5. Protecting Your Well from Contamination
- Safe Distances: Keep known contamination sources (septic systems, livestock, fertilizer storage) well away from your well, following your local regulations for distances.
- Mindful Chemical Use: Avoid using pesticides, herbicides, or fertilizers near the well.
- Proper Waste Disposal: Never dispose of hazardous, chemical, or medical waste near your well.
Additional Tips
- Well Records: Keep detailed records of well construction, testing results, and any repairs or maintenance.
- Treatment Systems: If water tests indicate contamination, consider installing a suitable water treatment system.
- Unused Wells: Decommission abandoned wells according to professional guidelines to protect groundwater.
The Importance of Professional Well Contractors
Always seek the expertise of licensed well contractors and pump installers for construction, repairs, and in-depth inspections. They possess the knowledge and tools to keep your well system operating effectively and safely.
By diligently following these guidelines, you'll significantly safeguard your family's health and ensure the longevity of your well water supply.
--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/85802019-0992-4bdb-b3f6-3fd8632554f1n%40googlegroups.com.
Senin, 22 April 2024
Re: [MSAccessProfessionals] Sandbox environment
Hi Jane
Coming up with a test database after a live database is in use can be very tricky.
First off, you will need data that is not live. That is something you will have to deal with. My applications always start out with test data as I develop so I can easily present that data to testers if required, but having to create new test data on the fly is tedious at best. Can the live data be altered enough to point primary keys to fake entities?
Secondly, you will need to build a front end that is linked to the test database and restricted to users doing the testing.
I hope this gives you some idea as to where to start.
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
MS Access MVP 2006-2016
My Nothing-to-do-with-Access blog
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Jane via groups.io
Sent: Monday, April 22, 2024 11:51 AM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Sandbox environment
Hi all
I've been asked to create a sandbox environment for an existing database, so that another company can go through it & try out some scenarios, not on live data.
I understood that you usually create a Windows sandbox on your own PC for development work, but that it's not something that you share. Am I hopelessly out of date / my depth? :-)
Any advice/help gratefully accepted.
Thanks
Jane
Langganan:
Postingan (Atom)