Search results

Hello, I am having a problem with an IF/ELSE statement, although used many other times. I have a cmd button on a form which executes or ends a certain code, depending on the value in txtbox1. Thank you for your help If Me.txt1 = "partial" Then MsgBox "Sorry, you cannot perform this action is...

Finally got it working. It was just a matter of putting the code in the right place Thank you

Thanks. I will give it a try and will let you know.

Hi, Both the template and new file will be in the same folder but here is the problem. I do not know how to write the StrSavePath. Do you mind helping me with it? Thanks

Hello. I am sorry for the confusion. I will try to be more clear. I export data from a form to a Word Template named Memo.dot. The template is stored in P:\Test\Memo.dot Its' path and name is indicated in a table named TablePath which has two fields: 1) Template ID, indicating the name of...

Yes, I will use the FileNo to concatenate. I have tried your code but getting an error (cannot find the file) in the .Attachments.Add strFileName,olByValue, 1 line. For your convenience, I am posting the entire code. Thank you Dim objWord As Object Dim strPath As String Dim strBody As...

Hello, I have a form which exports data to a Word file and saves it with the value indicated in the textbox (FILENO). I then have a code that opens Outlook but I am having problem in attaching the correct file. The code (wrong) that I have come up with, will only attached a file with a...

Perfect. Will try it.

Great. Working perfectly!!! Thank you

Hello, I have f form used to export data to a MS Word template which is then attached to a new Outlookl session. Since the recipient email address can change, I would like to choose the email address directly from a combo available on my form , which lists all the recipients. The part of the...

Thanks. I works in part as it now give me the decimals but always shows the value with the $ sign although the textbox is formatted as Euro.

Hello, back for some help. I am having problem when exporting data to Word. On my form ( records source is Table1), I have a textbox (Amounte), with format Euro and decimals as Auto. When I type or open the form, the value in textbox Amounte is displayed correctly (ex. €100.50). When I export...

Clear now.

Great. Working perfectly now. Thanks

Hello, I am exporting data from a form to a Word template using bookmarks and would like to include an input box which users can use to add additional information which is not stored in the form. I am getting an If without Else error and not sure if the code is correct. Appreciate your help...

Sorry Gasman. It's not a matter of being or not being bothered or wanting to be rude. It's not my style. It's years I have been using this forum and can only express my gratitude. As I like to say, I am only learnings and just don't know how to! You are referring to an icon.

got it. Working perfectly now. Thanks a have a great weekend.

Sorry. I will try to be more accurate. In my form, I have placed a certain number of textboxes. The form has a query as record Source. When I open the form, a first textbox (texbox1) can be used to set two values: A or B. If users type A, then all textbox2 and textbox3 should not be disabled...

Thanks to both for your help. However I am still having some problem. Whatever selection I type in texbox1, I textboxes are disabled.

Hello friends, still asking for your precious help. I have a form with a record source based on a query. It has a textbox which can indicate two different values: A or B. If it has A, I would like disable other textboxes. If B, then the textboxes should not be disabled. I have tried several...