this is my connection to my database

Public Sub conn()
Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\attendance.mdb;Persist Security...

help please, how to save a data between the time of what user input in the 2 textbox. 1 textbox is for intime and the 2 one is out time.

for example if the user input

7:30 - 9:30 Am Intime
...

i have no MSDN intstall to my computer sir :(

how?

hi to all my fellow programmers,

i'm creating now an attendance system. how to create a count down timer that will minus in the system time? it is possible and how? i have a 3 textbox 1 is for the...

all i want is change all the record in my table if the pcarrier="Credit" but my problem is only one data have been changes. .


Set rs = New ADODB.Recordset
rs.Open "Select * from Soldto where...

i have error to my code in the bold word!


Set rs = New ADODB.Recordset
Set rs1 = New ADODB.Recordset
Set rs2 = New ADODB.Recordset
rs.Open "Select * from temp where pcode='" & txtEdit.Text &...

hi thanks for your code but i have a problem


Set rs = New ADODB.Recordset
rs.Open "Select * from temp", cn, adOpenKeyset, adLockPessimistic
If Val(rs!quantity) = Null Then
calcel = False...

it is possible? if the user in the running time, click the close button or the X button that we can see in the top of the form and then if the user click the close or X button message box will appear...

im using adodb connection. . please help how can i load the data save to my table in database name SUPPLIER in mshflexgrid using textmatrix? thanks. . more power for daniweb.

can u post the code sir? so i can know. . thanks

i have an error

Operation is not allowed when the object is closed?

how can i save a data in listview1? i have a problem to my code heres my code



Dim objNewListItem As ListItem
Set rs = New ADODB.Recordset
rs.Open "Select * from Supplier", cn, adOpenKeyset,...

just use datagrid1.textmatrix. .

how sir?

sir comatose i have a problem how can i delete the camma? and the period in middle name?

how can i get the first name, the middle name and the last name in my textbox?

what i mean is i have 1 textbox to input his full name the format is this

sample:

Nash, Steve B.

then i have...

it is possible? may i know the code please?

label1.caption = date

im using textmatrix in my mshflexgrid my problem everytime e delete all the record the table did not update. .

please help. .

how can i update my table please help. .



MSHFlexGrid1.Clear
MSHFlexGrid1.Rows = 2
MSHFlexGrid1.FormatString = "|Product Description | Unit | Price Per Unit | Quantity"
Set...

help how can i know if the user is not an admin

i have combo box, in my combo box have a user or admin additem, if he choose admin then all i want is to validate if the username and password is...

help how can i know if the user is not an admin

i have combo box in my combo box have a user or admin additem if he choose admin then all i want is to validate if the username and password is for...

no all i want is this, if what is the record in my table 1 if i click my command button visual basic then the record of my table1 must save to table 2

access please i want to know the code. .

hi can anyone help me i have a billing system, how can i save the data to another table? using sql? may 1 table name is transac and all i want is if what the record have been save to my transac then...

its created problem because they have the same entity

sql = "INSERT INTO DayWiseRoster (id) select UserOFTheMonth (id) where emp_id='" & txtempid.text & " ' "

id
id

try to change that. .

if your using adodb try this

set rs as new adodb.recordset
rs.open "Select * from table1 where emp_id='" & textid.text & "'", cn, 3, 3
if rs.recourdcount > 0 then
rs.open "insert into table1 ...

same error

this is my error

mobjCmd.CommandText = strSQL

hope you can help me :(

i cant load my data in listview


this is my code

Private Sub LoadCustomerListView()
Dim strSQL As String
Dim objCurrLI As ListItem

strSQL = "Select Lastname" _

hi i have a problem puting a column header to my listview did not affair to my listview


here's my code


Private mobjConn As ADODB.Connection
Private mobjCmd ...

please help me all i want is simple if what i inputted to my 2 textbox for example i input 08:30 the timer of my system could change and i want a running time can i anyone help me?

hi can anyone help me? how can i convert to time if i inputted 2400 it should 12:00 then a running a time?

for example i have 1 textbox

if i input 2300

it should 11:00

how can i do this...

all i want is if the value of my product stock is 0 then the message box show for example theres no more product stock and also i want is if the user inputted higher value in my text2.text for...

can u elaborate that? in step by step? because i have no idea in networking :) i want it to learn

how can i send the 1 form in to another PC? because i have POS or point of sales system? is there anyway to send my 1 form to another pc? how?

try this

"Select DISTINCT req_no, emp_name, job_no, mr_date from NAME OF THE TABLE"

everytime i click my command button may mshflexgrid did not update :(

here's my code

If Text1.Text = "" Then
MsgBox "Please Input the Product Code", vbInformation
Text1.SetFocus
Exit Sub...

comatose the answer dont have a decimal .00 its only 2 it should 2.00

hi comatose i have 2 textbox 1 is text3 and the second is text4 and i have also 1 label in may label1 the caption is "00.00" all i want is everytime i click my command button for example if i input...