Maximizing Connectivity & Productivity

Archive for the MICROSOFT OFFICE Category

Access 2010 Error – MS Access not working

Whenever there is a code error, no matter how small – you may not be given a chance to correct it if you switch to another form or move to another object. MS Access 2010 abruptly pops up a box with the error MS Access Not Working […]

Read more

Access – Snap To Grid and To Grid

Snap To Grid Under Size/Space, when you move the control, Access aligns the upper-left corner of a control to the grid. To Grid Select the control, then goto Sizing & Ordering group -> Align, Access immediately moves the control’s upper left corner to the nearest grid point. […]

Read more

Using Application Part forms in Access 2010

Form Wizard or Quick Create can be used to create Access forms quickly, that can then be tweaked as per the user preferences. However Application Part forms, a new feature in Access 2010, supply a few buttons with the macros already incorporated – ex. a button with […]

Read more

Navigation control in Access 2010

There is a new control in Access 2010 – the Navigation Control. This is based on the old Switchboard Manager idea in previous Access releases. The navigation control is used to create a navigational interface similar to websites that mostly have buttons running along the top and […]

Read more

Selecting a single layered object on a slide in Powerpoint

With layered objects on a Powerpoint slide, press Tab to cycle through the objects on the slide, until Powerpoint selects the object you need.

Read more

Dates in Access – First and Last Day

FirstDay: DateSerial(Year([Testdate]),Month([Testdate]),1) LastDay: DateSerial(Year([Testdate]),Month([Testdate])+1,0) PrevMth_FirstDay: DateSerial(Year([Testdate]),Month([Testdate])-1,1) PrevMth_LastDay: DateSerial(Year([Testdate]),Month([Testdate]),0) NextMth_FirstDay: DateSerial(Year([Testdate]),Month([Testdate])+1,1) NextMth_LastDay: DateSerial(Year([Testdate]),Month([Testdate])+2,0)

Read more

Keyboard shortcuts for a smooth Powerpoint Presentation

By Jody Gilbert November 17, 2009, 2:11 PM PST Takeaway: You don’t need to get distracted by the mechanics of presenting a slide show. Learn just a few shortcuts and you can focus on your audience and your message instead. How do you feel about standing in […]

Read more

Reduce the #DIV/0! error in Excel

If you know your formula is correct, and it is okay for the column being used in the division to have a zero, (and you don’t want your end user to think your spreadsheet is wrong), then your formula should use the IF statement.  Ex. If  A2/B2=0 […]

Read more

Mail merge in Word 2007

Mailmerge is a super tool and the whole process can even be automated further using VBA.  However, here we are going to take the menu route. Further, this is an example only of the steps that can be taken – you can choose the option that suits […]

Read more

Use Text to Columns to split Excel columns containing a separation character

Use the Text to Columns feature in Excel if you have columns in Excel containing a lot of data seperated by either a comma, semi-colon, period or space(s). Simply select the column containing the unsplit data, go to the Data tab, select the Text to Columns button, […]

Read more
Page 4 of 512345
Mississauga, ON, Canada 905.607.3500