Search results

Amazing endurance, and outstanding expertise. All in one package! Thanks for teaching me so much via your responses to other people. :)

Well, I'm a complete scifi-fantasy junkie so I'll limit this to some authors not previously mentioned. There's some great stuff mentioned previously, and some stuff I got bored with pretty quickly. Genre: SciFi Lois McMaster Bujold - Vorkosigan Saga Essentially a 'space opera' series. One of...

Perhaps I phrased it poorly. Just to clarify. My original code produces a chart (attached to post 15) which is a line - colmn chart type. The first example of yours that I was referring to was the first example chart - also a line column chart type. I was suggesting you set the chart source...

oops...I see you already figured it out :) Good thing to know :)

I don't know if it makes any difference, but the charts produced by my code are column -line as per your first example (see attached for what my chart output looks like). I have With xlChartObj .SetSourceData source:=xlSourceRange, PlotBy:=xlColumns .ApplyCustomType...

It's a classic 1 to many situation. That indicates two tables to handle that relationship, and another to use as a lookup: tblSurvey SurveyID (autonumber, pk) SurveyDate SurveyLocation etc etc and another table that contains a list of species tblSpecies SpeciesID (autonumber, pk) Genus Species...

The most obvious issue I see if that you need three parts to an iif 1. A logical test 2. What to do if test evaluates true 3. What to do if test evaluates false IIf([Category]=4,[Concentrate]/99*[Quantity]) Only has parts 1 & 2. Have you lookeed into the switch function instead of using...

Sorry. I've never taken much joy from other people's turmoils. It seems pretty shallow to me to make light of something that has to be highly upsetting for some of the folks involved. Given time, maybe. But while the emotions are still raw it just strikes me as extremely poor taste.

That's actually the most revolting sentiment I've heard expressed in this, IMO, sad situation.

Well, that's good to hear :) 15 minutes is still a long time to sit and twiddle your thumbs though!

Keirnus, Sorry. I don't know of a list such as the one you asked for. Maybe try Excel's vba help for those numerical equivalents. I really never got the approach in M$'s example to work for me. The approach I took came from somewhere else, originally, and it works for me. DJkarl has the...

To reverse the order, you'd change the <= to >=, and probably change the Order by for ABS to DESC. SELECT MyTable.MyDate, MyTable.ABS, DCount("*","MyTable","[ABS]>=" & [ABS] & " AND [MyDate]=#" & [MyDate] & "#") AS Rank FROM MyTable GROUP BY MyTable.MyDate, MyTable.ABS...

Your best bet is to go into excel, start recording a macro, then make and format the chart you want. Stop recording the then take a look at the vba in the macro. Take that vba and use it inside the access vba module after you're opened the excel object etc as per the code I posted. That should...

Index's help by creating a very fast way for the db engine to find records. Think about scanning through a table, line by line to find a value. That's your db's situation without an index. Each read of each line is an operation that has to happen. Now, for comparison, consider if someone had...

Not that I am aware of....about the only thing I can recommend doing is to create an index on the date and ABS fields. This may improve performance. Also, if the data is going across a network, this might be slowing things down too. VBA is almost always slower than SQL. You may have to live...

As my father once told me, Bob: Nil illigitimi carborundum ;) (or more correctly: Noli nothis permittere te terere.) All the best.

No problem....I agree with you. This exercise does veer into the arcane, somewhat. But it is nice to know it can be done. :) I tend to record a macro in excel to figure out what the specific vba for manipulating the chart/spreadsheet should be, then copy and paste that into the Access module...

Well, for starters, having a field named Date/Time is an extremely bad idea. The slash mark is a special character and can cause odd things to happen. Try changing your table name and field names to something that does not use spaces, and does not use special characters. It may take a while...

Any chance you're thinking of the wrong forum? Do you moonlight over at UA perhaps?

How rude, pointing out my ignorance like that Bob ;) Thanks for the correction. :D