r/MSAccess

Hey everyone
Good morning

I use Rubber duck VBA Add In
So I test all logical code easily (automatic testing by code)

However I am struggling to test UI stuff without changing the actual program status

I don’t want my test to create changes in the production or design environments

Can anyone help me in this matter?

Microsoft's stated plans show that Access is in a state of "sustained maintenance".

If you are Considering MSAccess Migration to SQL? Access DB replication? Serious Statistical Analysis Tools with full AI support and Multi-Lingual capability?

GitHub has a free open source replicator built by Ron O'Hara

First ever post, but some people in the office have been having printing errors with Access as of late and I wanted to see if this was an in office issue or a problem with our version of the software.

When printing a report with multiple pages, the first page will format to fill a whole page as usual but the pages after will print really tiny and in the upper left corner of our printer paper. These are reports we run daily, and up until last week this hasn’t occured. The report previews look fine but still print incorrectly, and we haven’t made any changes to our reports so there shouldn’t be a sudden switch regardless.

Any advice would be much appreciated, I just wanted to see if this was a known bug and if we should revert back to an old update if it is.

I've been looking recently for a solution to have a group footer in a report print at the bottom of the page.

The common solution I could find online seems to be to put it in your page footer and apply conditional visibility; which is great if you have a really small footer, otherwise you lose space on every page (no good to me).

The other solution I found was to use MoveLayout, however this seems to have set positions that it will use on the page only? So I can get it lower, but not really where I want it or at the bottom of the page.

I came up with my own solution, which is to just compare the top value on the group footer on format event to where I want it to be, and then add the difference to the group footer height and the top position of each element within.

This seems to work well for me and my printer/page settings aren't really going to change, however I'm aware that this would be an issue if anything changed. I'm planning to change the offset amount to consider the group footer and page footer heights, but I'd like to avoid using a static value for the usable page height (so it's more generally usable) and I don't know how I can actually determine this value in the VBA?

Or is there a better approach to solve this problem entirely?

I just opened a office DB that I use on a daily basis and I have a message saying the VBA cannot be opened and needs to be deleted.
Is there a way out of this?
My file is only the front end and is located on a shared disc. There are 3 other occasional users.

For various reasons, i need to build a db that can be used on windows AND mac os.

I have developed many personal and work systems on access over 20 years, but need to be able to build a relational db on windows and MacOs. I am well versed in access, tables, forms, vba.

I am thinking about libre office base.

Anyone have experience with this, or alternative suggestions?

Thanks in advance.

Hello, I am requesting an honest look from those who have more familiarity with MS Access and VBA. I was hired on to work as a MS Access Developer for my organization of over 300 people where multiple people use a database at a time, however, I just started and have not had much experience learning Access or VBA. Long story short, I have other transferrable skills and come from a background in General IT.

So my responsibilities involve supporting very high level Access Databases with VBA built in, but they appear to be a mess. There is no documentation, and I am the sole person that can work on the databases. I am doing my best to get up to speed, but I am still lost went it comes how I can fix the issues that arise regarding the multiple databases. For example, a pressing issue is one of the databases needs to be rebuilt because the ACCDB file has been lost and we are just operating off the ACCDE file. The person who original built these retired during COVID and left no documentation. There is lot of VBA written in as well. A couple people before me came and left so there is no one I can go to for help with how to properly support the databases. Any help is few and far in between. (I know, a lot of red flags)

My main question, is it honestly realistic for essentially a Junior Access Developer to be capable of fully supporting multiple Access Databases within a short timeframe? It feels like I would need to become an Access Wizard with expert-level VBA, but without much input or resources. I am asking my organization to provide some resources (either in third-party consulting or paying for learning courses), but I do have in mind that they might just try and find someone else that can do the job.

This post is also a bit of a request for input from others more experienced than I, and how you would tackle this situation if you were in my shoes.

I appreciate any input. Feel free to ask any questions on areas that need more detail.

Got some end users saying our reports are not showing everything correctly. Took a look at it and it seems some machines have what might be a bad update. Solid lines on a report in Print Preview (or physical printouts) are not shown, but visible on Report view. If I change the type to something like "solid dash" instead of "solid", they show. Is Microsoft aware of this bug, and how fast do they typically release a hotfix for something like this?

Hey everyone

I am using a class module to create a form instant enforcing my common logic across all forms including events triggered behavior

Now I want the form to record time open and time close when I tried to include this logic in my form this part doesn’t work however other events fire just fine

I instantiate the class in the declaration area at the same line I create new class like this

Dim Form as New FormCM

In the desired form in on load event I pass some parameters to the class and that is it

Can any one tell me why the on open event doesn’t fire in my case?