DAP Server Filter Doesn't Work

[Juan]

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!

 

[Ken Snell \(MVP\)]

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.

 

[Juan]

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\)]

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

Ken Snell
<MS ACCESS MVP>

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??

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.

 

[Juan]

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

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

Ken Snell
<MS ACCESS MVP>

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??

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>

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!

 

[Ken Snell \(MVP\)]

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

--

Ken Snell
<MS ACCESS MVP>

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

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

Ken Snell
<MS ACCESS MVP>

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??


:

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>

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!

 

[Juan]

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

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

--

Ken Snell
<MS ACCESS MVP>

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

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

Ken Snell
<MS ACCESS MVP>


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??


:

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>

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!

 

[Ken Snell \(MVP\)]

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>

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

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

--

Ken Snell
<MS ACCESS MVP>

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

:

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

Ken Snell
<MS ACCESS MVP>


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??


:

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>

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!

 

[Juan]

[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".

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>

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

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

--

Ken Snell
<MS ACCESS MVP>

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

:

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

Ken Snell
<MS ACCESS MVP>


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??


:

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>

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!

 

[Ken Snell \(MVP\)]

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>

[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".

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>

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

:

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

--

Ken Snell
<MS ACCESS MVP>

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

:

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

Ken Snell
<MS ACCESS MVP>


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??


:

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>

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!

 

[Juan]

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];

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>

[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".

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>

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

:

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

--

Ken Snell
<MS ACCESS MVP>

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

:

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

Ken Snell
<MS ACCESS MVP>


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??


:

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>

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!

 

[Ken Snell \(MVP\)]

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>

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

[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".

:

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>

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

:

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

--

Ken Snell
<MS ACCESS MVP>

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

:

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

Ken Snell
<MS ACCESS MVP>


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??


:

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>

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!

 

[Juan]

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?

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>

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

[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".

:

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>

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

:

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

--

Ken Snell
<MS ACCESS MVP>

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

:

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

Ken Snell
<MS ACCESS MVP>


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??


:

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>

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!

 

[Ken Snell \(MVP\)]

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>

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?

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>

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

[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".

:

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>

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

:

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

--

Ken Snell
<MS ACCESS MVP>

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

:

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

Ken Snell
<MS ACCESS MVP>


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??


:

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>

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!

 

[Juan]

ken,

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

thank you so much.

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>

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?

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>


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


< snippped >

[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".

:

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>

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

:

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

--

Ken Snell
<MS ACCESS MVP>

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

:

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

Ken Snell
<MS ACCESS MVP>


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??


:

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>

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!

 

[Ken Snell \(MVP\)]

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

--

Ken Snell
<MS ACCESS MVP>

ken,

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

thank you so much.

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.).

<snipped>

 

[dbahooker]

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

come on bud

 

[Airbonzo]

how were you able to view the recordset query?

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

--

Ken Snell
<MS ACCESS MVP>

ken,

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

thank you so much.

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.).

<snipped>

 

[Ken Snell \(MVP\)]

? not understanding your question ??

--

Ken Snell
<MS ACCESS MVP>

how were you able to view the recordset query?

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

--

Ken Snell
<MS ACCESS MVP>

ken,

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

thank you so much.

:

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.).

<snipped>

 

[Airbonzo]

I have the same problem where in my noobish beginnings I put a space in one
of my record keys. I need to add an alais as you did but i cannot find the
recordset query code that contains all the select code.

Juan Posted this...
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
......

Where in the DAP is that found?
All I see when editing the page in script editor is this:


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns =
"urn:schemas-microsoft-comfficeffice" xmlns:x =
"urn:schemas-microsoft-comffice:excel" xmlns:a =
"urn:schemas-microsoft-comffice:access" xmlns:dt =
"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><HEAD><TITLE>additem_1</TITLE><LINK
href="additem_files/filelist.xml" type=text/xml rel=File-List>
<META content=Access.Application name=ProgId>
<META name=VBSForEventHandlers VALUE="TRUE">
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content=10.00.2225 name=DesignerVersion>
<META content="HTML 4.0" name=vs_targetSchema>
<OBJECT id=MSODSC tabIndex=-1
classid=CLSID:0002E553-0000-0000-C000-000000000046><PARAM NAME="XMLData"
VALUE="<xml xmlns:a="urn:schemas-microsoft-comffice:access">
<aataSourceControl>
<a:OWCVersion>10.0.0.6619 </a:OWCVersion>
<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=\\Lab-pc1\Swap\Lab Stock\Lab Database.mdb;Mode=Share Deny
None;Extended Properties=&quot;&quot;;Persist Security Info=False;Jet
OLEDB:System database=&quot;&quot;;Jet OLEDB:Registry Path=&quot;&quot;;Jet
OLEDBatabase Password=&quot;&quot;;Jet OLEDB:Engine Type=0;Jet
OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet
OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database
Password=&quot;&quot;;Jet OLEDB:Create System Database=False;Jet
OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet
OLEDB:Compact Without Replica Repair=False;Jet
OLEDB:SFP=False</a:ConnectionString>
<aataEntry/>
<a:MaxRecords>10000</a:MaxRecords>
<a:GridX>24</a:GridX>
<a:GridY>24</a:GridY>
<a:OfflineType>2</a:OfflineType>
<a:XMLLocation>0</a:XMLLocation>
<a:XMLDataTarget></a:XMLDataTarget>
<a:ConnectionFile></a:ConnectionFile>
<a:ElementExtension>
<a:ElementID>ItemName</a:ElementID>
<a:ControlSource>ItemName</a:ControlSource>
<a:ChildLabel>ItemName_Label</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>ItemType</a:ElementID>
<a:ControlSource>ItemType</a:ControlSource>
<a:ChildLabel>ItemType_Label</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Digikey#</a:ElementID>
<a:ControlSource>Digikey#</a:ControlSource>
<a:ChildLabel>Digikey#_Label</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Category</a:ElementID>
<a:ControlSource>Category</a:ControlSource>
<a:ListRowSource>Category_ListRowsource</a:ListRowSource>
<a:ListBoundField>Category</a:ListBoundField>
<a:ListDisplayField>Category</a:ListDisplayField>
<a:ChildLabel>Category_Label</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Draw#</a:ElementID>
<a:ControlSource>Draw#</a:ControlSource>
<a:ChildLabel>Draw#_Label</a:ChildLabel>
<aefaultValue>=0</aefaultValue>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Supplier</a:ElementID>
<a:ControlSource>Supplier</a:ControlSource>
<a:ListRowSource>Supplier_ListRowsource</a:ListRowSource>
<a:ListBoundField>SupplierID</a:ListBoundField>
<a:ListDisplayField>SupplierName</a:ListDisplayField>
<a:ChildLabel>Supplier_Label</a:ChildLabel>
<aefaultValue>=0</aefaultValue>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Description</a:ElementID>
<a:ControlSource>Description</a:ControlSource>
<a:ChildLabel>Description_Label</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>ItemID</a:ElementID>
<a:ControlSource>Item ID</a:ControlSource>
<a:ChildLabel>ItemID_Label</a:ChildLabel>
</a:ElementExtension>
<a:GroupLevel>
<a:RecordSource>Items</a:RecordSource>
<aefaultSort></aefaultSort>
<a:HeaderElementId>HeaderItems</a:HeaderElementId>
<a:FooterElementId></a:FooterElementId>
<a:CaptionElementId></a:CaptionElementId>
<a:RecordNavigationElementId></a:RecordNavigationElementId>
<aataPageSize>1</aataPageSize>
<a:GroupFilterControl></a:GroupFilterControl>
<a:AlternateRowColor>whitesmoke</a:AlternateRowColor>
</a:GroupLevel>
<aatamodel a:version="0816">
<a:SchemaRowsource a:id="Category_ListRowsource" a:type="dscCommandText">
<a:CommandText>SELECT Category.Category, Category.[Category ID] FROM
Category; </a:CommandText>
<a:SchemaField a:id="Category" a:datatype="202" a:size="50"/>
<a:SchemaField a:id="Category ID" a:datatype="3" a:size="4"/>
</a:SchemaRowsource>
<a:SchemaRowsource a:id="Supplier_ListRowsource" a:type="dscCommandText">
<a:CommandText>SELECT Suppliers.* FROM Suppliers; </a:CommandText>
<a:SchemaField a:id="SupplierID" a:datatype="3" a:size="4"/>
<a:SchemaField a:id="SupplierName" a:datatype="202" a:size="50"/>
<a:SchemaField a:id="Address" a:datatype="202" a:size="255"/>
<a:SchemaField a:id="City" a:datatype="202" a:size="50"/>
<a:SchemaField a:id="PostalCode" a:datatype="202" a:size="20"/>
<a:SchemaField a:id="StateOrProvince" a:datatype="202" a:size="20"/>
<a:SchemaField a:id="PhoneNumber" a:datatype="202" a:size="30"/>
<a:SchemaField a:id="EmailAddress" a:datatype="202" a:size="50"/>
<a:SchemaField a:id="VendorCode" a:datatype="202" a:size="50"/>
</a:SchemaRowsource>
<a:SchemaRowsource a:id="Items" a:type="dscTable">
<a:SchemaField a:id="Item ID" a:datatype="3" a:size="0" a:iskey="1"/>
<a:SchemaField a:id="ItemName" a:datatype="130" a:size="50"/>
<a:SchemaField a:id="ItemType" a:datatype="130" a:size="50"/>
<a:SchemaField a:id="Digikey#" a:datatype="130" a:size="50"/>
<a:SchemaField a:id="Category" a:datatype="130" a:size="50"/>
<a:SchemaField a:id="Draw#" a:datatype="3" a:size="0"/>
<a:SchemaField a:id="Supplier" a:datatype="3" a:size="0"/>
<a:SchemaField a:id="Description" a:datatype="130" a:size="50"/>
</a:SchemaRowsource>
<a:RecordsetDef a:id="Items">
<aageField a:id="ItemName"/>
<aageField a:id="ItemType"/>
<aageField a:id="Digikey#"/>
<aageField a:id="Category"/>
<aageField a:id="Draw#"/>
<aageField a:id="Supplier"/>
<aageField a:id="Description"/>
<aageField a:id="Item ID"/>
</a:RecordsetDef>
<a:RecordsetDef a:id="Category_ListRowsource">
<aageField a:id="Category"/>
</a:RecordsetDef>
<a:RecordsetDef a:id="Supplier_ListRowsource">
<aageField a:id="SupplierID"/>
<aageField a:id="SupplierName"/>
</a:RecordsetDef>
</aatamodel>
</aataSourceControl>
</xml>"></OBJECT>
<META content="MSHTML 6.00.2900.3086" name=GENERATOR>
<STYLE id=MSODAPDEFAULTS type=text/css>.MSTheme-Label {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px;
FONT-SIZE: 8pt; OVERFLOW: visible; BORDER-LEFT: 0px; WIDTH: 1in;
BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; HEIGHT: 0.156in; TEXT-ALIGN: left
}
..MsoTextbox {
PADDING-RIGHT: 3px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden;
WIDTH: 1in; FONT-FAMILY: Tahoma; HEIGHT: 0.197in
}
..MsoBoundSpan {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px;
FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px;
FONT-FAMILY: Tahoma; TEXT-ALIGN: left
}
..MsoHyperlinkDisplayText {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px;
FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; CURSOR: hand;
BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
}
..Mso2dSection {
LEFT: 0px; BEHAVIOR: url(#DEFAULT#Mso2dSection); OVERFLOW: hidden;
POSITION: relative; TOP: 0px; BACKGROUND-COLOR: transparent
}
..Mso2dSectionBanner {
PADDING-RIGHT: 4px; DISPLAY: none; PADDING-LEFT: 4px; FONT-WEIGHT: normal;
FONT-SIZE: 8pt; LEFT: 0px; BEHAVIOR: url(#DEFAULT#Mso2dSectionBanner);
OVERFLOW: visible; PADDING-TOP: 2px; FONT-FAMILY: Tahoma; TOP: 0px; HEIGHT:
0.2in; BACKGROUND-COLOR: buttonface
}
..MsoRectangle {
BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; OVERFLOW:
hidden; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid
}
..MsoTitle {
DISPLAY: none; FONT-WEIGHT: normal; COLOR: inactivecaptiontext
}
..MsoExpandCollapse {
CURSOR: hand
}
..MsoNavContainer {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid;
Z-INDEX: -1; BORDER-LEFT: gainsboro 1px solid; CURSOR: hand; BORDER-BOTTOM:
gainsboro 1px solid; HEIGHT: 25px; BACKGROUND-COLOR: gainsboro
}
..MsoNavButton {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid;
BORDER-LEFT: gainsboro 1px solid; CURSOR: auto; BORDER-BOTTOM: gainsboro 1px
solid; BACKGROUND-REPEAT: no-repeat
}
..MsoNavButtonMouseOver {
BORDER-RIGHT: highlight 1px solid; BORDER-TOP: highlight 1px solid;
BORDER-LEFT: highlight 1px solid; BORDER-BOTTOM: highlight 1px solid;
BACKGROUND-COLOR: buttonhighlight
}
..MsoNavToggleButtonMouseOver {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid;
BORDER-LEFT: buttonshadow 1px solid; BORDER-BOTTOM: buttonshadow 1px solid;
BACKGROUND-REPEAT: no-repeat; BACKGROUND-COLOR: buttonshadow
}
..MsoNavButtonMouseDown {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid;
BORDER-LEFT: buttonshadow 1px solid; CURSOR: hand; BORDER-BOTTOM:
buttonshadow 1px solid; BACKGROUND-COLOR: buttonshadow
}
..MsoNavRecordsetLabel {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid;
PADDING-LEFT: 0px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: gainsboro
1px solid; WIDTH: 100%; CURSOR: default; PADDING-TOP: 0px; BORDER-BOTTOM:
gainsboro 1px solid; FONT-FAMILY: Tahoma; POSITION: relative
}
..MsoRecordSelector {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid;
OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px solid; BORDER-BOTTOM:
buttonshadow 1px solid; HEIGHT: 100%; BACKGROUND-COLOR: gainsboro
}
..MsoRecordSelectorCurrent {
BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11240);
BACKGROUND-REPEAT: no-repeat
}
..MsoRecordSelectorSelectedImage {
BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11241);
BACKGROUND-REPEAT: no-repeat
}
..MsoRecordSelectorSelected {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid;
LEFT: 0px; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px solid;
BORDER-BOTTOM: buttonshadow 1px solid; TOP: 0px; HEIGHT: 100%;
BACKGROUND-COLOR: buttonshadow
}
..MsoRecordSelectorDirtyCurrent {
BACKGROUND-POSITION: -1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11242);
BACKGROUND-REPEAT: no-repeat
}
..MsoRecordSelectorDirty {
BACKGROUND-POSITION: -1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11245);
BACKGROUND-REPEAT: no-repeat
}
..MsoRecordSelectorTransparent {
LEFT: 0px; OVERFLOW: hidden; TOP: 0px
}
HR {
COLOR: black
}
SELECT {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
INPUT {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BODY {
FONT-SIZE: 10pt; FONT-FAMILY: Tahoma
}
MARQUEE {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
LEGEND {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BUTTON {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
TEXTAREA {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
</STYLE>

<SCRIPT language=Javascript id=MSODSC_Validation>
validateBrowser();

function validateBrowser() {
strVers=navigator.appVersion
strName=navigator.appName
strPlat=navigator.platform
intIndex1=strVers.indexOf("MSIE");
intIndex1=intIndex1+5
intIndex2=strVers.lastIndexOf(";");
intVer=strVers.substring(intIndex1, intIndex2)
intVer=parseInt(intVer)
if (strName=="Microsoft Internet Explorer" && strPlat=="Win32" &&
intVer>="5") {
validateOWC();
}
else {
strMsgGetIE="<TABLE cellSpacing=0 cellPadding=0 width='95%' border=0
height='8'><TR>"
strMsgGetIE+="<TD bgColor='#336699' height=25 width=15> </TD><TD
bgColor='#666666' width=500px><FONT face=Tahoma "
strMsgGetIE+="size=4 color=white><b> Data Access Page
Notification</B></FONT></TD></TR>"
strMsgGetIE+="<TR><TD bgColor='#cccccc' width=15> </TD><TD
bgColor='#cccccc' width=500px><BR>"
strMsgGetIE+="<p><font face='Tahoma' size='2'>"
strMsgGetIE+="This page requires Windows IE 5.0 or higher.</p>"
strMsgGetIE+="<a
href='http://www.microsoft.com/isapi/redi...s&Pver=10&Ar=DPdesigner&Sba=IEhome&Plcid=1033'><p align='center'>"
strMsgGetIE+="Click here to install the latest version of Internet
Explorer.</a></font></p><br></TD></TR></TABLE>"
document.write(strMsgGetIE)
}
}

function validateOWC() {
if (MSODSC.object==null) {
strMsgGetOWC="<TABLE width='95%' cellpadding=0 cellspacing=0 border=0
height='8'>"
strMsgGetOWC+="<TR><TD bgColor='#336699' height=25 width=15> </TD><TD
bgColor='#666666' width=500px>"
strMsgGetOWC+="<FONT face=Tahoma color=white size=4><B> "
strMsgGetOWC+="Data Access Page Notification</B></FONT></TD></TR><TR><TD
bgColor='#cccccc' width=15> </TD>"
strMsgGetOWC+="<TD bgColor='#cccccc' width='500px'><BR>"
strMsgGetOWC+="<p><font face='Tahoma' size='2'>This page requires the
Microsoft Office Web Components.</p>"
strMsgGetOWC+="</font><p><font face='Tahoma' size='2'>See the <a
HRef='http://office.microsoft.com/office/redirect/10/MSOWCPub.asp?&HelpLCID=1033'>Microsoft Office Web site</a> for more information. "
strMsgGetOWC+="</font></p><BR></TD></TR></TABLE>"
document.write(strMsgGetOWC)
}
}

</SCRIPT>
<!--[if gte mso 9]><xml>
<oocumentProperties>
<o:Author>acook</o:Author>
<o:LastAuthor>acook</o:LastAuthor>
<o:Revision>58</o:Revision>
<o:TotalTime>24</o:TotalTime>
<o:Created>2007-05-16T13:25:05Z</o:Created>
<o:LastSaved>2007-05-24T20:18:30Z</o:LastSaved>
<o:Company>Linear Technology</o:Company>
<o:Version>10.6830</o:Version>
</oocumentProperties>
<o:OfficeDocumentSettings>
<oownloadComponents/>
<o:LocationOfComponents HRef="file:///D:\"/>
</o:OfficeDocumentSettings>
</xml><![endif]--></HEAD>
<BODY style="OVERFLOW: auto" vLink=#800080 link=#0000ff>
<CENTER>
<H1 class="" id=HeadingText>Add Item</H1></CENTER>
<P> </P>
<DIV class=Mso2dSectionBanner id=HeaderItemsBanner
style="MARGIN-LEFT: 0px; WIDTH: 6.01in" tabIndex=-1><SPAN
id=HeaderItemsBannerCaption>Header: Items</SPAN></DIV>
<DIV class=Mso2dSection id=HeaderItems
style="VISIBILITY: hidden; MARGIN-LEFT: 0px; WIDTH: 6.01in; HEIGHT:
2.417in"><SPAN
class=MSTheme-Label id=ItemName_Label
style="LEFT: 0in; OVERFLOW: hidden; WIDTH: 66px; POSITION: absolute; TOP:
0.208in; HEIGHT: 15px">Item
Name:</SPAN><TEXTAREA class=MsoTextbox id=ItemName style="Z-INDEX: 2; LEFT:
1in; POSITION: absolute; TOP: 0.208in" tabIndex=16
MsoTextAlign="General"></TEXTAREA><SPAN
class=MSTheme-Label id=ItemType_Label
style="LEFT: 0in; OVERFLOW: hidden; WIDTH: 63px; POSITION: absolute; TOP:
0.417in; HEIGHT: 15px">Item
Type:</SPAN><TEXTAREA class=MsoTextbox id=ItemType style="Z-INDEX: 3; LEFT:
1in; POSITION: absolute; TOP: 0.417in" tabIndex=17
MsoTextAlign="General"></TEXTAREA><SPAN
class=MSTheme-Label id=Digikey#_Label
style="LEFT: 0in; OVERFLOW: hidden; WIDTH: 82px; POSITION: absolute; TOP:
0.625in; HEIGHT: 15px">Part
Number:</SPAN><TEXTAREA class=MsoTextbox id=Digikey# style="Z-INDEX: 4;
LEFT: 1in; POSITION: absolute; TOP: 0.625in" tabIndex=18
MsoTextAlign="General"></TEXTAREA><SPAN
class=MSTheme-Label id=Category_Label
style="LEFT: 0in; OVERFLOW: hidden; WIDTH: 59px; POSITION: absolute; TOP:
0.833in; HEIGHT: 15px">Category:</SPAN><SELECT
id=Category
style="Z-INDEX: 5; LEFT: 1in; WIDTH: 1in; POSITION: absolute; TOP: 0.833in;
HEIGHT: 0.197in"
tabIndex=19><OPTION selected></OPTION></SELECT><SPAN class=MSTheme-Label
id=Draw#_Label
style="LEFT: 0in; OVERFLOW: hidden; WIDTH: 47px; POSITION: absolute; TOP:
1.042in; HEIGHT: 15px">Draw#:</SPAN><TEXTAREA class=MsoTextbox id=Draw#
style="Z-INDEX: 6; LEFT: 1in; POSITION: absolute; TOP: 1.042in" tabIndex=20
MsoTextAlign="General"></TEXTAREA><SPAN
class=MSTheme-Label id=Supplier_Label
style="LEFT: 0in; OVERFLOW: hidden; WIDTH: 52px; POSITION: absolute; TOP:
1.25in; HEIGHT: 15px">Supplier:</SPAN><SELECT
id=Supplier
style="Z-INDEX: 7; LEFT: 1in; WIDTH: 1in; POSITION: absolute; TOP: 1.25in;
HEIGHT: 0.197in"
tabIndex=21><OPTION selected></OPTION></SELECT><BUTTON id=Command0
style="Z-INDEX: 9; LEFT: 5.167in; WIDTH: 0.833in; POSITION: absolute; TOP:
2.167in; HEIGHT: 0.24in"
tabIndex=23 MsoTextAlign="General">Save</BUTTON>
<SCRIPT language=javascript event=onclick for=Command0>
try { if (MSODSC.DataPages.Count > 0)
if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).Save();
else
MSODSC.CurrentSection.DataPage.Save(); }
catch (e)
{ alert (e.description);}
</SCRIPT>
<SPAN class=MSTheme-Label id=Description_Label
style="LEFT: 0in; OVERFLOW: hidden; WIDTH: 67px; POSITION: absolute; TOP:
1.458in; HEIGHT: 15px">Description:</SPAN><TEXTAREA class=MsoTextbox
id=Description style="Z-INDEX: 10; LEFT: 1in; WIDTH: 2.584in; POSITION:
absolute; TOP: 1.458in; HEIGHT: 0.197in" tabIndex=24 cols=22
MsoTextAlign="General"></TEXTAREA><SPAN
class=MSTheme-Label id=Label2
style="Z-INDEX: 11; LEFT: 3.708in; OVERFLOW: hidden; WIDTH: 1.54in;
POSITION: absolute; TOP: 1.438in; HEIGHT: 0.167in">As
it will appear on PO form</SPAN><SPAN class=MSTheme-Label id=Label3
style="Z-INDEX: 12; LEFT: 2.125in; OVERFLOW: hidden; WIDTH: 0.833in;
POSITION: absolute; TOP: 0.25in; HEIGHT: 0.167in">Value
e.g. 12K</SPAN><SPAN class=MSTheme-Label id=Label4
style="Z-INDEX: 13; LEFT: 2.125in; OVERFLOW: hidden; WIDTH: 1.448in;
POSITION: absolute; TOP: 0.458in; HEIGHT: 0.156in">size,
packaging e.g. 0603</SPAN><SPAN class=MSTheme-Label id=Label8
style="Z-INDEX: 14; LEFT: 3.708in; OVERFLOW: hidden; WIDTH: 2.156in;
POSITION: absolute; TOP: 1.604in; HEIGHT: 0.167in">usually
Item name+Item Type+Category</SPAN><BUTTON id=Command9
style="Z-INDEX: 15; LEFT: 5.167in; WIDTH: 0.842in; POSITION: absolute; TOP:
0in; HEIGHT: 0.24in"
tabIndex=25 MsoTextAlign="General">New</BUTTON>
<SCRIPT language=javascript event=onclick for=Command9>
try { if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).NewRecord();
else
MSODSC.CurrentSection.DataPage.NewRecord(); }
catch (e)
{ alert (e.description);}
</SCRIPT>
<SPAN class=MSTheme-Label id=Label0
style="Z-INDEX: 16; LEFT: 2.125in; OVERFLOW: hidden; WIDTH: 1.344in;
POSITION: absolute; TOP: 0.677in; HEIGHT: 0.156in">e.g.
Digikey #</SPAN><SPAN class=MSTheme-Label id=Label1
style="Z-INDEX: 17; LEFT: 3.708in; OVERFLOW: hidden; WIDTH: 1.604in;
POSITION: absolute; TOP: 1.792in; HEIGHT: 0.167in">e.g.
12K 0602 Resistor</SPAN><SPAN class=MSTheme-Label id=ItemID_Label
style="LEFT: 0.167in; OVERFLOW: hidden; WIDTH: 50px; POSITION: absolute;
TOP: 0in; HEIGHT: 15px">Item
ID:</SPAN><TEXTAREA class=MsoTextbox id=ItemID style="Z-INDEX: 18; LEFT:
1in; POSITION: absolute; TOP: 0in" tabIndex=26
MsoTextAlign="General"></TEXTAREA></DIV>
<P>
<P></P>
<P>Save and close when finished</P></BODY></HTML>


It seems to me that nothing of this sort is in the html code....but where is
it?