You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Today’s guest blogger is Edwin Blancovitch. Edwin is president of Advanced Developers.net, creators of Easy Payroll, a software package to manage your human resources, payroll, scheduling, time and attendance needs.
I like to be innovative and use new features from programs. Recently I updated my apps to Office 2010; the process was very easy. However, at the same time I also updated my developer machine to Windows 7 and I saw something very unusual/new for me: there was no Quick Launch. Instead, now you pin applications to the taskbar or to the Start menu. Originally I thought it was going to be easy, but then I realized that Access applications cannot be pinned to the Start menu or to the taskbar because they are not executable. OK, here we have a challenge. I could just forget about the nice functionality of the Quick Launch, but I like to use it because it allows you to start any app without looking for the shortcut on the desktop or in the Start menu.
Here is the problem:
Initially I thought, I will just forget about this. But then I remembered from old installations I used to do with Office 97 and Office 2000, that the way to start the applications was different, and I started to look for alternatives.
The trick is to edit the shortcut so it loads Access first, and then it loads your app. Here’s how to do it:
If you your application uses the .accdb or .accde file extension, you should now have a shortcut that you can pin to the taskbar. Right-click your shortcut, and now the Pin to Taskbar/Pin to Start Menu options are available. However, you might have noticed that I use the .accdr extension, because I use the Access runtime for my apps. Because of this, Access gives me a warning and closes the application:
To solve this problem for the .accdr extension, we need to take one extra step in the icon creation--add the runtime switch to the command line as shown here:
"C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE" C:\Payroll\Payroll.accdr /runtime
Again, make sure to add the space between the path and the /runtime switch. No double-quotes are needed for the switch.
There you have it!
This approach negates the flexibility inherent in the new Win7 start menu/ taskbar paradigm, where the last 10 files opened by the EXE are listed: by clicking the arrow to the right of the item in the start menu, and by right-clicking on the taskbar icon. The really neat aspect of this new approach is that you can also pin a file to the list. The above 'fix' wastes valuable screen space.
PS: The new paradigm also makes it much easier to open files when multiple versions of Access are installed: just pin each version's EXE...
My clients with Win7 don't run but one Access application, so this is actually a big win. I'll be implementing it at my first client on Thursday -- they've been complaining about it every since they got their Win7 box! For a developer who runs multiple versions or who has lots of apps to choose from, yes, the quick lists are preferable. But most Access users aren't in that position!
David W. Fenton, that was the reason i was fighting and fighting until i was able to make it work...I love Win7... and Access 2010...But we use the quick launch. . .for our apps... All my clients have one verssion of access installed in their machines, they also have more than one of my apps, so we can keep them pinned to the task bar or to the start menu..... YES!!! Edwin
Is it me or am I the only one that gets duplicated icons in the task bar using this method?