Maximizing Connectivity & Productivity

Archive for the MICROSOFT OFFICE Category

Picture background in Word

Choose Insert, select where you want the picture to come from, (you can also copy and paste a picture on to the page), pull handles to size, right-click picture and select Format Picture.  Select the Layout tab and choose the button for Behind Text. If a watermark […]

Read more

Four tips for a killer PowerPoint presentation

By Dave Johnson August 7, 2009, 11:07 AM PDT   Takeaway: Have you ever been tempted to chew off a paw to escape a mind-numbing slide show? Bad design and flawed delivery may have been to blame. BNET’s Dave Johnson offers a few simple suggestions to help […]

Read more

“Make MDE File” or “Make ADE File” Command Is Not Available

 You cannot create a Microsoft Office Access ADE or MDE file from a database saved in Microsoft Office Access 2000 format.

Read more

Access – Too Few Parameters. Expected 1

From Andy Baron: When a parameterized query is run in Access, Access provides an expression service that evaluates many parameters. For example, a reference to a control on an open form will be evaluated automatically, and the query containing that parameter will use the value contained in […]

Read more

Return a Worksheet name to a cell

 In Excel, use the CELL function/formula and the MID and FIND to return the name of an Excel Worksheet in a Workbook. The formula below shows us how; =MID(CELL(“filename”,A1),FIND(“]”,CELL(“filename”,A1))+1,256) Where A1 is any non error cell on the Worksheet. If you want the full path of the […]

Read more

Save file as Tab delimited with changes

 To save: ActiveWorkbook.Close SaveChanges:=1 or ActiveWorkbook.Close True Or to not save: ActiveWorkbook.Close SaveChanges:=0 or ActiveWorkbook.Close False

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