Recent content by iown714

Thank you very much Borislav! It worked! I originally used the CASE as well but I was missing some key parts.

Hello, I have a quick question. I'm currently using MS SQL 2005. I have a main table which has many fields. I created a view#1 which imports all the rows from the main table but I only select the "City" field, "PurchaseDescription" field and a "Cost" field. Only the city name is unique. There...

Thank you Tom and Bob. Bob, i chose as reference Microsoft DAO 3.51 but when i changed it to DAO 3.6 the connection that I used to use... Set dbsCurrent = OpenDatabase("C:\data\myDatabase.mdb") was able to open a table created with Access 2000. I think the DAo 3.6 did it!!! thanks very much Bob...

thanks for your input

Tom, Ruffnekk, thanks for ur earlier response. i just have one last question. i used Access 2000 to creat the table as such it is formatted with Access 2000 "stuff". When I do Set dbsCurrent = OpenDatabase("C:\data\myDatabase.mdb") I get an error message that says: "Run-time error '3343'...

Ruffnekk, thanks for ur earlier response. i just have one last question. i used Access 2000 to creat the table as such it is formatted with Access 2000 "stuff". When I do Set dbsCurrent = OpenDatabase("C:\data\myDatabase.mdb") I get an error message that says: "Run-time error '3343'...

Hi, I'm trying to write just a simple VB application that runs on machine X and accesses an Access table on machine Z. I don't really want to map any drives or such thing. Machine X and Z are in the same network so they can see each other. Does anyone know what the connection string would be for...

Hi, I'm trying to write just a simple VB application that runs on machine X and accesses an Access table on machine Z. I don't really want to map any drives or such thing. Machine X and Z are in the same network so they can see each other. Does anyone know what the connection string would be for...