Search results

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

Thank you

Hello, I use the following VBA to copy a record from a textbox (FILENO) to the body of an email (EMAILTOCLIENT). Me.EMAILTOCLIENT = "Hello ," & vbCrLf & vbCrLf & "this is your file number: " & " - " & [FILENO] & " " I would like to give the file number a SSN format (000-00-0000). I have...

Thanks to all of your for all the help. I really like arnelgp's sample db. I think it's great and for sure will borrow the idea. Thank you

Hello, I am using the code below (it's only a part of the whole code) to open Outlook from a form. Is there a way I can also add the Signature already available in Outlook, in the body of the mail? Thank you for your help. " ' Create the Outlook session. Set objOutlook =...

Works great. Thank you

Hello, I have found a code that opens Outlook, adds the email address in the To line and a text in the subject line. I would like to place this code behind a button on a form. I was wandering if there is a way to include the value of certain controls on the form (ex. txtFname, txtLName) in the...

This works fine. Thank you Application.FollowHyperlink Me.mycombo.Column(2)

Got it working. Thank you

Thank you. Unfortunately it still gives me the same error. If I try to open the hyperlink, directly from the table, it works fine. The files are locally stored on a shared drive.

Hello, I have added a combo to a form which has its record source to a table with three fields. It is used to open pdf/doc files. - City - Title - Hyperlink The combo will only display the document's Title as I have set the Column Width to: 0";1";0" Unfortunately the following code, does not...