Search results

Thanks :) I managed to sort out my issue but can't remember what I did differently!

Thank you for these replies. I will give it a go!

Thank you for the reply. Do you have an example of the coding which I could use please? I'm not sure of the correct format to use.

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...

Thank you for the reply. I was so close but was using "IF check150.enabled" or "IF check150.checked" THEN.. Yours works perfectly. Thanks again.

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...

Just an update in case anyone else has this issue. I managed to get it working by using the attached coding. Thanks again. Private Sub Command154_Click() On Error Resume Next Dim appExcel As Excel.Application Dim wbook As Excel.Workbook Dim wsheet As Excel.Worksheet...

Just an update - that works perfectly. Thanks for your help.

Thank you. I will try that. I appreciate your help :)

Hi. Well I am stuck on how to actually do what I said above. I understand that I just need change a bit of the code for command_153 BUT I don't know what to do to make Command_153 complete the actions of command_152 at the same time. Is there a simple line of code I can tag onto the end of...

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...

I am in the process of working out how to do 1) from your first reply. I am a total novice so it takes me a while to figure these things out. I'm OK with VBA coding but other than that I am rubbish. The data which is repeated is actually because there are different dish sizes and heights...

Thanks for the reply. Yes the 1141#2 field is where a user would enter text and then the rest of the fields are populated. On the attached the first picture is the front page. The box on the left highlighted in red is where the site reference is entered and the larger box to the right is all...

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...

Re: Remove reference to template / document properties & Personal information on word Thank you very much. I did try that but I couldn't seem to get it to work. I have taken the decision to take the template offline and give all employees a copy of the template to keep on their hard drives...

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...

Thanks for your responses. I will give it a go using saveas instead of saveas2. No I haven't been given a syntax error using the 2 suffix which is why I have been confused as to what is happening. Fingers crossed.

Hi. I can open the files on my computer but the recipient that uses office 2003 advises that it is still being sent as a .dotm template file so it looks like the coding for the file format doesn't work properly?

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...

Thanks for your responses. I still haven't sorted it out :(