PC Review


Reply
Thread Tools Rate Thread

Continuous Form

 
 
Andy
Guest
Posts: n/a
 
      9th Dec 2003
Can anyone tell me how I go about using a continuous form.
I want to enter upto five entries in my database but have
them all relating to the same invoice number.
Thanks
Andy
 
Reply With Quote
 
 
 
 
Albert D. Kallal
Guest
Posts: n/a
 
      9th Dec 2003
You don't mention what version of ms-access you are using.

However, try creating a new database when you launch ms-access.

When you go file->new, you get two tabs, the 2nd tab usually has a bunch of
sample applications you can create/use.

In addition, there is a Northwind sample application on your office cd.
Hopefully, you installed it during your ms-access install. That application
has some invoice screens in it.


The idea here is to use a main form which is based on the invoice table. You
then create a one-to "many" relationship to display the invoice "details".
You then place a continues sub-form on the main invoice form. So, each
invoice has "many" details (in your case, you mention up to 5, but why make
any limit. If you design is correct, then it is no more work to have 2, or
20 entries for a give invoice.

As mentioned, get a copy of the Northwind database that came with ms-access,
as it has many sample screens, including some invoice ones. Also, check out
the database wizard (when you create a new database...try the 2nd tab called
"databases". There is some sample applications that invoice screens).

In addition, check out the following sample applications, again many have
sample invoice forms you can learn from.

http://search.officeupdate.microsoft...t.asp?qu=datab
ase


Continues forms are really what we use in ms-access to "replace" grids with.
Here is some sample screen shots of continues forms of mine:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
http://www.pcreview.co.uk/forums/(E-Mail Removed)
http://www.attcanada.net/~kallal.msn



 
Reply With Quote
 
 
 
 
andy
Guest
Posts: n/a
 
      9th Dec 2003
Thanks for the help.




>-----Original Message-----
>You don't mention what version of ms-access you are using.
>
>However, try creating a new database when you launch ms-

access.
>
>When you go file->new, you get two tabs, the 2nd tab

usually has a bunch of
>sample applications you can create/use.
>
>In addition, there is a Northwind sample application on

your office cd.
>Hopefully, you installed it during your ms-access

install. That application
>has some invoice screens in it.
>
>
>The idea here is to use a main form which is based on the

invoice table. You
>then create a one-to "many" relationship to display the

invoice "details".
>You then place a continues sub-form on the main invoice

form. So, each
>invoice has "many" details (in your case, you mention up

to 5, but why make
>any limit. If you design is correct, then it is no more

work to have 2, or
>20 entries for a give invoice.
>
>As mentioned, get a copy of the Northwind database that

came with ms-access,
>as it has many sample screens, including some invoice

ones. Also, check out
>the database wizard (when you create a new database...try

the 2nd tab called
>"databases". There is some sample applications that

invoice screens).
>
>In addition, check out the following sample applications,

again many have
>sample invoice forms you can learn from.
>
>http://search.officeupdate.microsoft...plateGallery/r

esult.asp?qu=datab
>ase
>
>
>Continues forms are really what we use in ms-access

to "replace" grids with.
>Here is some sample screen shots of continues forms of

mine:
>
>http://www.attcanada.net/~kallal.msn/Articles/Grid.htm
>
>--
>Albert D. Kallal (MVP)
>Edmonton, Alberta Canada
>(E-Mail Removed)
>http://www.attcanada.net/~kallal.msn
>
>
>
>.
>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Continuous form on continuous form jim Microsoft Access Form Coding 2 6th Feb 2010 11:55 AM
Selecting non-continuous records in a continuous form wvaughan Microsoft Access VBA Modules 2 3rd Jun 2008 12:29 PM
Continuous form in continuous form =?Utf-8?B?YnZkYWhs?= Microsoft Access Form Coding 10 29th Nov 2006 08:07 PM
Continuous subform per continuous form element capkrugers@gmail.com Microsoft Access Forms 0 19th Jul 2006 07:10 PM
Concatenate records or Continuous Form within a continuous form Greg Hill Microsoft Access Form Coding 0 5th Sep 2003 08:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:47 PM.