Re: Combo Box AfterUpdate Help

Duane
Thank you for yor support, its a shame that Morrison now finds it so
amusing. I am not normally rude and I appreciate your comments. Its just a
shame that I came across that pompous arse and his mate TC, whose head is so
far up Morrison''s arse he must be short of air.

"Duane Hookom" wrote:

> Craig,
> I think one of the issues was your lack of bed-side manner by using the
> phrase "help you make an arse out of your database" and then later "big
> buckets of merde". I expect you can understand how if someone has really
> worked hard on a project that being presented with a critique using these
> phrases might be a little extreme. What might seem harmless to us is
> perceived as offensive by others.
>
> I am often very short (and possible seem curt/rude) with my responses. I try
> to not be too judgmental but it's often difficult to hide my opinions. You
> will find this true with almost every person who attempts to help here on a
> regular basis. I recall a recent thread where the very wise and kind John
> Vinson was perceived as rude by an OP. He immediately apologized changed the
> course of his response. He took responsibility for the perception of another
> person. It would be ideal if everyone showed the same demeanor.
>
> --
> Duane Hookom
> MS Access MVP
> --
>
>
> "Craig Alexander Morrison" <cam@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message news:%23qoZfOgEGHA.3384@xxxxxxxxxxxxxxxxxxxxxxx
> > Let's remind ourselves of your original question in the earlier thread:
> >
> > "I have two tables in an ordering system database. One contains names,
> > phone numbers etc of staff placing the orders and the other the main table
> > containing full details of the order. I use a combo box in a form to
> > select the name of the staff member from the staff table and place this
> > name in the main table. How do I also get other data to transfer across at
> > the same time, ie place the phone number from the staff table into a
> > corresponding field in the main table."
> >
> > Now to many here: placing the Staff Member's Name and Phone Number in the
> > Order table having copied them from the Staff table would appear to be not
> > in compliance with the rules of normalisation. This Staff and Order data
> > could be made available in reports and forms using queries to collate the
> > data.
> >
> > The slanging match as you put it would appear to be one sided I have only
> > pointed out the likely failings in your database design, whereas you have
> > decided to suggest that I may be an arse (not without the bounds of
> > possibility (vbg)) for being hesitant about your design.
> >
> > Whilst I did provide some guidance on how to acheive what you wanted to
> > achieve I felt it was my responsibility to point out that you may have
> > taken a wrong turn.
> >
> > Others use these newsgroups and read the messages that they have not
> > contributed to and glean useful information from them from time to time.
> > It would be irresponsible of me to just answer your question without being
> > curious as to the reason for such a requirement, someone lurking may be in
> > a similar situation and now they are thinking maybe my database design is
> > wrong, rather than just applying multiple values from a single combo-box
> > and stuffing one table with duplicate data from another.
> >
> > Indeed everyone who did answer your question was also curious about your
> > design...see the pattern emerging?
> >
> > As stated earlier in this thread, I can think of legitimate reasons,
> > "point-in-time" and "compound Foreign Key" however 99 times out of a 100
> > it is usually a badly normalised relational database design. For me a
> > database design that is not fully normalised is generally <insert
> > expletives of choice>. Access really does reward your application
> > development if you are working on a fully normalised relational database.
> >
> > --
> > Slainte
> >
> > Craig Alexander Morrison
> > Crawbridge Data (Scotland) Limited
> >
> > "Harry Thomas" <HarryThomas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:5E07A196-1177-4580-A790-39596D741A36@xxxxxxxxxxxxxxxx
> >
> >> Before the rest of you pick on me, I didn't start this slanging match. I
> >> asked a simple question and got back a lengthy reply about database
> >> design
> >> together with accusations that I was making an arse out of my design and
> >> that
> >> my approach was big buckets of merde. What is even more incredible is
> >> that
> >> the reply from Mr Morrison is based on assumptions made by him about the
> >> design of a database of which he has no knowledge. I do not for one
> >> minute
> >> doubt his ability or expertise and I wouldn't be posting such questions
> >> if
> >> I
> >> knew the answer. I do not however think it fair to receive such a reply.
> >>
> >
> >
> >
> > --
> > Slainte
> >
> > Craig Alexander Morrison
> > Crawbridge Data (Scotland) Limited
> > "Harry Thomas" <HarryThomas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:5E07A196-1177-4580-A790-39596D741A36@xxxxxxxxxxxxxxxx
> >> Before the rest of you pick on me, I didn't start this slanging match. I
> >> asked a simple question and got back a lengthy reply about database
> >> design
> >> together with accusations that I was making an arse out of my design and
> >> that
> >> my approach was big buckets of merde. What is even more incredible is
> >> that
> >> the reply from Mr Morrison is based on assumptions made by him about the
> >> design of a database of which he has no knowledge. I do not for one
> >> minute
> >> doubt his ability or expertise and I wouldn't be posting such questions
> >> if I
> >> knew the answer. I do not however think it fair to receive such a reply.
> >>
> >> "Harry Thomas" wrote:
> >>
> >>> I asked a question and expected a reasonable answer, if I wanted a
> >>> lecture on
> >>> database design I would have asked for that instead. You have no idea of
> >>> the
> >>> design, the examples I gave yesterday and today were purely to get an
> >>> answer
> >>> to a question. So unless you want to make an arse of yourself, read the
> >>> question.
> >>>
> >>> "Craig Alexander Morrison" wrote:
> >>>
> >>> > Dodgy design as already pointed out in "Updating....." thread
> >>> > yesterday.
> >>> >
> >>> > I think you will find most people will consider your design flawed.
> >>> >
> >>> > Anyway use the Column property of the ComboBox as already stated
> >>> > yesterday.
> >>> >
> >>> > I am hesitant to help you make an arse out of your database however in
> >>> > the
> >>> > AfterUpdate event procedure of the ComboBox do something like this:
> >>> >
> >>> > Me!FieldB4 = Me!cboFieldA1.Column(1)
> >>> >
> >>> > This assumes that cboFieldA1 is bound to FieldA1 and that FieldA3 is
> >>> > the
> >>> > next column.
> >>> >
> >>> > In this case with the correct design you would not need any code if
> >>> > the
> >>> > value of FieldA1 was the primary key of the table being referenced and
> >>> > FieldB4 was the foreign key in the related table.
> >>> >
> >>> > I speak from 25 years of experience with Relational Databases and
> >>> > nearly 15
> >>> > with Access/Jet.
> >>> >
> >>> > I would strongly recommend you redesign your database conforming to
> >>> > the
> >>> > relational model rather than the big buckets of merde approach.
> >>> >
> >>> > This last sentence is the one that is of most help to you although you
> >>> > may
> >>> > not realise it.
> >>> >
> >>> >
> >>> > --
> >>> > Slainte
> >>> >
> >>> > Craig Alexander Morrison
> >>> > Crawbridge Data (Scotland) Limited
> >>> >
> >>> > "Harry Thomas" <HarryThomas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> >>> > message
> >>> > news:1A035E32-DF85-442B-8D24-9EA87A84E34A@xxxxxxxxxxxxxxxx
> >>> > >I have two tables, TableA and TableB. In a form I use a combo Box to
> >>> > >select
> >>> > > data from Field1 in TableA and place it in Field2 in TableB. What is
> >>> > > the
> >>> > > exact command I put in the AfterUpdate field of the combo box to
> >>> > > also take
> >>> > > data from Field3 of TableA and place it in Field4 of TableB.
> >>> > >
> >>> > > Thank you
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >
> >
>
>
>
.

Relevant Pages

  • Re: Query to search multiple identical tables
    ... separate from the newsgroups and the advices given in these newsgroups are ... whether you referred to making your database, with you as the developer, as ... correct and then to design easy and intuitive GUI for your users. ... know how to apply the Database Normalisation technique). ...
    (microsoft.public.access.queries)
  • Re: database design question
    ... while designing a database with huge tables that are meant to hold ... I have often departed from normalisation, ... The design discipline I have followed for reporting and OLAP databases is ... recommend star schema design. ...
    (comp.databases)
  • Re: Normalization and AVG across columns
    ... columns (Proposal Phase Rating, Preconstruction Phase Rating, etc.) ... This is a bit of database theory that covers normalisation Forget that you are using Access for a while, because Access 12 might have new features. ... you need to answer these questions before you commit to a database design. ...
    (comp.databases.ms-access)
  • Re: Please Help with creating (what I call) a Dynamic Query
    ... normalisation, but his data comes from a Sage line 50 database brought to my ... Hence my attempt to get a query result in one step. ... Your current design includes ...
    (microsoft.public.access.queries)
  • C# programmer looking for a job
    ... Software Development including Desktop, Client/Server and Database ... Practical skills in object oriented design and design patterns ... XML, Oracle, CVS, VSS, Delphi, bug tracking. ... Developed in Delphi5; ...
    (misc.immigration.usa)