Recent content by eolson30

Hey AnitaPita, is there any chance to can email or post the one you use.

I have a database in 2003. and i need to create a login that has user and admin login. the user needs access to only 2 forms, and i need them to have no access to the tables, queries, or anything else. and the admin needs access to everything. it this possible. is there a template that...

Ill email you the fields for each table and the forms i need and the reports and any thing else i can remember thanks again

OK. What info do you want me to forward to you

That would be great. Just let me know what your email address is. And ill forward you the info for each table and any info that you need. Thanks for the help.

Ok thanks. Now where in the table to i add the vba come. and under what event?

ok thanks for trying. Is there a VBA code that can be added to a subform in a table that when clicked it would open a form with specific data that would be entered on the form. example. if there was a data table that had the field EmpID and when clicked or dbl clicked would open that employee...

Yeah i have it in a trusted location.

I have the "students" database from the MS website. and i need it converted to access 2003. i thought i was able to do it, but absolutely none of ther buttons or OnClick stuff doesnt work. i will donate or pay if someone can do this for me. thanks the database is to large to add to this post...

The "students" database has a form called Studenst list. and there is a field that says "new" when clicked it opens a form to add a new student. and if there already a student the field says "open". how can i get this from to work with access 2003. i just cant seem to get it to work. it there...

I found it. i think ive found everything to finish my database. but i need hel with 2 things. The MS Database Temlate "Students" has a form called "Students List" it has a field that has "new" in it and when clicked it opens a form to add a new student. if theres already a student there...

Thanks for the website. I its a good source. but i cant find the code im looking for. i need code to clear all text fields on a form and start new. Ive tried the gotonew record but it still saves the info. i need it to not save the info . thanks

i did the "GoToNewRecord" but it still saves the data. is there a way to add a VBA code to not save the info entered and clear the form. Is there any websites or info i can learn VBA code for access 2003 i think thats where i getting lost

I agree with you, but i need to make this idiot proof for my fellow staff. Thats why i need so many buttons. the one button im having problems with is the clear data button. I need the button to clear the data on the form not delete the original data. almost like i started to enter data...

Simon you are amazing. that test database was exactly what i needed. can you do one more thing for me. i need to add command buttons to a form. i have the buttons but not the VBA code. "Save & New" Save data and clears form for new entry "Save & Close" Save data and close the form "Clear...