Profile

Cover photo
Jeffery Hallett
Works at Mindea LLC
Attended University of Illinois at Urbana-Champaign
Lives in Arlington Heights, IL 60004
137 followers|321,514 views
AboutPostsPhotosVideosReviews

Stream

Jeffery Hallett

Rants, Vents, Misc. Posts  - 
 
I haven't seen a mouse-ball mouse in the wild for several years. Good riddance.
How to Clean a Mouse Ball. It takes only two minutes to clean a computer mouse and get it back into perfect working condition. Try this method if your mouse ball becomes gummy, dirty or darker than its original color Remove the plate that...
6
1
Dennis W's profile photoAlex Taylor's profile photoCarlos Alberto Sierra Torres's profile photoMorio Murase's profile photo
6 comments
 
I have a ps2 Microsoft one and it's working perfectly
Add a comment...

Jeffery Hallett

Rants, Vents, Misc. Posts  - 
 
Can you top this?
Someone at one of my clients will end the year with 29,000 emails received in 2015.
Her Outlook inbox goes back to Jan 2014 and contains 56,000 emails.
Approximately 17% of her email relates to personal shopping (Sears, Victoria's Secret, Limited, etc)
And she calls about once a month to complain with "email problems".
She refuses to unsubscribe and organize. She insists on CCing herself on "important" correspondence.
It makes me a little crazy.
8
Benjamin Lindner's profile photoMike Parker's profile photoj0mah j0mah's profile photoJeffery Hallett's profile photo
29 comments
 
Gad, I just got on this woman's boss's computer. He has received 49,949 emails in the last 360 days. WTF. I would shoot myself.
Add a comment...

Jeffery Hallett

Discussion  - 
 
I have an Excel workbook with a data table on worksheet A and a pivot table based on that table on worksheet B. The data table's source is an Access query. This all works great. Save, reopens, refreshes the data -- all good.
Now I create a new worksheet (C) and add a different data table from a different Access query. Works great. Saves, reopens, refreshes the data -- all good.
Then I add another worksheet (D) and build a pivot table based on the table on worksheet C.
Everything looks fine. I save and close the workbook.
When I reopen it, the data on C table is fine, but the pivot table on D is EMPTY. The PivotTable Fields shows Column1, Column2, ... not the columns in table C.
I've been working on this for HOURS. I've created a dozen new workbooks and rebuilt everything. Worksheets A, B and C are fine, but the pivot table on D keeps reverting to blank. What the heck could I be doing wrong?
3
NhinZ Yasuham's profile photoJeffery Hallett's profile photoRaoul Litjens's profile photoPhilippe Grohrock's profile photo
6 comments
 
Now that might sound very basic, but how are you processing the Access query. Are you using PowerQuery or a direct source? Are you modifying things with PowerPivot?

I've made very good experiences with Access + PowerPivot and a very restrictive approach to what data I really need.

Those are rather generic hints, as I don't really know what kind of data you are processing and what exactly you want to show with it :) If you don't need raw data, you might also change your queries to aggregate your data, giving you a less bulky data model.
Add a comment...

Jeffery Hallett

General IT Discussion  - 
 
Question: say a workstation or laptop has both a connected LAN cable and is connected to a WiFi point -- which connection is used?
10
2
Mike Sackett's profile photoMister Marc's profile photoJohn Dearden's profile photoDarryl Gambrell's profile photo
52 comments
 
You wife is used. So are you. Get a life.
Add a comment...

Jeffery Hallett

Rants, Vents, Misc. Posts  - 
 
Does anyone like Ask.com? I can't imagine any IT admin does. But I looked at their Jobs page on their web site today. It actually looks like a cool place to work. Yes, I can be bought!
Come Play with Us! At Ask it's not all work and no play. In fact, we have a blast building products that 100 million people rely on for answers, everyday. Jump on our bandwagon -- we promise, it won't be a boring ride. Interested in current openings at our sister company Ask Partner Network?
9
Mike Rigsby's profile photoJeffery Hallett's profile photoKieron Seymour-Howell's profile photoKevin Durette's profile photo
32 comments
 
+Jan Bierbrauer "not everybody is satisfied with working for a scam tech support company from home office ;)"

Who said anything about a tech support company, scam or otherwise?
Add a comment...

Jeffery Hallett

Rants, Vents, Misc. Posts  - 
 
Dear clients: If you're going to ask for help, be prepared to receive help and contribute to the process. "There's something wrong with my computer. Please fix it. I'm leaving for Bali for 2 weeks." is not acceptable. Neither is initiating a chat to ask for help and then not responding to my inquiries for more detail etc.

Thanks!
23
2
David Nickel's profile photoAnthony Ellis's profile photoMorio Murase's profile photoI'm Iain's profile photo
25 comments
 
+Dennis Costea Jr. Was able to fix the share issue. Windows 10 you have recreate a user with the same login for the share. But scan to pc for the mfp still seams to be a issue I believe win 10 don't fall back to smb1 Auth even when forced. Connection from other windows, mac, and Linux works but I believe the firmware on the printer don't support smb2+. The manufacturer haven't responded to my ticket yet so I'm trying to pitch a cheap Nas unit for the printer sharing. With windows 10 and it's upgrade policy and registry changed that are made I don't think will stick when a new build is rolled out.
Add a comment...
In his circles
163 people
Have him in circles
137 people
Tigran Sarhatyan's profile photo
Joe Lewis's profile photo
Barry Smith's profile photo
Trent Dobbs's profile photo
Brian Blad's profile photo
Kenneth “Digital Dr.” Hawrylak's profile photo
Apps4Rent's profile photo
Dungeons & Dragons's profile photo
Tim Bowermeister (InLikeTim)'s profile photo

Jeffery Hallett

Rants, Vents, Misc. Posts  - 
 
I just spent several hours trying to get a workstation upgraded from Office 2010 to 2016. It kept crashing. I tried many obvious things, followed many suggestions, but the one that did it was to update the DisplayLink driver from v6.x to the latest version. Ta da. Who woulda thunk?

Found the answer here http://office2013issues.blogspot.com/2013/02/fixed-office-2013-has-stopped-working.html
3
Mark Swope's profile photoTimothy Hamlett's profile photoNoah Laws's profile photoBenjamin Lindner's profile photo
5 comments
 
+Noah Laws argh. You're right. Didn't notice enough that he's having this problem with the installtion/upgrade itself.
Add a comment...

Jeffery Hallett

Shared publicly  - 
 
Couldn't get Office 2013 or 2016 installed on a workstation. The article really helped. Turned out to be outdated DisplayLink driver. Ta da!
1
1
Ed's Computer Solutions's profile photo
Add a comment...

Jeffery Hallett

Rants, Vents, Misc. Posts  - 
 
Since when did it become OK to end a declarative statement with one or more question marks?
Ex: "The Firefox icon is gone from my desktop?"
or, "My Outlook contacts stopped syncing with my phone??"

Stop it, or I'm going to hit you in the head with a hammer????
15
1
Scott Miller's profile photoXander Warrender's profile photoShawn Maggard's profile photoJason Hunter's profile photo
29 comments
 
I have a question?
Add a comment...

Jeffery Hallett

General IT Discussion  - 
 
Hi all. A potential client regularly receives and retains -- in un-encrypted Exchange email -- credit card information from customers. I want to talk to them about the risk of this and suggest some more secure methods . . .  but I don't know any! The PCI DSS web site lays out guidelines, but only in a very general way. Can anyone dealing with this kind of thing offer some suggestions to get me started?
6
Ian Ray's profile photoShawn Tovey's profile photoCurtis A. DeHart II's profile photo
31 comments
Add a comment...

Jeffery Hallett

Rants, Vents, Misc. Posts  - 
 
About once a month for the past 9 years I spend 10-15 minutes on LinkedIn, after which I admonish myself for wasting 10-15 minutes of my life. Part of what keeps me going back is trying to figure out why the company is valued at 7+ billion dollars. Am I missing something? Does anyone here get any value from a presence on LinkedIn?
7
Timothy Hamlett's profile photoRodney Fletcher's profile photoZach Rogers's profile photoCombined Employees CU's profile photo
17 comments
 
It helps on my end as I use my personal account for the free business networking account. It does allow free marketing in yet another form of SM as well as communication. I do not see this being the same for everyone however.
Add a comment...

Jeffery Hallett

Rants, Vents, Misc. Posts  - 
 
Don't take too long to think about this one.
Your at work (not at home or like out in public) and you see this screen.
Which do you pick?
10
Victor Campos's profile photoHaroon Feroz's profile photoJoe Frayer's profile photoKieron Seymour-Howell's profile photo
62 comments
 
Here is another useful link that I found also:

How to Enable Outbound Rules
https://www.it.cornell.edu/services/firewall/howto/windows/tsp/outbound.cfm
Add a comment...
People
In his circles
163 people
Have him in circles
137 people
Tigran Sarhatyan's profile photo
Joe Lewis's profile photo
Barry Smith's profile photo
Trent Dobbs's profile photo
Brian Blad's profile photo
Kenneth “Digital Dr.” Hawrylak's profile photo
Apps4Rent's profile photo
Dungeons & Dragons's profile photo
Tim Bowermeister (InLikeTim)'s profile photo
Work
Occupation
IT Consultant. Technology advocate, instigator and integrator.
Skills
Lotus Domino, Microsoft Exchange, Microsoft 365, Linux, Windows, Microsoft Access, Security, Email.
Employment
  • Mindea LLC
    President, 1996 - present
    Owner and sole employee most of the time.
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Arlington Heights, IL 60004
Links
Story
Tagline
I get your Technology WORKING
Introduction
I've got nothing against plumbers, but I don't think of Information Technology as plumbing and I am not a plumber. If you're ready to make technology integral to your company's existence and growth, I can help you.
Education
  • University of Illinois at Urbana-Champaign
    English, 1975 - 1979
Basic Information
Gender
Male
Outstanding food. There are several Mediterranean places within 5 miles of my house, but this place is by far the best.
Public - 8 months ago
reviewed 8 months ago
Good food. Seems like a good price, too, except they almost always leave something out of my carry-out order. So I call them and they say, "come back and will give you the [fill-in-the-blank]". Right, I'm gonna drive an extra 15 minutes for my $4.00 felafel. This happens there A LOT.
Public - a year ago
reviewed a year ago
2 reviews
Map
Map
Map