Invoicing Form Creation

  • Thread starter Thread starter Brook
  • Start date Start date
B

Brook

Hello All,

I am setting up a form to create invoices based on my
inventory table. Does anyone have any ideas or suggestions
on how to do this? I was wanting to use a subform which I
would choose my inventory item from then use a check box
or button to create my invoice. I am just getting started
so if anyone has any tips for me, please pass them along.

Brook
 
Brook said:
Hello All,

I am setting up a form to create invoices based on my
inventory table. Does anyone have any ideas or suggestions
on how to do this? I was wanting to use a subform which I
would choose my inventory item from then use a check box
or button to create my invoice. I am just getting started
so if anyone has any tips for me, please pass them along.
Click to expand...

The Northwind database has a lot of information on this.

A form and subforms is how most are done. The invoice is created at this
time but you would need a report to print it.,
 
Hi Brook,
I myself have created an invoicing system. The best method
will be to first create the forms & sub-forms and create a
report. The report should however be based on a query.
Since u would require automatic totals or even may want to
sometimes filter certain records.
I have even gone so far to the extent of making three
queries. For example query1 is based on the primary
information from the tables. query2 is based on query1 and
query3 is based on query2. Now what this helps me is to
get a very complex queries. For example if there are three
categories say c1, c2, c3 in my table and 5 status say s1
to s5. now if i wanted to list all the records between
1/4/04 to 31/4/4 that do not belong to c1 & c2 but have
the status of s1 or s4. this would be very complex (at
least i found it for myself) so having 3 queries helped
me. what i did was -
- in the first query i gave the criteria "category" <>c1
and c2
this filtered for the first criteria
- then in the second i gave the start & ending dates
- finally in the third i provided for the satus=s1 or s4
this solved my problem.
i hope u found this helpful & not confusing.
regards
manish
 
Thank you very much for the information,

But this is a little deaper than I need to be at this
point. I need assistance with the setup of the
form/subform to make sure I am updating my inventory table
correctly and to have the ability to create the report
based on both the form and subform...

Brook
 
Back
Top