Recent content by Sergio

It looks like report name, but it's a query. Thank you Pat.

Thank you all of you folks. Especially Pat to remember me the right sintax for this thread. Finally the right code line was: oEmail.To = DLookup("Mail","RpteRecibo") So easy, but my own programming ignorance didn't let me to move on. Thank you.

That's the problem, I don't know how to define a global variable inside my code.

That´s correct. My Report is based on a Query. But I don't know the sintax to introduce the variable field in my code.

Hello friends: I have the following code to send a report. My problem is how to replace the email adress "sepaal@yahoo.com" in the code (line in red), with the email adress inside the report I'm sending in the preliminary view. In the report I'm sending the email adress is in the "[Mail]"...

I try your code and it works perfectly !!! I'm grateful to you. Please, let me know, what can I do for you. Cheers.

I don't know why, but when I use SendObject method the mail sending is too slow and is not a discret method. I mean, Outlook App opens and then I have to wait to finish the files sending to close the pplication, because If I close before that, the files never leave from Outlook.

Thanks a lot. I'll try it.

Hello fellows: In the code below, how can I attach an access report to mail it. Thank you in advance. Private Sub btnSend_Click() Dim oApp As New Outlook.Application Dim oEmail As Outlook.MailItem Set oEmail = oApp.CreateItem(olMailItem) oEmail.To = Me.txtTo oEmail.Subject...

Tks Trevor for your quick reply. I'm going to check the link you sended to me. Have a good holidays.

Hi fellows How can I create a menu bar and how can I add command buttons inside of them with Access 2007. Tks in advance.

Tks for your quick reply. In fact I have used "Logme in" service already. But the point is I would like to learn how to build data bases in a Web platform to get access to them from any Internet point. In your opinion which is the best technology to do that and how can I started to learn it ...

Hi ! For several years I have been developing MS Access data bases. However, right now, I would like to migrate that access data bases to a web platform to get access to them trough Internet. I haven't any expierence on this issue, that is the reason I'm looking for an expert opinion to find...

I have a data base with a personalized main menu. with Access 2003 this menu appear ok, but with Access 2007 it doesn`t appear ??? Tks in advance for any clue.

Fortunately I found the way to solve this threat. Tks everybody are genius. In the view desig of the report introduce a text control in the detail section. In the window of properties write =1 in the line Origin of control and in the line continuous sum write on group. That's it. :)