Recent content by Koaz

Thanks folk. I managed to solve the problem by reinstalling the software. Thanks n Rgds.

Thanks dude.. I would try it out.. Gosh me, I actuallly spent 3 nite in the library searching the ans, thought something wrong with my coding. ohhh.. I try to create a new database then.. and import the necessary.

Thank dude!!, I actually tried the coding on my sis's pc and it works.. I'm not pretty sure if lies problem on my pc's office 2003 which says I have a missing reference. P.S very confidental that none of our coding was wrong. It just can't work in my office 2003 and advise one this? Or anyone...

Function BlnIsValidIC (ByVal strInput) If Len(strInput) <> 9 Then BlnIsValidIC = False Else If IsNumeric(Right(strInput, 1)) = True Or IsNumeric(Left(strInput, 1)) = True Or IsNumeric(Mid(strInput,2,7)) = False Then BlnIsValidIC = False End if end function...

Function BlnIsValidIC (ByVal strInput) If Len(strInput) <> 9 Then BlnIsValidIC = False Else If IsNumeric(Right(strInput, 1)) = True Or IsNumeric(Left(strInput, 1)) = True Or IsNumeric(Mid(strInput,2,7)) end if End Function -----------------------------------------------------------...

Hi guys, I am in a project of doing an 3D anime programming,just want to check up if VB could be used to program a DirectX anime. Intend to use VB.Net 2003 to do it. Completed work, is use in a local host pc, and it should be able to upload from a server for any update information. Rgds, Koaz

i tried, but it doesn't work. It say type mismatch? How??

I paste my sample code here: sub cmdBtn_click() ' the form will close lor my form name is Leave_form. How would close that form.

Hi all, I have a question here. How could close the form when condition is true. For example, if the condition require appear to be true and done, the form will close. I only know that, in visual Basic is 'End'. But it don't work in Ms Access. Thanz n i do appreciate any help from the folk!

Hi all, I had try writng the following statement in two access version, but it only worked in access 97. Private Sub command0_click() Dim frm As Form Set frm = [Forms]![form1] Dim dbs1 As Database Dim rst1 As Recordset Dim mrst As Recordset Dim SQL As String Set dbs1 = CurrentDb() *Set rst1 =...

Erm.. But how do i execute my sql statement, if i wanted to insert data to table, instead of selecting from the table?

Hi all, I know that inserting the data to table, had to use sql statement, but I am not sure how do i execute them? After writing all this. Sub DB_Connect() Dim db Dim sql As String db = &quot;C:\Documents and Settings\HoRiZoN\Desktop\Eleave_convert.mdb&quot; DataConn.ConnectionString =...

Oh!! Yes, i manage to debug the error.. thank for ur advise...

How could i do a connection between the form and table, using DSN-less? I had try something like this: Sub DB_Connect() Dim DataConn Set DataConn = server.CreateObject(&quot;ADODB.Connection&quot;) Dim db db = &quot;C:\Documents and Settings\HoRiZoN\Desktop\Eleave_convert.mdb&quot...

Haha!! Me think i fall in the same situation with u, lynne. I will follow closing with the post...