Search results

  1. E

    Combobox returns null value for columns 3+

    Hi All, I've got a combobox that returns 4 values eg ID , Client, MinVal, MaxVal 4,SG,530,4500 Only the Client is shown in combobox. When I run the Row Source query it returns the 4 values as expected. I am trying to set 2 other comboboxes to the min /max values The min works fine but max...
  2. E

    Dlookup syntax problem

    Hi all, I'm trying to set a text box value from a table based on a combobox selection but keep getting a missing table error. Me.ExpiryClose is the textbox Me.WrittenOptions is combo expirytable is a string variable TGDec16 is my table When I debug print expirytable it prints TGDec16...
  3. E

    Make Table Query type incorrect

    Hi All, I found the attached example a while back (can't find the site again though :( ) and it calculates a moving average. I've hacked out the parts I need for my own work and I can create my moving average query without an issue. However, I need to extract the MA data into a table so planned...
  4. E

    VB refresh query

    Hi all, Probably a newbie question but can't see an answer. I have a query that I run to extract some values for calculations. Its run on an event based on a dropdown selection. At the moment, I run via: DoCmd.OpenQuery "CallMidprice" and then close it. this seems to take more time than is...
  5. E

    Whats taking the most time ?

    Hi All, I've been working on my DB for a while and expanding on functionality with charts, calculations etc. It is becoming slower to update my charts, much slower than I would expect. Chances are I'm probably doing something wrong/bad practice but is there a way of determining what's taking...
  6. E

    Expression Builder : Query with calculation

    Hi All, I'm having problems getting calculated query to work. At the moment, my query returns 3 values. date, close, adjustment This would look like 2015-04-10 1170 1165 2015-04-13 1163 1158 2015-04-14 1167 1162 2015-04-15 1154 1149 2015-04-16 1137 1132 2015-04-17 1127 1122...
  7. E

    Multiple Data sets on chart

    Hi All, I have a simple line chart plotting price against date. I would like to plot a secondary line on this chart from an array of data that I calculate. I've searched hi and low but can't seem to find a way of doing this. The closest I've found is from this:-...
    • El-d
    • Thread
    • Replies: 9
    • Forum: Forms
  8. E

    Field from Combobox

    Hi All, I'm probably being stupid (new to this) but is there a way to select a query field from a combobox? I have a Table (History)that contains Record_date , Comp1 , Comp2 , Comp3 etc 1/1/13 , 1234, 2345, 3456 etc 2/1/13 , 1214, 2355, 3466 etc Basically a table of values for each Company...
  9. E

    append cross tab query

    Hi All, I'm new to this, so apologies if I'm asking silly questions, but I've looked and can't see a solution. Setup is:- I import a daily csv , query (filter)the relevant columns into a temp table. Headings: Date_actual, Company ,xxx,xxx,xxx,Price data is : actual date, company 1-30...
Back
Top Bottom