Search results

I have a database that is designed with a front and back end, with the FE linked to the BE. Some potential customers want to play around with the database, and the easiest way for me to get them access to it would be for me to combine the FE and BE and just give them a copy of that. Long term...

Howdy I have some custom shortcut menus that will call some functions. In the past I've always used functions that don't take any inputs, but I'm trying to use inputs on these functions and it doesn't seem to like it. here's the code: Sub fRunDataGraphC2Flow() Dim cmbshortcutmenu As...

I'm getting a syntax error on some SQL that is throwing me for a bit of a loop. This code throws a compile syntax error: Me.lbSearch.RowSource = "Select [General Data].PolyID, [General Data].SupCatID, [General Data].C6C2RatTarg, [General Data].H2C2RatTarg, [General Data].Productivity...

Got a real strange one here. I'm sure its something obvious, but I can't figure it out. I have a graph in excel I am building (from access). Here's the basic code: xlbook.Charts.Add xlbook.ActiveChart.ChartType = xlXYScatter RemoveUnwantedSeries xlbook 'custom function that strips all...

I have a report that lets you select which graphs you want on it and then it generates the report. To do this it has every possible graph in the upper left hand corner of the report but they are set to 'visible = no'. If they are selected they will be made visible and then moved to the...

I'm working on a database right now that has some very intensive graphing. And let me just say, I DESPISE MS graph. It is glitchy and outdated software with ridiculous limititations (3999 rows/records max per graph). So does anyone know when they are taking it out behind the chemical shed...

Having an issue with an R1C1 call, thought you guys may have some idea what I'm doing wrong here. .Range(.Cells(2, 2), .Cells(Seriescount + 1, 2)).FormulaR1C1 = "='ProcessData'!RC[14] / 'ProcessData'!R2C15" Apparently just putting the R1C1 into excel it doesn't like it either. Its...

Howdy I have been working on a database for a while now and just did something that made my life temporarily easier, but I feel might bite be in the butt later on. Everything was backed up before I did this (at least I've learned that much) I have a table called tGeneralFilm that contains a...

Howdy I finally got tired of having 100 macros managing my different custom shortcut menus, and decided to figure out how to generate the shortcut menus programatically (because lets be honest, Macros are the devil.) I found a good tutorial here that I suggest anyone trying to do this should...

So I have a report that is used to print out a bunch of graphs about some data. Right now there are something like 11 graphs. At the end there will be 15-20. The graph report is opened through another form that designates which graphs you would like to see, so you can customize the report...

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...

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...

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...

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...

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...

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...

I'm trying to clean up a form a bit and have it only show certain subforms/graphs if the data exists. I already have columns in a combobox query to show an "X" for if certain data appears: Now, I know I could build another query and have some system go through and identify these things, but...

[SOLVED] Graph Crashing (Microsoft Office 2010 Component Has Stopped Working) I've been getting some truly aggravating errors on some graphs recently. It's a simple XY Scatter graph. I'll set it up with the x and the 3 y variables going through the design wizard. When I go to view the form I...