Recent content by StuBailey

Hi, I have an Access 2003 Data Project in which programatically I import a load of data and then run an update query. I am having a problem though. I have a load of XML files which I import running in a loop, all importing with the same table name, for each import, I run and insert query to...

Going back to my first post about the FileSytemObject, I can't believe I forgot to dim my object!?!?! Other than that, it would have worked! Cheers guys!

All top level folder names are picked up from the database I am working in, those folders under that main folder may change, but could be picked up from a database under that first folder, all the file names will be the same as what are in the other folders of the same level, it starts getting a...

Hi, Thanks for the help, your 'Moving files in code' link is the most handy. I couldn't seem to get it to work though. I need to copy a folder and everything under it files and folders to a new location. Cheers Stu

You could split the array element into Sub elements using the Split() function and splitting on your comma. You will then be able to get it by SubArray(1,3). Have a look at the Split function in the VBA Help file and see if it will work for you. Stu

I would have used sql = "SELECT * FROM Music WHERE ([artist] = """ & sArtist & """ AND [title] = """ & sTitle & """)" Should work Stu

I can't seem to get my head round the CopyFolder using the FileSystemObject. Has anybody got an example or know of another way I can copy a folder and all files/subfolders underneath from one location to another using Access VBA? Cheers Stu:confused:

I have a real problem with one of the computers in my company that need to produce snapshot reports from access. We need to produce these type of reports because we then have a history of what was issed at a certian time while database's are continuously being updated. The problem is, that one...

Thats not really going to help, the onPrint does not run for the report, only the sections of the report i.e. the detail. The onOpen and onClose events do run for the report, but it is not going to help me trap when the report is sent to the printer. I could put some code in the detail onPrint...

Hi, I need a bit of help with this. Is there any way to trap when a report is printed. I need to ask the user if they wish to print a word document when they print a report and can't think how to do it. Any body got any ideas? Cheers Stu

No, that works with all objects such as froms etc., but doesn't seem to dive deep enough for Menubars. Cheers Anyway

I know I can do that, but I have to do it in code from the original database. What I have is a fully usable database, and I am trying to automate the building of a Read Only reporting database which can be created by the press of a button and shipped out to customers. The Staff who will be...

Has anybody got any idea how to Export custom built Menu/Toolbars into another database using code? I am automating a 'reporting version' of a database from the full blown version I use within the office. Many Thanks Stuart

Have a look at the Access 2000 Developers Handbook.

Has anybody got a clue on how I do the following? I have a number of tests which I am going to run on a database, and each test has been given it's own Sub, with the name of that sub held in the test table. I loop round a recordset of all the tests which need running and pull out the procedures...