Search results

I think I can see how that works, but I cant work out quite how to use that with my field names. This is my code for the whole thing, which does work, just not removing the spaces in what would be [tblGPSurgerys.Address3], and [tblGPSurgerys.Address4] Not sure on how to integrate what Peter...

OK, I am learning loads. I have made it so when a user clicks a certain button, it starts word up, fills in name and address of the recipient, and fills in who the letter is in reference to. Works a treat UNTIL a field tries to be inserted in to the bookmark, the code crashes out to debug, and...

Got it, tried playing about and got it to work If Len(strInputFileName) > 0 Then DocumentLink = strInputFileName & "#" & strInputFileName Thats what I tried, and thats what works, so thanks. Learn something new each day! lol

Thanks for the reply, but I have got no idea on what to do with what you have suggested. I dont understand if this should go in code and where. I am a complete novice to coding and you guys are teaching me loads. Where do I do this? Ta

I am using the current code to browse for a filename, which gets inserted in to the relevant text box on a form. Private Sub Command8_Click() Dim strFilter As String Dim strInputFileName As String strFilter = ahtAddFilterItem(strFilter, "Acrobat Files (*.pdf)", "*.pdf")...

OK, Having gone through this some more, I can see how it works now I think. How can I get the filename that displays within the msgbox in the TestIt function in to a text box within a form so it can be stored within the database? It says that 'special code' has to be written to retrieve this...

I am complete novice to coding, so please be gentle. I have come accross the following code so I can browse for a file, which I then want to store in a field in a table, so people just click on it as a hyperlink. Like many people, I dont want people typing in the link, I would prefer them to...

So a hyperlink would work on a 'local' file name? I thought they would only work on the web. Cheers!

Hi, newbie here to this forum, been looking about for ages to try and find an access based forum. I am not a great coder, have not really done it, nor remotely understand it, but I have still managed to write a database in access for the office. We run a residential care home, where we had 5...