Re: Still I need to know how

Tech-Archive recommends: Fix windows errors by optimizing your registry

That's great, it looks like you have successfully added a Counter control
Do you mean that you only want to see 1 invoice at a time or that you want
to see each invoice on a different page?
If you just mean that you don't want to see the word Description then click
on that control in the report's Design view and delete it.
Evi

"ak" <akuttym@xxxxxxxxxxx> wrote in message
news:4FF9EE8D-962B-4618-AE9E-5F06717C9CA9@xxxxxxxxxxxxxxxx
I have done as you told me. Let me tell you how my report can see now.
I dont want three invoices's description as below.

INV_NO : 1 Date:10/2/2008
TO : ABC COMPANY
_______________________
S# DESCRIPTION
--------------------------------

1 CUTTER 10.00
2 PENCIL 5.00
3 PEN 2.00


1 PAPER CLIP 4.00
2 RUBBER 3.00
3 STAPLER 8.00
4 PIN 6.00


1 PENCIL 2.00

Evi" wrote:

I see the problem. The word Control means (partly) anything that you put
in
a report or a form in Design view - lines, fields, text boxes, labels,
check
boxes etc.
Am I right? You have put in a text box called Line_No?
*This should not be a field in your Query*, just a text box which you
drew
there.
When you first put the text box in your report, it will have the word
(Unbound) written in it.
Type
=1
in it.
(this is the same as typing =1 in the Control Source)
When the Properties box is open, click on the tab that says Data.
One of the lines there will be labelled Control Source.
It should have =1 typed next to it.
Just below that in the Properties box is a line labelled
Running Sum

Click in that and you will see a down-arrow. Here you can choose Over
Group.

There is an example of one of these Running Sum controls in the Detail
section of the Sales By Year report in North Wind

Now, as for the Northwind Invoice report, this doesn't have line numbers
in
it. The field that looks like Line Numbers is a field in the table
called
Product ID. You will see that if (on a copy of Northwind) you delete one
of
the products, there will now be a gap in the Line numbers - they won't
be
consecutive (1, 2, 3, 4 etc) but may say something like 2, 4, 7 etc.



Please ask if any of this is unclear.

Evi.






"ak" <akuttym@xxxxxxxxxxx> wrote in message
news:22DE91CD-BF69-4DB9-AFC4-8B065DBD2921@xxxxxxxxxxxxxxxx
I need line number in detail section. I cant see control source
there. In
details section I have a field called "LINE_NO" . In this field I
right
clicked to go to properties. I could not see control source there.
Where
can I go ?

"Evi" wrote:

If you look back you will see that Alan and I and others have done
our
best
to answer your questions and each string of messages has ended with
you
NOT
replying to say which bits of our messages you don't understand.
I will quote the reply I gave earlier to this same question. Please
be
kind
enough to read it and then tell me which bit of my reply you don't
understand.
How to create Line Numbers:

Put a text box in the section where you want the line numbers to go.
Type
=1
next to Control Source in the Properties box
In the Properties box, choose Over Group next to Running Sum.
Does this give you the results you want?


It is not reasonable to expect anyone to spend the time to write a
long,
detailed explanation in a newsgroup when you haven't asked a
specific
question. There are many Internet Sites (and even books which you
can
buy)
which give details of Access for beginners. You only need to use
Google
to
find them.
But the newsgroups are there to answer specific questions.
For instance, if you didn't understand how to use the sorting and
grouping
box, or what the Properties box is, it would not be reasonable to
expect
anyone to spend the time writing a detailed explanation because you
can't be
bothered to ask the question.
However, few of us will begrudge giving you this explanation if you
just
say
that you don't understand that.
I do understand that it must be very difficult to ask questions in a
non-native language but please persevere.
Read our replies. Quote the bit you don't understand and we will do
our
best
to clarify it.
Evi


"ak" <akuttym@xxxxxxxxxxx> wrote in message
news:EAEEDDF4-07C6-4A0A-A9CC-217D97B83851@xxxxxxxxxxxxxxxx
Please help me to know how can I find out that northwind invoice
creation.
Specifically how that line number is coming in the invoice. Why
that
is
not
main
form and sub form. If it is not main form and sub form how come
change
its
invoice number for each invoice. How to arrange this? I need a
very
clear
and detailed explanation from you please. I am struggling for
this
for
long
time.
Nobody is educating me proper way.









.

Relevant Pages

  • Re: Get information to a form from another table
    ... okay, first of all, the Invoiced field in table Invoice is a Lookup field. ... field in a form, then create the control *at the form level*, don't set it ... you need to change the name of the checkbox control in the OrderEntry ... "tina" wrote: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Auto Number
    ... If you want to have "invoice numbers" that you can control, ... The Autonumber datatype exists for the sole purpose of generating ... Create a query with the newly created table as the source ...
    (microsoft.public.access.gettingstarted)
  • Re: Access 2002 CustomerInfoID Field
    ... If the DLookup returned an InvoiceNo like 1742, ... Candia Computer Consulting ... similar expression as the control source in the Customer ID Field. ... the Invoice Number is in fact a custom counter - you want it to ...
    (microsoft.public.access.forms)
  • Re: Get information to a form from another table
    ... All I'm showing is a greyed out checkbox. ... I placed your code in the control source for the checkbox named Invoiced on ... information from the invoice table because the order entry dept just needs to ... Invoiced field in the Invoice table. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Adding data in continuous subform
    ... what do you have for Control Source? ... forms, each bound to its table (invoice: PK is invoice number, and invoice ... the screen, the line I'd been entering now has a blank record selector, ... If I then click in the first record, ...
    (microsoft.public.access.formscoding)