Re: Order by property and OrderByOn

I think I remember you asking in another post about newsgroup etiquette. On
that topic, it is good form to acknowledge responses, even if you cannot use
them. I for one will not bother to answer your posts in the future.

"Hughie" <Hughie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:15F40514-EF61-4DE1-94F2-1DAFADE69E98@xxxxxxxxxxxxxxxx
> My objective is to create a behavior incident reporting and tracking
> database
> for the school in which I work. Staff members will input descriptions of
> incidents as they come up. The first form is for staff input. Another
> form
> which is built on the same table as the first but with added fields, will
> be
> used by administrators and detention room folks who deal with each
> incident.
> The Tables are composed of:
> Table 1) Student names with with home address, phone, etc.
> Table 2) Staff names, which includes all staff in our school.
> Table 3) Incident description Table 4) General time of day (during
> class,
> during lunch, between classes, etc., and Table 5) a list of consequences
> applied by staff
> As I started this task, I noticed that there were no common fields in
> these tables upon which to build relationships. So my efforts to build
> queries have not worked.
> Instead, I built another table, the TableA referred to earlier which is
> otherwise called tbStuldent_Behavior_Log. This table is built the
> "underlying tables", i.e., contains fields from first five tables. In
> this
> table, the unrelated data that would describe a single behavior incident
> is
> combined together in records. The records are created by staff members
> and
> stored in tbStuldent_Behavior_Log.
> I've not seen how to accomplish that same thing using queries.
> A NEW observation is that when Table 1 mentioned above (students with
> addresses) includes the 5 digit student ID number, that field overrides
> any
> attempt I'm made based on previous suggestions, to sort by a different
> field.
> When I went back to the Table 1 and deleted the student ID field, the sort
> order remained as imported, which is ascending by student last name. But
> when the student ID field is present, Access sorts by it. Problem is,
> while
> not totally necessary, I'd like to have the student ID field in the table.
> While I'm sure there are more elaborate approaches to this goal, as a
> newbie, I can't think of any other way to do it and I don't see the
> forthcoming hidden problem with this approach.
> I do appreciate all you the patience and will appreciate any further
> comment/direction.
>
> "BruceM" wrote:
>
>> You have lost me (and probably quite a few others as well) when you said
>> that the table is made up of other tables. What do you mean by that? A
>> table could have been created by combining two or more tables, but a
>> table
>> is a container for data, not for other tables. It would help if you list
>> your table fields and relationships, and include a brief general
>> description
>> of your database's purpose. You would probably do better if you created
>> the
>> realtionships before trying to create the query. Table relationships
>> will
>> be carried through to any queries based on those tables.
>> If you cannot get a query to work, that issue is worth the effort of
>> addressing. Attempting to work around something that should not have
>> been a
>> problem in the first place is likely to lead you nowhere.
>>
>> "Hughie" <Hughie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:372C6046-50A5-4F24-9C77-755AD0EADB9E@xxxxxxxxxxxxxxxx
>> > I've not been able to make a query work.
>> > The form is now based on a TableA that is made up of underlying tables
>> > that
>> > have no related fields:
>> > TableA contains a table of student names and demographics, a table of
>> > teacher names, and several other tables, again, that have no related
>> > fields.
>> > It has worked best to build the form on TableA.
>> > When I try to build a query on TableA, the query returns a record for
>> > (what
>> > appears to be) every combination of fields. As a newbie, I'm not
>> > familiar
>> > with the different types of queries. I'm confused when I add the
>> > tables
>> > in
>> > Query Design view, that there's no way to associate the tables and thus
>> > I
>> > can't control the join properties.
>> >
>> > Another point I've forgot to mention before is that the tables,
>> > regardless
>> > of what I do in the Order by property and the OrderByOn code, are being
>> > sorted on a numeric field in the TableA.
>> >
>> > "Ed Robichaud" wrote:
>> >
>> >> One of the simpler methods is to create a query that sorts your data
>> >> however
>> >> you like, then set the record source of your form to that query.
>> >> -Ed
>> >>
>> >> "Hughie" <Hughie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:4FE5009E-7513-4DAC-806A-2B2D1CCDAD37@xxxxxxxxxxxxxxxx
>> >> >I want to have my form set to sort by a particular field each time it
>> >> >opens.
>> >> > My reference book says to use Order by property in the table and
>> >> > OrderByProperty in the form.
>> >> > Problem is book doesn't say how to use the Order by property and I
>> >> > can't
>> >> > even find the OrderByOn property for the form. Please advise.
>> >> > Thanks.
>> >>
>> >>
>> >>
>>
>>
>>


.

Relevant Pages

  • Re: Order by property and OrderByOn
    ... My objective is to create a behavior incident reporting and tracking database ... The first form is for staff input. ... Table 1) Student names with with home address, phone, etc. ... > realtionships before trying to create the query. ...
    (microsoft.public.access.gettingstarted)
  • Re: Cumulative cost
    ... When you say "running total per student", I believe this means the same ... You can use a Totals query to get a "per student" Sum ... AND calculate something you're calling "cumulative cost". ...
    (microsoft.public.access.forms)
  • Re: HEY Jerry dink
    ... Ah HA here we go....you are not on staff at any of the local DZ's SO ... Its just the nature of the business, ... the little wino's who show up to drink up all the student beer. ... I see them as drunken mooches...make last load even back then and the ...
    (rec.skydiving)
  • Re: Searching for and editing a record in form view
    ... I've created a query but I was a bit unsure of this, ... different from the StudentID for any other student. ... So I've done what you said, went to the switchboard, highlighted the combo ... This one opens the form to a specific record. ...
    (microsoft.public.access.forms)
  • Re: After School Attendance
    ... run a query for a reporting period, ... attendance somewhere so we can run queries and reports for a given time ... What does the "select student" in the header do? ... and it would very time consuming to create a roster each site. ...
    (microsoft.public.access.tablesdbdesign)
Quantcast