Search results

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. :)

I have to print a student list with the first colum showing an automatic list number of each student. I have no idea :confused: how could I solve this thread. Tks in advance of any help.

Tks MStef Hi! Too obvious, no? Incredible but I didn't see. You'r right, it works fine. Tks for all. By the way, I don´t know how to include a sort criteria in the expresion: Private Sub Command55_Click() DoCmd.OpenReport "Report1", acViewPreview, , Me.Filter End Sub Can you help me...

I tried your solution, but ... Hi MStef I tried the solution you show me in Form1 The "Open Report1 preview:" button, works fine, meanwhile the Form1 data source is Table1. But if I change the data source for QueryTem appears the following legend: Introduce parameter value "QueryTem.f1" I...

Tks MStef Tks for the tip. It seems very simple and easy, I will try it. For the oder hand, do you know how to apply on the same report besides a filter an order criteria. It could be a variant of the same code: Private Sub Command55_Click() DoCmd.OpenReport "Report1", acViewPreview, ...

Hi! I have a continuos form (list of records) with a tool bar with "filter by form buton". This buton allow to users filter the list of records showed by the form by diferent field criterias. After applied a filter I need a buton in the tool bar to print the filtered records on a report with a...