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. http://support.microsoft.com/kb/824273

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
E-mail: info@netlogistix.com
Mississauga, ON, Canada 905.607.3500