Search results for query: *

This is what I do now: 1) In a datasheet in a form displaying the results of a direct ODBC-query I click one of the column headers to mark a column. 2) I push "Ctrl-C" to copy the data. 3) I open a form including a chart in Design View. 4) I dobule-click the chart to get the datasheet...

I have three tables representing the same series of measurements, but not all measurements are present in all tables: One Two ControlTable (this table should include all measurements) To simplify, all of them have these two columns/fields: PK field1 (PK is the primary key,and is also an index...

Hello! I have posted a question about plotting before with no response. But this is quite crucial to me and it should be generally quite fundamental as well, so I try to reformulate slightly: If you mark a column in a datasheet (by mouseclicking it), is it possible to plot this column into a...

Hello! I have a subform where the source is set to <<queries.MyDirectQuery>>. MyDirectQuery is then showed as a datasheet in the subform of MyForm. I can click on one of the columns in this form, and it gets highlighted. Now I want to plot the data in this column as a line plot. I would also...

I have this query: select sum(param_1) &quot;PARA1&quot;, sum(param_2) &quot;PARA2&quot; from (...) union select max(param_1), max(param_2) from (...) resulting in: PARA1 PARA2 [value of sum(param_1)] [value of sum(param_2)] [value of max(param_1)] [value of max(param_2)]...

Hello! I want to open a form (MyForm2) showing a record where MyID2 corresponds to MyID1 of the active/marked record in a datasheet. The datasheet is placed as a subform on a form (MyForm1) on which I want to add a command button that opens MyForm2. The datasheet uses...

This is what I have (a query with varying number of columns AND rows): ColID_0 ColID_1 ColID_2 Col_ID3 ColID_end -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- lots of rows...

I want to copy the records from a query except for the two first columns. I thought I could use: myRst = myQuery.OpenRecordset(dbOpenDynaset) myRst.Fields.Delete(&quot;MyFirstField&quot;) myRst.Fields.Delete(&quot;MySecondField&quot;) But I am not permitted to make updates on this...

I have a list box that is linked to a specified query in the QueryDefs of my CurrentDB. This list shows always the correct items. Further I use the function below to extract the information from the list. This always succeeds the first time. But after having manipulated the query that the list...

Issue 1: How to put e g 4 column values from a predefined gruop query containing a lot of columns into one column (4 rows) in a list? Issue 2: I want to report several parameters from a database based on the user's options in a &quot;FindData&quot;-form. Typical parameters: Amplitude, period...

I want to edit the labels of my controls at run-time: Forms!MyForm!Label2.Caption = &quot;LabelTxt&quot; works well. But at run time the nr of the Label will change. Therefore I used the Eval function like I would have done in eg Matlab: tmpString = &quot;Forms!MyForm!Label&quot; & idx &...

I need to perform direct queries from Access to an Oracle Database. Is it possible to manipulate saved queries from the VBA? (Visual Basic for Applications and Access 2000) In VBA I'll make SELECT-statements (SQL) based on user input in a form. Then I want to perform a &quot;direct query&quot...