Microsoft Office

68K

Solutions

42K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

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

Sign up to Post

Ranking rows in Microsoft Access


EE-Rank.png
To rank something isn't that difficult. Basically, it is just to sort on the values to rank - points, goals, sales, citizens, whatever - in descending order or (typically for time) ascending order.
But how to rank dupes? Five methods exist, and they can all be implemented in pure SQL or using VBA.

Ranking rows in Microsoft Access
0
Ensure you’re charging the right price for your IT
Ensure you’re charging the right price for your IT

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

Great Micro Tutorial Video on how to create Drop Down Menus in Excel

View it here: Create Dropdown menus in Excel 2016

Just published and authored by: Thomas Zucker-Scharff

Enjoy...
0
Heads up for Office 365 Users on the monthly channel: Version 1811 Build 11029.20079 has a bug that is breaking MAPI (used to send e-mails).  For Access, that means the SendObject command will fail, as will products such as vbMAPI or Outlook Redemption.

This is all the detail I have at the moment.  Not sure if it effects Access alone or all Office apps.
2
Office 365 Developer Bootcamp in Zurich 12th November, sign up here;
https://www.eventbrite.com/e/global-office-365-developer-bootcamp-tickets-50629886353 
1

ISO 4217 Currency Codes in VBA


Currency codesShould you need to maintain a table of current currency codes, here is how: ISO 4217 Currency Codes in VBA

My article demonstrates two sources:
ISO itself (the definitive source)
Currency Converter API
0
LVL 62

Author Comment

by:Jim Dettman (EE MVE)
I haven't experienced that myself yet, but there are many things that Microsoft is doing that I find annoying, like I can't postpone Windows updates indefinitely or even for a reasonable time frame.   Worse, I can't schedule them the way I want.   They only allow for a 12 hour window of when the system is considered active.

I have one client right now where the VP often starts his day at 4:00 am, normal hours are 8 to 5 in the office, and some of the estimators work until 6 or 7.  So my down time is basically 8:00 pm till 3:00 am with them.

I understand there are technical reasons for some things they do, and that not everything can be taken into account, but the past couple of years, I feel like I've got handcuffs on when I work with Office and Windows.

The hiding scroll bar on the start menu in Win10 is driving me absolutely nuts at the moment.

Fun, fun, fun....

Jim.
0
LVL 29

Expert Comment

by:Andrew Leniart
Hi Jim,
that I find annoying, like I can't postpone Windows updates indefinitely

A way has recently been found to address this problem in Windows 10.

I hope you find the following Question thread to be as interesting as I did, which shows an easy means of disabling (or turning off) Windows updates permanently until manually re-enabled.

https://www.experts-exchange.com/questions/29118745/Disable-Windows-Update-forever.html

Skip down to the last third of the comments for the solution to that problem. Quite an interesting piece of detective work by EE member McKnife :)

The hiding scroll bar on the start menu in Win10 is driving me absolutely nuts at the moment.

I feel your pain Jim! :)

Andrew
0
I have a client getting error 2287 using EmailDatabaseObject macro. They are using office 2016. Does this
have to do with a setting in Outlook. What is the workaround for this issue?
0
LVL 28

Expert Comment

by:Iamthecreator OM
Please post your issue as a 'Question' and not a POST.
0
LVL 29

Expert Comment

by:Andrew Leniart
rhSQL15,

You will have more luck getting Expert help with this issue if you use the big blue "Ask a Question" button at the top of your browser when logged into Experts Exchange.

I hope that's helpful.

Regards, Andrew
EE Topic Advisor
0
Amazon is launching a new business where you can franchise a branded Amazon courier service:
https://logistics.amazon.com/

Startup cost is $10k

They estimate annual profit for a fleet size of 20-40 vans at $75k - $300k a year:
https://logistics.amazon.com/marketing/opportunity

Is this the "Uber"ization of the Post Office?
2
LVL 59

Expert Comment

by:Scott Fell
I saw that the other day too.  I think the vans turn out to be daily rentals from Enterprise. Managing 20 to 40 vans probably means managing 30 to 60 people, 12 hour shifts, 7 days a week.  If you are at the low end of $75K, that is a lot of work for that amount.
2
LVL 21

Author Comment

by:Lucas Bishop
Yeah, package/mail delivery is a real grind. My parents are retired postmasters, so I'm interested to hear their take.

I could see how this would be an interesting fit for someone with experience in managing a delivery/logistics model, to be able to work for themselves. At the same time, you would have no negotiating power with Amazon as far as payment per package/van. Seems like an extremely high risk scenario.

Seems like the only way you could step into this safely, is if you could look at the historic package volume for the geographic region you'd like to service.
0
For those of you wondering what might be up and coming in Office, one way to stay on top of that is the office 365 road map page:  https://products.office.com/en-us/business/office-365-roadmap?filters=#abc

and checking the "In Development" section.  For those interested in Microsoft Access, you will find a new feature listed there:

"Access: New charts for modern data visualization
Introducing new charts to help you visualize data managed in Access in an appealing and modern way. Add any of the new eleven chart types, including a combo chart, to a form/report to visualize your data and make informed decisions."

Sounds like we are going to get a major new feature!   Of course, if your part of the Office Insider program, you'll be one of first to be able to check it out!
0
Exchange Admins,
Exchange Administrator of a O365 tenant that is using either DirSync or AADSync are no longer supported and may not work correctly. These tools are no longer supported as of April 2017, and after December 31, 2017 O365 team are not able to guarantee your connections from Windows Azure Active Directory Synchronization (DirSync) or Azure AD Sync work properly.  This may affect your ability to synchronize your local directory infrastructure with Office 365, and will result in users being unable to log in to their Office 365 services.

Recommended action
Azure Active Directory (AAD) Connect is the best way to connect your on-premises directory with Azure AD and Office 365.  Upgrade your sync functionality to the latest version of Azure AD Connect, which is the currently supported tool for syncing data to O365 cloud features.

Hope it helps.

Thanks
MAS
1
Become a CompTIA Certified Healthcare IT Tech
LVL 13
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

0
How Mobility Is Modernizing Oil Field Services

Mobility solutions is what personnel working at oil fields need. But are they doing their bits to revolutionize the oil fields? We need technological advancements not just on the field but also the backend office which till now was abstained from newer ways of service deliveries that goes beyond the perspective to legitimize the modern uphold.

Get more info: https://goo.gl/BkFtBt 
0
Microsoft has added a page to their Office Templates which provides templates for five types of Access databases (Asset Tracking, Contacts, Students, Event Management, and Task Management).  I have not had a chance to review these databases, but this is the first move we have seen in quite some time to add anything "Access" to Office marketing, and is good news.

Please download these templates and encourage others to do so.  If we generate enough traffic, maybe we will be able to get additional templates on the website.

0
gSuite help is still terrible.

I have several comments about how using paid support for Office 365 is far superior to the experience using gSuite including my comment on this article from 2015.

Yesterday's call to gSuite support reconfirms.  Problem is a user wants to have access to Android apps on his new Google Pixelbook. Going to settings on the Pixelbook to enable the feature is grayed out.  A call to Pixelbook support confirmed the issue is the user is a member of a business gSuite account and there is a feature that has to be turned on.  I was directed to call into gSuite. Calling gSuite support is about as helpful as talking to my 2 year old niece. The gSuite tech acted as if he had no knowledge of a Pixelbook. I had to explain several times it was a product of his own company. Even going down the Chromebook route didn't help. He could simply point to turning on a feature that was already set. Otherwise, I would have to call the Pixelbook Support.

I have called into office 365 support for many issues. Sometimes the issue went beyond the scope of what the tech should have helped for their own silo, but they still were able to spend 30 to 60 minutes on the phone to solve the issue with great patience and product knowledge.

After the sale support many times goes unnoticed or untested.  When evaluating a service or software, I will call in…
2
LVL 59

Author Comment

by:Scott Fell
Thanks for the nudge Andrew.  Perhaps I will do just that.
0
LVL 29

Expert Comment

by:Andrew Leniart
Please do Scott. I'll be more than happy to edit and get it published for you.

I think a lot of people may benefit from your experiences, and it may just be the push Google needs to provide some decent support.
0
I came across the issue discussed in this article https://www.experts-exchange.com/questions/29026898/outlook-email-not-working.html and what I did,  from control panal/uninstall progrem I selected office. clicked on change [not uninstall] and choose repair, this solved the issue
0

Microsoft Patch Tuesday December 2017 updates


Microsoft Patch Tuesday December 2017 is here, with a list of 34 critical security updates & 2 key fixes, for 7 products. Since the vacation isn't two far, make sure all the patches are updated in your network and have a happy vacation. Adobe also has released its security update

Key fixes:

  1. CVE-2017-11940
  2. CVE-2017-11937

Adobe:

APSB17-42

Potential impact for 34 security updates:

  • Remote code execution
  • Elevation of privilege
  • Information disclosure
  • Spoofing
  • Security feature bypass

Products:

  • Microsoft Exchange Server
  • ChakraCore
  • Microsoft Windows
  • Microsoft Edge
  • Internet Explorer
  • Microsoft Malware Protection Engine
  • Microsoft Office Services and Web Apps
  • Microsoft Office

You can read a complete report on https://goo.gl/mwbq1Q
1
Google just kickstarted the augmented reality stickers war - if you have a Pixel phone start sending AR stickers of Star Wars characters sitting in your office!

http://mashable.com/2017/12/11/google-launches-ar-stickers-pixel-phones/#pYlFdfU_nPqL
1
Excel cannot open the file because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. DDPE/Windows 10/ Office 2016
0
LVL 28

Expert Comment

by:Brian B
You have entered this as a post, but it looks like you are asking for help. To get the best response from the Experts, you should probably re-submit this as a question using the "ask a question" button at the top of the page, or this link: https://www.experts-exchange.com/askQuestion.jsp

If you do ask a question, please post the link to it back here so others can find your question and help you more quickly.

Please see here for further details: http://support.experts-exchange.com/customer/portal/articles/756544-how-to-succeed-at-ee-as-an-asker
0
Exploring ASP.NET Core: Fundamentals
LVL 13
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

I was just at a conference on Business Email Compromise (BEC).  various ISACs, Symantec, the FBI and the CIA presented.  It was very informative and here are a few things that were mentioned

  • Watch out for fraudulent scams involving IRS returns
  • Put 2FA in place everywhere you can and put a 2 factor policy in place for wire transfers
  • If you believe your GMAIL account may have been compromised, or just wish to keep an eye on it, there is a link on the bottom of the page to see the last 10 logins (although I don't see this in inbox, maybe it is only in gmail).
  • Set your out of Office messages to be internal only - or force this using rules
  • Use something like
  • DMARC

These were just some of the points made, but they were good ones.
2
This is a copy of part of the article located here:
http://www.tomshardware.com/news/how-to-fight-fcc-net-neutrality,36017.html

net neutrality
vote takes place 12/14/17:


Even so, it is the work of but a moment, so we all may as well do it. Go to www.fcc.gov/ecfs/filings/express, and under Proceeding, enter 17-108 (the dystopian-named “Restoring Internet Freedom” order). Fill in the form very, very, very carefully, ensure you get an email confirmation, and submit.

Your voice will be louder, as it were, with a phone call. Call the FCC and leave a message letting the agency know that you want to keep net neutrality as it is. Dial 1-888-225-5322, and be polite, patient, and persistent. You want Option 1, Option 4, Option 2, Option 0. Enter a complaint on proceeding 17-108.

Here’s a sample script: “Hi, my name is ___, and I live in [city], [state]. I’m registering a complaint about the proposed repeal of net neutrality, because it will hurt American consumers, reduce internet access, and restrict the open flow of information. I strongly oppose the undoing of net neutrality, which is at the core of proceeding 17-108. Thank you.”

Then call your members of Congress. The FCC commission is appointed and makes these decisions, but Congress can pressure the agency to do the right thing, and it can also put forward legislation to make net neutrality law instead of just policy. Find your congresscritter at https://contactingcongress.org/, and call the local office …
1
USB Microscope Comes in Handy
I considered making this an article, but this seemed to be the better way to do this.

The intro image  shows a USB microscope (~$30.00) and one of the pictures it took.  It is especially interesting because I didn't really think this would be of much use.  I just liked the idea of it.  I had the "toy" sitting in my office for only 4 days before I really needed to use it.  One of my users came to me with a MacBook Pro that no longer started, at all.  Under normal circumstances, meaning if it was a windows based computer, I would take it apart and see what the problem was.  There was a problem with that.  Since it was a MAC computer, I didn't have the correct wrench to unscrew the chassis.  I took my USB microscope, pictured above, and took a picture of the screw hole, also pictured, which I then sent out to my colleagues within the institution (a medical college) to see if anyone had a screwdriver to fit this screw.  


It took about 2 hours before I received a response that someone indeed did have the correct tool and would either be willing to lend it to me or do the job themselves.  
1
LVL 68

Expert Comment

by:☠ MASQ ☠
I so hope it wasn't someone in orthopaedics and you had to send it back to be resterilised afterwards! :)
0
LVL 33

Author Comment

by:Thomas Zucker-Scharff
Nope. :-)
0
0
Hi Friends,

Just a short note to explain why those of you who have been following me may be curious as to why I suddenly disappeared from EE all of a sudden and apparently started ignoring all of your messages for the last couple of months.

Without going into too much detail, I've basically been in and out of hospital with a rather serious condition. My last stint in hospital was 4 1/2 weeks and I'm finally now home again on a "Hospital in the Home" program where district nurses regularly visit my home and I go back into the hospital once a week for doctors reviews.

The situation I'm in isn't about to change real soon, but I'm confident I'll beat it eventually  :-)

So that's my story gang.. My apologies for the lack of replies and if I do seem to disappear, please know it has nothing to do with Experts Exchange forums, which I continue to thoroughly enjoy.

Best..

Andrew
3
LVL 114

Expert Comment

by:John
I continue to wish you well and think of you every time someone posts in here. I hope that the outcome is now brighter for you.
1

Expert Comment

by:Jerry D.
Sending you positive thoughts and best wishes. Be well!!
1
Skype-a-ThonSkype-a-Thon is a global learning event that makes it possible for students to virtually travel around the world and connect beyond the classroom.
Join us this year — on November 28-29 — as we aim to travel 10 million virtual miles to make new friends, open hearts and open minds in order to create a kinder, more compassionate world!  
https://education.microsoft.com/skypeathon

Have a look at Microsoft Education website, there are many free courses and you can have more fun there. I am sure you can gain more with Microsoft as they are really generous and you do not need to be a Premium Member to attend any course.
0

Microsoft Office

68K

Solutions

42K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.