Search results

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]"...

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

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.

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.

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.

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

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

Hi I'm writting from Mexico, City I upgrade from access 2003 to access 2007 But de VBA code of all my databases doesn't work in Access 2007. What can I do? I apreciate any help.

Hello! About my questión: "How to apply a filter by form to a report" I found this code from KKilfoil registered user of Access World Forums: Private Sub PreviewMeterReport_Click() On Error GoTo Err_PreviewMeterReport_Click Dim stDocName As String stDocName = "Meter Report" If Me.FilterOn...

Hello! About my last post: "How to apply the same filter used by a form to a report" I found this code from KKilfoil registered user of Access World Forums: Private Sub PreviewMeterReport_Click() On Error GoTo Err_PreviewMeterReport_Click Dim stDocName As String stDocName = "Meter Report"...

Hello! 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...

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

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

I looking for examples of VBA code working with Cancel Event. Tks in advance!

I need a simple way for the user to validate the changes or new data filled in a form. I made a macro with the close action but it doesn´t work properly. The macro don't ask user to save or not the record. Can you help me? Tks in advance!

I need a macro or an event procedure to close a Form with a subform, asking user to save or not the record. Actually I already made this macro but it didn´t ask user to save or not the record. Any help will be very usefull for me Tks in advance

I have an invoice form with an autonumerical Id field. When the user abort the form filling process the system loose autonumerical sequence. For example: I have the invoice 1001 in the system, then a new user open the invoice form (1002), start to fill the fields, but before finish close the...

How to create a dynamic stock field in a products form which value depends on buys and sales. In fact I have a query who calculate the existing stocks for each product, but I don't know how to carry this value to the stock field in the products form.

How to create a validation rule on a quantity control of an invoice form, to prevent to make an invoice which quantity be more than existing stocks. In general, how to create validation rules between two or more tables or queries. Tks in advanced.