Recent content by WillemdeNie

Guys, Great help; it works! Greetings Willem from Holland

Yes your explanation is clear. I indeeed would like to append the neew table to my collection of linked tables. Untill now: This what is in the example LinkJetTable "Gemeente", _ "C:\Program Files\Niebotel\SystemNiebotel.mdw", _ CurrentConn I changed it into: conDatabase.Open LinkJetTable...

Correct! I do not understand what your question means; but I will try to give you some info: The table has been created (running VBA inthe fromt-end) in the back-end .mdb. I would like to use this table in the front-end .mdb and therefore normally I link the table. Only now I have to do it from...

Ok Thanks I am starting to understand I have changed also the second variable into:C:\Program files etc in the name of the database in which is the table. In the example was referred to the workgroup. I assume this is right now It runs fine upto the the last statment in the sub...

Hi Roy Hope you do not mind: Compilation error on: LinkJetTable "Gemeente", _ "C:\Program Files\Niebotel\SystemNiebotel.mdw", _ CurrentConn On statement CuttentConn (variable not defined) Willem

Hi again; already found the library (I think)

Thanks for helping, Little problem left: I get a compilation error on the DIM statements; Userdefined type not defined (or something like that I have translated the message from Dutch). Could it be that I have to include a specific library? Willem

I have created a table using this code in the front-end: On Error GoTo Err_ConversieTabellen Dim conDatabase As ADODB.Connection Dim sDBName As String Set conDatabase = New ADODB.Connection conDatabase.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program...

I have to create a communication function in my ACCESS/Visual basic (6)application. I have received some coding from the other party to which I have to communicate with. It consist of a class module, a dll and some schema's which have the extension .XSD. I Imported the class module and did add...

Jerry, Great help! Tanks again!!! Willem (Netherlands)

Jerry thanks again, As you probably noticed I'm not that experienced. I hope you donot mind helpoing again. I tried what you wrote but run into new error. This what I created: Dim conDatabase As ADODB.Connection Dim sDBName As String conDatabase.ConnectionString =...

Hi Jerry, I think you gave me the right answer but I have still a problem with it. This is what I have created: Public Function ConversieTabellen() On Error GoTo Err_ConversieTabellen Dim conDatabase As ADODB.Connection Dim sDBName As String 'Initialize objects & variables. Set...

I have to add some fields to the definition of a table which is situated in a linked table. I cannot open the other mdb because it is in the backend part of my application and that is of course on the users computer. I want to add some new functions in my front-end, which I then distribute to my...

I have created a report (ACCESS2002) which displays each record on two lines; the first line normal text fields on the second line a memo field. If the memo field is empty a blank line is shown in the report. To prevent this I have set the properties can thrink (and also can grow)of both the...

Thanks, your answer helped me finding the solution. Instead of changing the database properties I changed one of the startup options (Allow Special ACCESS keys) Problem solved!!