Tuesday, February 20, 2018 - 06:30 PM
  Main Menu

Computer Tips & Tricks

Computer Tips, Networking Tips , Windows XP Tips , Windows 98 Tips , Dos Tips , Desktop Tips , Computer PC Tips , Hard Disk Tips , Web Design Tips

Windows Tips

Using ADO in Access 2000
To use a Microsoft Access 2000 database and ADO you have to add the correct references in your Visual Basic project. To add the references to your Visual Basic project follow the instruction's below.

Open a project.
From the Project menu, click References.
From the list, select Microsoft ActiveX Data Objects 2.1 Library.
From the list, select Microsoft ADO Ext. 2.1 for DDL and Security.
From the list, select Microsoft Jet and Replication Objects 2.1 Library.
Click OK.
This should let you now use an Access 2000 database with an ADODC control. However Data form Wizard will still face problems!

Understanding Error Handlers
When you use On Error GoTo and an error occurs, VB enters exception mode. The line you GoTo is supposed to be the beginning of an error handler. If an error occurs within an error handler, the program stops. What you need to do is leave the error handler and resume normal execution. Then you can use On Error to establish a new error handler for the next error. You do this with the Resume statement. See the help for details. In this case, you can use Resume LineLabel to make the program continue execution at a specific line.

Unfortunately, executing Resume from outside an error handler generates an error. Thus you cannot place the error handler in the flow of code the way you have. You need to jump out to the error handler and jump back with Resume.

Below is a subroutine that demonstrates two error handler.

Private Sub Command1_Click()
Dim i As Integer

On Error GoTo Error1
i = 1 / 0 ' Divide by zero.
On Error GoTo Error2
i = 1000000 ' Too big--overflow.
MsgBox "Finishing."
' Do not fall through into the error handlers!
Exit Sub

' Resume ends error handler mode.
MsgBox "First error handler."
Resume Error1Resume
' Resume ends error handler mode.
MsgBox "Second error handler."
Resume Error2Resume
End Sub

Stop your modem from frequently disconnecting

  • On the Desk Top Double click on the icon "My Computer"
  • Double click on Dial Up Networking
  • Right click on the Satyam Online icon (or the dialer that you are using) and select Properties on the menu, click on configure
  • Click on the Connection Tab and click on Advanced, in Extra Settings, type ats10=250
Prev   5  6  7  8  9  10  11  12    Next
Most Visited Topics
    Learn English   Universities   Study Abroad   Mobile & SMS   Computer & Laptop  
Learn English Language
Pakistan Universities
Student Visa for USA
Free Mobilink SMS
Computer Tips  
Easy Conversation
Foreign Universities
Student Visa for UK
Free Telenor SMS
Computer Rates  
Improve Vocabulary
Online Results
Student Visa for Spain
Free Zong SMS
Buy or Sell Laptops  
Online Jobs
Student Visa for Italy
Free Ufone SMS
Handmade Embroidery  
English to Urdu Dictionary
Newspapaer Jobs
Student Visa for France
Free Warid SMS
Diploma Courses  
Copyright © 2005-2018. All rights reserved ® 123freenet.com
Currently 10 Users Online