Hello there,
I am trying to plot 3 variables on one graph (specifically flow rate, pressure and flow path diameter) with the x-axis being measured in units of time.
Since these all have different units of measurement and there is only a primary and secondary axis I don't know how to fit them all on one graph or if it is even possible to do so. The reason why I need them all on one graph is to compare the values with...
amwkl4
Last Activity: Oct 5 '15, 06:06 PM
Joined: Mar 2 '15
Location:
-
Plotting 3 variables on 1 graph
-
Thanks for your time, I have finally found a solution. It is very simple, I just have to enclose the # with square brackets like so [#] when inputting the text in the textbox. -
That solution didn't work, it also made other words stop working too. Do you have any other ideas?Leave a comment:
-
Search Query isn't working for certain results
Hi all,
The program I am using is Microsoft Access 2010. I have a search form set up where I can type criteria in a textbox (Changed named to Keyword) and press a button to run a query. The Criteria for the query is is
Like "*" & [Forms]![Search Form]![Keyword] & "*"
I have a list item in the keywords column called "Port au Port #1 wells" (It's a local oil and gas well where... -
How do I implement this VBA? Also where would I put the button? I thought you could only put buttons in forms/reports. My goal is to be able to open the links that are shown after a search query has been performed to narrow the results.Leave a comment:
-
Hyperlinks are not working in Microsoft Access 2010
I have a column called "Links" which has many records of website addresses. The data type for this column is set to hyperlink and when I first made the table, the hyperlinks worked. The next time I tried clicking on any link nothing happened. Also, if I edit the text in a hyperlink field and click on it after editing, the link works again. What could be the problem? I should note that I do not know how to use VBA. -
I got it working now, I just created another table with the keywords column as the primary key so there are no hidden fields. The search query is functioning properly.Leave a comment:
-
Seth,
I think you are right, the combo box has a hidden column for ID (Primary Key). Is there any way I can select only the keywords column and exclude the ID column?Leave a comment:
-
Search Query doesn't work with combo box
I have a search query set up to search whatever value is present in a combo box in my search form. I also have a text box that holds the same function as the combo box.
When I enter a value in my text box the search query will return a list of records, however if I select the exact same value from the drop-down list of the combo box, the search query will not return any records.
The list that makes up the combo box... -
Thank you very much! Its displaying all the values now.Leave a comment:
-
Combo box issue on Microsoft Access 2010
I am using Microsoft Access 2010 for a database and I have a list of approximately 700 keywords that I want to add into the dropdown list of a combo box. I have copied and pasted all the words into the values list but only 105 show up. When I try to add another list item to the dropdown menu, the result will not show, implying that I have a full list. I was under the impression that combo boxes could hold more values than that. Could someone help...
No activity results to display
Leave a comment: