// Access Archives - Handheld.ie

Category

Access

Visit us at Catex in the RDS 19th-21st Feb

We will be demonstrating how our handheld software and systems can help your business at stand C24. Come along and let us know what your challenges are and we can discuss how we can…

Responsive Web Design

Responsive web design – as defined by wikipedia – (often abbreviated to RWD) is an approach to web design in which a site is crafted to provide an optimal viewing experience across a wide range of devices  from desktops to tablets and mobile phones in both landscape and portrait.

This site has some great free responsive web templates which you may be able to adapt for your own web…

The 5 Rules of Successful 21st Century Marketing

I attended a very interesting presentation on saturday from Franco De Bonis , DG Group – You can see the slides her…

Ransomware

I hadn’t heard of this until today. One of our client’s had an attack on their server , the malware makes a zipped (RAR) file of your data and adds an encryption to the file. It then deletes the data using the sdelete function which doesnt allow the traditional undelete file methods. There are various versions but the infected user is offered a password to decrypt the file.

The bottom line is…

MASC for TAS Accounting

MASC is now linked to TAS –  sales invoices can be loaded into TAS using the quick journal import

To import transactions into TASBooks:

From Company Manager, select the company you want to import transactions into then select Company à Import Transactions. The path to the company where the files will be imported is automatically displayed.
From the drop-down list select the type of…

Recording your PC Screen

Have you ever wanted to create a tutorial to record how something should be done on a PC. Well, here is a handy little utility program which will do it.

To aid their development of Windows 7 beta versions, the Microsoft engineers built in a diagnostic tool called Problem Steps Recorder that combines screen captures with mouse tracking to record your actions.  You can launch this program…

Printing comments on an excel sheet

Select File page Setup
Select the Sheet option
Beside comments select “As Displayed on…

Changing the System Date with VBA

I needed to reload files into an access database and process the contents based on the system date. To avoid having to process each file manually, I found that you can change the system date of the computer with this vba code

Date= #23-Feb-2011#

And you can also set the time , a bit too easy…

Sage 2011 integration for MASC and Wrap

We have updated our programs to support Sage 2011 version 17

Please call us before you upgrade to ensure you have the correct softwar…

SAP BOM Upload File

To load a BOM into SAP we needed to create a XML file with a hierarchy of the BOM.

To start this project in Access you will need to set a reference to ChilkatXML and have a recordset for the BOM items.

Function Make_SAP_XML()

Dim xml As New ChilkatXml
Dim MT_TPC_BOM As ChilkatXml
Dim ProductHeader As ChilkatXml
Dim Systems As ChilkatXml
Dim System As ChilkatXml
Dim SystemItems As…

Contact Information

Drop us a line or call and we'll discuss how we can help with your projects.

Handheld.ie
Waterford City Enterprise Centre
Waterford Business Park
Waterford

  • 051 391338
  • info@handheld.ie

Posts Categories

Copyright Handheld.ie ©2014 . All Rights Reserved.