Recent content by Ed2020

Great, thanks guys. Will try this tomorrow. Please do not feed the trolls.....

Hi, I am using the following DOS command to loop through all directories within my current directory and retrieve the Size and Size on Disk properties: FOR /D %G in ("*") DO "c:\Eds Stuff\Get Directory Sizes\du.exe" -l 0 "%G" >>"c:\Eds Stuff\Get Directory Sizes\dir_details.txt" This works...

Duane, Thank you for your reply. If we stick with MDB files with linked tables is there likely to be any work required to tune existing code and queries? Is there any value in rewriting all queries as passthrough queries? Or rewriting DAO into ADO? Thanks again, Ed. Please do not feed the...

Update: I've found an anwer (although not necessarily the best answer) to my first question. DAO code can be modified by replacing all references to CurrentDB() with a call to the following function: Public Function OpenThisDB() As DAO.Database Dim db As DAO.Database Dim wk As...

Hi, My employer has asked me to investigate options for migrating some of our larger MS Access 2003 databases to a more secure, stable and scaleable platform. One of the options I am looking at is migrating the databases to SQL Server 2008 whilst retaining the existing frontends. As a...

IIf([HireDate]+60<Date(),Date()-[HireDate]-60 & " days over due","") Ed Metcalfe. Please do not feed the trolls.....

There's a function here that will take the full file path as a parameter and return the file name: http://www.ozgrid.com/VBA/GetExcelFileNameFromPath.htm There is a mistake in the code. iCount isn't declared. Other than that it seems to work perfectly. Ed Metcalfe. Please do not feed the...

Nice suggestion! I hadn't thought of that. Have a star! Ed Metcalfe. Please do not feed the trolls.....

I secure the database with Access's user level security then create a launcher in VB6 to open the frontend and pass access.exe the user name and password. That way the user doesn't need their own user name and password so they have no way of opening the backend. Ed Metcalfe. Please do not feed...

Hi, Sorry it's taken me a little longer than I expected to take a look at this. There's a new version available here: http://rapidshare.com/files/368527475/SEGO_contact.mdb.html Ed Metcalfe. Please do not feed the trolls.....

I'll take a look this evening to see what else needs doing. It sounds like you've got the majority of it working perfectly, so there shouldn't be much more to do. I'll upload a new version later today. Ed Metcalfe. Please do not feed the trolls.....

When you say each new note overwrites the last note, do you mean in my example database or in yours? I have not managed to replicate this behaviour in mine... If it's only occurring in your database I'd need to have a look at it to find out why that's happening. In terms of Access books I'd...

Cos I didn't know that property even existed. :-) Ed Metcalfe. Please do not feed the trolls.....

Aha, I think there is a bit of a misunderstanding. In my example Field1, Field2 and Field3 are just dummy fields that I put in my main table because I don't know what your main table contains (i.e. what the notes are actually about). They are not supposed to be for entering notes into. The...

Lucky guess on my part then - the example I posted is 2002/2003. :-) Ed Metcalfe. Please do not feed the trolls.....