Topics Search

validating fields

validating fields
Views: 0
I have a table which has a country field and basis the values in that field I want the other field should get its value. For e.g. if country is 'uk' then the charges should be '200' or if the ountry is 'india' the chrges are '400'.if anybody could help solving this please
Sponsored Links:

Similar posts...


Validating Missing Data by Responding to Data Entry Events

Validating Missing Data by Responding to Data Entry Events Icon
We can use various techniques for validating data being entered into our database, as seen in the Validating Data in Microsoft Access article, however sometimes our validation routines can be overly restrictive.
There may be occasions where we need to be more flexible in our approach, and we may just want to warn the users of the database that data is missing when they are entering a record into the form. When we are entering the data, it is possible to respond the the data entry event, and use a Microsoft Access MsgBox function to perform different actions depending on what the database user wants to do.

Validating tables

Validating tables Icon
I am trying to validate two tables. I have 2 address fields that are from different people. One person may enter the address as 1 Main Street while the other may enter it as 1 Main St. How do I get the two entries to recognize each other in a query? I have the relationship between the Address fields and when I query them neither show up because they are different.

Validating Data in Microsoft Access

Validating Data in Microsoft Access Icon
Validating data in Microsoft Access allows you to check data whilst it is being entered by the database user and will enable you to not save the data if it breaks any validation rules or routines. It is easy for an end user to make a mistake when they are entering data or even to leave out important details that must be entered, so we need to check this data when it is being entered into the database. Allowing invalid data to be entered into the database ensures that the database and the data available will become less valuable and harder for the user to use.

Validating Required Data in Microsoft Access Text boxes

Validating Required Data in Microsoft Access Text boxes Icon
You may want to prevent users from saving Microsoft Access records with missing information, especially if this data is important. There are several approaches to this and various methods can be used in Microsoft Access, which can be applied in various places. Ideally, you will not be letting your Microsoft Access database users have access to your database tables, so you will need to validate this information in your database forms. You will need to put your validating code in the Microsoft Access form's BeforeUpdate event. This way you can cancel the saving or adding of a record with missing info.

Validating user input {Syntax error in FROM clause}

Validating user input {Syntax error in FROM clause} Icon
I am new here and I am having trouble with validating user input against a Microsoft Access Database. I am developing an application in which a user enters a user name and password. What I need to do is somehow validate the input against my access database.


But when I run it against an id and password in my database diz the error I get

OleDbException was unhandled {"Syntax error in FROM clause."}
And the error points to the statement dr = cmd.ExecuteReader,

MS-Access Find Duplicate Query Wizard

MS-Access Find Duplicate Query Wizard Icon
As the administrator of a Microsoft Access database, one of the jobs that you may need to do is the keep the database working as efficiently as possible. A major cause of performance issues and database slowdown is erroneous or duplicated data contained in a table. We can keep these problems to a minimum by validating data entry and preventing duplicate information from being entered.
We may have inherited a database that already contains duplicate information, and in the case we can use the Find Duplicates Query Wizard to search out this data.
Using this wizard we can create a query that reports which record(s) in a table are duplicated using some field or fields in this table as a basis for the query. Microsoft Access asks which fields that you want to use for checking duplication and also which other fields you would like to appear in the query results. We can also use the Find Duplicates Query Wizard to help find possible duplicate key violations; a valuable trick when you want to take an existing table of data and make a unique field with one of the existing data fields.

Validating a field to match a corresponding field in another table

Validating a field to match a corresponding field in another table Icon
Kind of an Access newbie here, so bear with me, but I have two tables: a master list of data and another that shares many of the same fields but the data is updated/replaced every so often. Let's say they both share a "Member ID" field. Can I make a validation rule on this field so that you can only enter data that matches what's in the Member ID field in the master table, and if so what would it look like?

Edit: The purpose of this would be to prevent errors. I'd like to get it so that you wouldn't be able to enter a MemberID in the second table unless it already appears in that field in the master table.


Report_Grouping Icon
I have a report with many fields from one table. Six of the fields are memo fields that can grow. I am trying to add a grouping to each of the memo fields so that I can force a new page and / or keep together.

The memo fields are not showing on the field/expression dropdown. They are valid fields and are present in the field listing.

Do I have too many other fields? Is there a limit? Can you not sort/group on memo fields?

I tried having each of the memo fields as a subreport, but that does not work either.

Checking\validating data in a subform?

Checking\validating data in a subform? Icon
Im trying to check for data in a subform and if its empty then allow the user to quit - can anyone shed some light on how to do this please? (Not too sure if its a vba question or not, although I will be trying to use VBA

UK postcode validation

UK postcode validation Icon
Can anyone please help me in validating the UK postcode. I have a textbox and on the after update event I want to check if the customer is UK customer or non UK customer