ACCESS FEED: Re: [MS_AccessPros] Help!

Senin, 25 Juni 2012

Re: [MS_AccessPros] Help! - Amendment to form

Thanks. Will amend accordingly.

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Toukey-
>
>
>
> Why in the world are you including the tblFireClaims table in your Row Source?
> It's probably disallowing the change because the code you're trying to enter
> isn't in the Row Source. Your Row Source should be from tblLossType since
> that'w shat you're trying to set.
>
>
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> <http://www.viescas.com/> http://www.viescas.com/
>
> (Paris, France)
>
>
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of toukey1
> Sent: Monday, June 25, 2012 7:27 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Help! - Amendment to form
>
>
>
>
>
> John,
>
> I have added the loss type to a couple claims and they appear in the query. What
> happens to those claims that already exists without loss types? Do I now have to
> go and enter loss types for all of them or is there a way for them to appear
> blank?
>
> Also, on the Claim form when I try to change the loss type it isn't allowing me
> to.
>
> Regards
> Toukey
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , John Viescas <JohnV@>
> wrote:
> >
> > Toukey-
> >
> > If you get no rows from that query, then there are no values in tblFireClms in
> > the loss_type field that match any values in tbllosstype. Didn't you say you
> > were entering data in a claims form? If so, then why are you joining the
> claims
> > data with the loss type data if none of the loss types are filled in for the
> > claims table?
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> > ------------------
> >
> > From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of toukey1
> > Sent: Saturday, June 23, 2012 8:52 PM
> > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > Subject: Re: [MS_AccessPros] Help! - Amendment to form
> >
> >
> > This is the SQL view of the query
> >
> > SELECT tblFireClms.*
> > FROM tblFireClms INNER JOIN tbllosstype ON tblFireClms.loss_type =
> > tbllosstype.loss_type;
> >
> > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , John Viescas <JohnV@>
> wrote:
> > >
> > > And more to the point, what is the SQL of your Row Source query?
> > >
> > > John Viescas, author
> > > Microsoft Office Access 2010 Inside Out
> > > Microsoft Office Access 2007 Inside Out
> > > Building Microsoft Access Applications
> > > Microsoft Office Access 2003 Inside Out
> > > SQL Queries for Mere Mortals
> > > http://www.viescas.com/
> > > (Paris, France)
> > >
> > > -------------------
> > >
> > > From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Liz Ravenwood
> > > Sent: Friday, June 22, 2012 10:30 PM
> > > To: 'MS_Access_Professionals@yahoogroups.com
> <mailto:%27MS_Access_Professionals%40yahoogroups.com> '
> > > Subject: RE: [MS_AccessPros] Help! - Amendment to form
> > >
> > >
> > > Is it a left join? right join? inner join?
> > >
> > > Liz Ravenwood
> > > Database Developer / Programmer
> > > Super First Class Products
> > > B/E Aerospace
> > > O: 1.520.239.4808
> > > www.beaerospace.com
> > >
> > > -----Original Message-----
> > > From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of toukey1
> > > Sent: Friday, June 22, 2012 1:25 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > Subject: [MS_AccessPros] Help! - Amendment to form
> > >
> > > Hi,
> > >
> > > I am at the point where frustration is setting in as I cannot get this
> simple
> > > thing to work.
> > >
> > > I have a form that was working but now the user wants to include a new
> > drop-down
> > > field. No problem I thought. I then proceeded to create a new table which I
> > have
> > > called LossType and I have 3 fields which are:
> > >
> > > seqno (auto number - primary key), loss_type (Text) and ins_type (Text).
> > >
> > > ins_type is an existing field from another table as the user wants to be
> able
> > > when entering data on the form, to only display the loss type for only that
> > > particular ins_type.
> > >
> > > I created a form based on the LossType table and entered the relevant info.
> I
> > > then proceeded to my existing claim form to add the combobox for the
> > loss_type.
> > > I had to create a query based on the claim and loss type tables and did a
> join
> > > on the loss_type fields.
> > >
> > > The problem when I view the results in the query I am getting no data. When
> I
> > > remove the join the data is duplicated.
> > >
> > > Please help!
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > > This email (and all attachments) is for the sole use of the intended
> > > recipient(s) and may contain privileged and/or proprietary information. Any
> > > unauthorized review, use, disclosure or distribution is prohibited. If you
> are
> > > not the intended recipient, please contact the sender by reply e-mail and
> > > destroy all copies of the original message.
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>