Search results

Perfect, Thank you. Looking at the formula, I think I understand how it works, all except for the Nz and the [/code] part.

DSum() sounds great...... would you be willing to educate me on how it works? and how the formula would flow? i have very basic knowledge of this, i clicked the embedded subform in the design menu to figure out how the two tables would go on the main form.

Hello, Need some advice. I have a VERY simple database set up to help a friend of mine to keep track of very simple plumbing business. he has been using for a while, but asked if i could figure out how to subtotal what customers still owe him so he does not have to do the math. I made three...

alright, so i think i finally figured out how to do what i wanted to do. i am using the Form's On Current selection and i am toggling the visibility of the item on and off based on a value in the field. here is a copy of the code that i used. Private Sub Form_Current() If...

it looks like i wont PM you. or at least, i cant figure out how to in this forum. Looking further at the additions, i have a couple of questions about how navigation or addition of students as well as showing students how many spots are left in each class. I know that you said that you did...

this does solve the hide names problem. Thank you. I will PM you.

here it is. I have 13 classes planned out so far. the open form is what was going to pop up first with the other forms hidden from view. the set up form gives access to the admins (myself and one other) to add more classes and see who is signed up for the class. there is a password on that...

I am not sure how to do that.

Any way that I can get it will work just fine. I need a way to list all available classes and how many slots are left without showing who is already signed up. what i have right now is a very simple form that lists students 1-16 and i was thinking about just having access cover up those that...

I don't have that ability yet. I am trying to make this work in the short term until we get our full sharepoint in which they will be able to sign up for things and it will be user dependent. until then, this is my best hope. the goal in hiding names from all users is to prevent "buddies" from...

Thank you for the Welcome. I am trying to prevent any of the students from seeing who else is signing up for classes. I plan on splitting the database and placing the locked front end in a shared folder for all users of our company systems. i just have to get it right before i can deploy.

Hello everyone, I am creating a database that has a couple of levels. The open form, which gives three choices, Student, Admin or close. The Admin form is password protected on load, and it is working fine. The Student form is the one that i need a little help with. when it loads a record...