Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.
All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!
mga sir, pno po gwing landscape ung Data Report?![]()
@ kuya eric : ya may mga pdf ka sa VB? yung bago..
tirahin mo sa printer yan, wala sa datareport
sa code pwede mo gawin yun na oset ang defualt printer to landscape
ang kulit..kailangan idivide pero di kailangan gumamit ng division operator..hehehe..
anyway try mo toh.
Dim var1 As Integer
Dim va2 As Integer
Dim ans As Integer
var1 = Text1.Text
var2 = Text2.Text
ans = 0
Do Until var2 > var1
var1 = var1 - var2
ans = ans + 1
Loop
Text3.Text = ans
kuya eric may ask po ako panu po gawin yung 2nd hand mouse pointer sa hand icon by vb6....
hindi yung nag papalit po ng kulay ah...
yung 2nd hand mouse pointer po nag papalit xa...
thank poh sa idea ..pwede n poh yan ..hehe![]()
Dim var1 As Integer
Dim va2 As Integer
Dim ans As Integer
var1 = Text1.Text
var2 = Text2.Text
Code:Dim var1 As Integer Dim va2 As Integer Dim ans As Integer var1 = Text1.Text var2 = Text2.Text
meron ka dapat code to check for PROPER data type bago mag assign
what if ang nsa TEXTBOX1.TEXT = "001NT"?
for sure TYPE MISMATCH NA YAN
check first if its integer before performing math operations
yan ang sign ng robustness at flexibility sa code ng isang programmer
Private Sub cmdAdd_Click()
clearform
MasterAction = "ADD"
resetFormControl True, vbWhite
blnchangemade = False
If empdeptrs.RecordCount > 0 Then
empbookmark = empdeptrs.Bookmark
End If
'Generate_no
Dim rsdb As Recordset
Set rsdb = employeedb.OpenRecordset("Select max(auid) as cntr from empPosition", dbOpenSnapshot)
' Set rsdb = employeedb.OpenRecordset("Select Max(" & strY & ") from " & strX & "")
If rsdb.RecordCount > 0 Then
rsdb.MoveLast
' Me.lbltry.Caption = rsdb!cntr + 1
Me.Text1 = rsdb!cntr + 1
'Me.Text1 = 1
' Else
' Me.Text1 = 1
End If
empdeptrs.AddNew
Text1.Enabled = True
Text2.Enabled = True
Text3.Enabled = True
Text2.SetFocus
OktoExit = False
End Sub
============================
May TAO po ba dito???
pede mag pa tulong...
ask ko lang po kung paano po kumuha ng maxID i mean na max ID
HAL: I add record 1 - 10 then i delete record #9 then the #9 record will be automatically available.
dapat wen i click the ADD button instead of 11 ang lalabas sa textbox. mag kakaroon ng message box "OPTION" asking for the number that is not yet avail...
may makaktulong po ba?
sorry naman idol..hehehe..clue nung logic lang naman ang binigay ko sa kanya eh..problema na nya ung mga error..para matuto..![]()
Dim num1 as integer
Dim rs as new adodb.recordset
rs.open "SELECT fieldname FROM tablename ORDER by fieldname ASC",dbConname,adOpenStatic,adLockOptimistic
If rs.RecordCount > 0 Then
num1 = 1
Do Until rs.EOF
If num1 <> Val(rs!ID) Then
If MsgBox(num1 & "is not yet used. Do you want to uset it?", vbYesNo + vbQuestion) = vbYes Then
textboxName.Text = num1
End If
Exit Do
End If
num1 = num1 + 1
rs.MoveNext
Loop
End If
e2 idea ko...=)
SIR may naka attach akong picture kasi hindi ko ma display yung name na nakalagay at yung address at nationality eh gusto ko sana ma display yun gumawa ako ng tatlong label box para dun sya madisplay di ko alam codes pwedeng pagawa naman nun?tapos pag aralan nalang po
[FONT="Lucida Console"]Label1.Label = TextboxName.Text
Label2.Label = TextboxAddress.Text
Label3.Label = TextboxNationality.Text[/FONT]
[FONT="Lucida Console"]
ButtonDisplay_Click
' This block
' Put your desired action after triggering button click event here
' This is a Sub Routine
End Sub[/FONT]
Code:[FONT="Lucida Console"]Label1.Label = TextboxName.Text Label2.Label = TextboxAddress.Text Label3.Label = TextboxNationality.Text[/FONT]
Ganito po ba? Ayon po sa detalyeng ibinigay nyo.
Kung gusto mong madisplay yung data on button click, let's say button namely ButtonDisplay, proceed to:
Code:[FONT="Lucida Console"] ButtonDisplay_Click ' This block ' Put your desired action after triggering button click event here ' This is a Sub Routine End Sub[/FONT]
Kuya pasensya na po kasi di ko talaga magawa eh eto po yung mga ginamit ko. frame , label para dun sa name, address, nationality tapos po text box dun sa 2nd frame naglagay me ng 3 label para dun lumabas yung na input ko sa text box tapos naglagay me ng tatlong command button cmdDisplay, cmdClear at cmdExit dapat po pag pinindot ko yung display lalabas dun yung nainput kong name or address sa label pag naman po pinindot ko yung clear dapat po mabura sya sa tatlong label sorry po kung magulosalamat po sa reply..
imagine kung gaano kabilis yan kung meron kang 1million records