some one inform me that :
'Create child label control for text box.
Set ctlLabel = CreateControl(frm.Name, acLabel, , ctlText.Name, _
"NewLabel", intLabelX, intLabelY)
but i cant understated it
can you explain it
I HAVE DATASHEET AS SUBFORM .. I WANT TO CHANGE LABEL CAPTION ON OPEN EVENT
I USED THIS CODE :
ME.LABEL1.CAPTION="iTEM NAME"
BUT NOT WORKING
WHATS THE PROBLEM ?
THANKS
when i am trying to write vba code its automatically change font color to red and not accepted to complete the code also refuse to get any text property like :
me. not open the properties combo box .
how can i solve it
hi all
i have a treeview control on my form ( office 2010 32 bit ) with windows 10 32 bit and it working well on my laptop but ...
when i try to open the same form on anther PC which have also ( office 2010 32 bit ) but with windows 7 32 bit , the treeview control not appear completely ...
@arnelgp
THERE NOTHING CHANGE ITS THE SAME DB WITHLOUT ANY CHANGES
ALLOCATE QUANITITY EMPTY .. NO CODES
I WANT TO ALLOCATE 60 LIKE ( 50 + 10 ) IN ALLOCATE FILED
HI ALL
IF YOU PLEASE I WANT YOUR HELP TO COMPELET MY QUERY
I WANT TO ALLOCATE THE QUANTITYOUT FILED ON QUANTITYIN , I UNDERSTAND THE IDEA BUT ITS HARD FOR ME ..
FOE EXAMPLE:
ID Transactiondate Itemcode itemname QuantityIn QuantityOut AllocateQuantity
1 01/01/2000...
HOW CAN I MAKE FIFO STOCK IN MY CURRENT DB WSING QUERIES ?
I HAVE ALL DATA IN ONE FILED AND I WANT TO GET STOCK COST LIKE :
ITEM A 25 UNIT
10 WITH 10 $
10WITH 11 $
5 WITH 15 $
IF I SOLD 21 UNIT THE ACCESS CALCULATE ( 10*10 + 10*11 + 1*15 )
HOW CAN I DO IT ?
THANKS