Viewing 15 posts - 1 through 15 (of 6,477 total)
In the long dark past where I maintained one such Access application, the only thing we published on the shared drive was a click-once application that installed itself to the...
January 29, 2020 at 7:30 pm
In terms of Access tricks that might help with lag: once you've moved the data to SQL server there isn't much rationale for requiring everyone to access the SAME access...
January 29, 2020 at 3:38 pm
I remember seeing the 4 decimal standard on commission/interest tracking purposes, so that you can limit the rounding error issues. when you're accumulating x % on a daily basis for...
January 16, 2020 at 4:40 pm
Thanks for sharing it. Great to see that cooperation is happening. Of course the cynic in me couldn't help but note there is no specific info as to WHEN the...
January 15, 2020 at 2:51 pm
Hey Matt, still interested to hear about the "administrative reversals," but only if it is NOT local to your company. If its just a local thing then never mind,...
January 10, 2020 at 4:12 am
So can you do this or can't you? The ONLY question you have to ask, is if the OP's design allows negative numbers. If the OP NEEDS to be...
January 9, 2020 at 7:11 pm
>> Given the request, pretty sure that debit and credits represent units in inventory NOT currency. <<
Why would you say "debit" and "credit" which are terms from...
January 9, 2020 at 2:40 pm
Why would you say "debit" and "credit" which are terms from accounting? What
January 7, 2020 at 5:23 pm
not sure I would jump to the conclusion that OP is wrong. Given the request, pretty sure that debit and credits represent units in inventory NOT currency.
As to just...
January 6, 2020 at 9:15 pm
So if I understand the request - you're looking to find the unused lots from a FIFO inventory system. or rather the remaining inventory by lot and inventory code.
January 6, 2020 at 3:43 pm
To add on to drew's comments you probably want to be clear about which state you want. it looks like for now you're lumping it in by state of residence,...
January 2, 2020 at 9:23 pm
Merry Christmas All, hope you enjoy the holidays (those of you that get them off 😉 ).
Won't lie, I really don't want to go see the latest Star Wars...
December 19, 2019 at 3:59 pm
Interesting topic! While I could see how one might argue against comparing yourself to others, I would caution against going too far onto the "snowflake path". Unique is great from...
December 11, 2019 at 4:52 pm
I love the technical historian brand of games. I call them a "brand" of games because they can take on a number of different flavors. For example:
October 30, 2019 at 4:54 pm
by without ODBC I am assuming you're meaning no direct linked tables within the Access front-end (you will be using ODBC or OLEDB in the end either way, since they're...
October 10, 2019 at 5:31 pm