Search results for query: *

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

In my application the breakpoints are not working anymore. If I set a breakpoint the program simply runs without stopping, I'm using ACCESS 2002. I want to debug but this is not possible now anymore. I'm quit sure the program passes the places where I have putted the breakpoints Help will be...

I have built an application in Access2002 and I already have created several times installation disks for installing on different computers. I'm use the packaging wizard of Office XP developer for this creation. Since last week the packaging wizard gives the error message: Run-time error 429...

I would like to create a report for making a address list which has to be printed as a booklet (a5). Do do so I use the program fineprint. This means that I have to create a report in Access which contains 2 pages A4 wide which contains different information. Is there a way to create a report...

I use the following code to retrieve data from a usrr level secured database: Dim dbe As DAO.PrivDBEngine Dim wrk As DAO.Workspace Dim dbs As DAO.Database Dim rst As DAO.Recordset Set dbe = New PrivDBEngine dbe.SystemDB = "C:\XXX.mdw"...

I want to import data from another .mdb which is secured with security on user level. It has its own workgroup file. I have available the workgroup file and userid and password with the required authorization (I need to import the data in a new program as conversion which can run on the users...