We will be attending the Catex Exhibition in the RDS on the 8, 9 and 10th of February, presenting the latest features of our Van sales system and demonstrating the integration to Sage and Intact.
You can visit us at Stand C34
We have had a number of issues with Access database giving the following error
[ODBC][Ora]ORA-01013: user requested cancel of current operation
Assuming you can access the ODBC database source directly the issue can be fixed by changing the Access query properties. Click on the query and select design , right click in the query and select properties, change the value for ODBC Timeout from 60 to 0( 0 is no timeout)
Save the query and retry.
Some of our clients were having issues with date entry in various applications since the 1st of Jan
The issue relates to how windows interprets a 2 digit year. Under control panel, regional and language, click on customize , then click on the date tab. The first section the calendar shows the range of years used to interpret the 2 digit year. This was set to 1911 to 2010 on some PC’s- when they entered a date for 2011 as 2 digits windows converted the year to 1911.
To fix this simply move the year to 2050.
We have updated our sage links for MASC and Wrap. The invoice upload routine has a number of new options which can increase the upload speed of your invoices into sage dramatically.
For more details contact our office http://www.e-ms.ie/contact.htm
This is a link to the Aceeca user guide
http://handheld.ie/dl/mez1000.pdf
See page 2 for the hard reset command.
I was first introduced to GREP in the early 90’s by Joe Sims!
http://www.wingrep.com very useful
Our custom PDF printer has a flaw which requires the user to configure the printer to print directly to the file otherwise the reports are spooled and printed into the incorrect name.
I used this function to check the setting and warn the user
Function GetPrinter()
If fReturnRegKeyValue(HKEY_LOCAL_MACHINE, "SOFTWAREMicrosoftWindows NTCurrentVersionPrintPrintersEMS PDFDsSpooler", "printSpooling") = "PrintWhileSpooling" Then
MsgBox "Your printer is not configured correctly. " & vbCrLf & "change the advanced setting to print directly to the printer"
Else
MsgBox "Your Setting is correct:" & fReturnRegKeyValue(HKEY_LOCAL_MACHINE, "SOFTWAREMicrosoftWindows NTCurrentVersionPrintPrintersEMS PDFDsSpooler", "printSpooling")
End If
End Function
This uses the function from the access web
I use this code to determine the time set a status label and run some code. These program are opened using a scheduler from splinterware. This action is executed when the form is opened and will automatically close the database when finished. In this sample it runs the reports between 10pm and 11pm.
If Val(Left(Format(Now(), “hh:ss”), 2)) >= 22 And Val(Left(Format(Now(), “hh:ss”), 2)) < 23 Then
Me.txtStatus.Caption = “Running Auto Reports”
Call MakeReports
DoCmd.Quit
End If
testing
To open a web page in a seperate window, call this function with your URL – for example openbrowser(“http://www.e-ms.ie”)
Function OpenBrowser(tmpURL)
Dim Browser As Object
Set Browser = CreateObject("InternetExplorer.Application")
Browser.Navigate (tmpURL)
Browser.StatusBar = False
Browser.Toolbar = False
Browser.Visible = True
Browser.Resizable = False
Browser.AddressBar = False
End Sub
This is a link to a good Excel template – you have to suffer the advertising on the right