User Data to Create a Custom Query

  • Thread starter Thread starter SLL
  • Start date Start date
S

SLL

Hi all-

I am fairly new to access and am currently working on a project that
pulls live data from excel every minute or so and stores it into an
access table. There is data for about 26 columns (call them A-Z) and
each minute a new line is added to the access table containing the
latest data. I am having no problem pulling in the data (using
timerinterval, starting and stopping, etc).

Now, I have a form which I want to give users the option of selecting
certain columns of data to view in a chart. So essentially, I want
the user to have a dropdown box with each of the column headers as
options. I envision that this data would then be used to create a
subset of data which would then be fed to a graph.

So I have tried to do exactly this - created the combobox, selected my
Source as the table with my excel data - but I cannot figure out how
to get it to select columns only. Can anyone help me out with this?

Also, partially related, I want to give user's an option to pick a
date/time range. One of my columns of data is Date and one is Time,
so it would be based off of these values. Any help here?

Thanks in advance.

-SLL
 
There is a complete query by form applet athttp://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duanewhich
allows users to select a "data source" query, fields, sorting, filtering,
etc. With a couple clicks the data can be sent to print, Excel, Word, Html,
graph, merge, etc.

--
Duane Hookom
Microsoft Access MVP











- Show quoted text -
Click to expand...

Thanks - now as a follow up, is it possible to simply create the
queries that I want, and have a user use a combobox to select them?

ie. I have query A, B and C

On a form I put a combox and a graph. i want to have the user use the
combobox to select A, B or C and then display that on the graph...

any ideas?

Thanks in advance.

Sean
 
This is possible. You should be able to update the Row Source property of the
chart control after the update of the combo box.
 
Back
Top