Search results for query: *

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.....

This is a very basic example: http://rapidshare.com/files/366836248/Notes_Example.mdb.html If you look at the data properties of the subform control on frmMain you will see a Link Child Fields property - this is how the form syncs the main form and the Notes subform, and ensures your foreign...

ParentRecordID in your Notes table needs be a number field and set to Long Integer. Which version of Access are you using? I'll need to create you an example in the same version... Ed Metcalfe. Please do not feed the trolls.....

Hmmm.... people posting the same advice on 2 March and again on 17 March that I originally gave on 24 January... :-) Ed Metcalfe Please do not feed the trolls.....

If you're lucky then the data has been "encrypted" by simply shifting the ASCII characters. If so you should start by searching your database's code for the ASC() and CHR() functions as there's a good chance the encryption (such as it is) has been implemented in VBA. Failing that you need to...

There's some good starting points here: http://www.databasedev.co.uk/login.html This doesn't include the retry count you want to track. To be honest, if the data is important enough to warrant this kind of security I'd argue Access isn't the right tool for the job. Anyone who can use Google...