Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

DAP Server Filter Doesn't Work

Discussion in 'Information Technology' started by Juan, Jul 28, 2006.

  1. Juan

    Juan
    Expand Collapse
    Guest

    Hi,

    I've been having a hard time using the server filter on DAP. What i want to
    do is click on a hyperlink and open up a DAP where it shows me a specific
    record based on a field on my current form. Can anyone help?

    thanks in advance!
     
  2. Loading...

    Similar Threads Forum Date
    Movies Ashdoc's movie review---The grand Budapest hotel Theatre, Movies & Cinema Jul 30, 2014
    USA How Kent Has Adapted to the Challenges of Multiculturalism Breaking News Mar 25, 2011
    Sikh News Coeur d'Alene Press Newspaper | CDAPress.com (Coeur d'Alene Press) Breaking News Dec 16, 2009
    Sikh News Coeur d'Alene Press Newspaper | CDAPress.com (Coeur d'Alene Press) Breaking News Dec 15, 2009
    All that glisters is not gold as dowries adapt to India's new wealth Business, Lifestyle & Leisure Dec 12, 2009

  3. Ken Snell \(MVP\)

    Ken Snell \(MVP\)
    Expand Collapse
    Guest

    Works for me when I use it...so, tell us what you've tried, what is
    happening (or not happening) when you try it, what is the syntax you're
    using for the ServerFilter expression, what is the setup of you DAP, what is
    its Recordset, etc.

    --

    Ken Snell
    <MS ACCESS MVP>

    "Juan" <Juan@discussions.microsoft.com> wrote in message
    news:65C37DEC-7429-4389-9A42-010BB0953CEB@microsoft.com...
    > Hi,
    >
    > I've been having a hard time using the server filter on DAP. What i want
    > to
    > do is click on a hyperlink and open up a DAP where it shows me a specific
    > record based on a field on my current form. Can anyone help?
    >
    > thanks in advance!
     
  4. Juan

    Juan
    Expand Collapse
    Guest

    well i have two DAP's they both have a common field called [client id] and
    the recordset for both is a query named "itin table qry". what i want to do
    is click on a hyperlink on the first dap, named "ITIN FORM2", and have the
    second dap, named "w72", open up and display the same record i was editing on
    the first form. what i have tried is putting the following code in the
    server filter section of the hyperlink: [client id]=[client id]

    when dap "w72" opens it always shows me the first record in the recordset
    and not the one that i want to see.

    am i doing something wrong??


    "Ken Snell (MVP)" wrote:

    > Works for me when I use it...so, tell us what you've tried, what is
    > happening (or not happening) when you try it, what is the syntax you're
    > using for the ServerFilter expression, what is the setup of you DAP, what is
    > its Recordset, etc.
    >
    > --
    >
    > Ken Snell
    > <MS ACCESS MVP>
    >
    > "Juan" <Juan@discussions.microsoft.com> wrote in message
    > news:65C37DEC-7429-4389-9A42-010BB0953CEB@microsoft.com...
    > > Hi,
    > >
    > > I've been having a hard time using the server filter on DAP. What i want
    > > to
    > > do is click on a hyperlink and open up a DAP where it shows me a specific
    > > record based on a field on my current form. Can anyone help?
    > >
    > > thanks in advance!

    >
    >
    >
     
  5. Ken Snell \(MVP\)

    Ken Snell \(MVP\)
    Expand Collapse
    Guest

    Is the first DAP showing more than one record?
    --

    Ken Snell
    <MS ACCESS MVP>


    "Juan" <Juan@discussions.microsoft.com> wrote in message
    news:F5107F68-F0A6-4EEE-97D5-6231D32F1918@microsoft.com...
    > well i have two DAP's they both have a common field called [client id] and
    > the recordset for both is a query named "itin table qry". what i want to
    > do
    > is click on a hyperlink on the first dap, named "ITIN FORM2", and have the
    > second dap, named "w72", open up and display the same record i was editing
    > on
    > the first form. what i have tried is putting the following code in the
    > server filter section of the hyperlink: [client id]=[client id]
    >
    > when dap "w72" opens it always shows me the first record in the recordset
    > and not the one that i want to see.
    >
    > am i doing something wrong??
    >
    >
    > "Ken Snell (MVP)" wrote:
    >
    >> Works for me when I use it...so, tell us what you've tried, what is
    >> happening (or not happening) when you try it, what is the syntax you're
    >> using for the ServerFilter expression, what is the setup of you DAP, what
    >> is
    >> its Recordset, etc.
    >>
    >> --
    >>
    >> Ken Snell
    >> <MS ACCESS MVP>
    >>
    >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> news:65C37DEC-7429-4389-9A42-010BB0953CEB@microsoft.com...
    >> > Hi,
    >> >
    >> > I've been having a hard time using the server filter on DAP. What i
    >> > want
    >> > to
    >> > do is click on a hyperlink and open up a DAP where it shows me a
    >> > specific
    >> > record based on a field on my current form. Can anyone help?
    >> >
    >> > thanks in advance!

    >>
    >>
    >>
     
  6. Juan

    Juan
    Expand Collapse
    Guest

    Well it shows one record at a time. It has a navigation bar on the bottom
    that i can use to navigate between records.

    "Ken Snell (MVP)" wrote:

    > Is the first DAP showing more than one record?
    > --
    >
    > Ken Snell
    > <MS ACCESS MVP>
    >
    >
    > "Juan" <Juan@discussions.microsoft.com> wrote in message
    > news:F5107F68-F0A6-4EEE-97D5-6231D32F1918@microsoft.com...
    > > well i have two DAP's they both have a common field called [client id] and
    > > the recordset for both is a query named "itin table qry". what i want to
    > > do
    > > is click on a hyperlink on the first dap, named "ITIN FORM2", and have the
    > > second dap, named "w72", open up and display the same record i was editing
    > > on
    > > the first form. what i have tried is putting the following code in the
    > > server filter section of the hyperlink: [client id]=[client id]
    > >
    > > when dap "w72" opens it always shows me the first record in the recordset
    > > and not the one that i want to see.
    > >
    > > am i doing something wrong??
    > >
    > >
    > > "Ken Snell (MVP)" wrote:
    > >
    > >> Works for me when I use it...so, tell us what you've tried, what is
    > >> happening (or not happening) when you try it, what is the syntax you're
    > >> using for the ServerFilter expression, what is the setup of you DAP, what
    > >> is
    > >> its Recordset, etc.
    > >>
    > >> --
    > >>
    > >> Ken Snell
    > >> <MS ACCESS MVP>
    > >>
    > >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> news:65C37DEC-7429-4389-9A42-010BB0953CEB@microsoft.com...
    > >> > Hi,
    > >> >
    > >> > I've been having a hard time using the server filter on DAP. What i
    > >> > want
    > >> > to
    > >> > do is click on a hyperlink and open up a DAP where it shows me a
    > >> > specific
    > >> > record based on a field on my current form. Can anyone help?
    > >> >
    > >> > thanks in advance!
    > >>
    > >>
    > >>

    >
    >
    >
     
  7. Ken Snell \(MVP\)

    Ken Snell \(MVP\)
    Expand Collapse
    Guest

    What is the data type of ClientID? numeric? text?

    --

    Ken Snell
    <MS ACCESS MVP>

    "Juan" <Juan@discussions.microsoft.com> wrote in message
    news:BA19F1C5-B40F-4036-BEBF-C066E34B0D7E@microsoft.com...
    > Well it shows one record at a time. It has a navigation bar on the bottom
    > that i can use to navigate between records.
    >
    > "Ken Snell (MVP)" wrote:
    >
    >> Is the first DAP showing more than one record?
    >> --
    >>
    >> Ken Snell
    >> <MS ACCESS MVP>
    >>
    >>
    >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> news:F5107F68-F0A6-4EEE-97D5-6231D32F1918@microsoft.com...
    >> > well i have two DAP's they both have a common field called [client id]
    >> > and
    >> > the recordset for both is a query named "itin table qry". what i want
    >> > to
    >> > do
    >> > is click on a hyperlink on the first dap, named "ITIN FORM2", and have
    >> > the
    >> > second dap, named "w72", open up and display the same record i was
    >> > editing
    >> > on
    >> > the first form. what i have tried is putting the following code in the
    >> > server filter section of the hyperlink: [client id]=[client id]
    >> >
    >> > when dap "w72" opens it always shows me the first record in the
    >> > recordset
    >> > and not the one that i want to see.
    >> >
    >> > am i doing something wrong??
    >> >
    >> >
    >> > "Ken Snell (MVP)" wrote:
    >> >
    >> >> Works for me when I use it...so, tell us what you've tried, what is
    >> >> happening (or not happening) when you try it, what is the syntax
    >> >> you're
    >> >> using for the ServerFilter expression, what is the setup of you DAP,
    >> >> what
    >> >> is
    >> >> its Recordset, etc.
    >> >>
    >> >> --
    >> >>
    >> >> Ken Snell
    >> >> <MS ACCESS MVP>
    >> >>
    >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> >> news:65C37DEC-7429-4389-9A42-010BB0953CEB@microsoft.com...
    >> >> > Hi,
    >> >> >
    >> >> > I've been having a hard time using the server filter on DAP. What i
    >> >> > want
    >> >> > to
    >> >> > do is click on a hyperlink and open up a DAP where it shows me a
    >> >> > specific
    >> >> > record based on a field on my current form. Can anyone help?
    >> >> >
    >> >> > thanks in advance!
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     
  8. Juan

    Juan
    Expand Collapse
    Guest

    It's numeric. It is an autonumber and also the primary key for this database

    "Ken Snell (MVP)" wrote:

    > What is the data type of ClientID? numeric? text?
    >
    > --
    >
    > Ken Snell
    > <MS ACCESS MVP>
    >
    > "Juan" <Juan@discussions.microsoft.com> wrote in message
    > news:BA19F1C5-B40F-4036-BEBF-C066E34B0D7E@microsoft.com...
    > > Well it shows one record at a time. It has a navigation bar on the bottom
    > > that i can use to navigate between records.
    > >
    > > "Ken Snell (MVP)" wrote:
    > >
    > >> Is the first DAP showing more than one record?
    > >> --
    > >>
    > >> Ken Snell
    > >> <MS ACCESS MVP>
    > >>
    > >>
    > >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> news:F5107F68-F0A6-4EEE-97D5-6231D32F1918@microsoft.com...
    > >> > well i have two DAP's they both have a common field called [client id]
    > >> > and
    > >> > the recordset for both is a query named "itin table qry". what i want
    > >> > to
    > >> > do
    > >> > is click on a hyperlink on the first dap, named "ITIN FORM2", and have
    > >> > the
    > >> > second dap, named "w72", open up and display the same record i was
    > >> > editing
    > >> > on
    > >> > the first form. what i have tried is putting the following code in the
    > >> > server filter section of the hyperlink: [client id]=[client id]
    > >> >
    > >> > when dap "w72" opens it always shows me the first record in the
    > >> > recordset
    > >> > and not the one that i want to see.
    > >> >
    > >> > am i doing something wrong??
    > >> >
    > >> >
    > >> > "Ken Snell (MVP)" wrote:
    > >> >
    > >> >> Works for me when I use it...so, tell us what you've tried, what is
    > >> >> happening (or not happening) when you try it, what is the syntax
    > >> >> you're
    > >> >> using for the ServerFilter expression, what is the setup of you DAP,
    > >> >> what
    > >> >> is
    > >> >> its Recordset, etc.
    > >> >>
    > >> >> --
    > >> >>
    > >> >> Ken Snell
    > >> >> <MS ACCESS MVP>
    > >> >>
    > >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> >> news:65C37DEC-7429-4389-9A42-010BB0953CEB@microsoft.com...
    > >> >> > Hi,
    > >> >> >
    > >> >> > I've been having a hard time using the server filter on DAP. What i
    > >> >> > want
    > >> >> > to
    > >> >> > do is click on a hyperlink and open up a DAP where it shows me a
    > >> >> > specific
    > >> >> > record based on a field on my current form. Can anyone help?
    > >> >> >
    > >> >> > thanks in advance!
    > >> >>
    > >> >>
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >
     
  9. Ken Snell \(MVP\)

    Ken Snell \(MVP\)
    Expand Collapse
    Guest

    Hyperlink server filter syntax requires that you use the name of the field,
    not the name of an element. Is client ID the name of the field that holds
    the actual value in the first DAP? Is that field bound to an element (even
    if the element is hidden) on the first DAP?

    --

    Ken Snell
    <MS ACCESS MVP>

    "Juan" <Juan@discussions.microsoft.com> wrote in message
    news:C20F5ADE-5940-4526-910E-D1ECEB773487@microsoft.com...
    > It's numeric. It is an autonumber and also the primary key for this
    > database
    >
    > "Ken Snell (MVP)" wrote:
    >
    >> What is the data type of ClientID? numeric? text?
    >>
    >> --
    >>
    >> Ken Snell
    >> <MS ACCESS MVP>
    >>
    >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> news:BA19F1C5-B40F-4036-BEBF-C066E34B0D7E@microsoft.com...
    >> > Well it shows one record at a time. It has a navigation bar on the
    >> > bottom
    >> > that i can use to navigate between records.
    >> >
    >> > "Ken Snell (MVP)" wrote:
    >> >
    >> >> Is the first DAP showing more than one record?
    >> >> --
    >> >>
    >> >> Ken Snell
    >> >> <MS ACCESS MVP>
    >> >>
    >> >>
    >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> >> news:F5107F68-F0A6-4EEE-97D5-6231D32F1918@microsoft.com...
    >> >> > well i have two DAP's they both have a common field called [client
    >> >> > id]
    >> >> > and
    >> >> > the recordset for both is a query named "itin table qry". what i
    >> >> > want
    >> >> > to
    >> >> > do
    >> >> > is click on a hyperlink on the first dap, named "ITIN FORM2", and
    >> >> > have
    >> >> > the
    >> >> > second dap, named "w72", open up and display the same record i was
    >> >> > editing
    >> >> > on
    >> >> > the first form. what i have tried is putting the following code in
    >> >> > the
    >> >> > server filter section of the hyperlink: [client id]=[client id]
    >> >> >
    >> >> > when dap "w72" opens it always shows me the first record in the
    >> >> > recordset
    >> >> > and not the one that i want to see.
    >> >> >
    >> >> > am i doing something wrong??
    >> >> >
    >> >> >
    >> >> > "Ken Snell (MVP)" wrote:
    >> >> >
    >> >> >> Works for me when I use it...so, tell us what you've tried, what is
    >> >> >> happening (or not happening) when you try it, what is the syntax
    >> >> >> you're
    >> >> >> using for the ServerFilter expression, what is the setup of you
    >> >> >> DAP,
    >> >> >> what
    >> >> >> is
    >> >> >> its Recordset, etc.
    >> >> >>
    >> >> >> --
    >> >> >>
    >> >> >> Ken Snell
    >> >> >> <MS ACCESS MVP>
    >> >> >>
    >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> >> >> news:65C37DEC-7429-4389-9A42-010BB0953CEB@microsoft.com...
    >> >> >> > Hi,
    >> >> >> >
    >> >> >> > I've been having a hard time using the server filter on DAP.
    >> >> >> > What i
    >> >> >> > want
    >> >> >> > to
    >> >> >> > do is click on a hyperlink and open up a DAP where it shows me a
    >> >> >> > specific
    >> >> >> > record based on a field on my current form. Can anyone help?
    >> >> >> >
    >> >> >> > thanks in advance!
    >> >> >>
    >> >> >>
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     
  10. Juan

    Juan
    Expand Collapse
    Guest

    [Client ID] is the name of the field that holds the value in the first dap
    and that field is bound to an element on the dap also named "client id".

    "Ken Snell (MVP)" wrote:

    > Hyperlink server filter syntax requires that you use the name of the field,
    > not the name of an element. Is client ID the name of the field that holds
    > the actual value in the first DAP? Is that field bound to an element (even
    > if the element is hidden) on the first DAP?
    >
    > --
    >
    > Ken Snell
    > <MS ACCESS MVP>
    >
    > "Juan" <Juan@discussions.microsoft.com> wrote in message
    > news:C20F5ADE-5940-4526-910E-D1ECEB773487@microsoft.com...
    > > It's numeric. It is an autonumber and also the primary key for this
    > > database
    > >
    > > "Ken Snell (MVP)" wrote:
    > >
    > >> What is the data type of ClientID? numeric? text?
    > >>
    > >> --
    > >>
    > >> Ken Snell
    > >> <MS ACCESS MVP>
    > >>
    > >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> news:BA19F1C5-B40F-4036-BEBF-C066E34B0D7E@microsoft.com...
    > >> > Well it shows one record at a time. It has a navigation bar on the
    > >> > bottom
    > >> > that i can use to navigate between records.
    > >> >
    > >> > "Ken Snell (MVP)" wrote:
    > >> >
    > >> >> Is the first DAP showing more than one record?
    > >> >> --
    > >> >>
    > >> >> Ken Snell
    > >> >> <MS ACCESS MVP>
    > >> >>
    > >> >>
    > >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> >> news:F5107F68-F0A6-4EEE-97D5-6231D32F1918@microsoft.com...
    > >> >> > well i have two DAP's they both have a common field called [client
    > >> >> > id]
    > >> >> > and
    > >> >> > the recordset for both is a query named "itin table qry". what i
    > >> >> > want
    > >> >> > to
    > >> >> > do
    > >> >> > is click on a hyperlink on the first dap, named "ITIN FORM2", and
    > >> >> > have
    > >> >> > the
    > >> >> > second dap, named "w72", open up and display the same record i was
    > >> >> > editing
    > >> >> > on
    > >> >> > the first form. what i have tried is putting the following code in
    > >> >> > the
    > >> >> > server filter section of the hyperlink: [client id]=[client id]
    > >> >> >
    > >> >> > when dap "w72" opens it always shows me the first record in the
    > >> >> > recordset
    > >> >> > and not the one that i want to see.
    > >> >> >
    > >> >> > am i doing something wrong??
    > >> >> >
    > >> >> >
    > >> >> > "Ken Snell (MVP)" wrote:
    > >> >> >
    > >> >> >> Works for me when I use it...so, tell us what you've tried, what is
    > >> >> >> happening (or not happening) when you try it, what is the syntax
    > >> >> >> you're
    > >> >> >> using for the ServerFilter expression, what is the setup of you
    > >> >> >> DAP,
    > >> >> >> what
    > >> >> >> is
    > >> >> >> its Recordset, etc.
    > >> >> >>
    > >> >> >> --
    > >> >> >>
    > >> >> >> Ken Snell
    > >> >> >> <MS ACCESS MVP>
    > >> >> >>
    > >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> >> >> news:65C37DEC-7429-4389-9A42-010BB0953CEB@microsoft.com...
    > >> >> >> > Hi,
    > >> >> >> >
    > >> >> >> > I've been having a hard time using the server filter on DAP.
    > >> >> >> > What i
    > >> >> >> > want
    > >> >> >> > to
    > >> >> >> > do is click on a hyperlink and open up a DAP where it shows me a
    > >> >> >> > specific
    > >> >> >> > record based on a field on my current form. Can anyone help?
    > >> >> >> >
    > >> >> >> > thanks in advance!
    > >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >>
    > >> >>
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >
     
  11. Ken Snell \(MVP\)

    Ken Snell \(MVP\)
    Expand Collapse
    Guest

    What is the query that is the first DAP's recordset? What is the query that
    is the second DAP's recordset? Post the SQL statements of the two queries.

    --

    Ken Snell
    <MS ACCESS MVP>

    "Juan" <Juan@discussions.microsoft.com> wrote in message
    news:434BF3C8-214A-458D-86D6-0BB2B25491F4@microsoft.com...
    > [Client ID] is the name of the field that holds the value in the first dap
    > and that field is bound to an element on the dap also named "client id".
    >
    > "Ken Snell (MVP)" wrote:
    >
    >> Hyperlink server filter syntax requires that you use the name of the
    >> field,
    >> not the name of an element. Is client ID the name of the field that holds
    >> the actual value in the first DAP? Is that field bound to an element
    >> (even
    >> if the element is hidden) on the first DAP?
    >>
    >> --
    >>
    >> Ken Snell
    >> <MS ACCESS MVP>
    >>
    >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> news:C20F5ADE-5940-4526-910E-D1ECEB773487@microsoft.com...
    >> > It's numeric. It is an autonumber and also the primary key for this
    >> > database
    >> >
    >> > "Ken Snell (MVP)" wrote:
    >> >
    >> >> What is the data type of ClientID? numeric? text?
    >> >>
    >> >> --
    >> >>
    >> >> Ken Snell
    >> >> <MS ACCESS MVP>
    >> >>
    >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> >> news:BA19F1C5-B40F-4036-BEBF-C066E34B0D7E@microsoft.com...
    >> >> > Well it shows one record at a time. It has a navigation bar on the
    >> >> > bottom
    >> >> > that i can use to navigate between records.
    >> >> >
    >> >> > "Ken Snell (MVP)" wrote:
    >> >> >
    >> >> >> Is the first DAP showing more than one record?
    >> >> >> --
    >> >> >>
    >> >> >> Ken Snell
    >> >> >> <MS ACCESS MVP>
    >> >> >>
    >> >> >>
    >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> >> >> news:F5107F68-F0A6-4EEE-97D5-6231D32F1918@microsoft.com...
    >> >> >> > well i have two DAP's they both have a common field called
    >> >> >> > [client
    >> >> >> > id]
    >> >> >> > and
    >> >> >> > the recordset for both is a query named "itin table qry". what i
    >> >> >> > want
    >> >> >> > to
    >> >> >> > do
    >> >> >> > is click on a hyperlink on the first dap, named "ITIN FORM2", and
    >> >> >> > have
    >> >> >> > the
    >> >> >> > second dap, named "w72", open up and display the same record i
    >> >> >> > was
    >> >> >> > editing
    >> >> >> > on
    >> >> >> > the first form. what i have tried is putting the following code
    >> >> >> > in
    >> >> >> > the
    >> >> >> > server filter section of the hyperlink: [client id]=[client id]
    >> >> >> >
    >> >> >> > when dap "w72" opens it always shows me the first record in the
    >> >> >> > recordset
    >> >> >> > and not the one that i want to see.
    >> >> >> >
    >> >> >> > am i doing something wrong??
    >> >> >> >
    >> >> >> >
    >> >> >> > "Ken Snell (MVP)" wrote:
    >> >> >> >
    >> >> >> >> Works for me when I use it...so, tell us what you've tried, what
    >> >> >> >> is
    >> >> >> >> happening (or not happening) when you try it, what is the syntax
    >> >> >> >> you're
    >> >> >> >> using for the ServerFilter expression, what is the setup of you
    >> >> >> >> DAP,
    >> >> >> >> what
    >> >> >> >> is
    >> >> >> >> its Recordset, etc.
    >> >> >> >>
    >> >> >> >> --
    >> >> >> >>
    >> >> >> >> Ken Snell
    >> >> >> >> <MS ACCESS MVP>
    >> >> >> >>
    >> >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> >> >> >> news:65C37DEC-7429-4389-9A42-010BB0953CEB@microsoft.com...
    >> >> >> >> > Hi,
    >> >> >> >> >
    >> >> >> >> > I've been having a hard time using the server filter on DAP.
    >> >> >> >> > What i
    >> >> >> >> > want
    >> >> >> >> > to
    >> >> >> >> > do is click on a hyperlink and open up a DAP where it shows me
    >> >> >> >> > a
    >> >> >> >> > specific
    >> >> >> >> > record based on a field on my current form. Can anyone help?
    >> >> >> >> >
    >> >> >> >> > thanks in advance!
    >> >> >> >>
    >> >> >> >>
    >> >> >> >>
    >> >> >>
    >> >> >>
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     
  12. Juan

    Juan
    Expand Collapse
    Guest

    the recordset for both dap's is the same query name "itin table qry' the
    recordset for this query is the following:

    SELECT [ITIN TABLE].[CLIENT ID], [ITIN TABLE].[DOCUMENT CODE #1], [ITIN
    TABLE].[DOCUMENT CODE #2], [ITIN TABLE].[C: US RESIDENT ALIEN], [ITIN
    TABLE].[D: DEPENDENT OF], [ITIN TABLE].[E: SPOUSE OF], [ITIN
    TABLE].[DEPENDENT OF], [ITIN TABLE].[SSN/ITIN OF MAIN TAXPAYER], [ITIN
    TABLE].[FIRST NAME], [ITIN TABLE].[MIDDLE NAME], [ITIN TABLE].[LAST NAME],
    [ITIN TABLE].[MAIDEN LAST NAME], [ITIN TABLE].[FOREIGN STREET ADDRESS], [ITIN
    TABLE].[FOREIGN CITY, ST, COUNTRY], [ITIN TABLE].[US STREET ADDRESS], [ITIN
    TABLE].[US CITY, STATE, ZIP], [ITIN TABLE].[DATE OF BIRTH], [ITIN
    TABLE].[COUNTRY OF BIRTH], [ITIN TABLE].[FOREIGN TAX ID], [ITIN TABLE].[CITY
    & STATE OF BIRTH], [ITIN TABLE].MALE, [ITIN TABLE].FEMALE, [ITIN
    TABLE].[COUNTRY OF CITIZENSHIP], [ITIN TABLE].[TYPE OF US VISA], [ITIN
    TABLE].[ISSUED BY], [ITIN TABLE].[NO:], [ITIN TABLE].[EXP DATE], [ITIN
    TABLE].[ENTRY DATE IN US], [ITIN TABLE].[PREPARATION DATE], [ITIN
    TABLE].[PHONE NUMBER], [ITIN TABLE].[TAX PREPARER], [ITIN TABLE].[NAME OF
    DELEGATE], [ITIN TABLE].PARENT, [ITIN TABLE].[POWER OF ATTORNEY], [ITIN
    TABLE].[COURT-APPOINTED GUARDIAN], [ITIN TABLE].[NAME OF COMPANY], [ITIN
    TABLE].PHONE, [ITIN TABLE].FAX, [ITIN TABLE].EIN, [ITIN TABLE].[TAX
    PREPARER1], [ITIN TABLE].[RECEIVED ITIN?], [ITIN TABLE].[RECEIPT DATE], [ITIN
    TABLE].[ITIN #], [ITIN TABLE].[BARCLAYS FIN INC], [ITIN TABLE].[PRINT LABEL],
    [ITIN TABLE].[DOCUMENT #1], [ITIN TABLE].[DOCUMENT #2], [ITIN
    TABLE].PASSPORT, [ITIN TABLE].[USCIS DOCUMENTATION], [ITIN TABLE].[DRIVERS
    LICENSE/STATE ID], [ITIN TABLE].OTHER, [ITIN TABLE].[DOCUMENT NAME], [last
    name]+", "+[first name]+" "+[middle name] AS [CLIENT FULL NAME]
    FROM [ITIN TABLE];


    "Ken Snell (MVP)" wrote:

    > What is the query that is the first DAP's recordset? What is the query that
    > is the second DAP's recordset? Post the SQL statements of the two queries.
    >
    > --
    >
    > Ken Snell
    > <MS ACCESS MVP>
    >
    > "Juan" <Juan@discussions.microsoft.com> wrote in message
    > news:434BF3C8-214A-458D-86D6-0BB2B25491F4@microsoft.com...
    > > [Client ID] is the name of the field that holds the value in the first dap
    > > and that field is bound to an element on the dap also named "client id".
    > >
    > > "Ken Snell (MVP)" wrote:
    > >
    > >> Hyperlink server filter syntax requires that you use the name of the
    > >> field,
    > >> not the name of an element. Is client ID the name of the field that holds
    > >> the actual value in the first DAP? Is that field bound to an element
    > >> (even
    > >> if the element is hidden) on the first DAP?
    > >>
    > >> --
    > >>
    > >> Ken Snell
    > >> <MS ACCESS MVP>
    > >>
    > >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> news:C20F5ADE-5940-4526-910E-D1ECEB773487@microsoft.com...
    > >> > It's numeric. It is an autonumber and also the primary key for this
    > >> > database
    > >> >
    > >> > "Ken Snell (MVP)" wrote:
    > >> >
    > >> >> What is the data type of ClientID? numeric? text?
    > >> >>
    > >> >> --
    > >> >>
    > >> >> Ken Snell
    > >> >> <MS ACCESS MVP>
    > >> >>
    > >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> >> news:BA19F1C5-B40F-4036-BEBF-C066E34B0D7E@microsoft.com...
    > >> >> > Well it shows one record at a time. It has a navigation bar on the
    > >> >> > bottom
    > >> >> > that i can use to navigate between records.
    > >> >> >
    > >> >> > "Ken Snell (MVP)" wrote:
    > >> >> >
    > >> >> >> Is the first DAP showing more than one record?
    > >> >> >> --
    > >> >> >>
    > >> >> >> Ken Snell
    > >> >> >> <MS ACCESS MVP>
    > >> >> >>
    > >> >> >>
    > >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> >> >> news:F5107F68-F0A6-4EEE-97D5-6231D32F1918@microsoft.com...
    > >> >> >> > well i have two DAP's they both have a common field called
    > >> >> >> > [client
    > >> >> >> > id]
    > >> >> >> > and
    > >> >> >> > the recordset for both is a query named "itin table qry". what i
    > >> >> >> > want
    > >> >> >> > to
    > >> >> >> > do
    > >> >> >> > is click on a hyperlink on the first dap, named "ITIN FORM2", and
    > >> >> >> > have
    > >> >> >> > the
    > >> >> >> > second dap, named "w72", open up and display the same record i
    > >> >> >> > was
    > >> >> >> > editing
    > >> >> >> > on
    > >> >> >> > the first form. what i have tried is putting the following code
    > >> >> >> > in
    > >> >> >> > the
    > >> >> >> > server filter section of the hyperlink: [client id]=[client id]
    > >> >> >> >
    > >> >> >> > when dap "w72" opens it always shows me the first record in the
    > >> >> >> > recordset
    > >> >> >> > and not the one that i want to see.
    > >> >> >> >
    > >> >> >> > am i doing something wrong??
    > >> >> >> >
    > >> >> >> >
    > >> >> >> > "Ken Snell (MVP)" wrote:
    > >> >> >> >
    > >> >> >> >> Works for me when I use it...so, tell us what you've tried, what
    > >> >> >> >> is
    > >> >> >> >> happening (or not happening) when you try it, what is the syntax
    > >> >> >> >> you're
    > >> >> >> >> using for the ServerFilter expression, what is the setup of you
    > >> >> >> >> DAP,
    > >> >> >> >> what
    > >> >> >> >> is
    > >> >> >> >> its Recordset, etc.
    > >> >> >> >>
    > >> >> >> >> --
    > >> >> >> >>
    > >> >> >> >> Ken Snell
    > >> >> >> >> <MS ACCESS MVP>
    > >> >> >> >>
    > >> >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> >> >> >> news:65C37DEC-7429-4389-9A42-010BB0953CEB@microsoft.com...
    > >> >> >> >> > Hi,
    > >> >> >> >> >
    > >> >> >> >> > I've been having a hard time using the server filter on DAP.
    > >> >> >> >> > What i
    > >> >> >> >> > want
    > >> >> >> >> > to
    > >> >> >> >> > do is click on a hyperlink and open up a DAP where it shows me
    > >> >> >> >> > a
    > >> >> >> >> > specific
    > >> >> >> >> > record based on a field on my current form. Can anyone help?
    > >> >> >> >> >
    > >> >> >> >> > thanks in advance!
    > >> >> >> >>
    > >> >> >> >>
    > >> >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >>
    > >> >>
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >
     
  13. Ken Snell \(MVP\)

    Ken Snell \(MVP\)
    Expand Collapse
    Guest

    It's been a while since I programmed a DAP, so I'd neglected to note the
    syntax error. DAPs are very "particular" about the syntax of the hyperlinks.

    Try this for the server filter expression:
    client id=[client id]

    --

    Ken Snell
    <MS ACCESS MVP>


    "Juan" <Juan@discussions.microsoft.com> wrote in message
    news:CD06A8F1-55D3-4C20-ABC4-497EF7798C8A@microsoft.com...
    > the recordset for both dap's is the same query name "itin table qry' the
    > recordset for this query is the following:
    >


    < snippped >

    >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> news:434BF3C8-214A-458D-86D6-0BB2B25491F4@microsoft.com...
    >> > [Client ID] is the name of the field that holds the value in the first
    >> > dap
    >> > and that field is bound to an element on the dap also named "client
    >> > id".
    >> >
    >> > "Ken Snell (MVP)" wrote:
    >> >
    >> >> Hyperlink server filter syntax requires that you use the name of the
    >> >> field,
    >> >> not the name of an element. Is client ID the name of the field that
    >> >> holds
    >> >> the actual value in the first DAP? Is that field bound to an element
    >> >> (even
    >> >> if the element is hidden) on the first DAP?
    >> >>
    >> >> --
    >> >>
    >> >> Ken Snell
    >> >> <MS ACCESS MVP>
    >> >>
    >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> >> news:C20F5ADE-5940-4526-910E-D1ECEB773487@microsoft.com...
    >> >> > It's numeric. It is an autonumber and also the primary key for this
    >> >> > database
    >> >> >
    >> >> > "Ken Snell (MVP)" wrote:
    >> >> >
    >> >> >> What is the data type of ClientID? numeric? text?
    >> >> >>
    >> >> >> --
    >> >> >>
    >> >> >> Ken Snell
    >> >> >> <MS ACCESS MVP>
    >> >> >>
    >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> >> >> news:BA19F1C5-B40F-4036-BEBF-C066E34B0D7E@microsoft.com...
    >> >> >> > Well it shows one record at a time. It has a navigation bar on
    >> >> >> > the
    >> >> >> > bottom
    >> >> >> > that i can use to navigate between records.
    >> >> >> >
    >> >> >> > "Ken Snell (MVP)" wrote:
    >> >> >> >
    >> >> >> >> Is the first DAP showing more than one record?
    >> >> >> >> --
    >> >> >> >>
    >> >> >> >> Ken Snell
    >> >> >> >> <MS ACCESS MVP>
    >> >> >> >>
    >> >> >> >>
    >> >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> >> >> >> news:F5107F68-F0A6-4EEE-97D5-6231D32F1918@microsoft.com...
    >> >> >> >> > well i have two DAP's they both have a common field called
    >> >> >> >> > [client
    >> >> >> >> > id]
    >> >> >> >> > and
    >> >> >> >> > the recordset for both is a query named "itin table qry".
    >> >> >> >> > what i
    >> >> >> >> > want
    >> >> >> >> > to
    >> >> >> >> > do
    >> >> >> >> > is click on a hyperlink on the first dap, named "ITIN FORM2",
    >> >> >> >> > and
    >> >> >> >> > have
    >> >> >> >> > the
    >> >> >> >> > second dap, named "w72", open up and display the same record i
    >> >> >> >> > was
    >> >> >> >> > editing
    >> >> >> >> > on
    >> >> >> >> > the first form. what i have tried is putting the following
    >> >> >> >> > code
    >> >> >> >> > in
    >> >> >> >> > the
    >> >> >> >> > server filter section of the hyperlink: [client id]=[client
    >> >> >> >> > id]
    >> >> >> >> >
    >> >> >> >> > when dap "w72" opens it always shows me the first record in
    >> >> >> >> > the
    >> >> >> >> > recordset
    >> >> >> >> > and not the one that i want to see.
    >> >> >> >> >
    >> >> >> >> > am i doing something wrong??
    >> >> >> >> >
    >> >> >> >> >
    >> >> >> >> > "Ken Snell (MVP)" wrote:
    >> >> >> >> >
    >> >> >> >> >> Works for me when I use it...so, tell us what you've tried,
    >> >> >> >> >> what
    >> >> >> >> >> is
    >> >> >> >> >> happening (or not happening) when you try it, what is the
    >> >> >> >> >> syntax
    >> >> >> >> >> you're
    >> >> >> >> >> using for the ServerFilter expression, what is the setup of
    >> >> >> >> >> you
    >> >> >> >> >> DAP,
    >> >> >> >> >> what
    >> >> >> >> >> is
    >> >> >> >> >> its Recordset, etc.
    >> >> >> >> >>
    >> >> >> >> >> --
    >> >> >> >> >>
    >> >> >> >> >> Ken Snell
    >> >> >> >> >> <MS ACCESS MVP>
    >> >> >> >> >>
    >> >> >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> >> >> >> >> news:65C37DEC-7429-4389-9A42-010BB0953CEB@microsoft.com...
    >> >> >> >> >> > Hi,
    >> >> >> >> >> >
    >> >> >> >> >> > I've been having a hard time using the server filter on
    >> >> >> >> >> > DAP.
    >> >> >> >> >> > What i
    >> >> >> >> >> > want
    >> >> >> >> >> > to
    >> >> >> >> >> > do is click on a hyperlink and open up a DAP where it shows
    >> >> >> >> >> > me
    >> >> >> >> >> > a
    >> >> >> >> >> > specific
    >> >> >> >> >> > record based on a field on my current form. Can anyone
    >> >> >> >> >> > help?
    >> >> >> >> >> >
    >> >> >> >> >> > thanks in advance!
    >> >> >> >> >>
    >> >> >> >> >>
    >> >> >> >> >>
    >> >> >> >>
    >> >> >> >>
    >> >> >> >>
    >> >> >>
    >> >> >>
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     
  14. Juan

    Juan
    Expand Collapse
    Guest

    sorry Ken, but apparantly this doesn't wanna work either, and frankly i am
    quite frustrated already.

    Basically what i wanted to achieve with the dap is connect multiple offices
    together so we can all share the same data. Dap's seemed like a good option
    but now that i personally have tried it, it seems like im worse off.

    do u have any suggestions on how to connect multiple worksites without the
    need of daps?

    "Ken Snell (MVP)" wrote:

    > It's been a while since I programmed a DAP, so I'd neglected to note the
    > syntax error. DAPs are very "particular" about the syntax of the hyperlinks.
    >
    > Try this for the server filter expression:
    > client id=[client id]
    >
    > --
    >
    > Ken Snell
    > <MS ACCESS MVP>
    >
    >
    > "Juan" <Juan@discussions.microsoft.com> wrote in message
    > news:CD06A8F1-55D3-4C20-ABC4-497EF7798C8A@microsoft.com...
    > > the recordset for both dap's is the same query name "itin table qry' the
    > > recordset for this query is the following:
    > >

    >
    > < snippped >
    >
    > >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> news:434BF3C8-214A-458D-86D6-0BB2B25491F4@microsoft.com...
    > >> > [Client ID] is the name of the field that holds the value in the first
    > >> > dap
    > >> > and that field is bound to an element on the dap also named "client
    > >> > id".
    > >> >
    > >> > "Ken Snell (MVP)" wrote:
    > >> >
    > >> >> Hyperlink server filter syntax requires that you use the name of the
    > >> >> field,
    > >> >> not the name of an element. Is client ID the name of the field that
    > >> >> holds
    > >> >> the actual value in the first DAP? Is that field bound to an element
    > >> >> (even
    > >> >> if the element is hidden) on the first DAP?
    > >> >>
    > >> >> --
    > >> >>
    > >> >> Ken Snell
    > >> >> <MS ACCESS MVP>
    > >> >>
    > >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> >> news:C20F5ADE-5940-4526-910E-D1ECEB773487@microsoft.com...
    > >> >> > It's numeric. It is an autonumber and also the primary key for this
    > >> >> > database
    > >> >> >
    > >> >> > "Ken Snell (MVP)" wrote:
    > >> >> >
    > >> >> >> What is the data type of ClientID? numeric? text?
    > >> >> >>
    > >> >> >> --
    > >> >> >>
    > >> >> >> Ken Snell
    > >> >> >> <MS ACCESS MVP>
    > >> >> >>
    > >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> >> >> news:BA19F1C5-B40F-4036-BEBF-C066E34B0D7E@microsoft.com...
    > >> >> >> > Well it shows one record at a time. It has a navigation bar on
    > >> >> >> > the
    > >> >> >> > bottom
    > >> >> >> > that i can use to navigate between records.
    > >> >> >> >
    > >> >> >> > "Ken Snell (MVP)" wrote:
    > >> >> >> >
    > >> >> >> >> Is the first DAP showing more than one record?
    > >> >> >> >> --
    > >> >> >> >>
    > >> >> >> >> Ken Snell
    > >> >> >> >> <MS ACCESS MVP>
    > >> >> >> >>
    > >> >> >> >>
    > >> >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> >> >> >> news:F5107F68-F0A6-4EEE-97D5-6231D32F1918@microsoft.com...
    > >> >> >> >> > well i have two DAP's they both have a common field called
    > >> >> >> >> > [client
    > >> >> >> >> > id]
    > >> >> >> >> > and
    > >> >> >> >> > the recordset for both is a query named "itin table qry".
    > >> >> >> >> > what i
    > >> >> >> >> > want
    > >> >> >> >> > to
    > >> >> >> >> > do
    > >> >> >> >> > is click on a hyperlink on the first dap, named "ITIN FORM2",
    > >> >> >> >> > and
    > >> >> >> >> > have
    > >> >> >> >> > the
    > >> >> >> >> > second dap, named "w72", open up and display the same record i
    > >> >> >> >> > was
    > >> >> >> >> > editing
    > >> >> >> >> > on
    > >> >> >> >> > the first form. what i have tried is putting the following
    > >> >> >> >> > code
    > >> >> >> >> > in
    > >> >> >> >> > the
    > >> >> >> >> > server filter section of the hyperlink: [client id]=[client
    > >> >> >> >> > id]
    > >> >> >> >> >
    > >> >> >> >> > when dap "w72" opens it always shows me the first record in
    > >> >> >> >> > the
    > >> >> >> >> > recordset
    > >> >> >> >> > and not the one that i want to see.
    > >> >> >> >> >
    > >> >> >> >> > am i doing something wrong??
    > >> >> >> >> >
    > >> >> >> >> >
    > >> >> >> >> > "Ken Snell (MVP)" wrote:
    > >> >> >> >> >
    > >> >> >> >> >> Works for me when I use it...so, tell us what you've tried,
    > >> >> >> >> >> what
    > >> >> >> >> >> is
    > >> >> >> >> >> happening (or not happening) when you try it, what is the
    > >> >> >> >> >> syntax
    > >> >> >> >> >> you're
    > >> >> >> >> >> using for the ServerFilter expression, what is the setup of
    > >> >> >> >> >> you
    > >> >> >> >> >> DAP,
    > >> >> >> >> >> what
    > >> >> >> >> >> is
    > >> >> >> >> >> its Recordset, etc.
    > >> >> >> >> >>
    > >> >> >> >> >> --
    > >> >> >> >> >>
    > >> >> >> >> >> Ken Snell
    > >> >> >> >> >> <MS ACCESS MVP>
    > >> >> >> >> >>
    > >> >> >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> >> >> >> >> news:65C37DEC-7429-4389-9A42-010BB0953CEB@microsoft.com...
    > >> >> >> >> >> > Hi,
    > >> >> >> >> >> >
    > >> >> >> >> >> > I've been having a hard time using the server filter on
    > >> >> >> >> >> > DAP.
    > >> >> >> >> >> > What i
    > >> >> >> >> >> > want
    > >> >> >> >> >> > to
    > >> >> >> >> >> > do is click on a hyperlink and open up a DAP where it shows
    > >> >> >> >> >> > me
    > >> >> >> >> >> > a
    > >> >> >> >> >> > specific
    > >> >> >> >> >> > record based on a field on my current form. Can anyone
    > >> >> >> >> >> > help?
    > >> >> >> >> >> >
    > >> >> >> >> >> > thanks in advance!
    > >> >> >> >> >>
    > >> >> >> >> >>
    > >> >> >> >> >>
    > >> >> >> >>
    > >> >> >> >>
    > >> >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >>
    > >> >>
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >
     
  15. Ken Snell \(MVP\)

    Ken Snell \(MVP\)
    Expand Collapse
    Guest

    Before you drop the DAP idea/concept, try a simple change to your query that
    is the recordset for both DAPs. Add an Alias for the client id field to make
    it clientid:

    SELECT [ITIN TABLE].[CLIENT ID] AS CLIENTID,
    [ITIN TABLE].[DOCUMENT CODE #1],
    (etc.)

    Then change the server filter syntax to
    clientid=[clientid]

    Believe me, I've shared your frustration with trying to figure out the
    idiosyncracies of DAPs...there are many things I yet haven't figured out.

    If the multiple offices are not on a LAN, then your options would be DAPs,
    or .asp pages, or other programmable web pages.
    If the offices are on a LAN, then you can use a "split" concept for the
    ACCESS database, where each user has a copy of a front end on his/her PC and
    the front ends link to a single backend file (the backend file has the
    tables/data, the frontend files have the forms, reports, queries, etc.).

    --

    Ken Snell
    <MS ACCESS MVP>



    "Juan" <Juan@discussions.microsoft.com> wrote in message
    news:7EA20617-B8C8-4A78-BBD9-B7C0C138FECB@microsoft.com...
    > sorry Ken, but apparantly this doesn't wanna work either, and frankly i am
    > quite frustrated already.
    >
    > Basically what i wanted to achieve with the dap is connect multiple
    > offices
    > together so we can all share the same data. Dap's seemed like a good
    > option
    > but now that i personally have tried it, it seems like im worse off.
    >
    > do u have any suggestions on how to connect multiple worksites without the
    > need of daps?
    >
    > "Ken Snell (MVP)" wrote:
    >
    >> It's been a while since I programmed a DAP, so I'd neglected to note the
    >> syntax error. DAPs are very "particular" about the syntax of the
    >> hyperlinks.
    >>
    >> Try this for the server filter expression:
    >> client id=[client id]
    >>
    >> --
    >>
    >> Ken Snell
    >> <MS ACCESS MVP>
    >>
    >>
    >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> news:CD06A8F1-55D3-4C20-ABC4-497EF7798C8A@microsoft.com...
    >> > the recordset for both dap's is the same query name "itin table qry'
    >> > the
    >> > recordset for this query is the following:
    >> >

    >>
    >> < snippped >
    >>
    >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> >> news:434BF3C8-214A-458D-86D6-0BB2B25491F4@microsoft.com...
    >> >> > [Client ID] is the name of the field that holds the value in the
    >> >> > first
    >> >> > dap
    >> >> > and that field is bound to an element on the dap also named "client
    >> >> > id".
    >> >> >
    >> >> > "Ken Snell (MVP)" wrote:
    >> >> >
    >> >> >> Hyperlink server filter syntax requires that you use the name of
    >> >> >> the
    >> >> >> field,
    >> >> >> not the name of an element. Is client ID the name of the field that
    >> >> >> holds
    >> >> >> the actual value in the first DAP? Is that field bound to an
    >> >> >> element
    >> >> >> (even
    >> >> >> if the element is hidden) on the first DAP?
    >> >> >>
    >> >> >> --
    >> >> >>
    >> >> >> Ken Snell
    >> >> >> <MS ACCESS MVP>
    >> >> >>
    >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> >> >> news:C20F5ADE-5940-4526-910E-D1ECEB773487@microsoft.com...
    >> >> >> > It's numeric. It is an autonumber and also the primary key for
    >> >> >> > this
    >> >> >> > database
    >> >> >> >
    >> >> >> > "Ken Snell (MVP)" wrote:
    >> >> >> >
    >> >> >> >> What is the data type of ClientID? numeric? text?
    >> >> >> >>
    >> >> >> >> --
    >> >> >> >>
    >> >> >> >> Ken Snell
    >> >> >> >> <MS ACCESS MVP>
    >> >> >> >>
    >> >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> >> >> >> news:BA19F1C5-B40F-4036-BEBF-C066E34B0D7E@microsoft.com...
    >> >> >> >> > Well it shows one record at a time. It has a navigation bar on
    >> >> >> >> > the
    >> >> >> >> > bottom
    >> >> >> >> > that i can use to navigate between records.
    >> >> >> >> >
    >> >> >> >> > "Ken Snell (MVP)" wrote:
    >> >> >> >> >
    >> >> >> >> >> Is the first DAP showing more than one record?
    >> >> >> >> >> --
    >> >> >> >> >>
    >> >> >> >> >> Ken Snell
    >> >> >> >> >> <MS ACCESS MVP>
    >> >> >> >> >>
    >> >> >> >> >>
    >> >> >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> >> >> >> >> news:F5107F68-F0A6-4EEE-97D5-6231D32F1918@microsoft.com...
    >> >> >> >> >> > well i have two DAP's they both have a common field called
    >> >> >> >> >> > [client
    >> >> >> >> >> > id]
    >> >> >> >> >> > and
    >> >> >> >> >> > the recordset for both is a query named "itin table qry".
    >> >> >> >> >> > what i
    >> >> >> >> >> > want
    >> >> >> >> >> > to
    >> >> >> >> >> > do
    >> >> >> >> >> > is click on a hyperlink on the first dap, named "ITIN
    >> >> >> >> >> > FORM2",
    >> >> >> >> >> > and
    >> >> >> >> >> > have
    >> >> >> >> >> > the
    >> >> >> >> >> > second dap, named "w72", open up and display the same
    >> >> >> >> >> > record i
    >> >> >> >> >> > was
    >> >> >> >> >> > editing
    >> >> >> >> >> > on
    >> >> >> >> >> > the first form. what i have tried is putting the following
    >> >> >> >> >> > code
    >> >> >> >> >> > in
    >> >> >> >> >> > the
    >> >> >> >> >> > server filter section of the hyperlink: [client
    >> >> >> >> >> > id]=[client
    >> >> >> >> >> > id]
    >> >> >> >> >> >
    >> >> >> >> >> > when dap "w72" opens it always shows me the first record in
    >> >> >> >> >> > the
    >> >> >> >> >> > recordset
    >> >> >> >> >> > and not the one that i want to see.
    >> >> >> >> >> >
    >> >> >> >> >> > am i doing something wrong??
    >> >> >> >> >> >
    >> >> >> >> >> >
    >> >> >> >> >> > "Ken Snell (MVP)" wrote:
    >> >> >> >> >> >
    >> >> >> >> >> >> Works for me when I use it...so, tell us what you've
    >> >> >> >> >> >> tried,
    >> >> >> >> >> >> what
    >> >> >> >> >> >> is
    >> >> >> >> >> >> happening (or not happening) when you try it, what is the
    >> >> >> >> >> >> syntax
    >> >> >> >> >> >> you're
    >> >> >> >> >> >> using for the ServerFilter expression, what is the setup
    >> >> >> >> >> >> of
    >> >> >> >> >> >> you
    >> >> >> >> >> >> DAP,
    >> >> >> >> >> >> what
    >> >> >> >> >> >> is
    >> >> >> >> >> >> its Recordset, etc.
    >> >> >> >> >> >>
    >> >> >> >> >> >> --
    >> >> >> >> >> >>
    >> >> >> >> >> >> Ken Snell
    >> >> >> >> >> >> <MS ACCESS MVP>
    >> >> >> >> >> >>
    >> >> >> >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    >> >> >> >> >> >> news:65C37DEC-7429-4389-9A42-010BB0953CEB@microsoft.com...
    >> >> >> >> >> >> > Hi,
    >> >> >> >> >> >> >
    >> >> >> >> >> >> > I've been having a hard time using the server filter on
    >> >> >> >> >> >> > DAP.
    >> >> >> >> >> >> > What i
    >> >> >> >> >> >> > want
    >> >> >> >> >> >> > to
    >> >> >> >> >> >> > do is click on a hyperlink and open up a DAP where it
    >> >> >> >> >> >> > shows
    >> >> >> >> >> >> > me
    >> >> >> >> >> >> > a
    >> >> >> >> >> >> > specific
    >> >> >> >> >> >> > record based on a field on my current form. Can anyone
    >> >> >> >> >> >> > help?
    >> >> >> >> >> >> >
    >> >> >> >> >> >> > thanks in advance!
    >> >> >> >> >> >>
    >> >> >> >> >> >>
    >> >> >> >> >> >>
    >> >> >> >> >>
    >> >> >> >> >>
    >> >> >> >> >>
    >> >> >> >>
    >> >> >> >>
    >> >> >> >>
    >> >> >>
    >> >> >>
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     
  16. Juan

    Juan
    Expand Collapse
    Guest

    ken,

    I'm not really sure what difference that made with the server filter
    expression but it worked perfectly!

    thank you so much.

    "Ken Snell (MVP)" wrote:

    > Before you drop the DAP idea/concept, try a simple change to your query that
    > is the recordset for both DAPs. Add an Alias for the client id field to make
    > it clientid:
    >
    > SELECT [ITIN TABLE].[CLIENT ID] AS CLIENTID,
    > [ITIN TABLE].[DOCUMENT CODE #1],
    > (etc.)
    >
    > Then change the server filter syntax to
    > clientid=[clientid]
    >
    > Believe me, I've shared your frustration with trying to figure out the
    > idiosyncracies of DAPs...there are many things I yet haven't figured out.
    >
    > If the multiple offices are not on a LAN, then your options would be DAPs,
    > or .asp pages, or other programmable web pages.
    > If the offices are on a LAN, then you can use a "split" concept for the
    > ACCESS database, where each user has a copy of a front end on his/her PC and
    > the front ends link to a single backend file (the backend file has the
    > tables/data, the frontend files have the forms, reports, queries, etc.).
    >
    > --
    >
    > Ken Snell
    > <MS ACCESS MVP>
    >
    >
    >
    > "Juan" <Juan@discussions.microsoft.com> wrote in message
    > news:7EA20617-B8C8-4A78-BBD9-B7C0C138FECB@microsoft.com...
    > > sorry Ken, but apparantly this doesn't wanna work either, and frankly i am
    > > quite frustrated already.
    > >
    > > Basically what i wanted to achieve with the dap is connect multiple
    > > offices
    > > together so we can all share the same data. Dap's seemed like a good
    > > option
    > > but now that i personally have tried it, it seems like im worse off.
    > >
    > > do u have any suggestions on how to connect multiple worksites without the
    > > need of daps?
    > >
    > > "Ken Snell (MVP)" wrote:
    > >
    > >> It's been a while since I programmed a DAP, so I'd neglected to note the
    > >> syntax error. DAPs are very "particular" about the syntax of the
    > >> hyperlinks.
    > >>
    > >> Try this for the server filter expression:
    > >> client id=[client id]
    > >>
    > >> --
    > >>
    > >> Ken Snell
    > >> <MS ACCESS MVP>
    > >>
    > >>
    > >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> news:CD06A8F1-55D3-4C20-ABC4-497EF7798C8A@microsoft.com...
    > >> > the recordset for both dap's is the same query name "itin table qry'
    > >> > the
    > >> > recordset for this query is the following:
    > >> >
    > >>
    > >> < snippped >
    > >>
    > >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> >> news:434BF3C8-214A-458D-86D6-0BB2B25491F4@microsoft.com...
    > >> >> > [Client ID] is the name of the field that holds the value in the
    > >> >> > first
    > >> >> > dap
    > >> >> > and that field is bound to an element on the dap also named "client
    > >> >> > id".
    > >> >> >
    > >> >> > "Ken Snell (MVP)" wrote:
    > >> >> >
    > >> >> >> Hyperlink server filter syntax requires that you use the name of
    > >> >> >> the
    > >> >> >> field,
    > >> >> >> not the name of an element. Is client ID the name of the field that
    > >> >> >> holds
    > >> >> >> the actual value in the first DAP? Is that field bound to an
    > >> >> >> element
    > >> >> >> (even
    > >> >> >> if the element is hidden) on the first DAP?
    > >> >> >>
    > >> >> >> --
    > >> >> >>
    > >> >> >> Ken Snell
    > >> >> >> <MS ACCESS MVP>
    > >> >> >>
    > >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> >> >> news:C20F5ADE-5940-4526-910E-D1ECEB773487@microsoft.com...
    > >> >> >> > It's numeric. It is an autonumber and also the primary key for
    > >> >> >> > this
    > >> >> >> > database
    > >> >> >> >
    > >> >> >> > "Ken Snell (MVP)" wrote:
    > >> >> >> >
    > >> >> >> >> What is the data type of ClientID? numeric? text?
    > >> >> >> >>
    > >> >> >> >> --
    > >> >> >> >>
    > >> >> >> >> Ken Snell
    > >> >> >> >> <MS ACCESS MVP>
    > >> >> >> >>
    > >> >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> >> >> >> news:BA19F1C5-B40F-4036-BEBF-C066E34B0D7E@microsoft.com...
    > >> >> >> >> > Well it shows one record at a time. It has a navigation bar on
    > >> >> >> >> > the
    > >> >> >> >> > bottom
    > >> >> >> >> > that i can use to navigate between records.
    > >> >> >> >> >
    > >> >> >> >> > "Ken Snell (MVP)" wrote:
    > >> >> >> >> >
    > >> >> >> >> >> Is the first DAP showing more than one record?
    > >> >> >> >> >> --
    > >> >> >> >> >>
    > >> >> >> >> >> Ken Snell
    > >> >> >> >> >> <MS ACCESS MVP>
    > >> >> >> >> >>
    > >> >> >> >> >>
    > >> >> >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> >> >> >> >> news:F5107F68-F0A6-4EEE-97D5-6231D32F1918@microsoft.com...
    > >> >> >> >> >> > well i have two DAP's they both have a common field called
    > >> >> >> >> >> > [client
    > >> >> >> >> >> > id]
    > >> >> >> >> >> > and
    > >> >> >> >> >> > the recordset for both is a query named "itin table qry".
    > >> >> >> >> >> > what i
    > >> >> >> >> >> > want
    > >> >> >> >> >> > to
    > >> >> >> >> >> > do
    > >> >> >> >> >> > is click on a hyperlink on the first dap, named "ITIN
    > >> >> >> >> >> > FORM2",
    > >> >> >> >> >> > and
    > >> >> >> >> >> > have
    > >> >> >> >> >> > the
    > >> >> >> >> >> > second dap, named "w72", open up and display the same
    > >> >> >> >> >> > record i
    > >> >> >> >> >> > was
    > >> >> >> >> >> > editing
    > >> >> >> >> >> > on
    > >> >> >> >> >> > the first form. what i have tried is putting the following
    > >> >> >> >> >> > code
    > >> >> >> >> >> > in
    > >> >> >> >> >> > the
    > >> >> >> >> >> > server filter section of the hyperlink: [client
    > >> >> >> >> >> > id]=[client
    > >> >> >> >> >> > id]
    > >> >> >> >> >> >
    > >> >> >> >> >> > when dap "w72" opens it always shows me the first record in
    > >> >> >> >> >> > the
    > >> >> >> >> >> > recordset
    > >> >> >> >> >> > and not the one that i want to see.
    > >> >> >> >> >> >
    > >> >> >> >> >> > am i doing something wrong??
    > >> >> >> >> >> >
    > >> >> >> >> >> >
    > >> >> >> >> >> > "Ken Snell (MVP)" wrote:
    > >> >> >> >> >> >
    > >> >> >> >> >> >> Works for me when I use it...so, tell us what you've
    > >> >> >> >> >> >> tried,
    > >> >> >> >> >> >> what
    > >> >> >> >> >> >> is
    > >> >> >> >> >> >> happening (or not happening) when you try it, what is the
    > >> >> >> >> >> >> syntax
    > >> >> >> >> >> >> you're
    > >> >> >> >> >> >> using for the ServerFilter expression, what is the setup
    > >> >> >> >> >> >> of
    > >> >> >> >> >> >> you
    > >> >> >> >> >> >> DAP,
    > >> >> >> >> >> >> what
    > >> >> >> >> >> >> is
    > >> >> >> >> >> >> its Recordset, etc.
    > >> >> >> >> >> >>
    > >> >> >> >> >> >> --
    > >> >> >> >> >> >>
    > >> >> >> >> >> >> Ken Snell
    > >> >> >> >> >> >> <MS ACCESS MVP>
    > >> >> >> >> >> >>
    > >> >> >> >> >> >> "Juan" <Juan@discussions.microsoft.com> wrote in message
    > >> >> >> >> >> >> news:65C37DEC-7429-4389-9A42-010BB0953CEB@microsoft.com...
    > >> >> >> >> >> >> > Hi,
    > >> >> >> >> >> >> >
    > >> >> >> >> >> >> > I've been having a hard time using the server filter on
    > >> >> >> >> >> >> > DAP.
    > >> >> >> >> >> >> > What i
    > >> >> >> >> >> >> > want
    > >> >> >> >> >> >> > to
    > >> >> >> >> >> >> > do is click on a hyperlink and open up a DAP where it
    > >> >> >> >> >> >> > shows
    > >> >> >> >> >> >> > me
    > >> >> >> >> >> >> > a
    > >> >> >> >> >> >> > specific
    > >> >> >> >> >> >> > record based on a field on my current form. Can anyone
    > >> >> >> >> >> >> > help?
    > >> >> >> >> >> >> >
    > >> >> >> >> >> >> > thanks in advance!
    > >> >> >> >> >> >>
    > >> >> >> >> >> >>
    > >> >> >> >> >> >>
    > >> >> >> >> >>
    > >> >> >> >> >>
    > >> >> >> >> >>
    > >> >> >> >>
    > >> >> >> >>
    > >> >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >>
    > >> >>
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >
     
  17. Ken Snell \(MVP\)

    Ken Snell \(MVP\)
    Expand Collapse
    Guest

    My guess.... the DAP doesn't handle field names with spaces in them.
    Glad it's working.

    --

    Ken Snell
    <MS ACCESS MVP>

    "Juan" <Juan@discussions.microsoft.com> wrote in message
    news:5ED0F31C-5114-4827-A522-C252736D64AF@microsoft.com...
    > ken,
    >
    > I'm not really sure what difference that made with the server filter
    > expression but it worked perfectly!
    >
    > thank you so much.
    >
    > "Ken Snell (MVP)" wrote:
    >
    >> Before you drop the DAP idea/concept, try a simple change to your query
    >> that
    >> is the recordset for both DAPs. Add an Alias for the client id field to
    >> make
    >> it clientid:
    >>
    >> SELECT [ITIN TABLE].[CLIENT ID] AS CLIENTID,
    >> [ITIN TABLE].[DOCUMENT CODE #1],
    >> (etc.)
    >>
    >> Then change the server filter syntax to
    >> clientid=[clientid]
    >>
    >> Believe me, I've shared your frustration with trying to figure out the
    >> idiosyncracies of DAPs...there are many things I yet haven't figured out.
    >>
    >> If the multiple offices are not on a LAN, then your options would be
    >> DAPs,
    >> or .asp pages, or other programmable web pages.
    >> If the offices are on a LAN, then you can use a "split" concept for the
    >> ACCESS database, where each user has a copy of a front end on his/her PC
    >> and
    >> the front ends link to a single backend file (the backend file has the
    >> tables/data, the frontend files have the forms, reports, queries, etc.).
    >>
    >> --
    >>
    >> Ken Snell
    >> <MS ACCESS MVP>


    <snipped>
     
  18. dbahooker@hotmail.com

    dbahooker@hotmail.com
    Expand Collapse
    Guest

    hey dont ever use anything with a space in it.
    no field names; no control names

    come on bud
     

Share This Page