Recent content by timekeepr9

Ok, that would work for forms...but how would I bar access from tables? Basically I think the problem is that if I restrict access to the tables and everything, then I can't allow access to the forms.

Hi, I have a database w/ multiple tables/forms/etc. There are 3 forms that the average user should use, but the rest of it I would like to hide from them, simply to keep people from going to the wrong place and accidentally messing things up. What I would like is to be able to password protect...

I figured out the problem..Anything you use in the WITH statement has to be in the report since foreign key wasn't in the report, it wouldn't work. So now to figure out if I can have it in the report without it being visible...

Each incident only involves one student. If more than one kid is involved, they each get their own entry. I know its bad to have spaces, but I didn't make the original tables, and its too late to change it now (used in too many places) There is a student 189, and he does have entries in the...

Hi, I have 2 relevant tables, one with a list of students, and one with a list of incidents regarding students. The student's primary key is the incident table's foreign key. I have a form where the user can basically create a query through combo boxes to create a report with the selected...

Hi, I have a table w/ a bunch of generic text fields. I am trying to create a form with a number of comboboxes where you can change the WHERE in the query by changing what is in the combo boxes and hitting search. This seems like it should be really simply, but I can't get it to work. I have...

Awesome, that works except one problem. For some reason the if Not Me.NewRecord part doesn't seem to be doing it's job. If it is already on a new record, it throws an error. I cheatingly got around it be telling it to exit sub if it gets an error, but is there a proper way to do it? Thanks...

Why not just have it save automatically if they click yes? Just copy paste what the save command does into the click yes code.

If you do what TheAceman1 said, you should still be able to navagate through all of the records. I got it to work for the main form, but I can't figure out how to make it work for the subforms. My subform is called [Points Sheet Table - 1 per Date Subform] (I didn't name it!) In the...

This works for when you first open the form. However, I have 2 subforms, and on the outer form you can change which person you are selected, and it brings up the data in the subform related to those people. Whenever I change people, it still goes to the first in the column. Is there a way to...

I have also been looking for an answer to it, if you figure it out elsewhere, could you post it for me? Thanks!

If all your database is keeping track of is customers, or something of the sort where there is only ever one entry per person, then you are right, you only need one table. If you wanted to keep track of say, customers and purchases, then you would want 2 tables, one for the customers and one...

It sounds like you are trying to figure things out a bit backwards. The first thing you need to do is to decide what database software you are going to use and how you are going to set it up. (It sounds like you don't have a database yet..) Since this is an ms access forum it would make I'll...

Well basically what I have is a table with all of the student information (first name, last name, classroom, etc) and then how they had it set up was a query for each classroom, taking information from the student info table based on the teacher. Two other tables, an incident report table and a...

Hi, This is probably really basic, but I'm having a hard time combining access and sql. Basically, I have a table with three relevent columns, foreign key, behaviors and consequences. The foreign key refers to another table with a list of names. I have three combo boxes, names, behaviors and...