Recent content by monyi
-
M
Clearing the Immediate Window
The code of the link I posted works for me in Win XP SP1 + Access 2003.- monyi
- Post #6
- Forum: Modules & VBA
-
M
Open a file using a non MS office application
This opens your file with the default registered program in Windows. Put this in a bas module (in 1 line): Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal...- monyi
- Post #2
- Forum: Modules & VBA
-
M
Clearing the Immediate Window
Try this http://accessvbafaq.mvps.org/item.asp?pagina=26- monyi
- Post #2
- Forum: Modules & VBA
-
M
access and its xml formatting
Hi davebm, try this. Public Function FormatXML(ByVal strXML As String) As String Dim rdr As Object 'MSXML2.SAXXMLReader40 Dim cnth As Object 'MSXML2.IVBSAXContentHandler Dim wrt As Object 'MSXML2.MXXMLWriter40 Set rdr = CreateObject("MSXML2.SAXXMLReader") Set wrt =...