Recent content by jme

have another issue with this. when i call my procedure, nothing happens...im assuming this is because it's an excel reference only calls macros in excel?

Ok sorted this issue Using VBA Editor Access Click Tools > References Select Microsoft Excel (Office 11) for 2003 Now the object references for excel are now loaded into access use the following to create excel application object to use application.methods Dim appXL As New...

hola my procedure needs to loop/stop and restart every 1minute. I've attempted to use the onTime method, however, after further reading i've found that this is not reference to access, but only excel. Has anyone ever had a similar issue - also thought about using the sleep method, however...

got the export to work rsCCure.Save c:\filename.xml, adPersistXML sorted

dude, i took the assumption that in order to do a SELECT statement you had to create a recordset?

to gather up my results and throw them into a readable file - but im lost

hola! I've been going in circles on google msdn etc, looking for a solution to my brat of a problem. The process Im trying to build up is as follows: -query 3 tables by joining -export results into a readable fileformat (xls/csv/xml) not too fussed So far I've created my query & got some vba...