Search results

hummmmm, another question. the prog you gave me does a great job in averaging that student. to take this a little further, do you know of anyway i can average an entire class?? im guessing using the DAvg statement you used but i cant seem to figure out how to make it give me the average...

that works great..... you guys make it seem so simple thanks Ricky

Dont know why the code isnt working, it still brings up all records with those initials instead of the one in the form now for the good news.... i managed to get it to work by creating another field, autonumber field, this way making each record unique....and used this field under the...

will trim the db and post later this evening as i do not have the ability to do that here at work, but in the meantime what is happening with the code is that it is grabbing the initials from the form and apparently doing a search in the db for all records that match the initials.....the code i...

works like a champ, but still have a small problem, could be in the way i structered the db.... what i am actually using is 2 tables....one stores the employees name, working initials, phone #'s etc... the other stores overtime activites....date assigned, amount of hours, supervisor who...

hey guys, i am kinda a newbie to this, where do i enter that code????

duhhhhh, dont i feel stupid, the only thing i didnt try was opening the be file...... guess youll never learn unless ya ask thanks for the help Ricky

but, but, but...... when i try to edit the fe it states that i cant because the be is linked....is there a way to open the front end without the be???

first let me start off by thanking all of you, the knowledge i have gained from this forum is invaluable....... now on to the next question... i have a db that works great, but whne i try to update the fe, tables, it says i cant update because the table is linked..... is there a way around...

I have seen several threads on this but for some reason i cannot get it to work. pblm: i have a form, pretty basic actually, empid, OTdate, hoursassigned when Overtime for the employee is assigned thru this form i would like the program to print a letter to the employee notifiying them of...

Thanks alot, worked like a champ ! ! ! Ricky

i have a db with two tables.....one has an incident basic information, such as case#, date, location etc..... the other table has reports on that case, this table includes fields such as case#(in order to sync with 1st table) time of reports, and so forth.... i created a query which will be...

works great... thanks for all the help guys Ricky

how can i design a query to search for a value that is selected from a listbox??? i would like to design the table so when the user clicks on a button they get a choice of data, (from the listbox) once they click on the one they want the query inserts that data into the query and displays the...

wow...... it worked, i have been beating my head against the wall for days with that one i guess its time i learned how to write code....... thanks alot Ricky ps, any good suggestions for books on how to learn to write code for access???

sorry but i dont understand where do i put that code??/ also, i read my original post and it seems a bit confusing, let me try and explain it again. my db has an employee_info table and an overtime_events table...through a form i created the supervisor assigns overtime to each employee and it...

hi guys, prob a simple solution but my simple mind just cant seem to figure it out.... my db tracks overtime, when a person is assigned ot the supervisor puts the total number of hours they are to work on that specific day along with other information into a table. i would like access to be...

Newbie here, so please be patient with me... here goes, I am attempting to create a database that calculates seniority dates. Employees lose seniority when they get temporarily assigned to different offices. for example if employee A was hired on Jan 1, 1990. that would be his seniority...