Search results

Thanks for the advice. In the meantime i've found the reason for this behavior. Somewhere in the code behind forms i've put a wrong inputmask to get active if a certain condition was met. This condition did indeed occure and therefore the wrong inputmask was applied.

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

Thanks for the help

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

Thanks very much

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

Thanks for the help. However, in Access 2007, replication is no futher supported.

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

Thank you very much

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

Thanks for the help

Thanks for the advice

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

Importing a table or a form or report from one database to another is quiet simple in MS Access 2007. Exporting or importing a saved import- or export specification -e.g. a table that must be exported to a csv file in a specific folder from one database to another seems to be a whole other...

After changing one or more fields of a record on a form, the form shows the first record. I want to stay on the record that has been changed. When the button "Change" is clicked, in the event that is fired the bookmark of the current record is saved: Bladwijzer = Me.Bookmark. ( Bladwijzer is...

Sometimes i need to send a table of my database to another database on another computer. To solve this problem i export the table to a textfile, and after that i put this textfile as a attachment on a email which i send to the destination. For most of the tables i need to send, everything is...