Access Experts: General discussion thread for Access Zone (9-Sept-2013)

This thread is intended for general discussion among Experts participating in the Access zones.  

Discussion topics can include (but are not limited to) Access and zone related issues, tips, tricks, news, events etc.

This thread is publically visible, so please keep comments professional.  If you do have topics that should be handled off-line, please contact myself, mbizup, or IrogSinta at our e-e.com email addresses (i.e. JDettman@e-e.com).

Thanks,
Jim Dettman
MS Access Topic Advisor

Previous Discussion Thread:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28141204.html
LVL 60
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nick67Commented:
<shame>
How do I follow a question without actually posting inane things, like this post, to it
</shame>
0
mbizupCommented:
Nick,

Click the "Monitor" button in the left-hand sidebar.

(although it probably looks like an 'Unmonitor' button to you now that you have posted  :-)  )
0
Dale FyeCommented:
Nick,

You should see a "Monitor" button either on the left side of your screen, or along the bottom of your screen.  That will add it to your "My monitored Questions" list.  It will also change the caption to "Unmonitor" so if you get bored with the thread, you can "unmonitor" it.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

aikimarkCommented:
Originally posted in the Access Expert Notify thread (i.e. bat signal)

Here is a helpful hint for queries and VBA code when dealing with null-able columns.
When you want to check that the column has a non-zero (or zero) length, use the following syntax.
SQL:
Where Len([mycolname] & "") <> 0    'non-zero length and Not Null
Where Len([mycolname] & "") = 0      'zero length and Not Null

Open in new window

VBA:
If Len([mycolname] & vbNullString) <> 0 Then    'non-zero length and Not Null
End If
If Len([mycolname] & vbNullString) = 0 Then      'zero length and Not Null
End If

Open in new window

It makes for simpler query syntax and code than checking for both Null values and the Length of the text in the column.

In a VB6 environment with unbound controls, you might avoid the problem of assigning a null value to a textbox by concatenating the vbNullString constant during your assignments.

============
I keep forgetting this and hope that posting it would help me remember.  Also, it isn't sufficiently long enough to constitute an article.

============
IrogSinta commented that he uses
If [mycolname] & "" = "" Then        'zero length

Open in new window

http:Q_28234401.html#a39481733

I explained that the Len() function is more efficient than string comparisons:

Strings are complex data structures that include both the text and the length of the text.  If you compare strings (<, <=, =, <> , >=, >) code has to first find the string with the lesser length and set up a comparison iteration for the characters in the strings.

If you use the Len() function, it gets the readily available datum out of the data structure.  Also, numeric comparisons, especially integers, are usually handled in registers and do not involve any floating point operations/circuitry.  This is why they are faster.

Way back in the 90s, I did some testing of common VB statements and demonstrated the string versus number performance differences to the local VB/Access user group.  This difference extends into If...Then and Select Case statements.  Although your code might be easier to understand if string comparisons are made, you will pay a performance penalty in high volume and critical situations.
0
Dale FyeCommented:
Anyone else experiencing problems with EE rendering its pages properly.  I've tried both IE and Firefox and neither is rendering properly?
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Same for me - IE, Firefox and Chrome all rendering incorrectly. Hopefully just a glitch ...
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I'm cool with Chrome ...
0
Nick67Commented:
IE 10 good but mobile onSamsumh SII has lost  its mind
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Started working again about 30 mins after I posted.
0
Nick67Commented:
The mobile site is still shot on my Galaxy SII
-------------------------------------------------------------------------
@mx
:)

"how long are your procedures"
Sub Questions:
  " how long is this question?"
  " how long are the posts?"
lol

You ain't seen nothin'
http://www.experts-exchange.com/Database/Oracle/Q_28232168.html#a39500250
0
omgangIT ManagerCommented:
Just noticed today that if I view an image posted to a Q, once I close the browser tab it opened in, I become logged out of EE and have to log back in to access the Q in the original browser tab.  I believe this is new but can't remember the last time I opened/viewed an image posted in a Q.  I'm using iE10.
OM Gang
0
Dale FyeCommented:
Just wondering what happened to the post titled:

Looking for Access expert to upgrade DB from Access 97

I know there is a "job board" feature in the current version of EE, but never figured out how to advertise my availability since they took the "Hire Me" button off of the user profile.
0
Dale FyeCommented:
Posted a new article "Sorting data in forms and lists" last night.  

Editor reviewed and approved it, but would appreciate any comments you guys might have as well.
0
mbizupCommented:
Has anyone seen this issue (or have the tools to test it)?

The OP's problem seems to be limited to Access 2013/Windows 8.1:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28302279.html
0
Nick67Commented:
Something's wonky with the date stamping in this Q
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27238758.html

We weren't working on it two+ years ago :)
Anybody noticed any others with wonky posting dates?
0
mbizupCommented:
Nick,

Was it possibly a stray email that prompted you to ask that?  The file that Dale posted in the question looks like it WAS created  2+ years ago.

I haven't seen anything odd with dates that appear in questions, but I do see the occasional odd email alert for questions that have seen no activity in a very long time.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerAuthor Commented:
Only thing odd I've noticed is that I've gotten a slew of "Your article was used in a solution" e-mails in last day or so.

I didn't have time to check them out.

Jim.
0
Nick67Commented:
"Only thing odd I've noticed is that I've gotten a slew of "Your article was used in a solution" e-mails in last day or so."

Bingo.

I could have sworn it wasn't that long ago I chimed in on that question -- but it really was August 2011.  At the time, I got the 500 point article bonus, and then on 27-Nov-13 I got the bonus again.

Articles and the points you get for them are funny things!
0
omgangIT ManagerCommented:
<<Only thing odd I've noticed is that I've gotten a slew of "Your article was used in a solution" e-mails in last day or so.>>

I received on Friday 11/29 a 'New Rank' notification email.  I was a bit confused (not necessarily abnormal) as I didn't have any answered questions and didn't think I was anywhere near a new rank.
OM Gang
0
omgangIT ManagerCommented:
@Netminder
Thank you.
0
Dale FyeCommented:
Miriam,

Are you playing with the "name" feature on the personal profile as well?

I wonder whether if you change that now, whether the posts you made as "Someone you  know" will still show up with that name, or whether it would show up with the new name?
0
mbizupCommented:
<< interesting >>

In a good or bad way?
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Pictures ... bout time, lol. Cool!
0
Dale FyeCommented:
Eric,  I could see how that could be confusing.  Especially with Miriam trying to decide whether she is "Someone you know" or "Da Man"!

Maybe they need to allow you to modify your site options to display the UserID or the Display name.  It will also make it harder to lookup answers posted by mBizup, or will the search feature allow you to search by either UserID or Display Name?
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Not quite seeing the point of changing your user name. For years peeps know you as DatabaseMX (example) and suddenly you are ImWayCool ... huh ?  Seems like a bad idea.
Just sayin' ...
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I say the username should not be allowed to change (if you want to do that, go to Match.com). Instead, retain the original UserName ... with an *option* of ... AKA

DatabaseMX
(aka  Jammin Joe)

mx
0
mbizupCommented:
The note on the edit feature explains the intent...
<<
 We recommend using your real name so that everyone can know how awesome you are.
>>

I've seen a lot of people starting to use it in that spirit.

(Not my cup of tea, though... )
0
Dale FyeCommented:
It could be a bit confusing, but you will continue to see the users UserName or ID, or whatever EE calls it in the Profile.  Note that Miriam is now "not my real name".
0
mbizupCommented:
One of the potential perks for a lot of people is that it instantly and dramatically reduces internet 'footprints' for people who might have regrets about choosing a username too close to their own.
0
Dale FyeCommented:
Well that would be interesting, I could change my Display Name to netminder and really confuse some people.  I'm leaning towards a 2 on a scale of 1-to-10 on the good idea scale.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
As I noted above - if anyone noticed:

I say the username should not be allowed to change (if you want to do that, go to Match.com). Instead, retain the original UserName ... with an *option* of ... AKA

DatabaseMX
(aka  Jammin Joe)
0
Mark WillsTopic AdvisorCommented:
People who want to be anonymous will choose a "username" while others may well choose their real name.

That's pretty obvious.

And others still will want to protect their real identity, or maybe cash in on history of blog and or twitter names. Being already fully awesome as that identity...

But whatever the "show me as <this name>" option is, it must be unique or have a right of ownership. Which is why usernames were invented in the first place - right ?

I guess this new feature is the opportunity to change your username so people no longer see the unawesome name of an otherwise fully awesome expert.

might change mine to Rose Byanyothername Stillstinksgreat.
0
Dale FyeCommented:
Actually, it provides me with an opportunity to change my display name when I need to ask one of those questions that an 2nd year Access developer should know but which I just cannot resolve during one of those over 50 "brain fart" moments.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerAuthor Commented:
High time for the changes (real names and pictures).

I think it was a great idea.  Raises the bar so to speak.   People like to know who their dealing with.

Jim.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerAuthor Commented:
<<Well that would be interesting, I could change my Display Name to netminder and really confuse some people>>

 While in the short term it might cause confusion, you could also bet your a$$ that you'd be out of here real quick if you did.

 And it is an AKA type thing.  I've caught a couple of places where my member name is displayed right along with my display name.

 Most forums have this and it's never been a problem on any that I've seen.  Most will change their avatar (picture) on whims, but wanting to change a handle is rare.

 In fact more often then not, in places where they can't, they usually express a very valid reason for wanting to change.  In fact I've wanted to change 'JDettman' to 'Jim Dettman' for many years now.

Jim.
0
Dale FyeCommented:
Jim,

I'm not encouraging anyone to do that, just saying there is potential for abuse.
0
Jim P.Commented:
Well for years I've been known around the tech sites as jimpen or Jim P. with the login still being jimpen.

So I'm glad EE finally implemented it. But it doesn't really matter to me.
0
Kyle SantosCustomer RelationsCommented:
Does anyone know:

1)  If there is a limit to how many times you can change it?

2)  Will there be a public record of formerly used 'Usernames' like Steam (Valve) allows their users to do?
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I don't see anywhere I can enter a Display Name or a profile picture on my profile. Am I missing something?
0
Dale FyeCommented:
Scott,

Just above your userID you should see an "add your name" hyperlink
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I don't see that on my profile:No username link
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerAuthor Commented:
<<I don't see that on my profile:>>

 Your not in the right place, your editing your account, not your profile.   Just click on your memeber name to get to your profile.

Jim.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I found it ... thanks ..
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerAuthor Commented:
For everyone else, here's what you should see:

screen shot profile pic change and display name change
Also as an FYI, a webinar is in the works covering all the new features with profiles.

Jim.
0
Nick67Commented:
The Achievements listing is badly out of whack in terms of time-frame.  A zealot is defined as earning 500K point in a month.  I am currently listed as a zealot--but I am just shy of 600K points lifetime, certainly not in a month.

And then there's the workspace, which shows me as only having participated in 42 questions, which is not accurate by a long shot either.  A lot of things have been tweaked, reset and recalibrated in the last almost two years.  Change is inevitable.  I'm not certain that it is always good, though.  I don't know if the decision process to truncate things like question history was made -- or it was unintentional.

And, @netminder, it has been almost 2 years, and we are still staring at this lightbulb-bright white background.  It is what it is, but it would be nice if long-standing issues got dealt with first, before tweaks and new features roll out.
0
Dale FyeCommented:
Is anyone else annoyed by the excessive white space around code blocks in questions and articles?  If so, you might want to pile on my feedback.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerAuthor Commented:
I tried to edit the question and can't tell if the extra line feeds were typed in for sure or not, but it looks like they were.

Not sure what you guys are seeing in regards to color scheme, but my background is fairly dark.  Certainly not white or light-bulb bright.  You might want to adjust your monitors.  Your contrast may be off or the "temp" of your monitor may be a bit too vivid.

Beyond that,  I think it's pretty obvious at this point is that they have no plans to change it.

Jim.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Not sure what you guys are seeing in regards to color scheme, but my background is fairly dark.
+1 for me. I have absolutely no issue with the color scheme, but then I use f.lux to modify my settings dependent on the time of day (my office has quite a few windows, and can get very bright at times) so may have different settings than most.

Plus, I have 4 monitors. 2 of them are quite different in terms of color/brightness.
0
Dale FyeCommented:
Scott, does F.lux allow you to customize all 4 monitors independently?
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerAuthor Commented:
Time to close this one off.  New thread:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28329950.html

Happy new year everyone!

Jim Dettman
MS Access Topic Advisor.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.