If The Target Table And Destination Table Are Having Same Structucet Then Use Simple Query
Insert Into <Target Table> Select * From <Destination Table>
User Profile
Collapse
-
u;ll find some code here for ur requirenemt
http://www.planet-source-code.com/vb/default.asp?lng CId=70823&lngWI d=1
but as debasisdas said... u must have to do something your self..Leave a comment:
-
May Be You Can Not Add Form in Tab Control But You Can Trt A Tab Control and Put Your All Form's Control In Tabular FormatLeave a comment:
-
In Your Select Statemant I Foud There is No Space Between Concating The String So, May U Get Error
source = "SELECT TBLGapApprovedC osts.* " & _
" From TBLGapApprovedC osts " & _
" Where TBLGapApprovedC osts.Applicatio n_Number= '" & Number & "'"
may be it'll workLeave a comment:
-
Make Clear1 Procedure
Public Sub Clear1()
Dim Otext As Object
For Each Otext In Me.Controls
If Typeof Otext Is TextBox Then Otext.Text=""
Next
End SUB
You Can Use This Procedure Whenever You Want Clear All Textbox In The Active FormLeave a comment:
No activity results to display
Show More
Leave a comment: