|
In agreement with others, depending upon the nature of the issue (VB or database related), post the question in either the VB or database forum.
If you detail that this is for MS Access 2013, people will be generally willing to help when the can.
I don't use Access much myself, but do use VBA extensively in Excel.
|
|
|
|
|
|
Because Access, like VB, sucks big hairy donkey schlongs.
".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Now is the schlong itself, hairy, or just the accompanying junk?
|
|
|
|
|
All of it.
".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
if you think access is bad you obviously never used DataEase, what a wonderful system that was a relational database that allowed MULTIPLE unique keys, you would think that naming the key unique would have given them a hint that there should be only one, wouldn't you!
You cant outrun the world, but there is no harm in getting a head start
Real stupidity beats artificial intelligence every time.
|
|
|
|
|
Well, mathematically, uniqueness always refers to a specific set of elements. I can therefore easily imagine definitions of overlapping sets with multiple keys that are all unique within their own set of reference, but not within the union of all elements of all sets.
To give an example: number plates on cars are guaranteed to be unique within the country that issued them. However, there may be identical alphanumeric sequences that are valid number plates in different countries. Since in many countries number plates do not (always) contain country codes, you'd need multiple keys, that are only locally unique.
That said, I agree you should name those keys appropriately, e. g. LUID (as opposed to GUID).
GOTOs are a bit like wire coat hangers: they tend to breed in the darkness, such that where there once were few, eventually there are many, and the program's architecture collapses beneath them. (Fran Poretto)
|
|
|
|
|
we are not talking user defined fields but the internal unique key assigned to a record, PKid in the vernacular, a system defined seeded auto incrementing Int and yet you could still end up with duplicates
You cant outrun the world, but there is no harm in getting a head start
Real stupidity beats artificial intelligence every time.
|
|
|
|
|
Ouch, I see your point. Reminds me: "How can you trust a man that wears both a belt and suspenders? Man can't even trust his own pants." (Once upon a Time in the west)
GOTOs are a bit like wire coat hangers: they tend to breed in the darkness, such that where there once were few, eventually there are many, and the program's architecture collapses beneath them. (Fran Poretto)
|
|
|
|
|
You'll have gathered from some of the uninformed comment that Access is not a popular development tool, at least not for professional developers. That's the main reason there is unlikely to ever be a forum for it here.
Like all tools it has its strengths and weaknesses. As a back-end, I'd never advocate Access unless it for a single user on a single machine. As a front-end for CRUD operations and applied to a small group of knowledgeable users (e.g., in-house) it's one of the most powerful tools around. 2013 has given it a nice modern facelift. I myself have created many quite powerful applications in Access, in very short turn around times. You can add input constraints and customized validation code and error handling, but the smarter you have to make the application (for a dumber user base), the less the attraction as a tool.
At what point you would choose a more sophisticated programming environment is a matter of choice, but writing it off as lightly as others above have is either trolling or prejudice based from ignorance.
Life is like a s**t sandwich; the more bread you have, the less s**t you eat.
|
|
|
|
|
Nice reply Phil! I agree with everything you just said! Now, if they'd at least give us views in SQL Compact I could find a suitable replacement for about a third of my customer base who are single user small operations...but I already know there are ways around the lack of views, but they can make life so much easier.
"Go forth into the source" - Neal Morse
|
|
|
|
|
I bet you cannot write a Clippy Add-On for Lotus Notes in AccessVB.
|
|
|
|
|
Now that is both cruel and mean - I couldn't write that in any language for the sheer physical pain both Clippy and Lotus Notes give me!
GOTOs are a bit like wire coat hangers: they tend to breed in the darkness, such that where there once were few, eventually there are many, and the program's architecture collapses beneath them. (Fran Poretto)
|
|
|
|
|
Oh please give him an Access forum, then Access questions won't pollute the database forum and we can all ignore it. Except of course those who actually make a living from building on that platform.
And yes I went from SuperBase to Access in the 90s and then to SQL Server, I have never gone back and do not regret the moves!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I had quite a bit of fun and a little agony creating databases which are indistinguishable from full blooded database applications. I found it very easy to develop beautiful interfaces which gave just as much or as little access to the underlying db structure as I do with ASP.Net and WPF.
All well structured companies need products that can meet the needs of low budget customers so MS Access is likely to be around for a while, buy there are no real changes going on for the platform and there are already many resources out there for it and they already have much more to offer than would accumulate quickly here. You are better off using those resources.
|
|
|
|
|
Because all the crazy CP members are in the Lounge, not out creating forums.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
Why? Just do a count of the number of Access questions every day. And anyone who is not sure whether to use VB or Database can always go to QA.
|
|
|
|
|
|
Seems more like Cupid's bow[^].
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
Why is "Hippopotomonstrosesquippedaliophobia[^]" such a long word?
[edit]linky fixed - stupid "paste truncate" bug [/edit]
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
modified 12-Feb-15 11:44am.
|
|
|
|
|
Link fail.
What do you get when you cross a joke with a rhetorical question?
---
The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism.
---
Do questions with multiple question marks annoy you???
|
|
|
|
|
The "Paste truncate" bug again: if you highlight text and paste a link over it, the link can get truncated but the text remains as the link text.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Because you misspelled[^] it?
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
Nope! The "Paste truncate" bug again: if you highlight text and paste a link over it, the link can get truncated but the text remains as the link text.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
I'm talking about the double-p in the middle, a serious addition I would say...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|