Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. timekeepr9

    limit general access to specific forms

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

    limit general access to specific 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...
  3. timekeepr9

    search breaks on foreign key

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

    search breaks on foreign key

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

    search breaks on foreign key

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

    update subform query from VBA

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

    Open a clean form rather than #1 and then go to clean

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

    Prompt for Save on Form Close. Keep Open if Yes and Close if No.

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

    Open a clean form rather than #1 and then go to clean

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

    Open a clean form rather than #1 and then go to clean

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

    Open a clean form rather than #1 and then go to clean

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

    i want to start with the FORM, not the database...

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

    i want to start with the FORM, not the database...

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

    subform used with multiple forms

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

    basic query-form help

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

    subform used with multiple forms

    I know I shouldn't need a form for each classroom, I didn't set up that part, but that is how it is setup. I think they were worried about concurrency issues since staff from each of the classrooms would be entering information in at the end of each day at about the same time. Would...
  17. timekeepr9

    subform used with multiple forms

    Hi, I am working on a form for a database for a school. Basically, I have one form for each classroom. On each of those forms is a subform, which is the same for all of the classrooms. I want to be able to show some information on the subform based on the student selected in the outer form...

Part and Inventory Search

Back
Top