Search results

I hate to bump, but... Anyone have any idea how I can make that 4th slice grey? Thanks

I’ve got a simple dataset that will ALWAYS have 4 rows, against which I have assigned the colours Green, Amber, Red, Grey. So I made a simple pie-chart to go on the report, but I can’t work out how to assign the same colours. Please see 3 attachments showing the current layout, the preferred...

Thanks for your reply and sorry for taking a few days to get back to you. I came to the same conclusion as you, that it would just HAVE to be done in portrait. So we dispensed with one column that we decided was not absolutely crucial, abbreviated another, and moved a third to to a sub header...

Hi, Is it possible to have part of a report set to portrait, but another part set to landscape? Like you can in Word by adding section breaks and setting the page layout separately for each section? I have a "MainReport" comprised of 5 sub reports which are all portrait. Now I've been asked...

Ahhhh... Nicely done! Yes, that works perfectly now. And I see you don't even have to specify ASC for ascending as it takes that as the default. Thank you so much, that helps out a lot! Pat

Hi, Stripped down copy attached. On the subform of the opening screen, click and re-click the Substantive Employer button and you'll see that it works fine. Now click and re-click the Surname button and it works only the first time. Apologies for the frankly ludicrous field names!! I didn't...

Thanks Paul, I'll give that a go this afternoon. I'll need to import the data from sharepoint into a table in the database, and I'm just off to a meeting soon so it may be a couple of hours before i get back to you. Pat

Mine's on a continuous form too, though not in a combo. It's in the On Click event of a transparent button which I have placed over the Surname header. That's exactly what I've done with the Employer header and that works fine. In this one however, I'm attempting to sort by Surname and by...

I wondered that too so I moved it but it's had no effect. And I moved it in the first block of code too but that STILL works, so it doesn't seem to matter.

I've got two buttons in the header of my form, to allow the user to toggle the sort order via various fields. This first one below uses a single field and works fine. The second one however, uses two fields and does not work Private Sub cmdSortEmployer_Click() Me.OrderByOn = True If...

OK, I see the problem. You relied on the pie-chart to "provide" the percentages which it does quite nicely because it knows everything must add up to 100%. In a bar-chart, it doesn't know that there won't be more data, so it won't calculate the percentage for you. See attached screenshots of...

Did you create it as a pie-chart first and then change it? If so, it sounds like something went wrong there and you might be better off starting over with the chart wizard. It would also help to know a bit more about your data, because I don't understand why everything is 100%. Can you post a...

Everything's 100% yet the bars are all of different length? That is strange. I could be wrong about this but I think you might have selected a 100% stacked bar chart. If so, it's worth trying the following: Design view > right-click chart > Chart object > Edit Right-click chart again >...

Hi kevlray, That worked - exactly as you said it would. I never even knew what Administrative Tools were, but I changed F to K, plugged in my USB stick, tested one of my Access apps and it all works fine. Thank you so much! Pat

Wow you must have been typing your message at the same time as me! I'll take a look there. Thank you!!

Just some further info...yes, F is my DVD RW drive. Anyone have any info on this? I guess the weekend's a bad time.

I have an encrypted Kingston USB drive which I use on a computer at work and on another at home. Some folders on my USB have Access front-ends which link to a back-end database in another folder on the same USB. At work, when I log onto the USB it uses two drive letters F and G. G is where...

Sorry Michael, Based on your original question I seriously underestimated your report skills. Looking at that example, you seem to generally know what you're doing! I'm having a little trouble following what you actually need though. If two samples had different comments, would you have...

Others may have a different opinion on this, but to me this sounds like a poor report layout. If there is data specific to a single record, then that data needs to be in the detail section, or if you want to go the extent of grouping on every single record, perhaps in the group footer (I...

Oh good call! I should've thought of that myself. Thanks CJ.