Recent content by emorris1000

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

Its got to be the quotes. Can't believe I missed that :banghead:. You sir are a gentleman and a scholar. Pip pip. ed: I just switched it, it was the quotes. I miscopied it, everything below the first line was the same for both queries.

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

EVERY TIME I have one of these stupid errors I spend 2 hours staring at it and getting nowhere. Then I finally break down and post onto here. Then the glaring error SMACKS me in the face and I feel like quite the idiot. I'm going from column 10 to column 2 in the .values range. DERP

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

The graphs are pulled using a one to many relationship based on the sample ID#. They are indexed on the "one" side of the relationships, but not on the "many" side. I didn't realize you could index on a non-unique-non-primary key field, I will try that and see if it helps. As for Pat's...

Slow means ~30 seconds to 1 minute. I'll give the empty row source a try. Since the slowdown seems to happen when moving the graphs into position I may add the rowsource after the move. CJ, I don't believe I am using domain functions, but could you give some more information on what you...

I thought I should update this since I was able to solve this problem. The problem has to do with MS Graph being a piece of garbage really, but specifically it has to do with MS Graph forcing the PlotOnX attribute into the wrong form. I have NO idea why it is doing this. It may have something...

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

There's no real reason to go EAV with this. Every record has the same properties. I remember one database I built that contained a bunch of recipes. There were 2-3k possible ingredients but only 4-8 were used for each item. This system needed an EAV design (or at least its the only solution I...

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

Re: Varibale Problem in VBA wait so it's throwing an SQL syntax error when you are assigning a value to a string? That makes zero sense. Unless you are using that string name somewhere else as a public variable and its messing with some concurrently running code....maybe? I get mixed up with...