Search results

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

Sorry, Do you want me to send you the database im working on. or set u a "dummy" database so you can add the code to the search form.

Thanks Simon. But where do i add the code. do i add it to a command button with a text field. Im a little confused sorry . I a noob when it comes to access and VBA.

jdraw that was very useful. Thank you. Is there any code that i can add to the one in the video that would open a specific form that would display the info i search for.

Thanks for the help. i have viewed lots of tutorials in the past 2 days. its a lot to take in. but i think i understand for the most part. So i have one specific question. I want to have a small single form with only a text field and a button, used to search. I have no idea how to code this...

I am willing to do the work, i have to learn somehow. here are the tables im using and the fields in each table. tblInmate DOC# - primary key Last Name First Name Date of Birth Age Height Weight Race Classification Institution Job Date of Hire Date removed tblWarning Date Offense Disposition...