Search results

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

So I went ahead and rolled back to a previous version of the FE and BE, and got the same error. You mentioned that you had some problems with logarithmic axes before, do you remember what the issues were?

A bit. But anyways, I do have some (a lot of) backups and I'll try rolling those back a bit to see if it makes a difference.

Honestly this problem is making me consider dumping Access for the FE entirely and switching to VB and some proper BE. There is something just really clunky about MS Graph.

So your suggestion is to fix the problem? ed: Ok I know what you mean. Just not sure how to do that just yet. There is already an excel export option that works great. People want this graph for triage analysis though. There really isn't an alternative to displaying a graph that I can...

As I said I don't think it's a corruption issue. I've compacted and repaired and it still occurs. I've created a new FE DB, a new form, and linked to the tables and it still occurs. I've copied the tables over from the BE to a new DB, created new forms, and it still occurs. Backups have the...

Modifying the axis should not cause MS Graph to crash. And it wasn't so much that I fiddled with the axis. It was opening up MS Graph that caused the problem from what I could tell. edit: And to be clear, there is no undoing it. Creating a new graph from scratch causes the same crash.

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

That's not true, I'm following it. I'm just coming from a very different attitude of what I mean by "calculated". I normally don't have to deal with simple summation, the closest inolved a pretty complex integration. For this one set I had to integrate a time-dependant data series. If the...

I'm working on a new database which will need to regularly display a bunch of values that are derived from raw data in the database. Like, I have x and y and the form needs to show x/y. Usually the calculations are simple, occasionally they are more complex (like one requires a very nasty...

An additional question. When someone enters a value into a min-max search box they can delete the value and the lbox will update correctly recognizing these values as not being used. But I also have 2 combo-boxes, these don't seem to have a "null" option, so unless I programattically reset the...

In Example 1 I'm not sure I understand what the difference in generating those two queries was, was the first one run through hand-written SQL?

well, I figured out how to write the SQL in a non VBA-generated way, not sure how fast this will run, but so far it's pretty good. Basically you just have to switch the AND and OR operators a bit: ..... WHERE ((TGeneralPoly.[Density]>[Forms]![fSearchPoly]![tbDensityMin] OR...

Yeah I was considering programmatically building the SQL string. There's going to be like 30 possible criteria, and I know how to do it fairly well. I'm just not 100% on how to use that as a rowsource for a listbox. Wish I could look at the sampledb, not allowed to download stuff like that at...

I'm putting together a big multi-field search form and was wondering about how to do the criteria. At first I just did stuff like <[forms]![fSearchPoly]![tbI2Max], but then I realized that if they left the field I2Max empty it wouldn't return any results. My first thought is to build an iff...

Quick update, I tried running regsvr32.exe on the dll and that didn't work either. I'm not sure if this is due to being on a company computer that has some strict rules on this thing or not.

Cloning the FE works for me as well, it's pretty straightforward and makes version control wayyyyyyy easier.

I'm trying to use Solver in an Excel template generated from access. I know the code (more or less), but I can't seem to find the reference for Solver. Only thread I found that mentions the reference here is this one...

bumping this again, still trying to figure this out. Just to reiterate the problem the graph will go wonky (technical term) and display incorrect data or data from previous data sets from time to time. When I open up microsoft Chart to manipulate the graph and switch it from "data in columns"...

Edit: Whoops sorry double post