Search results

As it happens, I have sort of returned to this one - the Count to only show those with no accidents seems to work just fine. However, I now have a second, very similar query where I have used Sum to add up each individuals accident totals - but, the Nz function is not working, which makes me...

I can see how the tickbox would work, having used it before - does make it very easy to query the data - however, with up to 150 options, I worry that it may swamp a user? Your app looks good @ridders - way more than I need though. Ours would simply be the first half (TW1, TW2, W4 etc); very...

Fantastic advice, thank you :) It won't be today, but I will do this and post back. Cheers :)

I used tick boxes on another database in this way - bound to a field in the underlying table which made querying really easy - adding a route, however, meant having to change forms and reports to match, which was laborious; I suppose this time, there will only be a couple of forms and a couple...

I am curious now - I currently don't have the OnAction against any of them, so they are not calling on any functions, but it is working fine??

As some of you already know, I work in public transport, and I am thinking ahead about creating a database that will allow us to keep tabs on disruptions that occur on our routes; some disruptions will affect one route, some will affect multiple, and a few will affect all. We have 120+ route...

And commenting out the functions for the actions, they all still work too :)

Interestingly, I didn't put an action in for Word, Copy or Paste - yet they are all working.....

Ah, I get it now - make it a public sub in a module. Works fine now, thank you for your patience, and my apologies for being thick.

Where do I actually put the sub then, as it was in the code for that one report, and I would like it to be available to all reports?

It will be deployed as runtime eventually, but I am currently running it with 2010 OK, I have put vbShortcutMenu in the Shortcut Menu Bar, where then do I tell it to load that shortcut menu bar? The last time I did this (admittedly some years ago), the OnLoad event had CreateShortcutMenu which...

OK, after a bit of faffing around, it now fires the save as excel function as the report opens. I think the problem lies with this line - Application.CommandBars(MenuName).Delete It doesn't delete the embedded shortcut menus because the CommandBars function is depreciated?

I don't have a lot of time to play with, and this was purely a nice to have :) The shortcut menu does not appear at all, despite the code running through - I have it as an OnLoad event in the report

Still doesn't work - no matter, I will just put a command button on the dashboard to export directly to excel. Nice of them to remove our ability to make things easier...... Thanks anyway guys :)

Access..... helpful......... Hmmmmmmmm......... Not often those two words are in the same sentence! :D

Ah, well as long as I can have the export to PDF, word and excel options I am happy. Thanks

Thank you both - working perfectly how. I did have the text box formatted to two decimal places, fixed, and that was working in terms of the display - - however, when I referenced that textbox in a text string, it was coming up with the weird numbers for those that were very low.

I have a text box which is calculates an individual's average number of accidents per year (Total Accidents/Years of Service) - I have this rounded to two decimal places. That text box will be hidden, but the information from it will form part of a text string that is visible. Some people, who...

I don't remember having to do that before :confused: - has something changed within Access with respect to how this works? Your suggestion looks spot on though, and will certainly do what I need it to - thank you :)

I have a database that when deployed will be used mainly via the Access Runtime environment, and therefore the features to export reports to Excel, Word etc will not be available. In the past, I have used a custom shortcut menu, code as follows: Dim MenuName As String Dim CB As CommandBar Dim...