Search results

The youtube video posted a couple of pages earlier says that because of the income from their land the UK taxpayer makes a net profit from the royal family. But why is it "their" land? Only because their ancestors strong-armed it from the peasants. The people who farm that land could well be...

This is the post that should have been linked http://www.access-programmers.co.uk/forums/showthread.php?t=260840 I'd love to find a way to make this possible - though it would need to be reasonably simple!!

Yeah...that's weird. Have you tried adjusting page margins a bit? Or removing some controls to see if that makes any difference to the print behaviour? It might help narrow things down. Have you tried printing to a different printer? Or can you upload a copy of the database, with fake data...

Oh...and take a look at Bob Larson's excellent site http://www.btabdevelopment.com/ts/samples "Cascading combo sample" about halfway down. I've learned a lot from Bob!

What you're asking for is called a "cascading combo". You select a value form one dropdown and then that changes the values that are available in the second. E.g. if you select "Customer A", you get to choose from Adam, Andy, or Anne, but if you select Customer B, then you get to choose from...

Do you really NEED pictures? My approach to this is: Use a calculated field (in the report or - my preferred option - in the underlying query.) This calculated field would return the values Green, Amber or Red. Bring that field onto your report and use conditional formatting, colouring it to...

I firmly believe that assisted suicide SHOULD be legalised in very strict circumstances. I'm still appalled by how Tony Nicklinson was treated in the UK and there has been a similar case in Ireland recently, although this story does at least report that she died peacefully. A civilised country...

Hi, I think I have a solution. I'm no expert and maybe there are better ways of going about this, but please see the attached database. There are two copies of the table, so you can verify for yourself that the right records have been removed, by comparing both afterwards. I created 10...

Thanks for that - I must have been googling the wrong words! Most of this seems way above my level, I have to admit, but when I get home I might try downloading the beta and having a play. Then I'll still need to convince our IT dept. I was hoping it would be easier, but nothing worthwhile...

Hi, Some colleagues have started using a shared Google spreadsheet on Google Drive, which is working quite well for them. It's basically a data store, with just a few calculated columns. Is there a way to link that sheet to an Access database? I know I could download it as an Excel or CSV...

Ha ha....someone as busy as you are...that's gonna happen!

Hi - Sorry for taking so long to come back to you. Lots of other stuff intervened over the past week! OK, so I DID completely misunderstand the -3. Asking that question was probably my smartest move so far :o I'll see how this report looks in a few weeks when it's time to include January...

Wow, that's very clever!! I don't want to report January yet (not until approx mid-Feb) so I have changed <= to < and it works perfectly. But can you explain what the -3 is for? Does it mean that there are three months where there is no data? So next month I would change it to -2? (assuming...

Hi namliam, Thanks so much for getting back to me so quickly. You have solved the problem of the gap in the data, but now there is another problem. I realise I didn't explain this requirement properly the first time! Your solution means that the cumulative total is carried forwards until the...

Hi, I have attached a stripped down version of my database which holds the dates that patients were enrolled in clinical studies. The requirement is to show the cumulative monthly total in a chart, also including a cumulative target line. Take a look at the report and you'll see I'm 99% of...

I work as part of a clinical network, interacting with colleagues in different organisations with different IT setups, and we use various SharePoint lists for collaborating on fairly basic datasets. To improve data validation on a particular list and for a better look-and-feel, I constructed a...

Hi, I've just tried this on another computer and it DOES work. Same office, same version of Windows and same version of Access but there must be something different on my PC. You are completely right, I previewed the report again, went to design view and then the report had four slices (also...

Thank you for your patience. I'm using Access 2003 in Windows XP professional, I wonder if that's causing a problem. I'm confused though. When you first opened this database was that section of the pie-chart ALREADY grey? If not, which step changes it from blue to grey? You are downloading...

Thank you for your help. I can see that you have made the 4th slice grey, but HOW did you do that? In print preview I see 4 slices, but one of them is blue and I cannot see how to select it. In design view I see only 3 slices, so once again I cannot change the colour of the 4th. I tried...

Hi, Thanks for your advice. I have designed, saved and previewed the report several times, but nothing seems to make any difference. Or are you saying that it should be previewed within the Microsoft Graph screen somehow? When the chart is open is design view, I can see THREE slices and I...