Search results

Hi Everyone, Im stumped and hoping someone might be able to point me in the right direction (or tell me it cant be done). I have created a database to manage Internal Incidents and got a button that sends a generic email to the Investigator and Raiser, using the following VBA; Private Sub...

Hi Everyone, I thought I had mastered everything on my new project, but i'm stuck on my last hurdle! I haven't managed to create anything yet as my mind has gone blank and anything I've tried has failed miserably! I've drawn out the two tables I need to reference, containing example data...

Hi All, I have been working on this for too long now and I am just banging my head against a wall now, admitting defeat and hoping someone might be able to help me! Background is that im making an Internal Incidents database, and each text box is locked/unlocked depending on your Department...

Hi Everybody, Me again, im hoping this is my last question as I have been playing all day and lost the plot haha! I have created a Query that lists all email addresses that need to receive an email notification when we raise an incident in the database. The query is called...

Hi Everyone, This has been bugging me for far too long now that I'm going blind and stupid! Im Trying to do automated access permissions to a database based on the users Active Directory Alias, but want to set 3 user levels being Admin, User and Read Only. I have done a Dlookup for one...

Hi Everybody, It's been a good while since posting on here, but hoping someone might be able to help with my following question, or if it is even possible haha! Is it possible to apply a email background colour using VBA? My current coding that works for the general message is the following...

Hi There, I have been learning more about SQL from a colleague at work and starting to get the hang of it and seeing the benefits from using the normal query designer. I have an issue where the following code works, but it returns the #num! error when the result is zero; Round(Sum(IIf([Last...

Hi There, It's been a little while since I have posted on here so hopefully someone might be able to help me with my predicament. I am trying to create a Complaints Tracker to ensure we keep to our SLAs. I want the database to return a 'Deadline' date for feedback to customer but based on...

Hi there, I've been trying to create a query to like the production BatchID to a Samples record based on when the samples were taken. BatchID is when a batch of pencils have gone through a machine (i.e. what type of pencil, its Shop Order and Release No's, Start Date and End Date). I have...

Hi there, I'm not 100% sure how and if this is possible, but I think I'm going in too deep with this one at my level of knowledge. I have a database where I enter sample results. For each batch, we take 30 samples and inspect each sample for faults. Each sample could have multiple faults so we...

Hi there, I’m sorry if this has already been asked but I’ve been struggling to know what to search. I want to separate out parts of a Lot Batch Number in my database. I have a field called ‘Lot Batch Number’ and their styles are as follows; O123456-1-0-00001 O123456-12-0-00001 I want to...

Hi there, It's been a while since I've used Access and I've gone a bit rusty (not that I was a master in the first place aha). I've created a database to store certificates from our suppliers and I want to create a query that returns the following; Count how many certificates arrived before...

Hi there, I am currently making a material movement database and I want to make a simple button command to return materials when finished with. Basically I have managed to make a command where when I press the 'Create Returns Receipt' it will populate everything I want but the Sub Records are...

Hi Everyone, I have been working on an Audit Database for a while now and basically got it going...until I found a flaw in one of my designs. I have a Form which allows you to update records in a table, and the issue I have is the following; When an isssue has been completed, you enter a...

Hi There, I want to set a rule where employees cannot change the "Status" from "Active" to "Closed" if there is no date entered in the "Actual Closure Date" field. The 2 fields I am trying to create a rule for are called 'Actual Closure Date' and 'Status'. When we raise an incident the...

Hi There, I want to create a button on my form so that once I have entered results of an Audit into the form, I want to be able to press the button to send the manager an email stating the Audit Observation Record ID to action. Is there a way of doing this? This would save a lot of admin if...

Hi Everyone, Stuck on one bit of a report i'm putting together. Basically I have a report that shows any 'Issues' that wasnt closed within the KPI Target. I have the report working, but I simply want to do a count of how many days the observations overran the 'Target Date of Closure'. The...

Hi There, Im a newby to Access (and the forum too!). I have made a database for work and is fully functional, but theres one thing I want to add but cant get my head around how to do it. I have created a Form called 'Filtered Search', on the form it has multiple combo boxes for 'Auditors'...