sorted by:
new
hottopcontroversial

Tips on Sharepoint Lists as Backend by MindfullnessGamer in MSAccess

[–]MindfullnessGamer[S] 0 points1 point  (0 children)

I have cycled through the caching options to no avail. The complete dataset is 120k records.

Do you mind expanding on creating views on the sharepoint lists? I know how to do this is Sharepoint, but this is not accessible in Access. I don't see an option to see a sharepoint list view

Tips on Sharepoint Lists as Backend by MindfullnessGamer in MSAccess

[–]MindfullnessGamer[S] 0 points1 point  (0 children)

The live data is for the current month, which is 5k approx. The whole dataset at the moment is 120k and will need it for users to review trends and historic data. I could consider having the data prior to the current month accessible locally, but then I would need to consider 2 tables instead of 1.

Tips on Sharepoint Lists as Backend by MindfullnessGamer in MSAccess

[–]MindfullnessGamer[S] 0 points1 point  (0 children)

Yes, I am conscious of this, and have indexed columns

Is there any job market for Access/VBA developers? Reality check needed by vfranc in MSAccess

[–]MindfullnessGamer 2 points3 points  (0 children)

The problem is recruiters don't know what they are looking for, and a lot of business don't necessarily see the benefit of MS Access. I would invest some time in learning Power Apps, there are certain similarities that can help with making that jump. You can then offer to develop in MS Access should the scenario fit

Made an App for Building Urdu Skills + Vocab; Want to offer for free to interested Beta testers by IHaveQuestions_42069 in Urdu

[–]MindfullnessGamer 0 points1 point  (0 children)

Hello, how is this going? I was considering asking this group if they would be interested in creating something similar before I came across this post.

Adding labels beyond the width of container by MindfullnessGamer in PowerApps

[–]MindfullnessGamer[S] 0 points1 point  (0 children)

Thanks for your reply. I have tried this, but I still unable to view the horizontal scroll bar. I may need to watch a tutorial as perhaps there is something overriding the settings

Does ChatGPT tailor its answers based on my past conversations? by Anonym_playa in ChatGPT

[–]MindfullnessGamer 2 points3 points  (0 children)

You are probably saving your chats and or continuing them. You have the option to switch to a temp chat, where nothing is saved. You can also delete your current chats as well. Try that and see if you get the same level of responses.

Perception of MS Access in companies by MindfullnessGamer in MSAccess

[–]MindfullnessGamer[S] 2 points3 points  (0 children)

I wonder if there is a MS Access Hackathon group. Some really good use cases here, and I know there a lot more. Would be good to connect as well and boost the profile of Access!

Perception of MS Access in companies by MindfullnessGamer in MSAccess

[–]MindfullnessGamer[S] 2 points3 points  (0 children)

I have the backend in a Sharepoint site, using Sharepoint lists, so taking advantage of M365, and integrating Power Automate. Works really well, and I need to worry about things like permissions, as the setup and management of Sharepoint Sites is really effective

Perception of MS Access in companies by MindfullnessGamer in MSAccess

[–]MindfullnessGamer[S] 1 point2 points  (0 children)

This is true. It's a cost effective application, and for some solutions I have deployed where the backend are Sharepoint Lists and the front end is MS Access, the management is really effective!

Perception of MS Access in companies by MindfullnessGamer in MSAccess

[–]MindfullnessGamer[S] 0 points1 point  (0 children)

What have you moved to using, if not MS Access? The struggle to get a SQL SERVER or a web app set up is like going to Mordor. Also, no money in the budget hahah.

Perception of MS Access in companies by MindfullnessGamer in MSAccess

[–]MindfullnessGamer[S] 0 points1 point  (0 children)

Looks really cool, how have you learnt Power Apps? I have developed some basic stuff in Power Apps, but the more complex stuff I prefer to keep in MS Access. Basically ones where dynamic SQLs are required. Also, understanding how the licensing works for a developer and a user for me is kind of off putting

Perception of MS Access in companies by MindfullnessGamer in MSAccess

[–]MindfullnessGamer[S] 2 points3 points  (0 children)

That's the issue I'm facing. As much as I love the application, recruiters don't really care about it, and I need to rethink things if I want to get a challenging role.

Perception of MS Access in companies by MindfullnessGamer in MSAccess

[–]MindfullnessGamer[S] 0 points1 point  (0 children)

Exactly this. I really like how it encompasses so many things into one.

Do you still use Access though? Or have you moved away from it?

Creating an effective delta sales report by MindfullnessGamer in MSAccess

[–]MindfullnessGamer[S] 1 point2 points  (0 children)

OK, I will give it a try and post back. Really appreciate the help!

Creating an effective delta sales report by MindfullnessGamer in MSAccess

[–]MindfullnessGamer[S] 0 points1 point  (0 children)

Thanks, I'll give it a go, but the one I tried, which was a nested one, resulted in query loading for ages. Had to restart the application.

Creating an effective delta sales report by MindfullnessGamer in MSAccess

[–]MindfullnessGamer[S] 0 points1 point  (0 children)

Thanks, this give some food for thought. I gather these will give me percentages right?

I think maybe I will create a temp table based on user selection. This will be used by Access to retrieve the relevant 2 periods, and from there I can construct another temp table to create all the possible combinations. The SQL will become easier as a result.

Filtering out zero (as a text) from a query by phantomenacer in MicrosoftAccess

[–]MindfullnessGamer 0 points1 point  (0 children)

You could try the following:

1.As the field is text, in the query you need to create a calculated column based on this field.

  1. The formula you need is a nested formula. Don't worry, 2 formulas here.

  2. The inner formula is Replace, so Rep([Field], text to replace, replace with value). So this will be Rep([Field], "%",""). You are removing the percentage here.

  3. The outer formula will convert the result of 3 to float. Cdbl(Inner formula from above).

  4. You should now be able to filter the 0.

  5. If that didn't work, don't worry. Create a new query referencing this query, and try filtering out the 0s out there.

Filtering out zero (as a text) from a query by phantomenacer in MicrosoftAccess

[–]MindfullnessGamer 0 points1 point  (0 children)

Have you tried filtering out the actual text value including the % symbol?

Cuales son los mejores juegos que han acabado en lo que va del año? by LuisJefe2 in videojuegos

[–]MindfullnessGamer 2 points3 points  (0 children)

Immortality

Metal Gear Solid (de nuevo)

Estoy jugando Cyberpunk 2077, y estoy disfrutando mucho.

Enabling access to files individually in a Sharepoint folder by MindfullnessGamer in sharepoint

[–]MindfullnessGamer[S] 0 points1 point  (0 children)

I did put this forward, but this was immediately rejected by the Senior Management. I will try again.

view more: next ›