Search results

Thanks for the tip Dear Pace, I appreciate your guidance in this matter. I will certainly try and do some more reading on database design. I have only recently started getting my feet wet in Access and am quite aware I do have a great deal of learning to accomplish. Again many thanks. Irshad

Thanks Dear Neil and Larry, Thanks for your responses. Neil - I have created a query that joins all the relevant tables and gives me the output I need. However, what I need to accomplish is to have a Water_System table in another Access DB (A GIS Geodatabase to be more specific, let's call in...

Hi Neil, Thanks for responding. Actually, I do not need this information in a form or report. My requirement is that the "place" values of the Oblast, District etc... be stored in the table not the ID's. This is needed as I will be exporting data to a Geodatabase (ArcGIS table). The values that...

Dear members, I have a form with 4 Combo boxes bound to fields in 4 tables; 1) Oblast Name 2) District Name 3) Jamoat Name 4) Village Name The selections work fine. Cascade works from Oblast to Village Name. My question is ; Currently the ID's of the bound columns are stored in the tables...

Need to use setlink Hi g, I have found out that I cannot have more than one database pathname using the "IN" clause. I will need to create a link to the other database and then use the append statement. I know how to do this. I will sum this once I have succeeded. Thanks, Irshad

Dear members, I have two databases, Source and destination ; strSrceDB = "C:\WSS_DB\Rehabilitated_Water_Supply_Kulyob.mdb" StrDestDB = "C:\DB\WSS_Khatlon.mdb" I would like to append records to the destination table (Contractor_GIS) when there are no matching records in the source table...

Thanks Hi RuralGuy, Thanks, that is what I needed! It works. Best regards, Irshad

Deleting link from Access DB via code Dear RuralGuy, I actually have used the "Set" statement, with the name of the table to link to (System table). The "update" takes place fine but I need help with the code to delete the link after update has been completed. Appreciate your help. Thanks...

Deleting Access Table link after update outside an Access DB Version: 2003 Hi RuralGuy, The problem is at this line: If tbl.Name = "System" Then etc.... Thanks, Irshad

Dear members, I am trying to delete a link after a table has been updated. When I run this code I get "Error 91"- Object variable or with block variable not set. The code works fine without the "IF" statement. But I would like to have the link deleted automatically after the update has been...