Good morning all,
First off, let me say that I'm not well versed in VBA. I can read it and understand what it's doing, but do not have the skill to sit and use all the functions from memory.
To give an analogy of what I'm trying to do, imagine you're a game tester for some company. Every Monday you are given 10 new levels to work on, and the same for all other employees. Instead of manually dropping 10 levels to each employee, I need to drop 10 to everyone at once from a form.
I have the idea of how I want my combo boxes to be. One will be used to specify how many levels are to be dropped to the testers, another will be to pick the game the levels come from, and the last will be to pick which tester get them including a final option that says "Everyone".
My table structure is simple. One is used as the "levels" table so we will call it dbo_Levels. There is one field in this table that is used as the "tester" field, which is just a number ID that refers to the dbo_testers table. How would I go about adding a button to the form that updates every 10 records with a testers ID in dbo_Levels, then another tester gets 10, etc...until each tester has 10 levels each with one form button?
Hope thats easily understood.
Wes
First off, let me say that I'm not well versed in VBA. I can read it and understand what it's doing, but do not have the skill to sit and use all the functions from memory.
To give an analogy of what I'm trying to do, imagine you're a game tester for some company. Every Monday you are given 10 new levels to work on, and the same for all other employees. Instead of manually dropping 10 levels to each employee, I need to drop 10 to everyone at once from a form.
I have the idea of how I want my combo boxes to be. One will be used to specify how many levels are to be dropped to the testers, another will be to pick the game the levels come from, and the last will be to pick which tester get them including a final option that says "Everyone".
My table structure is simple. One is used as the "levels" table so we will call it dbo_Levels. There is one field in this table that is used as the "tester" field, which is just a number ID that refers to the dbo_testers table. How would I go about adding a button to the form that updates every 10 records with a testers ID in dbo_Levels, then another tester gets 10, etc...until each tester has 10 levels each with one form button?
Hope thats easily understood.
Wes
