Recent content by Rickalty

I've asked the users who've reported this to me to respond and tell me exactly what happened. All I've got so far is "there was an error message and then nothing happened". I'll post more details when I get them. I don't have 2007 available to me to test. Richard

Hello. I have a VBA application written in Excel 2003 that works just fine. However, when a user opens the workbook in Excel 2007 the appication errors out and won't run. Are there any hints or tips to make sure an app will run fine in 2003 or 2007 ? Richard

Thanks, everyone. The problem was that I've mostly worked in VB itself rather than VBA, and the differences keep biting me. Fumei is right... using the dropdown list would have saved me hassle :-) Richard

Thank you very much. I was sure that Form_Open was right, but UserForm_Initialize is working. Thanks for the advice.

Hi all, I'm obviously missing something basic here. When a form (frmOpenSplash) opens, I want it to display a value in a label. I can't get the Form_Open() event to work at all though. My code is... Private Sub Form_Open() lblNoOfQuestions.Caption = "20" End Sub I've also tried Private sub...

Never mind...... Our SMTP server is mail.myserver.com, not smtp.myserver.com I made the change and it works fine. Richard

Sorry, I had missed copying over some of the code :-( Here is the full coding I am using now... Private Sub cmdFinished_Click() Set objMessage = CreateObject("CDO.Message") objMessage.Subject = "Sample test results message" objMessage.Sender = "rickalty@myserver.com" objMessage.To =...

Thanks, I followed that link, and looked further into CDO, but can't get it to work. I got this sample code... Private Sub cmdFinished_Click() Set objMessage = CreateObject("CDO.Message") objMessage.Subject = "Sampling test results" objMessage.From = "me@myserver.com" objMessage.To =...

Hi everyone, I have an online test that is completed on a SharePoint site. When the user finishes the test, I'd like the results (the test is scored as it goes, and the results listed on a worksheet) to be emailed to me. I know I can use "ActiveWorkbook.SendMail" to send the whole workbook to...

Thank you, that did it. Richard

Yes, I did - the help did indeed tell me that PrintObject isn't a valid property. What it *didn't* tell me is how to not print the button. Richard

Thanks for the reply, but it's not an Access form, it's a VBA form in Excel. Richard

He everyone, I have a form that I wish to print. I've put a button on the form to print it, but I don't want the button itself to print. I've done this... "frmEQLabel.cmdPrintEQLabel.PrintObject = False" but it errors out, saying that the class or data member "PrintObject" is not found. What...

Hi... On a 012 with ring generator, we wish to use a regular basic one-line phone, but have it set on delayed ring. However, since it's not a Merlin phone I can't do the feature *36 to set the line to delayed ring. I assume I have to do it from the MLX-20 through system programming, but I...

Thanks, Tommy, that was it exactly. (And all the direct lines at our biggest clients plant are 344-xxxx so that certainly explains it too.) Richard