Search results

I want to display a popup form when a user right-clicks a control. I'm using the MouseDown event. No sweat displaying my popup form but when it closes the standard MS Properties Dialog is displayed. Does anyone know a way to cancel the Properties Dialog? :( Thanks for your help!

DoCmd.GoToRecord ,, acNext

I have a subform that is set to AllowAdditions = True. It is a single record subform with Navigation Buttons on the Parent that I created (not MS Access Nav Bar). I did this because the form has an unusualy user interface. It was confusing the for the user to keep hitting the [Next] Button...

Access 2002 OOPS! Meant Access 2002.

Lebans RTF with Access 2002 I also tried the RTF2 with Access 2000 and I cannot select formatting properties by right clicking on control. Any Suggestions?

Lebans RTF2 & Underlining on Reports I downloaded Lebans RTF2. I created a RTF Text Box on a form in Access 2000 with Windows 2000 Pro. I then tested bolding, underling, and indenting. All worked well on the form. However a test report including the RTF Field did everything except...

Try this Sub Sub SendEMail(strRecipient As String, strSubject As String, strBody As String, optional strAttachment As String) Dim bStarted As Boolean Dim oOutlookApp As Outlook.Application Dim oItem As Outlook.MailItem Dim intAtt As Integer On Error Resume Next Set oOutlookApp = GetObject(...

Sean, Thanks again for the answer. It worked great. I did want to mention that the Dir(path) > vbnullstring does not work properly when there are no files in the folder. It returns false. I seemed to remember that MS changed this function a revision or two ago. I got the code from another...

Thanks for the prompt reply. You have made my day! :)

I would like to create a folder under MS Access control. I have tried the following code: strMakeDir = "md " & strBackupFolder var = Shell(strMakeDir, 0) but I keep getting the error message "File Not Found". I get the same message when I type in "md c:\testfolder"...

Pat, That's all well and good. But I'm not sure that Microsoft is that rational. If they had intended using the second number as DOM, why does it accept 99 and convert it to 1999? Using the same entry for two different values is at best confusing, and at worst poor design. Jay

I would like to use a date field in the format mm/yyyy, but want to allow users to enter it in the format mm/yy. I set Format: mm/yyyy Input Mask: 99/99;0 When I enter 02/99 it returns 02/1999 but when I enter 02/01 it returns 02/03 Upon further research Access thinks the 01 is the DOM and...

Jon. I went out to my client this morning and tested the Preview Email. She said that Outlook 2002 always opens in a Word Window. I guess that's how Microsoft gets full text formatting in Outlook. Thanks again for your help. :D

I know it seems crazy (but them again it's Microsoft). You see the code I'm using. It's shown in the first Post on this Thread. I'm using Windows XP and Outlook XP. Any thoughts? I will do some more research tomorrow to see if this is a known problem or if something is screwy on my...

Jon, Thanks for the reply. I tested it and it opens the email in an Outlook Window in a Word Window (Yes its true). When the email window is open, it also opens a popup asking do you want to save the document? Is this just my system? Is there any way to open just the Outlook Email Window...

I'm using the following function to send Outlook Email Public Function SendOutlookEmail(pasEmailAddress, pasEmailCC As Variant, pasEmailSubject As Variant, pasEmailMessage As Variant, pasSendEmail As Boolean) As Boolean On Error GoTo Err_Proc Dim NameSpace As Object Dim EmailSend As...

Travis, Thanks! That will save me a lot of time. Jay

Does anyone have some Javascript code to validate phone numbers and emails? Thanks for your help :)

Glad that worked. When we use this code, we test that the Form from which you set the default is open. Under normal circumstances it should be open, but during testing or under some wierd circumstances the "calling Form" may be closed. To prevent an error message, we always test that the form...

My problem seems to be that the selstart doesn't want to work on the mousedn event. It works consistently on the click event. Now I have to figure out how to use this for selected purposes.