Recent content by odrap

Just an unbound form with a textbox and the code in beforeupdate of the textbox. When you fill in more than two numbers of letters, you get the message and after that you see the wrong input selected in the textbox

Thank You for the help, but .... I followed your advice, see code beneath, but that doesn't work as i want it to work. After this event, the whole input in the textbox remains and is selected (black background). I work with Access 2007 Private Sub txtJaartal_BeforeUpdate(Cancel As Integer)...

I my form i have a textbox into which the user can enter a value that will serve as criteria in a query. In the beforeupdate of this textbox there is a check about the validity of the input. If this input is wrong, a message tells the user what's wrong . In such a case i like to cancel the...

All the possibilities that you suggested doesn't fix the problem. By mean of test, i removed the orders for the years 2009 and 2010 out of the order- and orderdetail table. With this reduction, the orders i missed are now visible in the dropdownlist. For me that means that there exists a limit...

Thanks for the help: I will give them a try

In the form frmOrders of my database i have a combobox where i can choose a ClientID and the dropdown list shows me all the clients in upgoing order with their related orders in descent order. But the dropdownlist doesn't show all available clients. The two hundred heighest clientnumbers...

i have MS Access 2010 and want to buy ms Access 2013 ( upgrade version) Is this still possible as it was for earlier versions ?

I like to create a form for managing client data with the following behaviour: When the form opens all controls are displayed, without any data in it and locked. When clicking on a button to enter a new client, all controls must be unlocked, and after entering the new client and hitting the...

In a combination of two tables : tblInvoices and tblPaymentInvoices i gather all information re payments of invoices by clients. The table tblInvoicepayments is used to record the partial as well as whole payment of each invoice. Here we the invoicenumber, the paydate, the amount paid . Apart of...

In one of my Access forms i use a groupbox with multiple radiobuttons, to make it possible for the user to build the where clause for his query. Some of the options are used to build a where clause that must make it possible to search for invoices in a table with an invoice amount that is the...

In the reference window both: Microsoft Access 12.0 object library as well as Microsoft Office 12.0 Access database engine are referenced

By the by I deleted MS Access 2007 and after a shut down of the computer i reinstalled MS Access 2007. However the problem remains !!!

In the sub in question i have : Private Sub CmdVervangBtw_Click() On Error GoTo ErrorHandler Dim db As DAO.Database Dim rst As DAO.Recordset Dim waarde As Integer Set db = CurrentDb() ...

Set db = Currentdb()

On my computer, running windows 7 Ultimate with Ms office 2010 Professional i have MS Access 2007 as well as MS Access 2010. When i run my Ms Access database with MS Access 2010, everything get fine. Testing the same program with MS Access 2007 gives me a compile error: Error during loading dll...