i tried it already but nothing happen
this my code before
DB as adodb.connection ' mysql connection
OP as adodb.connection 'access connection

insert into OP.myaccesstable from DB.mysqltable
...

@AndreRet
i have 2 identical table 1 in mysql and 1 in access. i just want to insert all the data from access to mysql. let say the name of table of in mysql is MySQLTABLE1 and the name of table in...

Hello guys,

i been searching this for a month still cannot find anything.
is there any way to copy mysql table to ms access?


Best Regards

Hello guys

hello rajesh,
can you please give me a copy of developer key, it would be very helpful to me.
thanks regards

sample i have a table consisting the following data
ID TIME
1 08:00
2 09:00
3 11:00
4 14:00
5 15:00

when i query from this table, i want to find the nearest...

try this
dim rs as new adodb.recordset

rs.CursorLocation = adUseClient
rs.open "Select * from table",conn
msgbox rs.recordcount
set rs=nothing

hello guys,
how can i select from table with a given time then select the nearest time available
sample select * from mytable where Time=10:00, i want to get the nearest time
ID | Time
1 ...

hello Venna,
rs_Wtax.CursorLocation = adUseClient
rs_Wtax.Open "Select * from tblWTax where Code='" & "HF" & "'", conn
If rs_Wtax.RecordCount > 0 Then
MyQty = rs_Wtax(1)
...

Code Range1 Range2 Range3 Range4 Range5 Range6
A $0.00 $10.42 $52.08 $177.08 $468.75 $1,041.67
B $0.05 $0.10 $0.15 $0.20 ...

Hello Venna,
i'm using mysql, Select Format(sum(Late,'hh:mm') From tbltimecard
error in 'hh:mm'
Regards

hello jireh
i already change the dataformat of that field to time, but still same error occurs

hello veena,
thanks for your quick reponse, i'm using data report. im trying to group the data, my only problem is how to average the time.. im working my time and attendance and im on the final...

hello guys,
how can i sum the total time in report footer? when i use function sum
i got this following error data type mismatch in function object function1... is there any on how to do...

hello guys,
we have a device, this device is creating a textfile log..
my problem is how to read a new line everytime the last line of the textlog changes..thanks in advance

yes i want to separate all the text files base on the date...thanks

hello veena,

can you please help me with this problem, i have a .dat file
the contents is like this
00001 2007-02-12 18:13:13
00001 2007-02-12 18:13:23
00001 2007-02-12 18:13:33...

my sample code gives me a wrong output,
, Event:Access Door:1, Card No.:
, Event:Access Door:1, Card No.:
, Event:Access Door:1, Card No.:
, Event:Access Door:1, Card No.:
,...

hello Guys,

can somebody help me reading a .dat file then output the file in a textfile

sample .dat file

1 2007-02-12 18:13:13 1
1 2007-02-12 18:13:20 1
...

Hello guys,
im trying to connect to .dbf table every time i try to query from the table it gives a error
[Microsoft][ODBC Visual FoxPro]Operator/operand type ,mismatch

heres my sample code......

Veena,
hello my project is almost done! i have two quetions for you how can i output the textfile in a accending order,sample

I have READER A which have this file

2006/12/17 13:22:29,...

Hello everyone,
how can i call a exe fox pro .exe file? is this possible?
thanks.

Veena, WaltP
thanks guys, i got the correct output!:cheesy: i just place the Close#FN before the wend

Regards

Veena,
thanks, you've solve my 2nd problem, but still my main problem is if i will download all the attendance from the reader it will save only in one file..this is the sample output file... the...

Veena,
Hello
this is for my other project which i have to donwload all the attendance from the biometric device, then saved it to "C:\TNA\" .txt
as text files, this is sample the code

Dim...

Veena,
Hello. again it's working very nice..thanks..

Veena,
thanks for you quick response, your given code is working well in access, but when i use in mysql it's give a error "FUCNTION CDate does not exist" do have any idea about it..? thanks again..

Veena,
hello, i add a field in the database named total TotalHours, i add this to compute the difference time of TimeIn and TimeOut, but i have a hardtime doing it, i didn't know where is my error...

Veena,
it's working very well, thanks to your help!!!

veena,
thanks for you quick response....;) i got the rigth output that i want.. but there is only few bugs...
first when i select a date i.e. 11012006 to 11302006 there is a error, when the...

try this code;
avg = format((val(txt_num1.text) + val(txt_num2.text) + val(txt_num3.text)) /4, "##")
msg = "The average of four given numbers is " & avg

Sir Yomet,
thank you very much it's working very well i just replace the # because it's not valid in mysql... i can now move on to my project...
again THANKS;)

Option Explicit

Dim dbCn As String
Dim Cn As ADODB.Connection

dbCn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=dbEvaluation;data...

hello sir Yomet
first thanks for helping me with this project
the problem is when i put the "if not rs.eof then" the return record in the data base in empty... and when i replace it with "if...

sir yomet
hello sir i have some good news for you, i was able to set the TIMEOUT, but there is few error i want to fix..
SAMPLE OUTPUT mysql...

Marikanna,
how about reading or sending file thru LAN port...
thanks

Dim dbCn As String
Dim conn As ADODB.Connection
Dim rptCn As Connection
Dim rptRs As Recordset


Public Sub RptConnect()
Set rptCn = New Connection
rptCn.CursorLocation =...

Code:
---------
'You will need to add the following declaration
Dim rs As Recordset
---------
Code:
---------
While Not EOF(inFile)
Line Input #inFile, InLine
If InStr(InLine,...

hello every one..
good day...
first i was able find the solution in this site on how to open the textfile and save it to the
database, i'm using mysql as my database...thanks to sir "jomet" ;)...

hello sir jomet its me again.. still i can't solve my problem before.. please help. this is regarding with the timein timeout issue that i tell you before i include the program so you could tell...