Search results

Hi there. No Alias is a Short Text field that I will enter the Windows Active Directory Alias for that user (mine for example is randalls)

Thank you for your quick response, unfortunately that didn't work. I don't know what i've done wrong but even my original code don't work either now ha-ha. My original full code is; Private Sub Form_Load() On Error Resume Next Dim Flag As Integer Flag = 0 'Hides all fields Me.Label0.Visible =...

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

Yes the Desktop Application. Apologies I do forget there's a lot of web based apps now ha-ha!

Hi There, Thanks for the advice, I will have a nosey at .htmlbody. I have no experience in this so this will be interesting haha! All the best Stuart

Hi There, I am using Outlook as part of Office 365. All the best Stuart

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 arnelgp, Thank you so much, that has worked a treat. I don't want to be a pain, but are you able to explain the VBA above so hopefully I can learn from it going forward? I don't want to be one to keep asking for solutions :) aha All the best Stuart

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

Absolutely spot on, It works perfectly! You sir are a star and have made me happy at the end of a crappy week trying to get this sorted aha! Sorry if you got my last message where I mentioned I had issues, it was my error! :)

Many thanks for the detailed response, im having issues when adding the Dlookups to the Control Sources as it keeps returning "The expression you entered has an invalid date value." I did adjust the format from mm/dd/yyyy to dd/mm/yyyy but still same issue.....I'm lost now aha!

I don't have any SQL as I don't have a working query.

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

Also big thanks to you JHB, I've used your method on another section and works perfectly :)

Mark, absolutely spot on mate! I can understand how you've achieved the result in the end. Apologies for the hard work of explaining what I was looking for, I'll keep this in mind in future. :D

Thank you for laying out the sample data clearer, apologies its not very often I put examples together. I have highlighted the results and tallied them up in the count box (please find attached), I hope this helps. :)

Apologies I totally messed up my question and got to admit it isn't really clear. I have attached a spread sheet hopefully explaining the requirements, hopefully it helps. I have removed the word 'sheet', that was a typo on my part

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

Would you know if its possible to use the results from the LEFT and MID expressions as a filter of a query? When I try to do a simple filter, it errors stating; "syntax error (missing operator) in query expression 'Shop Order'"