Search results

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?

Thanks a lot for this idea. This might work. Since I am quite new in MS Access & VBA, can you please give me a bit more details (maybe code examples) how I do that? Thank you so much.

I am trying the following: I have a subform with maximum 10 records. If one or more of the records have a negative value, I would like to make a certain text box in another subform visible. I guess that to achieve this, I will have to somehow loop through each record in the subform to check...

I have solved it somehow. Thank you anyway. I appreciate your help.

Is use Access 97 in German. When I distribute a database with the Runtime 97, the msgboxes, etc. have their command buttons in German (OK, etc.). How can I change them to English?

FACTS I designed a report that looks great in layout preview on the screen. The report includes text boxes. The text boxes have borderlines (black / hairline). The borderlines are clearly visible in the layout view of the report. Furthermore, the report has rows with alternate colors which...