|
|
I'm waiting for the naysayers to ask why on earth you would consider using Access for anything. Just the other day I came across a system still using Access 97 databases for the backend. This is a fairly popular (in my niche) inventory system...It may be popular, but it really sucks as it can only ever provide values at a point in time, not for a point in time like all the others I've dealt with. Of course my manager forces me to spend days trying to match a report that was printed a week prior.
Sorry to have hijacked your question...I think Database is the right forum. Of course you could always just submit in QA.
"Go forth into the source" - Neal Morse
|
|
|
|
|
This is a typical Access app. It was created by someone who needed a small tracking system and over time it morphed into a mid to large size app.
They have plans to create an enterprise level app, first to SQL Server, then into .Net/Web/Mobile.
kmoorevs wrote: .I think Database is the right forum.
I considered it, but this isn't really a data question. It's more about the VBA than anything else.
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
I've had considerable experience with Access and VBA but I sure wouldn't admit it in polite conversation.
if (Object.DividedByZero == true) { Universe.Implode(); }
Meus ratio ex fortis machina. Simplicitatis de formae ac munus. -Foothill, 2016
|
|
|
|
|
The answer is always to do the steps manually while recording a macro.
|
|
|
|
|
Surely you have a daily backup that you keep for a month before you replace it with the monthly backup! I learnt this was the best solution for reproduction of Access stuff in the 90s.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: Surely you have a daily backup
Good idea, but not my call. It would probably work, but I refuse to put any more time into interfacing with a system using Access 97 databases ...I mean, c'mon, at least move them to 2K!..or better yet, rewrite the application to use SQL Server!
"Go forth into the source" - Neal Morse
|
|
|
|
|
Yup when dealing with stubborn idiots who won't listen it is sometimes correct to let them shoot themselves in the foot. I told you so can be very satisfying sometimes.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Just stick it in QA and tag it appropriately;
"SQL, ADO.NET, Entity Framework, c#, c#3, c#4, c#5, MVC, MVC3, MVC4, MVC5, Oracle, VB.Net, VB"
Well, that's what everyone else does anyway.
|
|
|
|
|
|
[^]
Jeremy Falcon
|
|
|
|
|
The code supported by Access would be VBA. So the VB forum would be the right place.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Tip: use SQLite, it is more portable and Open Source, so you arent locked in the Microsoft universe.
Press F1 for help or google it.
Greetings from Germany
|
|
|
|
|
|
Thank you
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
Is a cowboy a bull?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Now that's just udder nonsense.
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
could be a steer? [author crosses legs]
Sin tack
the any key okay
|
|
|
|
|
Is a callgirl a good helping hand?
|
|
|
|
|
That's just the demo.
Software Zen: delete this;
|
|
|
|
|
Do bulls engage in cowpokes?
(We'll milk this for all it's worth).
Ravings en masse^ |
---|
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
|
"... stars will ultimately be cutoff from the reservoir of star stuff."
I always thought stars would eat pretty much anything (that's not more massive than itself).
Sin tack
the any key okay
|
|
|
|
|
The gorgeous color view is a composition of image data from narrowband filters, mapping emission from the nebula's atomic oxygen, hydrogen, and sulfur into blue, green, and red hues.
We often forget that these amazing pictures have no bearing on what the human eye would see.
Marc
Latest Article - Create a Dockerized Python Fiddle Web App
Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
Artificial intelligence is the only remedy for natural stupidity. - CDP1802
|
|
|
|
|
Marc Clifton wrote: amazing pictures have no bearing on what the human eye would see While true, it's amazing in its own way, that we can visualize these things.
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|