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:

More topics


Validating Missing Data by Responding to Data Entry Events

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

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

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}

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

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

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.

Checking\validating data in a subform?

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

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

Require Data Entry with a Microsoft Access Macro

If you are using a Microsoft Access database application for data entry you will want to ensure the quality of the data that is being entered. Validating data in Microsoft Access allows you to check data whilst it is being entered into the database, and there are various ways of performing these actions.
You don't want to be trying to ship an order to a company that does not have address details associated with it. If you don't have a contact name associated either, you can't even call to find the data. Creating a Microsoft Access macro to require data entry into certain fields will prompt the database user to complete this vital information. This will in turn deem your data to be more accurate and useful to all database users.