strongm, work perfect...
But the user can see the price by date to date, and the related period example:
admit have "25/08/2024" to "07/09/2024"
price from 25/08/2024 to 31/08/2024 a price for SINGOLA
price from 01/09/2024 to 07/09/2024 a price for SINGOLA
possible?
note:
in this case the...
for strongm
You have understand my question!
Yes my database is Access
For now use only a STRUTTURA=MARE
Yes,
possible date from for example:
myvarfrom=07/06/2024 myvarto=14/11/2024
...yea, now i see your face:)
this table contain a price list of room.
DAL and AL is the period (from>to) PREZZO is the price
Based myvarfrom="05/06/2024 and myvarto="15/06/2024" and myvaroom="SINGOLA" how to calculate the price of the living room
note:
Naturally myvarfrom and myvarto and myvaroom is dinamic
Private Sub MSFlexGrid1_Click()
Dim I As Integer
With MSFlexGrid1
If .Col = 0 Then
If .CellPicture = picChecked Then
Set .CellPicture = picUnchecked
'.TextMatrix(.Row, 34) = "S"
Else
Set...
My code:
Private Sub CONTA_COMUNI()
Dim MYNODE As Node
Dim NRTOT As Long
VALORE = "004017"
NRTOT = 0
For Each MYNODE In Me.TreeView1.nodes
If MYNODE.children = 0 Then
NRTOT = NRTOT + 1
ISTAT = Split(MYNODE, "-")(0)...
possible when i lick on a node to dont set focus the node?
actually when i click on node the node is covered with a blue rectangle, i dont love tath...
https://files.engineering.com/getfile.aspx?folder=9cc39e69-fce6-4dde-b28f-d988e8205f12&file=Immagine.gif
part of code when add the frist node:
...
With Me.TreeView1
'LockWindowUpdate .hwnd
M = 0
.LineStyle = tvwRootLines
Set Me.TreeView1.ImageList = Me.ImageList1
.Style = tvwTreelinesPlusMinusText
.nodes.Clear
Set NOD =...
Based a click on each node with a splitted value "-" of node i need to get the left part of node...(i think is a (0) item of splitted value)
for example click on 1-NORD-OVEST i need 1
for example click on 1-PIEMONTE i need 1
for example click on AL-ALESSANDRIA i need AL
...
for example click on...
i create an array with:
'PR_ISTAT
SQL = "SELECT PR, PROVINCIA, COUNT(ISTATEXT) AS NUM FROM (SELECT DISTINCT PR, PROVINCIA, ISTATEXT FROM COMUNI_ISTAT) GROUP BY PR, PROVINCIA"
Set RST = New ADODB.Recordset
RST.CursorLocation = adUseClient
RST.Open SQL, CON, adOpenForwardOnly...
i have a series of shape, similar shp(0), shp(1)... shp(N) on label 1.
Possible to check with mouse move on restricted area of label1 the color of shape and the index of single shape shp(n)?
note:
i can have only tree color:
'VERDE &H0000C000&
'ARANCIONE &H000080FF&
'ROSSO &H000000FF&...
Hi strong,
if you see in the form(chart.zip) are present 30 shape.
Is possible via code to create instead the current 30 shapes a dinamic number of shape for example 47 shapes, started for the shape array(0)?
peraph is your first your help for me... (bho)
three question...
-1 in my case the current project have a fixed 30 shape, in my access the fields are 74... how to create dinamiclly the shape element
-2 in my case i can have a negative number in PERC, in this case the shape it must go below and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.