User Data to Create a Custom Query

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
 
S

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
 
D

Duane Hookom

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