Automatic Entry

[rt49]

Using Access 2000, I am creating a database to compile results of district all-state band tryouts. Students who make all-state are assigned to one of three bands ? red, white, or blue. For example, six flutes are chosen from the district. Two are assigned to red, two to white, and two to blue. The seventh highest scoring student is given alternate status. I have a form and a report based on a query. Both the form and the report list only the seven highest scoring students and are sorted highest to lowest. The sorting and selection of the top seven was done in the query. In the query, I have a field named band to put either red, white, blue, or alternate. What I would like to do next is have the query, form, and/or report automatically fill in this information. I do some VB programming, but do not know much about VBA. So any help needs to be specific as to steps to take and to syntax. I?ve tried some things that might work, but possibly the syntax is wrong or maybe the code is wrong or is in the wrong place. Thanks for any help.

 

[David R]

Now which post would you like us to reply to? You've asked the same question in four different Forums. Please, pick one next time that it seems to fit under; if none seem to fit or it crosses boundaries, use General. Someone will read it (whether they know the answer is still up for debate, but posting it four times only tires people out and makes them less likely to help you, not more).

Good luck,
David R

 

[rt49]

Sorry if that was a problem. Since I don't know the solution to the problem, (obviously, or I wouldn't have posted) I wasn't sure where to post it. If this was some sort of breach of ettiquite, I didn't know. If what you say is true, why are there so many forums on this site? But, again, sorry and thanks for the advice.

 

[David R]

There are different forums because most questions are specific enough that they deal with a problem with a Query, or a Form, or formatting a Report, or...you get the idea. When something is generalized, it goes in General. When it's high-level code, you may get a better response in Modules & VBA.

Since your question was so broad, General would have been an appropriate place for it.

The problem with posting in multiple forums is (for example) I may read and post a suggestion in Forms, someone else may post a possible solution in Queries, a third person may respond in General asking a clarification question, and someone else may correct your syntax in Tables. Now you've got four different people working on the same problem, but in different ways and not working together. The strength of these Forums is the collective knowledge of all the users who read your post(s). If my suggestion makes person B have another idea, they post that, and then person C asks the clarification question that A & B didn't spot, and D catches a typo all three of the other posters missed. Now you've got a very strong thread toward a solution.

Now, that having been said; you might want to followup your post in General with some examples of the code/tactics you've tried. It will both help people spot errors and know what your current coding level is.

Good luck,
David R