Recent content by Captain Frog

I got a litlle bit confused with the name Module! For me Module is an assembly of separate functions. The code running from a button on a form i'm use to call CBF (code behind the form) so I was incertain. This afternoon I imported the static class in my DB and coded a Raise error command behind...

Sorry for the primitiveness At the time I wrote the reply I wasn't sure whether it appeared for everyone or just for the privileged interlocutor. So I copied and pasted it as a precaution.

I downloaded Northwind 2.2 to see how the error handling was implemented and I have to admit that I didn't really understand everything. I'm not a complete novice in VBA but I quickly got lost in the explanations and codes. Is there, by any chance, a simple instruction manual that indicates...

Sorry, I didn't realize how primitively Access had been programmed. That's exactly what's explained in the video. Up until now I'd let Access take care of programming the basic navigation functions in a form to save time, but no more. I have a solid error recovery system in all my other forms...

Sorry, I didn't realize how primitively Access had been programmed. That's exactly what's explained in the video. Up until now I'd let Access take care of programming the basic navigation functions in a form to save time, but no more. I have a solid error recovery system in all my other forms...

Well it would be a lot of work I would have to replace all the private data with anonymous one . The error appears just after I get the usual warning from Acces: Relationship that specifies cascading delete are about to cause 1 record(s) in this table along with related record in related table...

Hi! I have a DB where I decided to convert some macro to VBA (delete, print, etc) Those macro behaved OK before, but now after conversion I get an error message if try to cancel the action. Runtime error 2501. The RunCommand was canceld. When I use the macro button everything is fine but the...

Well first of all thank you for all these information. Sharepoint lists seems the way to go.! I do have nevertheless some questions about user access. Until now my DB is build so that users never see the tables (only forms and reports) and I did implement a simple user rights access with...

Hey! I have developed a DB for my Sailing club. Nothing fancy nor big. About 230 entries for members and boats. The club has a MS 365 abo with SharePoint for 5 users, but actually only 3 person need access to the DB (President, Cashier and Harbor master). Until now I did not split the DB. It is...

Oh Great I'll have a look immediately. Thanks for the tip! Oh yeah it is a good idea to handle error in a centralised way, but what I miss is the bit what is most important for later comprehension of the database: when my code works it automaticaly fills the sub or function with a very usfull...

Hi I have a small function that I used many many time to create automatically an error handling whenever I write a new sub or function. It has been working flawlessly over years, from Access 2 until now. But now, for some reason it does not work anymore. It uses a form with a text control to...

Hi! I'm a long time Access developer although with long interruptions but I started again with access 2019 and developed a DB for my sailing club. I'm French but lives in Germany since many many years.