Maximizing Connectivity & Productivity

Archive for March 2012

“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

The Rearview Mirror

Moving ahead in life or business – Driving with glances at the rearview mirror gives you insight on how fast to move forward or how and when you must change lanes, or exit.

Read more
Mississauga, ON, Canada 905.607.3500