Search results

  1. M

    DB Linked with SharePoint No Longer has the Option to Use the Create E-Mail Facility

    Hi, I'm working with my first SharePoint linked DB, which is an experience, and noticed that I can't use the 'Create E-mail' facility on the external data tab anymore. The point of the DB is to manage global contacts, which I want to do by providing people with access via SharePoint but also...
  2. M

    How can I send an Outlook email based on a list of emails in an Access query?

    Hi, I've setup a selection form that returns a specific list of email addresses in a query. What I can't work out is how to press a button and have the email addresses populate the To: field in a blank Outlook email - I don't need any bells or whistles. I thought it would be simple but I'm...
  3. M

    Setting parameter labels is causing my query to return no data

    Hi, I'm losing hair over this one so any help would be very welcome. My parameters are linked to a form and say: [Forms]![FormName]![Field] or [Forms]![FormName]![Field] Is Null Ordinarily this works fine in returning either the selected value or all values if left null. I need to pull in...
  4. M

    'You do not have the necessary permissions' just appeared on a working DB

    Hi, I've looked in a few places for answer to this but not found the answer yet. I'm running Access 2010 but using an .mdb to maintain user level security. For the most part everything is working as it should. I've rolled out a new version of the DB for 2014 (don't ask, but it is necessary)...
  5. M

    Error when trying to link data between Access and Excel

    Hello, I'm trying to pull data into Excel 2010 from Access 2010 (running as a 2003 .mdb), which works fine on all but one database and I can't find the reason. On every other .mdb or .accdb I use I can link up via the wizard easily but this specific database makes a Data Link Properties window...
  6. M

    Need to prevent people entering a return when they paste data

    I've just come accross a problem where pasted data dissapears from view. It's caused by people being a bit careless and copying the line above (from word or notepad for example), which adds a return and then the data drops out of view. I really want to create a validation rule to make it...
  7. M

    Automatically log users off

    I'm looking for a way to log users off either instantly or when they have been inactive for 10 minutes, any help would be much appreciated. I've found a couple of online examples but after going through the various steps (closely I think) I end up with errors. I expect there are posts here...
  8. M

    Validation rule doesn't recognise a hyphen as text

    This is my first post so hello :) I'm struggling with a validation rule that almost works but not quite. I want to restrict the values in a feild by characters between 0-9, A-Z, _ and - Using the following string works for all except the hyphen, which I assume is because it's an operator...
Top Bottom