Search results for query: *

Thanks pjadie! That improved the look of the array and got rid of the duplicate values. I guess I was effectively pulling an array into an array? Array result using mysql_fetch_assoc is now: Array ( [0] => Array ( [blkyr] => 1264 ) [1] => Array ( [blkyr] => 1293 ) [2] => Array ( [blkyr] =>...

I have a series of queries that, according to a number of conditions submitted on a form, only ONE of the queries will execute. That's working fine. I then put the result of that query into an array. It's only one field that I want, but there will be a variable number of records returned. I...

*LOL* ok, well now I'm thoroughly confused... but I will make the effort to dissect what you're saying until I get it (the terminology is all new to me so I have to go very step by step).

PHV, yer wunnerful! It didn't work initially, because it didn't like the "A" notation in the first Cells(), but since A is a constant I just changed that to '1' and it worked. Complete code is now: Sub chartadjustment() ActiveSheet.ChartObjects("Chart 11").Activate...

Is it a question of where in the macro I'm putting the line? To test the above I put it directly above the 'end sub' line. Maybe it makes more sense to have it earlier in the macro?

Skip, that looks good to me, but throws an error: Run-time Error: 1004 Method 'Cells'of object '_Global' failed

PHV - in the same sheet - "DIAMETER REPORT" Thanks Skip - not quite what I need though (but I'm copying that syntax down for future use - thank you). Maybe an example to make it a bit clearer: Current value of C6 = 2 (2 data sets to graph) Start of range = A42 Data is arranged in columns...

Hiya. I have a spreadsheet which produces a pretty chart based on a bunch of data thrown at it from Access. The number of rows of data the chart needs to show varies, according to the selected output from Access. At the moment, with a fixed data range, the legend shows symbols for a full...

Cool, thanks sleipnir - I've got a support ticket in with my host to see if they can shed any light. Fingers crossed.

Thanks sleipnir214. I thought that might be the case. Along that localhost line, I have some further progress: Occurred to me that the new test members I had been trying to set up were using addresses at another of my sites, hosted on the same server as example.com. So have tried setting...

I have a website hosted on "SiteHost1", but the email is handled by "MailHost2" through an MX redirect. General email is working fine and dandy. The problem is that the PHP Mail script that I use to send emails to new users I have registered on the site is no longer working. In short emails...

:) Hiya TheAceMan1 hmmm.. could do. Would the user have to manually select from both columns? I can't have them increasing their data entry, plus the risk of errors is huge any time I give them any leeway. Or are you envisaging the second combo auto-populating from the first somehow?

Eureka! Found it. Turns out it's dead easy. In the text box you want to capture the hidden field in: =[comboboxname].Column(2) - where (2) is the number of the visible column you want to capture. ie, if the bound column [bin id] is set to zero width (which it is), then [bin weight] is...

One of my forms has a combo box for 'bin type', which has three fields in the combo box: bin id bin desc bin weight 'bin id' is the bound field, which is correct. However, I'd also like to be able to make use of the 'bin weight' field on the form. Specifically the form is recording the...

Ken, yer a pearler, mate! (that's a good thing, btw). Thanks for that.

That's it in a nutshell - I have a table where I want to show the sums of a list of items, but also show the percentage each of these items makes of the total. Now, I can achieve this simply by dragging the 'value' field into the data area twice - formatting one as 'sum' and one as 'percentage...

To open a form when the database is opened, create a macro and save it as "autoexec". Macro Actions: Openform - select the form you want to open. Maximise

Hi cdagenais Yep, actually we did find the solution. It was originating from a simple subquery in one of the queries this query was based on. The answer in the end was to simply make the subquery a saved query in its own right, and then include that in the next query up. Here's the thread...

Like you, nwdurcholz, I'm a jack of all trades in a position that grew because I was here. I 'invented' a title.. IT Specialist... primarily because we already have another 'specialist' in the company (totally unrelated field), so it wasn't an unfamiliar-type title to use, and it also avoided...

willir - I suspect your sales rep has become my boss. I get that pretty regularly. :) I'm working on something of a template now that I hope will give me a firmer base to quote from. heh... and I suspect along the way it will open the bosses eyes a bit when he sees how many bits and pieces are...