Hi all,

I am currently working to create a page that insert data into my database
(the 
database is located in a remote server), this page is like the data access 
page in Microsoft Access where when view on the web, you see all the 
records in that table and you could add, update, or delete the records in 
that table. But the question I am having here is: I have a table name 
Products, and it has a relationship a table named Product Availability, 
when you expand one of the records in the Products table, from there you 
could enter info into the Product Availability table, that some of the 
related info from the Products table will cascade into the Product 
Availablility table. Is there any why to create a page/form that would let 
me enter data into the database just like the way I would in the data 
sheet view?

Thanks in advance!

<< Is there any why to create a page/form that would let me enter data 
into the database just like the way I would in the data sheet view? >>

Create a main form (single form) and make the Products table its control 
source.  Put a subform (Product Availability is the control source) in the 
main form and make the subform appear in datasheet view.  Tie the 
master/child fields of the main form and subform together.

Greg

Thanks Greg for the reply! But I still have a question in mind: after I
created the form/subform, is there any way I could put it on the web so
that I could use it to access my Database on my ISP's server?

Please advice.

Thanks in advance.

-----Original Message-----
From: Gregory Serrano [mailto:SerranoG@m...] 
Sent: Tuesday, January 28, 2003 1:08 PM
To: Access
Subject: [access] Re: Forms & Access

<< Is there any why to create a page/form that would let me enter data 
into the database just like the way I would in the data sheet view? >>

Create a main form (single form) and make the Products table its control

source.  Put a subform (Product Availability is the control source) in
the 
main form and make the subform appear in datasheet view.  Tie the 
master/child fields of the main form and subform together.

Greg

<< after I created the form/subform, is there any way I could put it on 
the web so that I could use it to access my Database on my ISP's server? >>

Access XP will let you create a data access page on the web, but I've 
never used this feature.  Using something like Microsoft FrontPage will 
also put your dB on the web.  I'm sure there are other preferred methods 
out there.  It's not an area I've dealth much with.  Can anyone else out 
there shed some light on the subject?

Greg

I've used an earlier version of Access (2000) to create access data pages & 
it worked very well. I have not seen the tool to convert an existing form (I 
had to create mine new in HTML). I found however that when I created the 
HTML, I needed to use JavaScript (or VBScript) to create some of the 
functionality I had in the original form. I do not know if the conversion 
tool will do this properly or not.






>From: "Gregory Serrano" <SerranoG@m...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] Re: Forms & Access
>Date: Tue, 28 Jan 2003 17:46:48
>
><< after I created the form/subform, is there any way I could put it on
>the web so that I could use it to access my Database on my ISP's server? >>
>
>Access XP will let you create a data access page on the web, but I've
>never used this feature.  Using something like Microsoft FrontPage will
>also put your dB on the web.  I'm sure there are other preferred methods
>out there.  It's not an area I've dealth much with.  Can anyone else out
>there shed some light on the subject?
>
>Greg


_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail