Page Design Questions

[Adam]

I'm having some trouble getting a Page to work the way I want it to in
Access 2003. I'm trying to do some simple internal tracking at my
office for a specific item that we sell. Each item has a serial
number, so I created two tables. Here's the structure:

Table Name: T_ITEM
Primary Key: SERIAL_NUMBER
Other fileds: CLIENT_ID, DEPLOY_DATE, COMMENTS
Table Name: T_CLIENT_LIST
Primary Key: CLIENT_ID
Other fields: CLIENT_NAME
The CLIENT_ID fields are linked with a one-to-many relationship with
enforced integrity.
I'm fairly inexperienced in Access, so the controls on the pages I've
generated aren't working together :( Here's what I'm trying to
accomplish:
I would like a page that has a drop-down box from which you would pick
a serial number, and the relevant information (client name, deployment
date, comments) would appear in non-editable text boxes below.
I would also like to create a second page that has a drop-down list
containing all the client names, and directly below that a list box
that would populate with every item that had been sold to this, and
when you select an item in the list-box I would like the deployment
date and comments to appear in fields below that.
Since I will be hosting this on a web-acessible server, I only want
people to be able to view these pages and all the data, without being
able to edit records or create new ones.
Sounds pretty simple, but I have to admit I'm just not that good yet
:-P
(Thanks in advance for any help! I can provide the .mdb for reference)

[ManningFan]

You'll want to do that in ASP to make it web-accessible, which is a
whole nother bird.

Adam wrote:

I'm having some trouble getting a Page to work the way I want it to in
Access 2003. I'm trying to do some simple internal tracking at my
office for a specific item that we sell. Each item has a serial
number, so I created two tables. Here's the structure:

Table Name: T_ITEM
Primary Key: SERIAL_NUMBER
Other fileds: CLIENT_ID, DEPLOY_DATE, COMMENTS
Table Name: T_CLIENT_LIST
Primary Key: CLIENT_ID
Other fields: CLIENT_NAME
The CLIENT_ID fields are linked with a one-to-many relationship with
enforced integrity.
I'm fairly inexperienced in Access, so the controls on the pages I've
generated aren't working together :( Here's what I'm trying to
accomplish:
I would like a page that has a drop-down box from which you would pick
a serial number, and the relevant information (client name, deployment
date, comments) would appear in non-editable text boxes below.
I would also like to create a second page that has a drop-down list
containing all the client names, and directly below that a list box
that would populate with every item that had been sold to this, and
when you select an item in the list-box I would like the deployment
date and comments to appear in fields below that.
Since I will be hosting this on a web-acessible server, I only want
people to be able to view these pages and all the data, without being
able to edit records or create new ones.
Sounds pretty simple, but I have to admit I'm just not that good yet
:-P
(Thanks in advance for any help! I can provide the .mdb for reference)

[Adam]

Well since Access 2003 supports creating HTML pages, I'm planning on
just sticking to that, as it will only be accessed from within the LAN
anyway.

ManningFan wrote:

You'll want to do that in ASP to make it web-accessible, which is a
whole nother bird.

Adam wrote:

I'm having some trouble getting a Page to work the way I want it to in
Access 2003. I'm trying to do some simple internal tracking at my
office for a specific item that we sell. Each item has a serial
number, so I created two tables. Here's the structure:

Table Name: T_ITEM
Primary Key: SERIAL_NUMBER
Other fileds: CLIENT_ID, DEPLOY_DATE, COMMENTS
Table Name: T_CLIENT_LIST
Primary Key: CLIENT_ID
Other fields: CLIENT_NAME
The CLIENT_ID fields are linked with a one-to-many relationship with
enforced integrity.
I'm fairly inexperienced in Access, so the controls on the pages I've
generated aren't working together :( Here's what I'm trying to
accomplish:
I would like a page that has a drop-down box from which you would pick
a serial number, and the relevant information (client name, deployment
date, comments) would appear in non-editable text boxes below.
I would also like to create a second page that has a drop-down list
containing all the client names, and directly below that a list box
that would populate with every item that had been sold to this, and
when you select an item in the list-box I would like the deployment
date and comments to appear in fields below that.
Since I will be hosting this on a web-acessible server, I only want
people to be able to view these pages and all the data, without being
able to edit records or create new ones.
Sounds pretty simple, but I have to admit I'm just not that good yet
:-P
(Thanks in advance for any help! I can provide the .mdb for reference)

[Larry Linson]

"Adam" wrote

Well since Access 2003 supports creating
HTML pages, I'm planning on just sticking
to that, as it will only be accessed from
within the LAN anyway.

Plan, too, on keeping Access 2003 around, because Data Access Pages are
"deprecated" in Access 2007, and Access 2007 will not allow you to create
nor maintain them, though execution continues to be supported. And, I
wouldn't expect a lot of "fixes" for any of DAPs limitations or bugs.

If you can justify learning ASP.NET to accomplish your project, that will be
an ongoing benefit to you. If you do it in DAPs, it's obsolescent, soon to
be obsolete, technology.

Larry Linson
Microsoft Access MVP