Search results

Hello. I hope someone can help. I use the below code as part of a database which creates documents and then saves them using data from the form fields. Every now and again one of the form fields contains a "special" character such as /,@,& and this prevents the file from saving. Is...

Hi. I have the following code which works perfectly BUT I want to be able to add another line of text if users enable a checkbox. I have tried everything I can think of but can't get it to work. When using an "IF check150" statement it just adds the extra text in regardless of selection or not...

Hello. I have been told that I say too much without saying very much so I will try to keep this short. I currently have a setup which allows users to click one button (command152_click) which then generates a word document using info on my form then attaches and sends to a pre-determined...

Hi. I have looked and can't seem to find anything which helps so I have started a new thread. The below isn't the actual use but it is easier to explain like this... I have a system set up on access and I have a front page (form) where I can enter the reference number (1141#2) of a...

I have a template word document saved on sharepoint. I use an Click private sub on access to start the VBA which lifts information from access form fields and puts them into the word template in a pre-defined position. The issue is that one of the customers gets the following error message...

Hi. I have the code below and I would like to save it as a .doc file which is a 97 version, i.e FileFormat:=Word.WdSaveFormat.wdFormatDocument97 I think that i have done this the right way but the receipient of the e-mail (using office 2003) can't open the file as it says "cannot open...

Hi! I have found this forum so helpful in the past so I am hoping that this is the place to get help for my new issue too. I have the code below which takes information from a form on access and sends it over to the correct place on an excel spreadsheet template. This works fine but I then...

Hi. Please can you advise what is wrong with this code? It works as far as the data from access is taken over to excel and then the save box will come up - the issue is that I want to to automatically save this as a file name, open up outlook, attach it to an e-mail and send it. Please let...

Hi. I have tried searching on the forum before posting but can't seem to find this (maybe because it is probably very easy). I have info on my access form which is located here.... Forms![Front Page]![Site 2 Owner] and here Forms![Front Page]![Postcode S2] I would like to export...

Hi. I have also posted this in the "reports" section as I wasn't sure where it would go. I have looked around on the threads and don't seem to be able to find the answer. I currently have a working model which opens up a word document template, fills the bookmarks with info from...

Hi. I currently have a working model which opens up a word document template, fills the bookmarks with info from access, saves the file as a preset name and then send the document on Outlook. What I would like to do is save the document as a variable, preferably as something like " Climbing...

Hi. I have been working on a project for 3 months now and i am really close to completion but this last but is a real sticking point. As you'll see in the code below i have the code to fill in bookmarks on word using data from my access database, the "activedocument.sendmail" line only allows...