Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Access: Restrict Data entry Tables
Name: MAllen Date: May 28, 2005 at 06:41:10 Pacific OS: - CPU/Ram: -
Comment:
Hi
I am currently working on an Access table for a phone call centre (scenario)
The table has to be normalised so the customers can pick no more than 10 best friend numbers and the ten country codes selected are different.
I was wondering how do you set the table validation so only 10 records can be entered.
And also how can you get it that once one countrycode has been used from a lookup in the table it can't be used again.
Name: smithdk Date: May 30, 2005 at 06:18:36 Pacific
Reply:
Look into using the dcount command in the form. Just have it count the records in the table that shows the customer to best friend relationship. You can use dcount for the countrycode too.
Summary: Well, you did entitle your post "1 Click Data entry" and that's what the SelectionChange code will give you. <g> Plus, if you don't want the date in the cell you selected, all you have to do is sta...
Summary: Access 2003 I have created a basic RA tracking database On a data entry form there is a dropdown list that contains a list of suppliers. Is there a way to add new suppliers to my current dropdown list...
Summary: Hello, I am currently making an access database which reads .txt files for which a C++ program has written data to. I am therefore right clicking in the table section in access and choosing "Link Tabl...
0 
