search function and update function

[beanbeanbean]

hi guys i need some help here.

i am quite new to access and was wondering.



1) are there ways to create a search function in which a person can locate all the information of a particular query from my database by the person's lanid ?


2) are there ways to update the information after i've inserted them ? like for example. i've inserted the information into the table and i would like to edit it as some information has been updated.

are there ways to edit the data besides going to the table to edit it ? i'm having some problems as if i edit the data from the table. some fields can be left blank. which i do not want that to happen.


3) for my date portion, is it possible to restrict the date input ? like for example, the date that can be inserted into my text box could be

32 / 32 / 2008 this is wrong as there is no such day.
is it possible to restrict it the 31 days , 12 months only ?


would really need your help ! thanks

attached is my database.

 

[Rich]

You should be using forms to enter/view data and not the table, set your date fields as Date/Time and not text

 

[beanbeanbean]

i'm sorry i'm kinda new to it. is there any possible way to get help ?

 

[Balr14]

I don't have a lot of experience either, but I don't think it's practical to ask anybody to enter that much information. They could find what they are looking for faster by scanning the table, manually. You need to quantify your search with some pulldown lists to select from.

For updates, attach your table to a form, have a pull down list to select the record, populate the form from the pulldown list selection and update the form. Use code to validate your form data.

 

[Rich]

i'm sorry i'm kinda new to it. is there any possible way to get help ?

Download some of the samples from Microsoft, Northwind/Orders etc are very helpful