Search results

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 found it ! I found it why the VBA code in access 2003 doesn't work in access 2007. The option "Ability all the macros" in "Macros configuring" in "Trust center configuring" was disability. Tks anyway.

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

Tks for your comments. I'll keep in mind your warning

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

Tks for the tip. If you have an example of this kind of VBA module would be very usefull for me (I'm a beginner programer).

Tks for your reply. I will try with this.

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

Yuor help has been very worthly Tks for share your experience. I hope so see you around soon. Bye

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

Tks for your advice and for your original logic point of view. I going to try these solutions. See you!

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.