Recent content by wichtel

Hello, Is it possible to set an array Data(10,10) as record source of a chart? Thanks, Tom

Hi, is it possible to set an array as a record source of a form (Datasheet type)? I tried: Data(1,1)=5 Data(1,2)=6 Data(2,1)=10 .... Me.Test.RecordSource=Data but it doesn't work. Any idea whats wrong? Thanks Tom

Hello, Is it possible to define field formats of Update-Queries? In particulary, how can I define a field in the querie as decimal (28,10)? Thanks for your help Tom

Hello, I've got a query which unions two queries. Now, how can I goup the query by "DATUM" and sum up SERIES1 and SERIES2? Is this possible to write as one SQL code? Thanks, Tom SELECT AEST_D01.DATUM, AEST_D01.PB AS SERIES1, Null AS SERIES2 FROM AEST_D01 WHERE (AEST_D01.SERIESID)="1003" UNION...

Hi, I'd like to transfer access-queries to Oracle. If I export access-queries, Oracle recognize these as tables and not as dynamic queries? Any idea how to solve this or does anybody know a tool to create queris in Oracle? Thank! Tom

Hello I want to create charts in Access with VBA but unfortunately, I can't find much in the Access help. Also the Macro record in Excel is not a good help because VBA in Access seems to be not the same as in Excel. Therefore, where can I find a reference guide? Are there good books you can...

Hello I want to display the maximum y scale of a chart in an text box. When I change the source of the chart and requery, I don't get the current maximum y scale but the previous one. Have you any idea how I can get the current maximum scale? the code is like this: strSQL = "SELECT Date, R68...

How can I rename a Module? I can't find anything when I right click on a module? Thanks Tim Hart

does't work either ;-(