Search results for query: *

I am trying to run my ACCESS 2007 application in 2013. But, as expected :(, I have some problems. The first thing is that the application opens with a form and that the form is to small in 2013 although there is a command on opening docmd.maximize...

I already use for some time the sharepoint to keep the data of my ACCEES (2007) application. Several people work on the same data. I know that I can work offline, but I'm not sure if that is OK for testing purposes. So I want to work offline, test my changes in the frontend and after that work...

Hello, i'm forced to use ACCESS Runtime 2010 for my ACCESS 2007 application, because Runtime 2007 does not work on Windows 10. That is not a problem, but there are two version of Runrime 2010, 32 and 64 bits. On my development PC I have still office 2007, so the 64 bits version won't install...

On my new PC with windows 10 it seems impossible to use access runtime 2007. Everytime when I want to use it the system pops up with the question whether I want to use this application or to search for a app in teh store. Choosing using the application doe snot give any results. Is this a know...

In my application in Access 2007 I have a form with a button. If I click on the button a report starts with a query which gets the record based on the ID which is dislayed on the form. In normal access operation it works well. In runtime on my own computer it works well. If I run the program on...

I have a table from which I removed some thousands records. Now I want to renumber the records which are still in the table. I have a field for that purpose which is numeric. So first record 1, second : 2; etc until the last record (about 2000 records) This is not the internal ID, but just a...

I have a numeric field which is defined as a numeric field, double precision and two decimal digits; the table is migrated to a sharepoint table (some time ago) and now attributes can only be changed in the sharepoint table. So not in Access anymore. In the sharepoint the field is defined as...

In a report all records are correctly shown in preview. But if the number of records is bigger then one page the next page does not show all the records anymore when printing, but still shows all records in preview. Any suggestions to solve?

On a form I have two date fields (with pull down menu for selecting the date); after leaving the field a calculation takes place. On another normal field I have the same trigger and calculation. On another unbound field I have the value calculated depending from this calculation and the value...

I'm trying to add a column to an existing table: db.Execute "ALTER TABLE Passanten ADD COLUMN ToeslagBerekend YesNo" db.TableDefs("Passanten").Fields("ToeslagBerekend").Properties("DefaultValue") = False The result is confusing: In the table definition is the datatype Yes/No In data view there...

thread701-1691734 UPDATE Ontvangsten SET ID = DCount("*","Ontvangsten","IDIn<=" & [IDIn]) did work in the past but now it fails on another table: UPDATE [Kopie van Passanten] SET ID = DCount("*","[Kopie van Ontvangsten]","IDIntern<=" & [IDIntern]); When the query runs it dais that it could...

Let me first explain the background; my application is running on a sharepoint so it is rather slow with "large" tables. Visistors of our sailingclub are booked into the system and we use data of the visitors if the visitor was here before. Some visitors come up to ten times a year; they have...

I have a table (Ontvangsten) with two number fields: IDIn and ID In IDIn are numbers like 1312, 1313, 1314, 1320 etc. so in the right sequence but not starting from 1 and having missing numbers of deleted records (this is an autonumber field) Now I want to number the records in ID like 1, 2 , 3...

I have a form on which data can added. Each records gets its own recordnumber which is made on moment of enetering data. (I cannot use the internal number because in backgrounf sometime records are added and deleted again) If I look into the table I see that my field ID in this table starts...

In my ACCESS 2007 application I have exported all tables to a sharepoint. This works fine for 2 years now. The frontends are installed with 6 users (local on there PC's) and they are using the same data on the sharepoint. For 1 of the tables we run into a problem. Records which were added (in...

When I export my file as TXT file the txt file shows the my field Datum (this is a date) always with some time fields (Something like 00:00:00) I must have in the asci file: dd/mm/yyyy In the export I cannot define to skip the time. So I have to convert the date before exporting in a text field...

I'm creating a txt file as an interface to another program. The first step is that I add records to a table; after that I export it as an TXT file. If I look to that table the sequence is not the sequnce in which I addded the records. I can solve it quit easy by adding a autonumbering field...

I have created a report based on the following query: .....HAVING (((Totalen.Datum)>=[Forms]![Form_menu_finance].[DatumStart] And (Totalen.Datum)<=[Forms]![Form_menu_finance].[DatumEind])) I enter the parameters on the form 29-11-2011 and 30-11-2011 If I run the query it only returns the first...

My application works fine, on my PC but on another PC under ACCESS runtime I get a lot of errors on moment of starting up. Type mismatch Class does not support automation or does not support expected interface Object variable or with block variable not set I tried on several computers; no...

My application (ACCESS2007) is ready and tested. But if I run it with ACCESS RUNTIME on other PC's it does not work well and gives error massages: Type mismatch Class does not support automation or does not support expected interface Object variable or with block variable not set What can I...