Please help me

  • Thread starter Thread starter Kutty
  • Start date Start date
K

Kutty

How to create msaccess report of purchase order? Shall I do this form
in form and subform system? I think then only I will get the report's
purchase
item under form. Please tell me.
 
A purchase order report is much like an invoice report. A good place to start
designing is by reviewing the Invoice report in the Northwind sample MDB.

If you have some specific questions, come back.
 
I went to northwind sample database. There is invoice. That is enough for
me. I want to input datas whatever displays in the invoice report, and
because of this I want connected database of invoice form. Can I get it
separately from northwind sample database or shall I create separate one?
Please inform. Let me tell you in other word, tell me how can I copy this
invoice report and connected form for invoice to input datas for which I need
in report.
 
You can import objects into your MDB from other MDBs. You would need to
change at least the Record Sources and Control Sources to match your table
structures.

You might also need to change some code and other stuff in the imported
objects.
 
I have created one MDB named 111. Another one 222. I opened 111 to import
from 222. Not worked out. Once I go to 222 no data there. There is data
once I go to 222 's help. Please help me.
 
I have no idea what you have or what you are attempting to do. Can you
describe your expectations/specifications?
 
I need an invoice software or purchase order software. As per your
instruction I have tried to copy invoice from northwind database. But I
could not copy or I could not import. I dont know how to create from scratch
too. So repeatedly I am looking for a way to implement this database with
report. How can I do that? I hope you this is clear for you.
 
How far have you gotten? Do you have tables created?
Your question is way to broad. It's like you are asking us to design an
invoice system for you.
 
I have created a simple invoice data base as below :
Table1 : main form
INV_NO : auto number, primary key
DATA : date/time
CUSTOMER_NAME : text
CASH/CHECK : text

Table2 : sub form
INV_NO : number
LINE_NO : number
DESCRIPTION : TEXT
UNIT_PRICE : number
AMOUNT : number
I have hided INV_NO field in the subform.
I created one form with both table1 and table2 as main form and sub form.
I want auto number in LINE_NO field. In case I make this field as auto I
get new line number. But this number is getting depends on every invoice
number. Let me tell you this way for example: Once I input 3 records in
invoice 1 I get first line in invoice 2 as four. I don’t want this way. In
invoice 1 I need 1,2,3,4,5………so on as serial number. This way once I start
new invoice I need line number of description in 1,2,3,4,5…. so on. I hope
you got what I mean.
--------------------------------------------------------------------
 
Dear Duane,
I went to the site you suggested. But I could not find the specific place
to solve the problem. Please help me where is it. Would appreciate. I have
tried to solve this problem long time.
 
Back
Top