Recent content by pastymann

Hi David Got there in the end. My database is not really being used as a database. It is being used to manipulate data easier than if I used Excel. So more a tool than a datasbase. In the end I needed to use the following line of code. =========================================== Set...

Hi David My Table tblMonths has fields of NOV10, DEC10, JAN11 etc I know my code probably doesn't read correct but it is a precis version of a mutch bigger block of code, which does what I want it to do but contains many bits of code that are duplicated. I just used this to show the way...

Hi David I must be missing something here. If I use your line in my code I get an error message of 'Item Not Found In This Collection'. What am I doing wrong? ============================================= Set BOMdb = DBEngine.Workspaces(0).Databases(0) Set Monthset =...

Hi There I use code like the following to create virtual recordsets in my modules that allows me to manipulate data very easily and make my database very versatile. ================================================= Set BOMdb = DBEngine.Workspaces(0).Databases(0) Set Monthset =...

Solution Found Thanks Oclaym but the coding was beyond me :o However I have now managed to work out a solution and it is posted below for others to see. It works well for my Auto SMS program :D Function IE_Operation() 'IE Application Dim objexplorer As Object 'Attempt to find an open...

Hi there I have created a database that I use to auto sms customers. To do this at present I use office automation and create an Excel Application Set appExcel = GetObject(, "Excel.Application") I use this to open an Excel Workbook and run a macro within it to send info to the sms gateway...