Search results

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.

I have a database for measurement requests and i would like to link it to our company intranet so that my uninformed users can just fill in one form and press a button to send it off without actually touching the database. I think i know how to do this - i'm planning to convert an existing form...

I have a "model line" drop down box on a form. This is comes from the main table. When i set up the main table i set it to lookup the options in another table. The problem i have is that when i add new model lines to this table they dont show up in the form drop down menu unless i delete...

I am using the following code to send emails from Access. Is there any way to format the text in these emails? At the moment they just come out as a big long line of text and i would like to be able to put the text in different rows, maybe change colours etc. Any help would be appreciated...

I am working on a database for measurement requests and i want the database to send an email to the administrator when a button is pressed. I can get everything to work apart from getting the database to look up the name of the admin in a seperate table. I have been using the following code...

I have a form which people enter details of an evaluation drive they have taken. They fill all the details of the drive in, date etc and then click a button to add any problems with the car. The button click opens a pop up form which closes when they click "add". The first form has a subform...