Experts Exchange

98

Solutions

340

Contributors

We connect you with people and information to solve problems, inspire learning and influence the future of technology.

Share tech news, updates, or what's on your mind.

Sign up to Post

FallProduct-SocialMedia-Native--1-.pngOur Fall Product Updates are here! Check out what is new, updated, and improved on Experts Exchange.
2
Tech or Treat! - Giveaway
LVL 10
Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Tech spooks aren't just for those who are tech savvy, it also happens to those of us running a business. Check out the top tech spooks for business owners.
3
Want to receive fewer emails but still keep up with what's happening at Experts Exchange? Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
3
Hello, EE Experts!

I wanted to make sure that all Apple users understand what's going on with the new Wi-Fi (WPA2) vulnerability "KRACK."

Apple is working on a fix to roll out as soon as possible to all its users. They've stated that there is a fix for this vulnerability in the beta versions, but that the fix is not in the latest update you have on your device.

So, what can you do?

Don't connect to Wi-Fi at hotels, coffee shops, or anywhere outside your place of business or home. Even at your house or area of work use a VPN.

Wait, even at my house?

Yes. Essentially the attacker can read all the information that is being transmitted wirelessly throughout your home. That said, if you use a VPN you're making an encrypted tunnel around the information you're sending and not relying on the WPA2 protocol that should keep your data safe. So, even if the attacker is looking at the data on your home network, the VPN is making it unreadable.

Also, if you're out and about, please turn off the Wi-Fi capability on your iPhone or iPad. By turning off the Wi-Fi, you're making your iPhone or iPad solely dependent upon cellular data, which is not susceptible to this attack.

Where can I get a VPN?

I use Encypt.me because it's fast, simple, relatively cheap, and works on all of my devices without In-app purchases. However, there are free VPNs that you can grab …
3
Hello

I am new to Experts Exchange, I came across it when searching the internet for help with VBA UserForm coding.  I landed on https://www.experts-exchange.com/questions/28706684/VBA-Code-to-Populate-Userform-with-Existing-Records-Edit-them-and-add-them-back-to-the-worksheet.html  which not only answered my search but helped me to complete my UserForm.  Basically, the form on that thread was exactly what I was doing.  So I downloaded the solution and set about completing my form, copying and editing the code.

All was going well considering I haven’t used VBA for years (10+) and my coding skills are a bit rusty.  My problem is when I test my form I get “runtime error 9: subscript out of range” for the SEARCH, ADD and UPDATE buttons.  Set ws = Sheets("Sheet4") seems to be causing the problem.

I’ve also noticed that if I start the form from any other sheet than the sheet with the data in it the form is basically empty.  Since I have set the Workbook to open on the USER GUIDE sheet, as this has a button to open the form, this causes a problem.

Well as I say I’m a bit rusty and I’ve been at this for days, reading and re-reading the code, search after search online as well as VBA Help, and now I think I have gone code blind (can’t see the wood for the trees) and my rusty skills are making it hard to find what’s wrong.  If someone could take a look at the attached file and point me in the right direction I would be most grateful.

The above thread was solved by …
0
Have you enrolled in this month’s complimentary course? Enroll now for a free Microsoft SQL Server and Database Concepts course. Get 7+ hours of step-by-step SQL training, including possible topic interview questions.
0
[Webinar] How to Protect Against Ransomware
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.

Watch this webinar to learn:
  • What is ransomware and why does it hurt?
  • How to prevent ransomware
  • How to create and implement a recovery plan

With a proper disaster recovery plan in place, you don’t have to fear the worst, should your company become a target of ransomware.
1
New Here. Will I receive email notifications of replies to my posts?
0
MAR-3453-TechOrTreat-nativeAd-revise.jpgWe are preparing for Halloween by sharing our scariest tech experiences and how we uncovered the solution. Submit you #TechorTreat article today, share it on social media, and be automatically entered to win one of four tech prizes. Check out the prizes and learn more here http://bit.ly/2ymXihs
3
Hello, EE Experts!

If you haven't already updated your iOS devices to 11.0.3, please do so. I've tested it out (it's only been out two days), and it seems stable. That's it! Take care everyone.

Side note: Be on the lookout for my article on the Apple Watch 3 Series with LTE, since my wife and I are pushing them to the limits to give you the best information on whether or not you should buy one.
6
 
LVL 14

Author Comment

by:Justin Pierce, CEH
Someone has to. ;)
1
 
LVL 123
already upgraded!
1
Important Lessons on Recovering from Petya
LVL 10
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
6
when i view the EE questions list, everywhere i move the mouse  - it causes popups to appear, usually in front of the questions i try to read - very frustating
can this popup be disabled?
0
I am new in this Crystal Reports thing and I have problem, since my coworker usually doing this stuff is sick at home I need to figure it out my self. I have 2 tables.

First is like this:

Article.ID    Article.name Article.buyingprice
1              aa           2.00
2              bb           1.00
3              cc           3.50
4              dd           4.20
5              ee           2.00

And second is like this:

Income.ID Income.article  Income.date  Income.number Income.quantity
1          2               79100        P1            2.00
2          1               79100        P1            3.00
3          4               79101        P2            2.00
4          3               79101        P2            1.00
5          1               79101        P2            4.00
6          5               79101        P2            1.00
7          2               79103        P3            15.00

What I need is formula for selecting Income.quantity from the latest Income document. For example for article aa it will be 4.00 and for article bb it will be 15. Please save my job folks :)

Report is grouped by article.name.
0
It’s time for spooky stories and consuming way too much sugar, including the many treats we’ve whipped for you in the world of tech. Check it out!
4
Oh, here's another technology I'd like to learn: Google Apps Scripting. There's a lot of common things I do with Google Docs & Sheets on a regular basis and being able to automate some of it seems pretty handy. I know EE has a ton of great stuff about VBA scripting for Excel, Word, and such, but I mostly work in Google Apps and I've had no info at all about scripting for those products. (I honestly expected the Google apps might not have been mature enough to support scripting, but I was completely wrong about that!)

Just looked up Google's documentation site for it, and the whole thing is based on JavaScript (I'm not good at JavaScript, but I'm at least familiar with some basics). That also means I've got plenty of experts in-office and on the site for when I need help :-)

Will have to start experimenting with it this weekend!
1
v2-native-ad-no-button.pngDo you work with and analyze data? Enroll in October’s Course of the Month to get step-by-step SQL training. Learn SQL to quickly and efficiently store and retrieve data!
0
native-ad-no-button.pngOctober’s Course of the Month is available! Enroll today to get 7+ hours of step-by-step Microsoft SQL Server training.
4
Good morning, EE Experts!

I read an interesting article about both Macs & PCs being vulnerable to a firmware attack. To sum up the piece, some Macs weren't updating their firmware when their dutiful owners were performing common updates. Once notified of the issue Apple immediately jumped on it and fixed the problems. In short, if you update to macOS High Sierra your Mac will automatically check every week for firmware updates. As for you PC enthusiast, I recommend that you check your manufacturer's website for any new firmware updates. Have a great Monday everyone and take care.
3
onsite-native-ad-no-button-2017-sept.pngAccess to September’s Course of the Month expires in 2 days! Enroll today in our VMware Professional - Data Center Virtualization course.
1
Free Tool: ZipGrep
LVL 10
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

How to Increase the Priority of your Question
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signaling to participating experts which questions need more immediate resolutions.

Low priority questions, for example, may just be an inquiry, while a medium priority may involve a deadline. A high priority question is best described as something that needs immediate attention, such as a server outage or similar issue that could halt production at your company.

Check out how to ask a priority question today!

For more information, check out our on-site article.
4
August and September have been big months for VMware—from VMworld last month to our new Course of the Month in VMware Professional - Data Center Virtualization. We reached out to Andrew Hancock, resident VMware vExpert, to have a more in-depth discussion about the growth of this field.
7
iOS 11Good morning, EE Experts!

Apple released iOS 11.0.1 yesterday, which fixes the pesky Exchange bug that was stopping users from emailing out. This does not squash all bugs or problems found with iOS 11 since its release, but that doesn't mean it's still not a solid update from iOS 10. That's it for the big Apple news!

Side note: I'll be submitting my iOS 11 tips and tricks article to the EE gods and goddesses soon, so be on the lookout for it.
4
 
LVL 98

Expert Comment

by:John Hurst
FWIW IOS 11.0.2 just came out today. Working fine.
2
 
LVL 14

Author Comment

by:Justin Pierce, CEH
I just grabbed it too. ;)
0
v2-twitter-2017-september-ad.pngDon’t miss the chance to add VMware virtualization skills to your resume. Five days remain to enroll!
5
 
LVL 8

Expert Comment

by:Senior IT System Engineer
So if I enrol today, can I still access it on the next month ?
2
 
LVL 17

Expert Comment

by:Kyle Santos
You have 30 days from the date of enrollment to complete it for free.
3
UpdateGood morning, EE!

Today is the release of macOS High Sierra, the OS that many of us Apple geeks want on our Macs as of yesterday. It will be available for download at 1 PM EST, so make sure that you have your ducks in order before you make the switch.

Here is a short list of things to consider before upgrading:

1) Update your antivirus application and perform a full scan. What? Your Mac doesn't have an antivirus? Well, then you might be carrying malware with you to the new OS. Even if your Mac hasn't been showing the classic signs of being infected, you might be smuggling Windows viruses into your new operating system. (No, Windows viruses don't infect Macintosh computers, but that's no reason to keep them around.)

Side note: It's important to know that malware is growing for Mac with no end in sight. While some purists believe that it's still fine to run Macs without antivirus, there are more of us security guys/gals sounding the alarm that times have changed and Macs are no longer impervious. Lastly, if you use your Mac for any business related functions, you're more likely than not sharing documents with your colleagues who are using Windows systems. Meaning that you don't want to be the person who hands them a work altering piece of malware.

2) Make a Time Machine backup.

3) Manually move significant folders onto an Ext HDD in case your Time Machine backup fails at some point in the future. This extra step ensures that you're …
4
 
LVL 7

Expert Comment

by:Brian Matis
Happy to say that my upgrade went smoothly last night!
1
Question Hijacking:  The Experts in EE are professional and polite.  Sometimes maybe too polite.  What is the reduction in response rate if a question has already had but ONE response?  Is it diminished?  It must be.  

I'd hate to blame striving for "points" is a reason for responding; so I won't.

Yet, we sometimes get responses that miss the point (don't answer the question), are tangential, are patronizing.  These responses, if early in the hoped-for responses, reduce the likelihood of getting a good response that *is* on point.  So, a few suggestions:
- if you don't know the answer, wait for other responses before you post.
- if you don't know the answer, say so.
- if you think you might be responding to a neophyte and your intended answer reflects that view, re-read the question.
- Focus on answering the question and not on "THE PROBLEM" that may only be there for background.
I'm sure there are others suggestions that folks could add.
The value of EE to all of us is helped by encouraging responses.
2
 
LVL 26

Author Comment

by:Fred Marshall
I think that is a perception but not entirely reality
Well, I've sure had answers and threads that had but one responder.  So I rather have to say this is more than perception.  I may be biased by other venues where it's MORE prevalent.  I end up that it's more than perception and worthy of consideration.  Thus the suggestions.

If we are posting too much background information, that just really gets in the way.
Yes.  Examples can be misleading as well as possibly helpful.  Over time I've tried to do less.  Over time I've tried to make the actual question clearer.  When one does that then it's particularly frustrating to see the bandwidth used up.

 
If there is an answer you don't like or understand, take a step back, close the browser and come back to it later.
You're right of course.  My baggage is when clear questions are ignored or sidestepped.  My favorite baggage boils down to: "Is that a Yes or a No?"

The original post wasn't so much a complaint as a set of suggestions for more positive interaction.  I hope it was taken that way.  But the title *was* intended to get some attention.
1
 
LVL 6

Expert Comment

by:Craig Kehler
We are planning on some updates to the question workflow to address some of these concerns. Some Experts are too polite, not wanting to add a comment unless they *know* they have the best solution. Others will try anything, presumably in an effort to help. Many Experts skip over questions that already have comments with the assumption that the user has already been helped.

We are looking at how we can improve ways for authors to indicate their solution hasn't been reached yet and for Experts to be able to indicate they need more information from an author.
0

Experts Exchange

98

Solutions

340

Contributors

We connect you with people and information to solve problems, inspire learning and influence the future of technology.

Vendor Experts

Craig KehlerExperts Exchange
Stacy RichardExperts Exchange
Experts ExchangeExperts Exchange
Kyle SantosExperts Exchange