Search results

Well, I solved this with a series of nested queries, and I'm not super thrilled about them. Part of the reason is that they are nested subqueries, which I have heard bad things about. Secondly, while these queries work, I'm not sure they should be able to since I didn't alias a table in the...

I'm trying to build a query that will normalize some graphical data along the x-axis. To do this I need all the peaks to be at the same point. I'll just talk in generic terms of FieldX and FieldY for the X and Y variables (resp) In my mind the steps require me to 1) Determine FieldX at...

Thanks for that. I decided to (on a whim), just stick in like 4k and it moved it down somewhat. I had tried 300 before, but I guess that wasn't enough to notice it.

That kind of seems right, but the graphs are all on one page. It will repaint graphs on the page that I can currently see as I move down the page. It definitely seems like a memory/cache issue, as this report will occasionally throw a memory error (which is a problem on my end from what I can...

I have some graphs on a report that I need to dynamically position. The user selects which graphs he wants to put in and then the reports repositions the graphs based on input. I've been using the following code to move the graph: reports!rpoly.gGPCMWbyDRI.top = 3.625 which compiles...

There aren't any mouse events.

So whenever I scroll through my report it will repaint all of the graphs and other stuff on each scroll event. Its pretty fast, but it still looks pretty bad. Any ideas on what's causing this? My only guess is that there are enough graphs on there that its handling too much data, but its...

Works like a charm. You sir are a gentleman and a scholar. PIP PIP.

Turning Enabled to No removes the double click problem, but it also removes the context menu I built for it. Locking it doesn't change the response. Was worth a shot though

Whenever I double-click a graph in a form that is being viewed it opens up MS Graph in edit form. This is confusing/ugly/etc and I don't want it to do that. I tried adding some code to the double click event to make it do some other action (bringing up some graph modification tools I...

Thanks much

That's interesting, I didn't think people added menus like that. I just did it with the Macro's and tied it to the "shortcut menu" property (this is in 2007/2010). I'm not really sure about managing the context menu this way since it's so radically different from how the rest of mine are...

When you haven't added a custom context menue to a chart you get an option for "copy" which gives you a nice chart you can move over to word or wherever and then manipulate further. I've added a custom context menu to the graphs, but I would really like to keep the "Copy Chart" option that...

I should know how to do this :banghead: I need to have a combobox (cboxNB) update its selected value to match another field (NotebookNum). I've tried this: Me.cboxNB = Me.NotebookNum didn't work I know this is super easy, I just haven't done it in years. Anyone want some easy...

I have been having some strange problems with graph errors that can be found here: http://www.access-programmers.co.uk/forums/showthread.php?t=245033 (not necessary to read to help with problem, unless you want to try and tackle the underlying bug.) Now, I've found a workaround that fixes...

So I'm still having crazy problems with this issue. Any legit assistance that goes beyond the trolling above would be appreciated. EDIT: OK, I THINK I found something. This seems to be partially related to a command in MS Graph called "Plot on X Axis". *I THINK* that, for some reason, MS...

OK. So I found the object model for this under an old VB model and was happy to see that it works here as well. To select a secondary axis you use: .axes(2,xlsecondary) The 2 means "y". so for a secondary x-axis you would use .axes(1,xlsecondary) Now, what this doesn't do is tell me how to...

Howdy all, 2 posts in one day, so you know I'm having fun. I have a bunch of charts in my forms, and my boss wants to be able to adjust axes. I have added a context menu that brings up a little form and takes values that are then thrown into the graph by way of a function. I've copied some...

you could have a button that opens a hyperlink...I think.

I was having some difficulty figuring out how to do that. For some reason calling Me!subform![field] was yielding data even though it should have been null. I think this has to do with how it was bound to [field]. Anyways, I figured out a simple duct tape solution, so far it seems to work...