Replies

A lot of the security I’ve figured out….I just realized I needed the One – To – Many relationship, but forgot that I’d set the SSN as the primary key in Table 2. My primary key is only in table 1, but when i try to enter a ssn again in the form to add another instance, it won’t let me….

A lot of the security I’ve figured out….I just realized I needed the One – To – Many relationship, but forgot that I’d set the SSN as the primary key in Table 2. My primary key is only in table 1, but when i try to enter a ssn again in the form to add another instance, it won’t let me….

Well yes, I have my admin user level set, but 1) how do i create more? Also – I have two tables, my main table (Table 1), and another one (Table 2), both have ssn. I want to allow multiple occurrances of SSN in Table 2, as Table 2 will contain recurring events (scores from competitions…) how do I have to set that up? I’m trying to set up a form where all that is entered is SSN, date, and score (assuming that will create a new record), and then I can create a report saying who hasn’t competed, as well as all previous competition scores. I’d also like to export that info as excel, so I don’t have to PRINT the grouped report….

Well yes, I have my admin user level set, but 1) how do i create more? Also – I have two tables, my main table (Table 1), and another one (Table 2), both have ssn. I want to allow multiple occurrances of SSN in Table 2, as Table 2 will contain recurring events (scores from competitions…) how do I have to set that up? I’m trying to set up a form where all that is entered is SSN, date, and score (assuming that will create a new record), and then I can create a report saying who hasn’t competed, as well as all previous competition scores. I’d also like to export that info as excel, so I don’t have to PRINT the grouped report….

Awesome…thanks! I’m a little confused right now. How do I set a user group so it is unable to view the database window, but able to edit information I select?

Awesome…thanks! I’m a little confused right now. How do I set a user group so it is unable to view the database window, but able to edit information I select?

What if I have a FE/BE design? What kind of measures would I have to take to ensure they can’t access it directly? I’m going to have a password on the back end…

What if I have a FE/BE design? What kind of measures would I have to take to ensure they can’t access it directly? I’m going to have a password on the back end…

In an update query, how do you assign a destination?

In an update query, how do you assign a destination?

I understand it will make a new table…I’m ok with that, what I don’t want to change is my original list of records.

I understand it will make a new table…I’m ok with that, what I don’t want to change is my original list of records.

So Rng.Rows.Count To 1 Step -1 Is looking at the current row, and then moving on? or backwards through the entire document, going row 1 then to row 65536, then to 65535, and so on?

So Rng.Rows.Count To 1 Step -1 Is looking at the current row, and then moving on? or backwards through the entire document, going row 1 then to row 65536, then to 65535, and so on?

Thanks for the help, I’m trying to absorb all this in and decipher it on my own, I’m taking a class on this but it isn’t as in-depth as this…I’m trying this problem just to test myself and push myself to learn more….I have a question….

What exactly does this do: Count To 1 Step -1