Search results for query: *

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'm currently using Access to transfer huge data tables to Oracle (ODBC). The problem is that this takes a very long time. Do you know a better tool to transfer .csv to Oracle? Thanks, Tom

Thanks PHV and lupins46 for your great answer. But I've got a big problem: when I want to save the code from PHV in a query, the DB crashes (when I cust execute the code, it works fine). I also tried to to copy the code in another DB, but the same crash occures when I want to save. Sounds...

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

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

Thanks, but does't work either

How can I prevent Access to ask the password each time I import a table with ODBC? I used this code to get the tables: DoCmd.TransferDatabase acImport, "ODBC Database", "ODBC;Database=dora;UID=test;PW=test;DSN=dora", acTable, Me.Type, "pb6", False[/COLOR][/COLOR][/COLOR] Thanks for your help! Tim

How can I requery a subform with a chart, when I change parameters in the main form? The subform is NOT linked with the form! This code does not work: Private Sub Form_Current() [Subform_Chart].Requery End Sub also this one does not work: Forms!F_Menu.Refresh Forms!F_Menu.Requery Thanks...

How can I change the legend label with VBA. I found out how to show or hide a legend, but how to change the name? With Chart .HasLegend = True . ??? End With Thanks for your help! Tim