Recent content by StefanSch

Hi Want I want to achieve is something like the following: -------------------------------------------- If AllowBypassKey = true then 'something like this should check whether the user has 'enabled the shift-key create a text file on c:\ End If...

I have the following problem. Access 97 tells me that PropType As DAO.DataTypeEnum is not an Automation type supported in Visual Basic. I have the reference set to DAO 3.6. I have also tried DAO 3.51 but with no success. In Access 2000. The code worked perfectly. Thanks for any help.

Can anyone help. I am lost on this.

Thanks. I'll try that.

when I try to install a runtime97-Application I get the following error message. ____________________________ C:\Programme\Gemeinsame Dateien\msacc8.olb (this is the German version for shared files) Unable to register the type library: LoadTypeLib failed; code 0x80029C4A Click retry to try...

Question regarding the issue below. I had an idea. Should the following idea basically work? In the position value I would write something like: numbers + DSUM([FieldIncreaseNumber])..... Numbers would be a given value (running sum calculated in another query). The [FieldIncreaseNumber]...

I will give this a try. Thanks

I have a crosstab query with the following elements: rows: date columns: articles values: numbers The numbers are running sums calculated in another query. NUMBERS TODAY: The numbers in the crosstab query according to the state today are as following (example Article A): 5 6 9 14...

I have a crosstab query with the following elements: rows: date columns: articles values: numbers The numbers are running sums calculated in another query. NUMBERS TODAY: The numbers in the crosstab query according to the state today are as following (example Article A): 5 6 9 14 etc...

Sorry, the format has been screwed Example ___________________ As it is now 3 5 6 9 etc. _________________ As it should be 5 (3+2) 9 (3+2+2+2) 12 (3+2+2+2+1+2) 17 (3+2+2+2+1+2+3+2) etc. _________________ FYI: The above numbers are running sums

I have a crosstab query with the following settings: rows: dates columns: articles Values: Numbers how can I always add the number 2 to each value and not only to the first value? Example As it is now As it should be 3 5 (3+2) 5...

Thanks. I will try this. Hopefully the effect of the "me.requery" will take effect before the on current event is started. Otherwise the on current event is useless. With "me.dirty = false / me.requery", a text box (let's say text box A) in another subform must be updated with the entered...

I have a question regarding the on current event of a subform. My subform has 5 fields. Each field has an after update event, something like this (shortened): Begin code ..... .... me.dirty = false Me.requery .... ..... End code When the after update event of a field is finished I would like...

Problem is solved. The "Name" occured because the field control which was referenced was a calculated control as well. Thank very much for your help.

Hi I understood now what you meant. The source data of the calculated control in the footer should be the formula below. I did that. However, unfotunately, the text box brings up #Name? Do you know what could be the problem?