Recent content by Studenn

Ok. Looks like you will need to revert to your back - up. There must be something unstable in your Database structure. Try to simplify as much as possible. Use VBA rather than macros. When I had this problem it was caused by corrupt data in one or more of my tables. Once you have recoverd the...

Thanks - Looks like i have of got some work to do. Stuart Dennis

Thanks - "Ghudson" I respect the advice you give have taken note of your many posts in the past and am usually able to find the answer I need. In your opinion is the problem with stale LDB's an Access problem or a Citrix server problem? I've also noticed the ldb seem to delete automatically...

Hi Noreen. Are you able to open the database window. If so suspect it is the same problem I had some time ago. I was using loads of Macros to trigger events attached to buttons on various forms. Proved to be very flakey. Had to revert to a backup on more than one occasion. My solution was to...

Hi can anyone help. My database is running on a Citrix server. No real problems except that I am continualy being left with the database apparantly locked by another user. Am unable to delete the LDB file even when no other users are logged on. Is there a way of deleting LDB files in relation...

Thanks. Thats cracked it :) :)

Thanks - Can't get it to work. Using this code. I want to be able to open a folder with same name as ClientName on the open form. On Click MkDir "C:\TestFolder\Me![ClientName]" Help Please Stuart

Hi again, still developing my database. Have made lots of progress thanks to help from this forum. Can anyone help with this problem. The database amongst other things is a client record. When setting up a new client I use a seperate form. I would like to code the form to confirm that I wish to...

Thanks Roy & Wayne After a lot of trial and error following code works fine:- Private Sub Command165_Click() Dim xPath, xFolder, xCmd, Result As String xPath = "C:\Documents and Settings\admin\My Documents\folder\" xFolder = xPath & Me![ClientName] ' (MkDir xFolder ' create folder ) xCmd =...

Thanks for all the help so far. Although I have designed and use a number of databases this has all been done very successfully using very little code. I have used the following to open a named folder from a command button on an access form. The window opens minimised, Have searched the forum...

Help with macimising folder window. Thanks for all the help so far. Although I have designed and use a number of databases this has all been done very successfully using very little code. I have used the following to open a named folder from a command button on an access form. The window...

Opening a folder from Access Cracked it! Thanks Wayne.

I need some help with something I presumed would be easy. I want to be able to open a named folder using a command button on a form The name of the folder is to be linked to a field on the open form. e.g. I've folders for clients in which I store letters etc. I want to open this folder in list...