Search results

Is it possible to restrict certian people from adding records using certian forms? I have a group of 3 different people that need to add records but the rest of the office only need to view the db. The database was made using access 2000. Cheers

solved i think ive solved it.... in my other form i put this in the default value. =Forms![FirstFormName]![Fieldname] easy as that :D

? cany anoyone help?

ok i wasnt sure if this problem can be solved by using a macro or is something i have to do in a form, so thats why iam posting here. ok what i have is a company details table that has a company ID field that obviuosly makes each company unique in the database. I have also got a Company Waste...

ok worked it out hi again. worked out how to do it. didnt relise you had to do it this way [postcode]="m11" or "m1" or "m5" thought i could use "and" :( thanks anyways

hi im having trouble with my query. ok what i want to do is only show certain records, i want it to pull the record according them to there postcode (in my table postcode is seperate to postcode unit). ok what i can do at the minute is pull say M11 and M1 using criteria and Or but that...

Ok heres the situation. I have 2 tables Company Details and Waste Available, what happens at the minute is that i have a form showing company details which contains a sub form which shows what waste the company has available. so what happens at the minute is when i click on the sub form, you...

whoops... sorry about that the one thing i didnt check, the thing was that customers were assigned a company, but the companies they were assigned to didnt exsist. thanks

ok this might be a dumb question but i cant seem to solve it. ok heres the situation. i have a table called Customer Details which has these fields (only important ones included): Contact ID - Company representative's index number Company ID - obviouly where the person works. Title Firstname...