Truncate Table [TABLENAME] Will DELETE ALL Data AND RESET the Autonumber field in Microsoft SQL Server (any version) This will also apply to most SQL92- SQL99...
I will try on my access database or else I will do it by compact and repair method;) ... From: Oakes, George [mailto:goakes@...] Sent: quarta-feira,...
Truncate table WILL NOT work on Access Databases, you HAVE to use Compact and Repair George Oakes VB.Net Programmer/Analyst Morgan Tire & Auto dba. Tires Plus,...
uh that didn't work with my windows media player component and i dont have the microsoft multimedia control so.. could u recommend a site where i can get the...
Do you need this process only once or it's a part of a procedure that should reset the autonumber every time the user run the procedure? If only once, compact...
hi all, iam new to VB programming. can anybody tell me the use of Like function in VB with an example remya ... Do you Yahoo!? New and Improved Yahoo! Mail...
Ok, I have solved my problem thanks to all that reply to my answer. I will use compact and repair database, the reason is if someone ask me to use the databae...
sorry for my previous email my purpose was ascii characters 180-210 or in microsoft word box drawing characters for example unicode 2554 . thank you ...
Hello , I need to change the paper size in the datareport to A5. but it is always printed and designed in A4. i need to know how i can change the paper size to...
First of all change the paper size from the properties of cuurently installed printer on your computer and then open DATAREPORT for design. It will work...
I hope I'm not posting in the wrong group since this is not really a VB6 question but a VB.NET question. I'm trying to use a DataGrid in VB.NET and we are...
hi george check how u saved your .rpt, maybe u didn't UNCHECK the "save data with
report" option under the File tab. hope it will help rdb ... From:...
Hi Group, Can anyone tell how to use kodak image edit on Vb form or any other alternative to edit image within Vb application Regards, Nilesh [Non-text...
Hi, Like Operator is used to compare a string to a pattern Example Dim Res as Boolean res = "A" Like "[A-Z]" returns True res = "A" Like "[a-z]" returns False ...
Arul Nayagam
arul@...
Sep 3, 2004 4:14 am
17113
Use this code. It is from HYPERLINK "http://www.allapi.net/"www.allapi.net. Private Const SND_APPLICATION = &H80 ' look for application specific...
In Crystal Report you will find a menu called database. there is an option of verify database. click on it. ... _______________________________ Do you Yahoo!? ...
Good evening, I'd like to start using VB 6 in the near future. Though I've looked and looked, I simply can't find any info saying whether or not there are any...
Hello Programmers, i want to check for the Broken links in a web page in a WebBrowser i made it i know that there is some thing sent to the server to ensure...
For VB6 I don't know, but for VB5 there is a free version where you can code but you can't conect to database or generate the exe of your code. Try to finf it...
In Crystal Report, there is one option menu under file menu...there is one option of save data with report. so uncheck that option then every time the data...
You have VB 5 Control Creation edition. It is only 7 MB. Otherwise try to get VB .net Express edition. It is available in the beta version. With Regards ...
Sometimes it cause with the sql stmt. Go to Database menu--> Show Sql query and check if you are getting samething when you run in editor. And also I would ...
Many programming books contain a working version of VB6 included with the book. I recommend "Learn to Program with Visual Basic 6" by John Smiley. This is one...
All right, thank you all for your replies. I have found VB5 CCE and have tried using it. I have to say, although I have extensive programming experience, it is...