Recent content by cie00011

Solved The solution to this was to approach from a different angle. I made the graph simply look at one table that changed depending on the selection, which was a lot easier to do. From the combo selection, VBA copied that table and renamed that "Graph_Data". In the Row Source I entered the...

My problems is a difficult one. Here is the breakdown. I have a number of tables within a database, I have a main screen as to pick the required table I want to display in either tabular or graph format, the table works. I have created a graph and am trying to get the code or row source in the...

This is what I know so far. I have the code and every thing set up to go. The only problem is that I cannot get the graph to look at the VBA to define the graph. I think that I need to put something in the row Source Type field or the Row Source field to get it to look at the VBA in access. Any...

For a graph i have the below code sql to define the chart results SELECT [Load],[Displacement] FROM [try]; try is a text box containing a table name within the access DB. how do i change the FROM sql statement to look at the name in the text box and use it as to draw the graph? options in...

For a graph i have the below code sql to define the chart results SELECT [Load],[Displacement] FROM [try]; try is a text box containing a table name within the access DB. how do i change the FROM sql statement to look at the name in the text box and use it as to draw the graph? options in...

=DLookUp("Load",[Forms]![Main_Screen]![Project_Name]) But no it only displays the first data point of the series, how do i get it to display all the series?

I have a text box on form "Table" and have a combo box on "main" first the combo box on Main selects the table i want to use "Table1" then i want the "Table" page to display one of the data series "seriesA". I know to use a Dlookup function in the Control Source, but i am having trouble making...

What i need is a text box that displays the values of a of one of the field with a selected table. To explain. I have a series of combo boxes to get dwon to the final choice of a table within the access database, eg T1_project1_121206_1200 within each table is load and displacement. with the...

I have a access form that after a series of combo boxs i get to a final name of a table within the access database. i would like, with this selection and a button to create a line graph in either, access, excel or better the web page graph you can create. the axis will aways be load and...