Search results

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

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

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

When i try to use the datadocumentation for my database written in MS Access 2007 on my desktop, i get the following message: Error during loading DLL When i try to compile the database I get the error Compile Error Error during loading dll In the source of my program the line Set db =...

I need to assemble information about de buying history of clients. That means , that i need to view all articles that the client have ordered in the past, the date each article was last ordered as well as the quantity that was ordered, as well as the number of times each article has been...

I"m using Ms Access 2007. 1)In my program i have reports that are used the normal way, but also reports that must be used the normal way as well as in PDF format. To get this done, for the moment i use a copy of the report that has to be used the normal way as well as in PDF format. I feel that...

In one of my forms i have a textbox with the following inputmask >LL" "0000" "000" "000 which must make it possible to enter data as BE 5489 458 789 However when i enter the textbox to put in data the following is shown in the textbox: ** ***.***.*** As result of this i can't put in the...

1)In Ms Access2007 the systemtables MSysIMEXSpecs and MSysIMEXColumns contains the necessary data for the saved import- and exportspecifications. Is it possible by importing these tables from one database to another, to have the same import- and exportspecifications in both databases? 2)After...

I need to have the possibility to send an access datatable as attachment of an Email. Because i do not have MS outlook but only Ms outlook Express,the only way i see to fullfill this goal is using the method DoCmd.SendObject acSendtable, tablename, ... acFormatTxt ... When we look at the...

In ms access 2007 we have the possibility to create a E-mail in the collect Datagroup. This results in a form foreseen of the selected fields of a datatable, that the recepient of the form must fill in with data. This way data for a new record can be collected from the recepient. But what about...

When Outlook is present we can use the following code to work with Outlook. Dim olNs As NameSpace Dim olApp as Outlook.Application Dim olMi As Outlook.MailItem Dim olAtt As Outlook.Attachment Dim Fldr As MAPIFolder Set olapp = CreateObject("Outlook.Application") Set olNs =...

In my database i have a table 'tblClients" who has a one to many relationship with the table 'tblOrders'. This table 'tblClients' is a 100% copy of a table with the same name that resides in another database. Each moment, the data in my table must be exactly the same as the data in the table in...

To make it possible to enter orders of clients at the site of the client itself, some coworkers have a mini-laptop with a MS Access databaseprogram. This database consists of the tables "tblClients" and "tblArticles" as well as a table "tblOrders" and a table "tblOrderdetails". The first two...

For archiving purposes,at the end of each year, a procedure is running that selects all records in the tables tblOrderdetails and tblOrders, of which the orderdate dates from two years ago: e.g.at the end of 2009 this will be all records with an orderdate = 2007. This records are put...

I have a databaseprogram that until now is composed of a data database and a program database ( using linking tables) Now on the site where the program is in use, the owner installed the program XP Unlimited, what makes that all the pc's in the network has immediatly connection with the main...

All of my forms saves the size of the form during the unload event form: acbSaveSize Me. During the load event of the form the size of the form as it was during unloading is restored: acbRestoreSize Me That works fine, except when code on a form activate the opening of a report in preview. In...