Search results

  1. M

    Zoom function crashes DB

    Ok so i have done this and set the double click event to open the notes form. Any ideas how i dynamically anchor this to the relevant line in the dataset?
  2. M

    Zoom function crashes DB

    Yea i did consider this but thinking i wanted something less cumbersome lol
  3. M

    Zoom function crashes DB

    Hi All Trying to get the zoom function to work so that my team can expand a notes field to read the full detail. i am using the Shift + F2 function and the moment but will implement the VBA once it works. so some screen shots. This is the split view form that i use (i have redacted the...
  4. M

    Expanding Note Field

    Any chance of this? this could be really helpfull. Thanks
  5. M

    Pop up when record is changed.

    Ok thanks. Will need to do some research and learning on this. Aprreciate the suggestion.
  6. M

    Expanding Note Field

    Thanks, i actually prefer the pop up option. this works well apart from it crashing lol
  7. M

    Expanding Note Field

    This would be good if you could.
  8. M

    Expanding Note Field

    Thanks for that. Not quite sure why yet but when i select the font button it just crashes and closes the DB.
  9. M

    Pop up when record is changed.

    Hi All so i have what i believe to be a complicated and probably an impossible thing to try and impliment. Background I have a job progress tracker that is updated by multiple users in multiple sites. it controls access through a log in feature. There is a split form view datasheet that pre...
  10. M

    Expanding Note Field

    This is a great feature! However, when i double click on my notes section the popup is too tiny to read lol. Is the size and layout adjustable?
  11. M

    Calculations in text boxes

    Sorry i should have said. The 3 options are selected by combo boxes. There is a table that holds the 3 options that the combo box uses to create the selection so spelling etc will never be an issue.
  12. M

    Calculations in text boxes

    They are all in the header Can you post examples of yours?
  13. M

    Calculations in text boxes

    I did fix the standardisation just to check. Its difficult to post here as it links to a sharepoint list with sensative data etc
  14. M

    Calculations in text boxes

    Yea, they were thrown together as a test of concept lol. If i can get it working i will standardise them.
  15. M

    Calculations in text boxes

    Hi Everyone. Need some more advise please. I have tblA which has a filed for NPS. There are 3 possible entries to that field, Promotor, Passive and Detractor. These are inputted by the user. i now need to calculate what the NPS score would be and display it in the split view form. I would...
  16. M

    Time out

    Hi All I have a db with a front end that user log into. Is there a way of measuring inactivity time and running a log out code after a specified time frame?
  17. M

    filter a form on load

    Very true The frmUserList is a form based on qryCusrrentSiteUsers that filters the tblUsers using a tempvar for the site that the user is logged in as. I have a similar set of queries that are first filtered by the site, then by the user name, then a click to update function based on a number...
  18. M

    filter a form on load

    Sorry, i did i just wanted to get it working before i played with the syntax. I have already changed LastName to UserName as this is unique to each user. Still cant work out why it doesn't work tho.
  19. M

    filter a form on load

    The code The error Any ideas?
  20. M

    Exclude data when appears on other tables

    Couldnt agree more, however our opperation and management sytem we use makes that impossible.
Top Bottom