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]
Tidak ada komentar:
Posting Komentar