Search results

I've been bitten more than once by a backup device going to sleep before my nightly back up job ran. And I don't even have IT to interfere help me run backups.

Please join us at the Access Pacific Chapter for our Monthly Presentation at 6:30PM Pacific (UTC -8) on February 6th, 2025. Adam Waller will join us to discuss his Access Version Control add-in. It's available at Adam Waller's Github Site Adam will lead a “Developers’ Walkthrough”, reviewing...

For an example of how one can manage stock for orders, download and study how we did it in the Northwest Developer Edition template. You can also watch a couple of videos in which two of the team who created the templates explain Orders and Inventory.

BTW, Nothing was ever FailSafe, nor ever will be. 😉

What Tom suggested... Look at the options for Task Scheduler tasks. Put MSAccess.exe in the Program to Run Setting. Add the appropriate command line setting to open a specific accdb and run a specific macro when that accdb opens. For details, you can search online for command line options for...

Hurry up and wait, Doc.

" The asset management offered by MS s very basic..." All of Microsoft's templates are starting points for further customization, not Turn Key applications.

Thank you. Maybe we are talking about two different things, though. You say, "... I close the main menu in the user's computer..." I was referring, not to a menu in an Access application, but Access itself. @The_Doc_Man has offered some resources that may be helpful in resolving the...

The default behavior is that an accdb opens on the monitor where it was displayed the last time it was closed. How does your code determine the default monitor?

"....a) all tab page subforms are loaded into memory. " If you use the so-called Lazy Loading approach, that can be avoided. You only put the subform into it's tab page subform control when that tab page gets focus. This does require coding that the navigation form doesn't require to achieve...

Hm. "...not what I want." Sometimes, when working with a relational database, we have to relinquish "what we want" and adopt "what actually works". The nature of relational database dictates what is, and what is not, effective. Is that possibly the case here? I am referring to the subform...

I am a firm believer in the idea that being explicit is better than naively accepting the implicit in almost every aspect of a database. For better or worse, Access is very good at accommodating ambiguous references, such as not bothering to specify the target fields in an insert query. But in...

Given that scenario, I agree with @MajP then. Azure SQL might be overkill for this particular situation. On the other hand, Azure SQL is essentially a version of SQL Server "in the cloud", so whatever factors would apply to SQL Server would be more or less applicable to Azure SQL. In either...

LOL, Chatty got it mostly right. I recognize a lot of that text, which comes directly from blogs and announcements about the NW2 templates. I might even have contributed to some of it. Tom vS did write some of it for sure. To make a long story short, and appropriate to your requirement...

I understand there is a way to remove the toggle switch for enabling New Outlook by setting a registry key. I learned about that earlier today. Unfortunately, I think reverting back once the change has happened is a lot more difficult. That article talks about a PowerShell command to remove New...

Oh, don't tempt me. I have one eye on "New Outlook" all the time.

You can migrate the data from Access tables to SharePoint lists. Perhaps the cautions you read pertained more to moving the accdb itself to SharePoint, which is not advisable. A few years ago, Albert Kallal gave a presentation to our Access User Group on SharePoint with Access. You should...

I am sure that's closer to the truth than is comfortable.

Thanks for the extended overview. Our problem is that the first and only reference we have to where he came from is the entry to the US through Ellis Island, in which our ancestor indicated he was from Ireland. There is no way to even verify that that much was true. His written history begins...

Phillip Stiefel's presentation on COM add-ins is now on the AUG YouTube channel. I'm editing Geoffrey L. Griffith's presentation on using VSTO to create COM add-ins. I'll upload it to YouTube soon, I hope.