Search results

The tag you two reference, is that the "Tag" property in the Other tab at the bottom in 2016?

I am trying to prevent changes to specific controls when a record is not new to prevent accidental editing and to have more control over when an edit occurs. Is there a way to check on a form if the record is new and if not, locked and disable a series of controls along with changing their...

I do agree with that. Personally I always prefer dark theme as I am prone to headaches and having darker screens makes them no quite so frequent.

Dark theme. Always. :ROFLMAO:

You would still want to log changes when a discrepancy arises though, correct? If the DB shows having x and you confirm you only have y, you would want to log that before simply adjusting.

I cant determine how to do the table structure for handling cycling counting. Do I need an audit table? Or is one table with before/after quantities enough? Do I need to lock tables while the DB is in "cycle count mode" to prevent records from changing? I can see so many different possible...

Ah that makes sense. I also just noticed the custom ribbon and am reading up on how to do that because that is really nice. It looks really professional, makes it look like a standalone application that isnt just Access and saves space on the forms while not having buttons repeat across said...

I managed to finally snag the new Northwind and I was really surprised when I opened the relationship window to see a huge spiderweb. I always thought that you shouldn't be able to trace your way from point A to point B via multiple paths as that would mean a possible circular problem (excluding...

Indeed it does! The main problem I was grappling with was not cutting words into pieces but am reading that thread now. I like the module JDraw shared. The one I currently use to deal with strings that are too long doesnt care about cutting words apart as that is just how it is done in the...

That looks like it will have the answer for this thanks!

I need a little assistance in coming up with a formula to split a string apart based on length. This is part of a module to export a recordset to an Excel file template for import into my companies system. If IsNull("Description") then 'do nothing' Else If Len("Description") > 60 then...

That may have been why I was told early on to never bother with Integer as there is no reason to use it over Long.

I have a friend who is also learning VBA and Access (more Excel than Access, but still) who asked me last night what datatype is best to use and surprisingly I didn't really know the answer. All I know is Long can go out to like 2 billion but doesn't do decimals, double I am not sure on its...

Ive used Isla's code for that as well. I haven't managed to get it to work without being really clunky though.

I believe the version I have is the old one. Now as to which version, I am not entirely sure. I do use code to hide the ribbon and such that I found from one of your post but I wont implement it until the DB is ready to distribute. Out of the couple Access apps I have made (or butchered...

I had looked at that but I don't like disabling things that people generally expect to work as I think it makes things even more clunky in the long run. Should I not use the current Northwind as a reference point? I liked the layout of the forms for the most part and how the navigation was...

I model a lot of my forms from Northwind where they have "hyperlinked" fields to click that open other forms. I have started using buttons/combos more and more however to handle navigation due to the problems I described in OP with my current methods.

This is a best practice question. Should there be a module that, when someone just closes the DB via say the X in the top corner, to handle all the forms closing and unloading? I have a couple users that love to just close the DB when they are done rather then backing out of it and closing it...

I have not done a query quite like this before so could use a little help. I know the field names I am about to show are awful but I have no control over them so don't beat me up too badly. Goal: Find all [Sales Register #] where [Extened Price] (yes that is spelled wrong, I know) matches...

So what you are saying Doc is that Windows askes nicely the first time then not nicely the second time :ROFLMAO: