Recent content by Psiren17

Sadly the exact folder does matter - we have a slightly odd system where we have one big drive with lots of secure folders. If someone attaches something thats in a secure folder no one else would be able to open it which kind of defeats the object! Thanks anyway!

Thanks but that might take a while as we have a lot of places on our servers where i wouldnt want them to put the files due to permissions etc. Is there no easy way to specify a particular folder the file must come from?

I use the following code (got from this forum somewhere a while back) to open a "browse" box which enables my user to link a file to the database. it works from an "add" button which then places the string for the file into a field and turns it into a hyperlink using another bit of code. I now...

That works exactly how i need it to - thanks so much for your help and patience!

Hmmm.. i think i'm making a real mess of this because i'm bodging bits of code without really understanding them. I dont think i actually need to use a DLookup because there will only be one value in the table - i just need the code to pick up the one entry in there and add @companyname.com to...

Thanks - what do you mean by: "FieldIDToMatch=YourValueAsInputCiteria" I'm not quite sure what to put in those bits. I have the following so far: STRTOADMIN1 = DLookup("[admin1]", "[Administrators]", "FieldIDToMatch=YourValueAsInputCiteria") MsgBox "IMPORTANT: IF YOU SEE A WARNING MESSAGE...

In case anyone else needs to know.... Private Sub Model__Enter() Requery Exit Sub End Sub

Don't worry - i figured it out!! Thanks a LOT for your help.

The OnEnter might work.... what code would i use to do it though?

Hi, thats great but i dont really want the user to be able to add any old text (and believe me they will!) by using this method. Ideally i would like the manager (also an uninformed user) to be able to open a simple form and enter a new model name which then goes into the table. I have all...

Can anyone help??

are there any examples anywhere? I cant find anything.

thanks very much!

What does this mean? "concatenate in vbCrLf "

Hi - how would i do that? I'm pretty new to all this so i cant write code - just adapt it.