If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HELP!!! Validation rule
I have to introduce in a table some data, using a form with contrtols: combo
boxes and text boxes. The fields need to follow some VALIDATION RULES, and to display the VALIDATION TEXT as the error message. The validation rules must to fields from a query, because the that table is used to extract items from a storage and it musn't contain data that was not entered (that query representing the state of the storage at that moment). How can I do this thing? Please, help me! I'm stucked. |
#2
|
|||
|
|||
HELP!!! Validation rule
Access supports both validation rules and text within the
table design. Simply select edit on your table and check out the properties. These rules are followed regardless of how the data is entered. Directly in the tables or via forms, queries, whatever. -----Original Message----- I have to introduce in a table some data, using a form with contrtols: combo boxes and text boxes. The fields need to follow some VALIDATION RULES, and to display the VALIDATION TEXT as the error message. The validation rules must to fields from a query, because the that table is used to extract items from a storage and it musn't contain data that was not entered (that query representing the state of the storage at that moment). How can I do this thing? Please, help me! I'm stucked. . |
#3
|
|||
|
|||
HELP!!! Validation rule
I have to introduce in a table some data, using a form with contrtols: combo boxes and text boxes. The fields need to follow some VALIDATION RULES, and to display the VALIDATION TEXT as the error message. The validation rules must REFER to fields from a query, because the that table is used to extract items from a storage and it musn't contain data that was not entered (that query representing the state of the storage at that moment). How can I do this thing? Please, help me! I'm stucked. |
#4
|
|||
|
|||
HELP!!!!!! Validation rule
I know. The problem was:
The validation rules must report to fields from a query, because the that table is used to extract items from a storage AND THE TABLE MUSTN'T CONTAIN DATA THAT WAS NOT ENTERED (that query representing the state of the storage at that moment). How can I do this thing? Please, help me! I'm stucked. "Turner" wrote in message ... Access supports both validation rules and text within the table design. Simply select edit on your table and check out the properties. These rules are followed regardless of how the data is entered. Directly in the tables or via forms, queries, whatever. -----Original Message----- I have to introduce in a table some data, using a form with contrtols: combo boxes and text boxes. The fields need to follow some VALIDATION RULES, and to display the VALIDATION TEXT as the error message. The validation rules must to fields from a query, because the that table is used to extract items from a storage and it musn't contain data that was not entered (that query representing the state of the storage at that moment). How can I do this thing? Please, help me! I'm stucked. . |
#5
|
|||
|
|||
HELP!!! Validation rule
Hi Chris,
If you're storing your data in a Jet database (an .mdb file) you can't do this at the table level. Instead, put your validation code in event procedures of the form and its controls. Typically, validation for a single field would be in the corresponding control's BeforeUpdate event, or validation for the entire record in the form's BeforeUpdate event. On Sun, 30 May 2004 01:37:08 +0300, "Chris" wrote: I have to introduce in a table some data, using a form with contrtols: combo boxes and text boxes. The fields need to follow some VALIDATION RULES, and to display the VALIDATION TEXT as the error message. The validation rules must to fields from a query, because the that table is used to extract items from a storage and it musn't contain data that was not entered (that query representing the state of the storage at that moment). How can I do this thing? Please, help me! I'm stucked. -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
#6
|
|||
|
|||
HELP!!!!!! Validation rule
On Mon, 31 May 2004 13:24:02 +0300, "Chris" wrote:
I know. The problem was: The validation rules must report to fields from a query, because the that table is used to extract items from a storage AND THE TABLE MUSTN'T CONTAIN DATA THAT WAS NOT ENTERED (that query representing the state of the storage at that moment). How can I do this thing? Please, help me! I'm stucked. Could you please post an example of the kind of data that needs to be validated? How are your tables related? What is the SQL view of this query? You may need to use VBA code in the BeforeUpdate event of your Form to determine whether the user entry is valid, rather than a table validation rule. But at present I do not understand exactly what is valid and invalid data. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#7
|
|||
|
|||
HELP!!! Validation rule
I must introduce the data in a table(the table of the exits from a stock)
through a form having the controls : TextboxATA; cmbbox ID_material; cmbbox ID_dimensions; cmbbox ID_Quality; Textbox Quantity, cmbbox UM (kg, m, or pieces); Texbox UnitPrice; cmbbox MonetarUnit; CmbBox ID_order; textbox ProductCode; Textbox UnitsOfProduct These record must not contain data not entered. The entered data (totalized by categories) is represented by the query: SELECT DISTINCT [stoc1-0].Mat_Code, [stoc1-0].Material, [stoc1-0].Dimensions, [stoc1-0].Quality, Sum([stoc1-0].[Length(m)]) AS [SumOfLength(m)], Sum([stoc1-0].[Quantity(kg)]) AS [SumOfQuantity(kg)], Sum([stoc1-0].[Quantity(pieces)]) AS SumOf[Quantity(pieces)], [stoc1-0].ID_material, [stoc1-0].ID_Dimensions, [stoc1-0].Cod_Calit, [stoc1-0].UM, [stoc1-0].UnitPrice, Sum([stoc1-0].[TotalPrice]) AS [SumOfTotalPrice], [stoc1-0].[Price(euro)], Sum([stoc1-0].[TotalPrice(euro)]) AS SumOf[TotalPrice(euro)] FROM [stoc1-0] GROUP BY [stoc1-0].Material_Code, [stoc1-0].Material, [stoc1-0].Dimensions, [stoc1-0].Quality, [stoc1-0].ID_material, [stoc1-0].ID_Dimensions, [stoc1-0].Cod_Calit, [stoc1-0].UM, [stoc1-0].UnitPrice, [stoc1-0].[Price(euro)] ORDER BY [stoc1-0].Material, [stoc1-0].Quality, [stoc1-0].Dimensions; (Mat_code is : Format([id_material];"000") & Format([id_dimensions];"000") & Format([ID_Quality];"000") Can you help me ? How can I validate in this situation the entire record in the BeforeUpdate event? Or how can it be made for every field? I would apreciate your help. "John Nurick" wrote in message ... Hi Chris, If you're storing your data in a Jet database (an .mdb file) you can't do this at the table level. Instead, put your validation code in event procedures of the form and its controls. Typically, validation for a single field would be in the corresponding control's BeforeUpdate event, or validation for the entire record in the form's BeforeUpdate event. On Sun, 30 May 2004 01:37:08 +0300, "Chris" wrote: I have to introduce in a table some data, using a form with contrtols: combo boxes and text boxes. The fields need to follow some VALIDATION RULES, and to display the VALIDATION TEXT as the error message. The validation rules must to fields from a query, because the that table is used to extract items from a storage and it musn't contain data that was not entered (that query representing the state of the storage at that moment). How can I do this thing? Please, help me! I'm stucked. -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
#8
|
|||
|
|||
HELP!!! Validation rule
Chris,
You can create a validation rule per control on a form. On the form, select a control and in the properties window, select the DATA tab. If you want to validate data on a calculated field, you will need to create a procedure on the Form BeforeUpdate Event: Let assume that the SumOfTotalPrice field must be validated: Private Sub Form_BeforeUpdate(Cancel As Integer) 'If SumOfTotalPrice must be 5: If Me.SumOfTotalPrice = 5 Then MsgBox "SumOfTotalPrice must be greater than 5..." 'Set cancel to true so no update to the table Cancel = True End If End Sub Eric "Chris" wrote in message ... I must introduce the data in a table(the table of the exits from a stock) through a form having the controls : TextboxATA; cmbbox ID_material; cmbbox ID_dimensions; cmbbox ID_Quality; Textbox Quantity, cmbbox UM (kg, m, or pieces); Texbox UnitPrice; cmbbox MonetarUnit; CmbBox ID_order; textbox ProductCode; Textbox UnitsOfProduct These record must not contain data not entered. The entered data (totalized by categories) is represented by the query: SELECT DISTINCT [stoc1-0].Mat_Code, [stoc1-0].Material, [stoc1-0].Dimensions, [stoc1-0].Quality, Sum([stoc1-0].[Length(m)]) AS [SumOfLength(m)], Sum([stoc1-0].[Quantity(kg)]) AS [SumOfQuantity(kg)], Sum([stoc1-0].[Quantity(pieces)]) AS SumOf[Quantity(pieces)], [stoc1-0].ID_material, [stoc1-0].ID_Dimensions, [stoc1-0].Cod_Calit, [stoc1-0].UM, [stoc1-0].UnitPrice, Sum([stoc1-0].[TotalPrice]) AS [SumOfTotalPrice], [stoc1-0].[Price(euro)], Sum([stoc1-0].[TotalPrice(euro)]) AS SumOf[TotalPrice(euro)] FROM [stoc1-0] GROUP BY [stoc1-0].Material_Code, [stoc1-0].Material, [stoc1-0].Dimensions, [stoc1-0].Quality, [stoc1-0].ID_material, [stoc1-0].ID_Dimensions, [stoc1-0].Cod_Calit, [stoc1-0].UM, [stoc1-0].UnitPrice, [stoc1-0].[Price(euro)] ORDER BY [stoc1-0].Material, [stoc1-0].Quality, [stoc1-0].Dimensions; (Mat_code is : Format([id_material];"000") & Format([id_dimensions];"000") & Format([ID_Quality];"000") Can you help me ? How can I validate in this situation the entire record in the BeforeUpdate event? Or how can it be made for every field? I would apreciate your help. "John Nurick" wrote in message ... Hi Chris, If you're storing your data in a Jet database (an .mdb file) you can't do this at the table level. Instead, put your validation code in event procedures of the form and its controls. Typically, validation for a single field would be in the corresponding control's BeforeUpdate event, or validation for the entire record in the form's BeforeUpdate event. On Sun, 30 May 2004 01:37:08 +0300, "Chris" wrote: I have to introduce in a table some data, using a form with contrtols: combo boxes and text boxes. The fields need to follow some VALIDATION RULES, and to display the VALIDATION TEXT as the error message. The validation rules must to fields from a query, because the that table is used to extract items from a storage and it musn't contain data that was not entered (that query representing the state of the storage at that moment). How can I do this thing? Please, help me! I'm stucked. -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
Thread Tools | |
Display Modes | |
|
|