Search results

You my friend are a lifesaver! I like to research myself and try and learn myself before caving in, but this was doing my head in aha! Thank you :D

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...

Sussed it!! SELECT [Certificates Query].[Supplier Name], Sum(IIf([getcert]<0,1,0)) AS [Before Delivery], Sum(IIf([getcert]>=0,1,0)) AS [After Delivery], Sum(IIf([getcert] Is Null,1,0)) AS [Awaiting Certificate] FROM [Certificates Query] WHERE ([Certificates Query].[Arrival Date]) Between...

Okay I should have thought about this next request before I submitted my original question. I want to add a date range into the query (i.e. Certificate Stats based on deliveries between these dates, or show all deliveries if left blank). I've got part of it working, but I can't seem to group...

Thanks to both of you for your replies, I tried CJ_London's response first and it returned what I was after! Thank you loads as I would have been sat here forever trying to work that out. :)

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...

Made the relevant adjustments and running with no errors, but still not populating the Subform.

Cheers, I've gone blind on the coding after staring at it for so long! Changed it and now getting the following (highlighting the section I just took the apostrophe from); Run-time error '3346': Number of query values and destinations fields are not the same. :banghead:

Thanks for that. I have been playing with the code on the webpage, the main Form information is transferring to a new record as I want it to, but it's not copying any of the information from the SubForm. Here's my code for reference, any idea where I am going wrong? (Please Note: I have removed...

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...

You sir are an absolute legend. I am gradually getting the hang of VBA but keep confussing myself. I was writing something basically to do what you wrote, but looks nothing like it haha! Once again, thank you, it's been doing my head in for a while :banghead: :D

Thanks for the feedback Ben, if I change the Master Query to link Status to Issues, what should I do as an 'After Update' event to get the database to automatically chance Active to Closed when a date is inputted? Again, thanks in advance :)

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...

Sorry for the delay in getting back in touch, have been on days off. That worked a treat! Thank you so much for your help :)

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...

I've never done something like this before so apologies for sounding stupid. How would I write this and where? I am guessing from what you have wrote about I need to write something along the lines of; "Please note that an audit has been carried out. Please review Audit ID" & Me.ID & vbCRLf...

Is there a way of it just entering the ID into an automated email, for example; Dear Joe Bloggs, Please note that an audit has been carried out. Please review Audit ID 99 and provide feedback where possible. Kind Regards John Smith

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...

I was being an idiot and entering it in the wrong area. Issue solved. Thanks for your reply :)

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...