Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tinkertek

  1. tinkertek

    What is VB.Net ?

    Hi, What is the difference between Visual Basic 6 and VB.Net ? I am somewhat familair with using VB6 with .mdb back ends, but what does VB.Net do ? Thanks for any help ! Paul
  2. tinkertek

    Change Windows Explorer file icon from key to custom .ico

    Hi, I'd like to change the regular Access 97 key icon to a custom .ico icon. This must work for a .mdb file stored on a server, so that everyone will see the custom icon. Any ideas ? Thanks for any help, Paul
  3. tinkertek

    Convert Access 97 to VB Software

    Ok, Thanks !
  4. tinkertek

    Convert Access 97 to VB Software

    Hi, Is there any shareware out there that will convert Access 97 to VB 6 ? Thanks for any help, Paul
  5. tinkertek

    Append Records using VB and Where clause

    Thankyou for your help !
  6. tinkertek

    Append Records using VB and Where clause

    Hi CCLINT, I fixed the single quote as you said and now it seems to function. However, it only copies the source database to itself, not to the destination database. It creates all kinds of duplicates in itself. What a nightmare trying to get this project done ! I created a unique autonumber...
  7. tinkertek

    Append Records using VB and Where clause

    Hi CCLINT, I tried out your code and keep getting an error "syntax error in FROM clause". Here's the code: Sub command1_click() Dim cn As ADODB.Connection Dim dbError As ADODB.Error On Error GoTo ErrHandler Set cn = New ADODB.Connection...
  8. tinkertek

    Append Records using VB and Where clause

    Well, I set this whole thing up on my home computer and finally figured out the line that is causing the error, "Too few parameters expected 1" objRS3.Open "SELECT BarcodeNumber FROM Assets WHERE BarcodeNumber=" & objRS1("BarcodeNumber"), objCN2, adOpenForwardOnly...
  9. tinkertek

    Append Records using VB and Where clause

    Hi bjrollet, I don't know which line is causing the error. You won't believe this, but I do not have VB at work, I only have it at home. So, I have to write the code at home, use the Package and Deployment Wizard, then email it to work, then go to work and run the setup file, then actually run...
  10. tinkertek

    Append Records using VB and Where clause

    Hi bjrollet, I tried out the code and got this error after several seconds: Run-time error 2147217904 (80040e10) [Microsoft][ODBC Microsoft Access Driver] Too = few parameters. Expected 1. Source: Microsoft OLE DB Provider for ODBC Drivers Here is the code as I...
  11. tinkertek

    Append Records using VB and Where clause

    Hi BJRollet, Wow, you went through all that work for me ! That's awesome. I can't wait to try it out. I was way off. I'll try it tommorrow or Friday and will let you know ! Thanks again !!!! Tinkertek
  12. tinkertek

    Append Records using VB and Where clause

    I'm lost !!! I've got hours into this and can't make it work properly. Call me dense. What would the complete code be ? Thanks again for any help !
  13. tinkertek

    Append Records using VB and Where clause

    Thanks for the reply. I'll give it a try. I have to be careful not to add duplicate records to the appended table. I'm not that great using VB6, so I'll try to muddle through. Tinkertek
  14. tinkertek

    Append Records using VB and Where clause

    Hi, I have 2 similar Access 97 databases residing on 2 different servers. Let's call them \\Server1\DB1.mdb and \\Server2\DB2.mdb. Every day, I need to Append records to DB1.mdb using records from DB2.mdb, but don't want to create duplicates in DB1.mdb either. Any ideas how to code this using...
  15. tinkertek

    Visio Line Jumps

    Hi, I am working on a design of an electrical system. For the life of me, I can't figure out how to make line jumps. Can anyone please help ? Thanks, Paul
See more

Part and Inventory Search

Back
Top