Search results for query: *

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

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

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

In my existing mdb I run into a "new" problem. Every time I click on a calendar control Both in design as in normal view) on a form ACESS2002 totally dumps. It was working well in the past; so I do not understand wat happens (SP2?)

I have created an application with front-end and backend mdb's in ACESS2002 with full user security implemented. Now I'm creating a new application (with its own mdb's and workgroup file) and want to re-use queries, tables and forms from the old application. I can export them from the old mdb...

My application is distributed on several computers. Although I have made it in that way that in all resolution settings all the fields and lables are OK there is reported a problem of one user. Because he has a different DPI setting (Control, display advanced) Lable fields are not big enough...

My application is built in ACCESS 2000 Dutch version. Now I try to run the application on a different computer which has the Enlish version of the ACCESS application. Queries which refer to fields in the criteria field are now not recognised anymore. This because the Forms are renamed from the...

The following query is used in my application: UPDATE Tbl_box SET Tbl_box.Vrij = False, Tbl_box.[Vrij vanaf datum] = Null, Tbl_box.[Vrij t/m datum] = Null WHERE (((Tbl_box.[Vrij t/m datum])<=Date())) WITH OWNERACCESS OPTION; It does not cause any problems. If I put this application on a other...

In a VBA module of ACCESS I added a reference to a dll I need for extra programming. Compiled and OK I created a MDE of the updated program. MDE runs fine under ACCESS I moved the new mde to an existing runtime environment of ACCESS. During startup of the application I get the error message...

I want to distribute my ACCESS2002 application. I have now to buy the complete Developers toolkit for having the runtime version of ACCESS2002. It is not possible (in Holland) to buy a upgrade from Office proffesional into developers toolkit (in which the runtime version is included). Is it...

When I create a MDE file ACCESS2002 stops and gives a message "ACCESS2002 is not responding". I created the MDE file already several times. Also "Compacting and repair" works fine. Tha latest change to my MDB was adding a form. The version before is still working fine and can be still converted...

I have created a combobox to find matching records. After typing some characters the field shows a matching record, but to see all the info (the orther colums and possible other matching records) I have to click on the arrow on the combobox. I would like to have the combo box opened as soon a...

Input field requires to enter a decimal numer. User should enter for example 2.30 but enters 2,30 2,30 is seen by ACCESS as 230 because , is not the decimal seperator but as the thousand seperator. Testing on numeric does not work On a other computer with other language settings it could be...

On my form I do not want the user to use buttons availanle on the menu bar. Whatever I try I cannot remove the last button &quot;Restore window&quot; How to solve?