codeCruncher
Last Activity: Mar 28 '08, 02:07 AM
Joined: Sep 11 '07
Location: Malaysia
-
This function has become too complicated. I redid everything, made it simpler and now it works but I still don't know how to close this thread.Last edited by Killer42; Oct 10 '07, 02:39 AM. -
Select case problem
Using VB6, MS Access 97.
This function is supposed to insert the data if the table is empty or if it is not, delete the data and replace it with the new data in the new table. However; what happens is that it automatically exits the sub and displays the error (which is not supposed to happen unless there is no data to insert[table1 =no data]). Can anyone help? Thank you.
This is my code:
[CODE=vb]Private Sub Command1_Click( )... -
One simple way you can do it is by using a label saying that the process is still running and set the visibility of the label to False when the process ends. Or if it is just for a short while, you can just set your cursor to hourglass.
MousePointer = 11Last edited by Killer42; Oct 9 '07, 04:08 AM.Leave a comment:
-
Sql statement
i wasn't sure whether to post it in access or in vb as it involves sql..This is my sql code. I felt like it was right but it doesnt seem to work. Like a wrong sql statement or some sort. Can any1 detect the error? Your help is very much appreciated.
Dim mDataBase As database
mExcelFile = "A:\Service_21. xls"
mAccessFile = VAppPath & "\RMIV.mdb"
mWorkSheet = "SERVICE_21 "... -
wut do u mean by corrupted? hv u tried registering the .dll? if yes, then try to replace the .dll file with a new 1 n reregister that 1. g'lck! :)...Leave a comment:
-
Progress Bar / Gauge
Hi;
Can any1 tell me wuts da differences between using gauge n progressbar? when shud we use which n y? I am trying to develop a program which tells the user when the program has finish executing. Which 1 is best?
Language: vb6 -
Hi Daniel! Im having the same problem with my code. Have u tried adding the reference?Leave a comment:
-
excel to access in vb
Hi! im a newbie here n im kinda stuck at dis function. This function is to import excel file(book1.xls) into a an access(97) table(name Service). I am using the code below but sumhow its not working. All i get is an error saying method 'range' of object '_global' failed. Can any1 help me detect the problem pleeeze...tq:)
Sub ConvertExcel()
Dim db As Database, rs As Recordset, r As Integer
Dim k
...
No activity results to display
Leave a comment: