Search results

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

Hello, getting a run time error 13. Thank you

Hello. I have given a look at Bob Larsen's thread and found it very useful. Before I finally decide to abandon my idea I would like to share what I have come up with and know if its something still possible to do or if I am completely going in the wrong direction. I apologize for my confusion on...

Thanks you both. I will give a look and take your advises.

Hello. I have a database that I periodically requires some updates to either a form, a query, etc. The db is used in different offices and to avoid other users to open the program in design view and cause problems, I was thinking of using the transfer object method. For this reason I have...

Hello. I am planning to design a form that can be used to set appointments for the customers listed in my db. Data related to customers is stored in tblCustomers and appointments time/date is stored in another table, named AppTime. Appointments should be available from 09:00 to 05:00 with slots...

Hello friends, I am back for some other help. I have some vba which exports data to Word via bookmarks: <Dim objWord As Object Set objWord = CreateObject("Word.Application") objWord.Visible = False objWord.Documents.Add ("C:\MyDocs\MyTemplate.dot")...