Re: Question on displaying repeating data

From: Rich (rstringer_at_provide.net)
Date: 04/08/04 

Date: Thu, 8 Apr 2004 12:08:44 -0400

Dirk,

Thanks for the quick reply but I don't quite understand what you mean.
Still looking at this, I have not set this up as a sub-form, which I am now
doing. When going through the form/sub-form wizard, I ams opting to use
existing table, then I select the 4 columns from the daily_quotes table.
Next, I have to choose the link from the main form, to the subform. I have
to "choose from a list", or "Define my own". Problem is that I cannot read
what is presented when I opt to choose from a list. The dialog does not
scroll right and the visible portion of each choice is identical. Duhhh. I
basically want to link on the stock symbol on the primary form (I think)
such that for whatever stock symbol is selected on primary, I get the 10 (or
whatver #) or quotes on the bottom for the same symbol.

Thanks,
Rich

"Dirk Goldgar" <dg@NOdataSPAMgnostics.com> wrote in message
news:OgNHfEYHEHA.2928@TK2MSFTNGP10.phx.gbl...
> "Rich" <rstringer@provide.net> wrote in message
> news:eq1Ss4XHEHA.2580@TK2MSFTNGP12.phx.gbl
> > Hello,
> >
> > I am developing a financial application that tracks various aspects
> > of the stock and financial markets. I am currently developing it
> > using Access 2003 although eventually, all the data will reside in
> > SQL Server. Access will still provide the UI.
> >
> > On 1 form, which has to sections (top and bottom), I want to
> > enter/display opening and closing stock prices for a given company.
> > On the bottom half of the same form, I want to display a given number
> > of historical opening/closing prices. The list will be in reverse
> > order based on the current. For example, the last 10 days beginning
> > yesterday. There will be a text box so the user can input the number
> > of historical quotes. The query logic is relatively simple.
> > Something like:
> > Select date, opening_quote, closing_quote
> > from tbl_daily_quotes
> > where date is in (today's date - 10 days). I obvisously don't know
> > the SQL syntax here, but I think the meaning is clear.
> >
> > My problem is that I don't know how to display this. How can I set
> > up what I imagine is basically an array or table to display the data?
> >
> > Also, a little help in getting my SQL Syntax is also appreciated.
> >
> > Many thanks in advance,
> >
> > Rich
>
> A subform in continuous view seems the most likely way to display this
> information. The subform's recordsource would be the query that returns
> the last 10 days of quotes. You don't actually say, but would these be
> quotes for the specific company that is shown on the main form? Then
> you'll need to include the company code (or other identifier) in the
> query and use the Link Master/Child Fields of the subform control to
> identify that field on the main form and subform. Your query would look
> something like this:
>
> SELECT CompanyCode, StockDate, Opening_Quote, Closing_Quote
> FROM tbl_Daily_Quotes
> WHERE StockDate >= DateAdd("d", -10, Date())
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>

Relevant Pages

  • Re: How can one subform be controlled by several combos?
    ... subform would not be the way to go. ... generic subform to display the address fields, ... I would think that setting the filter would ... This query is made up of the ...
    (microsoft.public.access.formscoding)
  • Re: Cant Count Records in Form
    ... "Jeff Boyce" wrote: ... Include in the query a selection criterion something like: ... in Table1 sequentially and in a subform I display the records from Table2 ...
    (microsoft.public.access.forms)
  • Re: Subform Recordsource changes
    ... I've come to the same conclusion but have decided that the TreeView control ... is probably the better way to display the hierarchial data set. ... > You could make it a bit easier by having the subform be a datasheet view ... > assign the control source for each column based on which query was selected ...
    (microsoft.public.access.forms)
  • Re: Use crosstab column heading in a calculation
    ... subform could be used as a kind of blank display screen to display the ... results of any query. ... >crosstab has defined column headings. ...
    (microsoft.public.access.queries)
  • Re: Subforms & Crosstab Querys
    ... I can't identify why the subform won't display the query. ... One of the queries that I used to build my Crosstab uses the value from ...
    (microsoft.public.access.forms)