Search results

Thank you, that is most helpful. Robert

Or if I do this from the main form, how would I code it? The pop up form is a separate form and not a subform. Robert

Bob: Thanks. I am not clear what to put in Me.Name, as I am already on that form. Would that be 'Me.MyFormName' ? Robert

I have a main form. A Button on the main form pops up an email form. I send the email and do a Dcmd.Close on the email form. But what happens is the main form closes and the pop-up email form remains open! I have tried doing a SetFocus to one of the controls on the email form before doing the...

I am using SendObject to send an email from my application. I get two warning messages which must be cleared before the email is sent. One of my users does not get the warning messages. Is there something I can do to remove these warning messages each time I send an email? Robert

Yes, I did ask a question about how to program a simple calendar. I never got a reply, so this is my answer. Robert

I needed to add a working calendar to an application. First I drew a calendar grid, seven days wide and six weeks deep (you need six weeks on the calendar for some months.) I put a control into every date on the grid, Date1 through Date42. Looks good so far! Then I used a combo box to load...

Thanks so much. I tried the first one and it worked perfectly! Robert

I have this Dlookup() in a query: DLookUp("[RECCOUNT]","[CalRecCount0]","[DATE] =' [Forms]![Calmain]![Calsub].[Form]![Day13]'") I am getting a Data Type mismatch in Criteria Expression error. [Date] is a field in the CalRecCount0 query (which works fine) and [Day13] is a date field on a...

More mysterious. One user gets no Outlook warning messages. Other users get two Outlook warning messages. Is this some sort of security setting? Robert

I am using SendObject to send Outlook email messages from my application. On my development system, I get two Outlook warning messages each time I send an email. A user tested this on the live system today and said they got no Outlook warning messages. Is this something that I can set? To not...

I have a form on which there is a button. You click the button to display another small form, to send an email. That works OK, but the small email form displays BEHIND the main form - you cannot see it unless you close the main form. Why is that happening? How can I get the email form to...

You are correct! I was confusing Access 11.0 with Outlook 11.0. It works now. Robert

I don't have SnipTool on the server that hosts my application. Also I don't have PrtScrn on my Mac keyboard - I am running Windows 7 on an iMac. So here is a list of my checked references: Visual Basic for Applications Microsoft Access 11.0 object library OLE automation Microsoft DAO 3.6...

How do I make a pic of my references list to post here? Robert

Here is the code that I am having problems with: 'The sub procedure below sends e-mail in response to a click on the Send button. Private Sub SendMessagesButton_Click() 'For Access, define some object variables and make connections. Dim myConnection As ADODB.Connection Set myConnection =...

Will do, thanks. What are code tags? I am not familiar with that. Robert

Are there no arrays in Access? I am looking for a way to put sequential dates onto a calendar. An array would work fine, with an offset for Weekday(FirstDayOfMonth). Robert

I am trying to work with the ActiveX control: Calendar to make a working calendar. How do I get from the calendar to anything else, using the date selected on the calendar? Can I even do that? Robert

OK, it came us as 11. Now I am getting a 'not defined; on this email code I am trying to use: ' Define some object variables for Outlook Dim appOutlook As Outlook.Application 'Refers to Outlook's Application object. Dim appOutlookMsg As Outlook.MailItem 'Refers to an Outlook e-mail message...