two text box use in form
aa.......bound text
bb......unbound text
if data enter in bb not show in aa i use vba code but not work
code
Private Sub bb_AfterUpdate()
Me.aa.value = Me.bb.value
Me.Refresh
End Sub
code
give some tips
file attach
my table
aa.......number
form1
value---unbound
aa------bound
code
Private Sub value_AfterUpdate()
aa = value
Me.Refresh
End Sub
code
in form use unbound and bound when enter data in unbound no diaplay in boundo bject
give some tips
file attach
this part not work proper------
complete code give you guide me
-------------------------------------------------------------------------
ElseIf aa > bb Then
Ram.BackColor = 10092543
MsgBox "Please !!!Check your Amount Again !!!!"
DoCmd.GoToControl "ram"...
table data
id_no
p_name
q_work
i use a continuous form and insert data in table easily but i use unbound text in continuous form it is not work
need insert data in table unbound text in use continuous form
i type this code
Private Sub Command2_Click()
DoCmd.SetWarnings False
DoCmd.OpenQuery "query1", acViewNormal
Me.b1.Visible = True
Me.b2.Visible = True
DoEvents
End Sub
you see this link in video
http://www.datapigtechnologies.com/f...ogressbar.html
some errors in your code
no result...
this is a link
http://www.datapigtechnologies.com/flashfiles/progressbar.html
i make file from this link but but not work it
expert person guide for this tutorial
in form use two rows
counter and p_name as unbound text
need help for run counter auto sequence and save button press record save and next counter no display
see my code in file
sample file attach
i check your link and file work best but
i change some thing in file and need use as unbound counter in form
and counter run auto to next record
guide for me
Data of table
Lot_no............Product
01.......................aa
02.......................bb
for example delete lot_no 02
Lot_no............Product
01.......................aa
i need when insert new data in form lot_no runing auto serial
lot_no start is 02
give some tips file attach
Table1 data
ID_No(AUTO NMBER)
01
02
03
04
IF I AM DELETE ID_NO 03 & 04
AUTO NUMBER START 05 AND MY DATA SHOW IN THIS STYLE
AND ALL DATA DISTURB
Table1 data
ID_No(AUTO NMBER)
01
02
05
06
NEED ID_NO SERIAL WISE NO ANY DISTURB IF I DELETE ANY
RECORD
table data
Ename=Melsi
Payrate=100
I Update Ename Melsei to Carl in update query and result it
Ename= Carl
Payrate=100
but i update other data wrongly change Ename is Johan to Carl for example orignal data
Ename=Johan
Payrate=100
update data
Ename= Carl
Payrate=100
i need tip to update...