Search results

Hmm, think it is me being stupid. I now think I understand, this code is to do the attachment, it then puts the attachments name in to the field DocMgrDesc. Is this right?

Hi Lightwave, Thanks for the code, was tearing my hair out. I take it that intNumber = Len([DocMgrPath]) would be the drive letter and path of where the document is stored? Thanks.

Gotcha, thanks. Once I get round to it I'll post a copy of it working in case anyone else needs this. Thanks again.

Just the name of the file if possible

Yeah, thats what I was thinking about. Another post I did was to create a list of the documents in a text box and then set them as hyperlinks to the documents. Do you know how this would work? Don't know how I would show them in a text box. Thanks.

Hi, I have attachments for customers and I want to make a text box that displays the names of all attachments the customer has. Any idea how this would work? Thanks.

Hi vbaInet, Do you know how to set this up? I really have no idea where to start with something like this. Thanks.

Hi, Just a quick one, can you make a preview pane in Access to show a document? They are all primarily pdf's as these are scanned in and we would need to view them on a regular basis. Thanks.

Hi Dcrake, Thanks for the reply. I have two real options, one is to log any field changes (which is what our management team want) or to just log any changes to the fields within the subform. A bit more info, the main section of the database is a datasheet with a hyperlink on the customer...

Hi, I am wanting to log the changes made to a customer record against a username. I have created a login form so the database stores the employee's name as a tempvar. I believe I would have to create a tempvar for every field in the forms I have (this would be approx 80 fields) and then when a...

So just to clarify, I would need to create a query for each field I want to filter by and use that? Also just a thought, would I need to set up an on update macro in the control box to set a TempVar to the user selection so it can run the apply filter command? Thanks.

Hi, I have a bit of a strange question. I have a split form/datasheet that shows details of our customers with certain fields on (such as First/Surname, Status of order, Area of Order, Sales Person etc) and I want to be able to make it easier to filter the data. As it stands, you can filter by...