Search results

  1. D

    VBA, I desperately need help.

    It's all become irrelevant, after much searching and trying I almost got it working then I found out it is very difficult to lock a user out of having access to the ribbon etc. It seems that while you can hide things, add passwords, encrypt etc. some things are still accessible to a user with...
  2. D

    VBA, I desperately need help.

    Isladogs. I've found how to call filterByForm by clicking text with assigned event but once the records are found I can't do anything other than entering a search term in a field box. I can of course click the ApplyFilter button on the ribbon at which time any buttons or clickable text becomes...
  3. D

    VBA, I desperately need help.

    It wouldn't help me giving field names as there will be over 20 and filtering could be done on from any 1 to 12 fields out of 20 or more. Fictitious field names of F1 to F25 in a routine would do and I'd adapt to suit. To be perfectly the build in filter commands work perfectly but as I say...
  4. D

    VBA, I desperately need help.

    Had a look at that info, To me it's all double dutch (translated to Martian by a Klingon lol). Up to now the only thing I have managed to do is the reset filter and have changed it so it selects all records rather than none. I'll keep looking but first impressions it won't give the results I...
  5. D

    VBA, I desperately need help.

    That was an example rather than the actual data names. All data will be entered in to fields in a table and displayed on a form. In total there are 20 fields with a few more required. Object of the filter is to select only the records that match all of the search criteria which could be data...
  6. D

    VBA, I desperately need help.

    I have found that the "Filter by button" option shows as Filter By Form (FilterAdvancedByForm) when hovered over in the Customize the Quick Access Toolbar but I've not been able to run that no matter what I've tried. If I could figure out the correct way to do that then the other commands could...
  7. D

    VBA, I desperately need help.

    I might be able to figure it out if I could convert the built in macros to VBA, that's the ones on the ribbon especially those groups in the Sort & filter section.
  8. D

    Hi from East Durham, UK

    Access 2007 but can't find an action in the macro actions to do advanced filtering, clear all filters or toggle filters and can't find the code for the ribbon buttons
  9. D

    VBA, I desperately need help.

    Assume the database is a list of photos. It could contain the following (and more) Title Location Photographers Name Camera used Lens used Thumbnail of photo Option Box, select radio buttons for landscape, cityscape, portrait, nightscape (one option only) Option Box, select radio buttons for...
  10. D

    Hi from East Durham, UK

    Tried that, feet didn't even get damp as I could only see a same number of actions, none of which did what I need.
  11. D

    VBA, I desperately need help.

    I don't know how best to do what I want. I can do what I need to by using the sort & filter commands on the ribbon but as the ribbon will be hidden (plus I won't want people to have to read or remember the steps every time) I need it to be automated. I don't know exactly what you mean by STATE...
  12. D

    VBA, I desperately need help.

    I have built an Assess database with various forms and in the process of expanding it to cover everything I need to do with it. I'm at the point where before I proceed I need to be able to select a group of record. There are about 30 fields in each record, some of which contain data from...
  13. D

    Hi from East Durham, UK

    Hi everyone, Thanks to the admin for letting me join. I've just started with access but have used other database programs in the past. I'm a complete beginner with VBA and it seems that to do any automated task in Access you need VBA. I'm from the north east of England and have used computers...
Back
Top Bottom