[AccessD] Office shortcuts (was: Ramblings of a nutcase)

Hi Jürgen

Thanks for the update! Lots of challenges I must say.

On a much smaller scale we run Office 365 here as well, mostly for mail which is a challenge by itself due its very aggressive spam filtering. You cannot say it doesn't work as It leaves zero spam but I've found that this is because it cuts some good mails as well, mostly from fora while mailing lists like this are untouched.

What I still can't get my head around is SharePoint. Maybe it is just me - but I don't think so - but I just can't find the angle to "attach" it. Quite frustrating as I feel it has a lot of potential. With your much better resources, I'm sure you will succeed.

/gustav


-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Jurgen Welz
Sendt: 4. marts 2014 19:26
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] Office shortcuts (was: Ramblings of a nutcase)

Gustav:  I haven't really been lurking as I've rarely read anything posted to this list.  I never did unsubscribe though.  You are right about the insert shortcut.  It works for Excel 2010 and 2013.  I could have sworn it didn't.  In fact, I did swear a lot.

I'd been managing safety for the construction company I've been with since 2006 and hired my younger brother in 2010 to take over the Access development I was involved with when I was first joined the list.

We are now splitting from the parent company and their former security obsession that had hindered our software independence.  The result is a new safety manager is in place and I've been back in the IT world since mid December.  We plan to go live with a completely new infrastructure as soon as the parent allows the split.  They have been involved in a multi-million dollar SAP implementation for their 3 billion dollar annual volume business and we have been implementing an integrated software package that interfaces with our estimating system to take over payroll, accounting, purchasing and accounts payable by April 1.  No irony in that date, but realistically, we won't be allowed to leave until they can get some meaningful data out of SAP.  They don't currently have the resources to make that happen nor have they been able to get meaningful and accurate reporting that meet our needs.  We'll be lucky if we can go our separate ways by May.  Chances are, we'll take a best guess, saw off the projects that are active on a given date and then make adjustments when they figure out their end.

We've cut our business to 5 offices in western Canada with 50 users supporting about 300 field workers today.  We will be using Office 365 in a cloud deployment and will be colocating in a data center.  Figuring out the Microsoft licensing for the cores on SQL Server, client access licensing, terminals, exchange, software assurance (or not) has been challenging but it's all coming together.  Infiniband, SSDs and spinning disks, back up power, inter connectivity, an office without fibre, new phone systems.

Once we're up, then it's work on Sharepoint and connect our exisiting MS Access system to our new software, implement a Sharepoint environment, build a web interface for field entry of time, purchasing and cost coding, and then lastly, move our MS Access system into dot Net.  Exciting times.

Ciao

Jürgen Welz

Edmonton, Alberta

jwelz at hotmail.com
 

> From: gustav at cactus.dk
> To: accessd at databaseadvisors.com
> Date: Tue, 4 Mar 2014 08:08:36 +0000
> Subject: Re: [AccessD] Office shortcuts (was: Ramblings of a nutcase)
> 
> Hi Jürgen
> 
> So you are still here ... after lurking for 2½ years. Great!
> 
> However, with Excel 2010, if I press Alt+i, a tip pops up telling that I can continue using the shortcuts. Then, still holding Alt, I press r, and the row is inserted, but only from the current column and onwards.
> Shift+Space, Ctrl++ will insert a full row (from and including column A) no matter which column is current. So these two actions are not fully identical.
> 
> If you have Access in mind, pressing Ctrl++ directly will move you to a new record.
> 
> So is something missing from your installation?
> 
> /gustav
> 
> -----Oprindelig meddelelse-----
> Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Jurgen Welz
> Sendt: 3. marts 2014 20:38
> Til: Access Developers discussion and problem solving
> Emne: Re: [AccessD] Ramblings of a nutcase
> 
> I was happy until they started messing with the keyboard shortcuts. Office began the downward spiral with the ribbon. I used to be able to insert a row with alt i, r. Now it's shift space, ctrl +. It was 3 keys on a typical keyboard turned to 4 (one key with your hands away from the home row) and 5 keys with my laptop (add shift = to get the +).
> 
> 
> 
> I'd start any application I needed with the Windows key and a single other key (the first letter of the application- I'd just rename so the shortcut worked).
> 
> 
> I fail to understand the need to lose the old capability. It's not like it couldn't coexist. Windows 8 is negatively impacting productivity and there was never any need for it to do so. If the task bar takes up too much real estate on a screen, I can't help but wonder what braniac came up with the ribbon menu. Put that on a 21:9 widescreen monitor.. I've taken to setting up dual screens with one vertical and one horizontal.
> 
> 
> Ciao
> 
> Jürgen Welz
> 
> Edmonton, Alberta
> 
> jwelz at hotmail.com