Recent content by robben

Yep I have been granted read/write/delete access to the folder. So I'm pretty confused

Hi Bob, Thanks, for your reply, yes I know that the front-end, each user must have it stored on thier local machine. Also I know, that that I need to grant access to the users who will use the backend file. The problem I'm having is I'm not sure why I'm receiving the error I'm getting about...

I have a database which I have split into two (back and front end). I have been working on it on my local machine. However, it will be going on a shared network drive where multiple users will have access to it. I have copied to database to the shared network drive and changed the linking of...

Got it working, Public Function GetFilenameFromPath(FullPath As String) As String 'Returns the filename and extension GetFilenameFromPath = Right(FullPath, Len(FullPath) - InStrRev(FullPath, "\")) End Function

If I have full path for a filename i.e. C:\Documents and Settings\test\file.doc How do I just extract the filname and extension i.e. file.doc in this case using Left? I tried but can't work it out. Thanks

Many thanks namliam, excellent the code worked. However, I'm now trying to copy a file (selected by the user) to the database directory. I have a directory named "testDFirectory" in the root directory where the database is located which I want to copy the file over to. However, when I run...

I have a simple question what I want to do is get the current directory path of where the Access database resides, how would I do this using VB? Thank you.

Got it working now. Seems strange I just deleted it and added it again.

yes namliam, thats what I thought even though I very little knowledge of VBA. It just seems to not like the first line. I've had this function working on other apps and it runs ok.

* When I run the code it hightlights the line I've shown in the first message. * Textbox exists as when I write Me. the textbox appears * If i take all the code out of the function it runs ok so its not some other code elsewhere which is causing the problem, so this is confusing me...

Thank you for your reply, please see the function code. Basically the function attempts to open a word file therefore it checks that it has the filename before it attempts to open it. Private Sub OpnFrm680Btn_Click() 'Check to see that there is a document file path associated with the...

I have the following code which determines whether the field is blank or if there is an empty string. (see below) If IsNull(Me.myTextBox) Or Me.myTextBox = "" Then ' DO SOMETHING However, when the code runs I get the following error: "Run-time error '438' "Object doesn't support this...

I haven't got access installed here. So I will let you know how I get on tomorrow. Many thanks for your work, much appreciated!

Hi Ken, Yes the subfrom control is the original. Ken can you do me a favour can you copy the subcontrol onto a form and then I can work out how to do it? Thanks in advance for your help!

Please find attached the test database. Thanks for your help!