Re: for Lynn Trapp RE: two records for one relationship

From: JohnLute (JohnLute_at_discussions.microsoft.com)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 08:52:01 -0700

They are both the same datatype so this is very strange. Any other ideas?

BTW: your previous concern about a finished good being associated with another finished good has been addresssed. The sfrm used in the finished goods form is filtered so that finished good types are filtered out.

"Lynn Trapp" wrote:

> It's likely that you have a type mismatch error. The datatype of both the
> primary key and the foreign key MUST be the same.
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
>
>
> "JohnLute" <JohnLute@discussions.microsoft.com> wrote in message
> news:9736F7DD-FA87-40E4-8A8C-E438A98075B2@microsoft.com...
> > Great - thanks!
> >
> > I have one more "bug" to exterminate. My txtProfileID's can be numbers or
> text or numbers/text. The code shows a bug when selecting a txtProfileID
> that's text. The bug is pointed to:
> > DoCmd.RunSQL (v_Str_SQL)
> >
> > This seems straight-forward. What do I need to adjust in the code to allow
> for text?
> >
> > "Lynn Trapp" wrote:
> >
> > > Run a Delete query that references both the values for the ParentID in
> the
> > > where clause.
> > >
> > > --
> > > Lynn Trapp
> > > MS Access MVP
> > > www.ltcomputerdesigns.com
> > > Access Security: www.ltcomputerdesigns.com/Security.htm
> > >
> > >
> > > "JohnLute" <JohnLute@discussions.microsoft.com> wrote in message
> > > news:7349B47F-D1E1-465A-A3F4-A4080091C8B7@microsoft.com...
> > > > Thanks, Lynn!!! Someone instructed me of this before but I couldn't
> > > remember.
> > > >
> > > > This is now working!!! THANKS!!!
> > > >
> > > > I just have one more issue. I can delete an association but the
> associated
> > > record will remain. How can I delete both records?
> > > >
> > > > I very much appreciate your help.
> > > >
> > > >
> > > > "Lynn Trapp" wrote:
> > > >
> > > > > Open your main form in design view. Click on the Subform ONE time.
> That
> > > > > should cause the subform CONTROL to be highlighted. You can then
> find
> > > out
> > > > > what the name of that control is.
> > > > >
> > > > > --
> > > > > Lynn Trapp
> > > > > MS Access MVP
> > > > > www.ltcomputerdesigns.com
> > > > > Access Security: www.ltcomputerdesigns.com/Security.htm
> > > > >
> > > > >
> > > > > "JohnLute" <JohnLute@discussions.microsoft.com> wrote in message
> > > > > news:9FEA130F-0E74-4AE1-800B-38F7F1493F2A@microsoft.com...
> > > > > > I'm not understanding this:
> > > > > > "The code is referencing the subform CONTROL as it is named on the
> > > main
> > > > > form."
> > > > > >
> > > > > > I'm lost - where do I find this info?
> > > > > >
> > > > > > "Lynn Trapp" wrote:
> > > > > >
> > > > > > > > Now I get the error message that Access can't find the field
> > > > > > > 'sfrmProfilesAssociationsTEMPLATE'. This is confusing because
> this
> > > form
> > > > > > > exists, however, the message is stating that it can't find the
> > > "field"
> > > > > with
> > > > > > > this name...?
> > > > > > > >
> > > > > > >
> > > > > > > The code is referencing the subform CONTROL as it is named on
> the
> > > main
> > > > > form.
> > > > > > > It doesn't matter what the subform what named when you created
> it.
> > > It
> > > > > has to
> > > > > > > be the name that was used when you added the control to the main
> > > form.
> > > > > > >
> > > > > > > --
> > > > > > > Lynn Trapp
> > > > > > > MS Access MVP
> > > > > > > www.ltcomputerdesigns.com
> > > > > > > Access Security: www.ltcomputerdesigns.com/Security.htm
> > > > > > >
> > > > > > >
> > > > > > > "JohnLute" <JohnLute@discussions.microsoft.com> wrote in message
> > > > > > > news:C59FD866-D94B-4390-A15F-74C5CF23BD1C@microsoft.com...
> > > > > > > > I see the error now. I've corrected it by using two lines:
> > > > > > > >
> > > > > > > > v_parent_id =
> > > > > > >
> > > > >
> > >
> Forms!frmPKProfilesTEMPLATEcbtype.Form!sfrmProfilesAssociationsTEMPLATE!cbPr
> > > > > > > ofilesAssociations
> > > > > > > > v_child_id = Forms!frmPKProfilesTEMPLATEcbtype!txtProfileID
> > > > > > > >
> > > > > > > > Now I get the error message that Access can't find the field
> > > > > > > 'sfrmProfilesAssociationsTEMPLATE'. This is confusing because
> this
> > > form
> > > > > > > exists, however, the message is stating that it can't find the
> > > "field"
> > > > > with
> > > > > > > this name...?
> > > > > > > >
> > > > > > > > "JohnLute" wrote:
> > > > > > > >
> > > > > > > > > No. I'm guessing that it should be? Here's what I have - I
> just
> > > > > > > copy/pasted the code you put in your post:
> > > > > > > > >
> > > > > > > > > v_parent_id =
> > > > > > > > >
> > > > > > >
> > > > >
> > >
> Forms!frmPKProfilesTEMPLATE.Form!sfrmProfilesAssociations!cbProfilesAssociat
> > > > > > > ions
> > > > > > > > > v_child_id = Forms!frmPKProfilesTEMPLATE!txtProfileID
> > > > > > > > >
> > > > > > > > > "Lynn Trapp" wrote:
> > > > > > > > >
> > > > > > > > > > > v_parent_id =
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > >
> > > > >
> > >
> Forms!frmPKProfilesTEMPLATE.Form!sfrmProfilesAssociations!cbProfilesAssociat
> > > > > > > > > > ions
> > > > > > > > > >
> > > > > > > > > > Is this all on one line in your code?
> > > > > > > > > >
> > > > > > > > > > --
> > > > > > > > > > Lynn Trapp
> > > > > > > > > > MS Access MVP
> > > > > > > > > > www.ltcomputerdesigns.com
> > > > > > > > > > Access Security: www.ltcomputerdesigns.com/Security.htm
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>

Relevant Pages