Search results

I know I am kicking this thing to death, but the other day my wife told me that she and our daughter-in-law were talking about something person to person in the same room, although her phone was on. Then she went on Facebook (yes the evil one)later on and lo and behold an ad came up for what...

Go play golf, come home grumping about their "game" and then talk about how they just can't wait to go golfing again. :p

You ever hear of the saying.... "If it ain't broke, don't fix it"!!

For what it is worth, I had a lot of trouble with this too and finally found this that works for me. It is a module that tests for Outlook being open. If not then Outlook is opened. Sub TestOutlookIsOpen() Dim A, B, C, D As String A = "Outlook Is Not Open, Outlook Will Now Open." B =...

I do not know if this will be of any help, but I used this for inputting telephone numbers (10 digit numbers) so that regardless of what the user entered, the correct format would be shown. I put in an unbound text box where the user could enter the ten digits in any format that I could think...

Do your cars fly? More advanced then anything here in California. Ours don't have wings! 🤪

I ave used this for years and it works great. No spaces if anything is missing. You can adapt it to your particular application. With the proper carriage return codes, of course. =([Title]) & (" "+[FirstName]) & (" "+[MiddleName]) & (" "+[Surname]) & (" "+[NameSuffix])

So, finally I came up with what I think is a decent solution. I set up the unbound text box to be visible if there is no telephone number listed. Then I paste the telephone number in any format into it and use Double Click event to populate the telephone control. First I used an extended...

My way seems to work except, always the except, if you paste 8005551212 and double click it enters 805551212 and not the input mask format. Likewise for 800.555.1212, gets pasted as 800.555.1212. Most other formats work fine. Going to have to figure out how to get these odd formats into the...

Yes, I now understand. I fixed it in my usual half ass way. Put in an unbound text box (like a note pad) only visible if nothing in the Telephone control, paste the number to the unbound text box and then on double click it enters into the Telephone control and the unbound text box disappears.

Pasting into the notepad works fine. It just doesn't go into the text field. It will if I paste it to an unbound text box and then use code to update the Telephone text box.

No validation rule, just the input mask.

I am trying to copy a telephone number from a web page and paste it into my form. The text field on the form is the standard ten digit USA telephone input mask. !\(999") "000\-0000;0;_ But when I try to copy a telephone number, 212-555-1212 or (212)-555-1212 or 212.555.1212 only the first three...

GotFocus did not work properly. Only the Onclick.

Thank you. I hadn't tried the on click event. Of course it works fine. Just wondering why it wouldn't work on the OnFocus on OnMouseDown.

This has been driving me crazy for the last hour. Should be simple but it just doesn’t want to do what I want it to do. Set the cursor at the beginning of the text box if the box is void of any data. I have tried the following but nothing seems to provide me with the required results. It is a...

Yes, thank you, now I understand. I figured out another way of doing it, a little more complicated, but it works.

I am trying to figure out why the first code seems to work and the second doesn’t. I am trying to create a folder on Dropbox using VBA so that I don’t need to know the user (or computer) name to do it. Dim myPath As String Dim myFolder As String myFolder = myPath & "AAAAA" myPath =...

Thanks, but I know why this is happening. I wanted to know is there is an error code so I could use error handling so that I could use a message box pop up to warn the user that the import didn't work and to contact their supervisor. The warning that Microsoft uses is fine, but users are...

At times when I try to import data from Excel I get the error message” “Microsoft unable to append all the data to the table” or something like that. I am trying to figure out what error code this is if any and how do I trap it so I can advise the user to contact me. I know that there are error...