C
Cat Winslow
[I was disconnected while trying to post this before; apologies if it repeats.]
I have a db with 6 users who input data from the 5 programs our company
runs. For each program, when a Customer buys a certain amount of a Product,
they also get either a Game setup, or a choice of other Stuff (hats,
T-shirts, etc). (2 of the users do the separate halves of the largest
program.)
Here's the problem: For each user, the input person enters the order for:
*How much Product was ordered
*Stuff available (one Program may have XL shirts and hats, another S M L XL
shirts, another has different hats and tennis balls, etc.)
*Games available (according to the Program, just like the Stuff) according
to the Program they run
*Times are different for each Game (some run at 8am and 2pm, another at 10am
and 2pm)
My fields all correspond to 99% of the data (one Program lets the Customer
choose a Team, so that field is only used for the one program), but my users
all want their Form/Subform setup and their reports to be unique to their
Program. As it is now, say for my main input form, I have 5 queries and 5
form/subforms, one for each user. Small, but irritating differences exist,
like one program runs on a funky fiscal year.
It just seems like ther should be a more compact way of doing this. I have
maybe 50 queries, which seems like a lot (?) Is there a better way? (I'm a
pretty good Access user, but haven't done much VB.) Thanks in advance!
I have a db with 6 users who input data from the 5 programs our company
runs. For each program, when a Customer buys a certain amount of a Product,
they also get either a Game setup, or a choice of other Stuff (hats,
T-shirts, etc). (2 of the users do the separate halves of the largest
program.)
Here's the problem: For each user, the input person enters the order for:
*How much Product was ordered
*Stuff available (one Program may have XL shirts and hats, another S M L XL
shirts, another has different hats and tennis balls, etc.)
*Games available (according to the Program, just like the Stuff) according
to the Program they run
*Times are different for each Game (some run at 8am and 2pm, another at 10am
and 2pm)
My fields all correspond to 99% of the data (one Program lets the Customer
choose a Team, so that field is only used for the one program), but my users
all want their Form/Subform setup and their reports to be unique to their
Program. As it is now, say for my main input form, I have 5 queries and 5
form/subforms, one for each user. Small, but irritating differences exist,
like one program runs on a funky fiscal year.
It just seems like ther should be a more compact way of doing this. I have
maybe 50 queries, which seems like a lot (?) Is there a better way? (I'm a
pretty good Access user, but haven't done much VB.) Thanks in advance!