Search results for query: *

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

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

Ok, Thanks !

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

Thankyou for your help !

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...

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...

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...

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...

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...

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

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 !

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

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...

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