informerFR
Last Activity: Feb 5 '20, 10:07 AM
Joined: Jun 6 '16
Location:
-
Thanks a lot for your great tricky solution Phil. You made my day ! -
I RonnyGilisen,
you write- lowest value in Total-Field
- lowest value in faults-field
- lowest value in refus-Field
- lowest value in TimeFlt-field
- lowest value in Time-field
But considering just a table with 3 fields
- Nbr
- Total-Field
- faults-field
Let's imagine two rows
1 - 10 - 15
2 - 8 - 25
what are the rules to sort them?Leave a comment:
-
Hi andrualex09
Very easy :
In your combobox property select format tab- In comumn number set up : 2
- In column column width : 0cm;2cm --> 0 if you don't want display the PK and cm if your metric setting is in centimeter
Then select data tab- Control source :
- Row source type : table/query
- Row source: Query name or directly SQL request
You can see this tuto hereLeave a comment:
-
Hi 5236
If you declare an auto number field on a table, this field increments itself automatically when you add a record on this table. Nothing to do.Leave a comment:
-
Thanks for your very precious help PhilOfWalton.
with your code, I build my report as I want
Once again thanks a lotLeave a comment:
-
PhilOfWalton,
I need to get invisible the page footer on last page of a report, but I don't know how to proceed, an idea?
Thanks by advanceLeave a comment:
-
Hi PhilOfWalton
Thanks for your answer. I find an other way by using textbox cumul property as follow
- In detail area
- A textBox named txtAmount with Control source = amount, bound field with report.source = Table/requery...
- CumulAmount text box named txtCumulAmount with properties as follows
- Hidden field
- ControlSource = txtAmount
- Cumul = Continue
- In Page footer
- A field with ControlSource = txtCumulAmount with
Leave a comment:
- In detail area
-
Hi mshakeelattari
Don't forget to compile your VBA code (go to VBA editor -> debugging -> compile) before creating an accde db.Leave a comment:
-
How to Display Intermediate Cumulative Sum By Page Footer
Hi,
On a report, how to display
- Intermediate cumulative sums by page footer, that is, on
- Page 1, sum of displayed records ,
- page 2, sum of displayed records + Page 1 records ,
- And so on
Thanks for your help - Intermediate cumulative sums by page footer, that is, on
-
Hi jforbes
Thanks for your answer.
I read that all registry API retrun long value so My problem is solvedLeave a comment:
-
Hi PhilOfWalton,
Thanks for your answer.
My post is about DLLs which depend on windows environment not Access.Leave a comment:
-
Declaring API functions in 32 or 64 bits
Hi
My Access project must run on 32 bits & 64 bits and uses registry API. So I turned to How To Use the Registry API to Save and Retrieve Setting for inspiration. And for typing my variables considering the environment, I use DefType command.
My code in a module is as follows:
...Code:#If Win64 Then DefLngPtr Z #Else DefLng Z #End If -
I changed my post and you're right, Giving credit where credit is due
one must give to Caesar what is Caesar's'.Leave a comment:
-
Hi Mshmyob
Thanks a lot for this information. You make my day and now it works perfectlyLeave a comment:
No activity results to display
Leave a comment: