Search results

Hi all! Recently got some help with the following code (thank you arnelgp!): =IIf(Date()-30-[Field1]<0,Abs(Date()-30-[Field1]) & " Days before approval","30 days target has elapsed") This allowed me to develop a reliable countdown timer based on a date set in Field1. Users enter a...

Hi all! I have one (field1) whereby users enter a date, and then I have another (field2) which shows a countdown timer (of sorts) which counts down from -30. The justification is the data that has been entered must be approved within a 30 day timeline. I use the following code on Field2 in...

Hi all! Wondered if somebody could help me... I have 26 fields on a form that require manual data input. I want a progress bar at the top of the form to show the user how much % they have completed, as I want 100% completed data per record. Can find plenty of threads on progress bars, but...

Dear All, I require your vast, collective intellects! I have the following age calculation query: Age: (Now()-[DOB])\365 It works a treat! However, I do not want this to continue to caluclate if the record has them as deceased - I want it to stop at their date of death. I have a tick...

Hi all, ...maths never was my strong-point... So, I'd like to populate some fields with a count of the amount of times a specific answer occurs in a range of fields. For example, I have 5 textboxes on a form, with possible answers A,B,C,D: TB1 = A; TB2 = B, TB3 = A; TB4 = C; TB5 = A...

Hi Guys, Thanks for the help in advance!!! :-) and sorry for cross-posting but I'm desperate for some assistance!!!!! I have a form on which there is a button. Clicking this button opens a pivot table that is on a form but opens in a default pivot table view. I've noticed that information on...

Hi Guys, Thanks for the help in advance!!! :-) I have a form on which there is a button. Clicking this button opens a pivot table that is on a form but opens in a default pivot table view. I've noticed that information on this pivot does not update, even when clicking refresh. The data...

Hi Guys, Thanks for the on-going support! I'm trying to do something that seems simple but I'm having a problem! I have a form (see attached) where there is a box called 'CV Date of Renewal' which has a date in. If the date is in the future, I'd like the 'CV Information' Box to go Green and...

Hi guys! Apologies for cross-posting, but I am completely stuck and I'm hoping posting this on General will get more looks than a specific page. I've hit a stumbling block :banghead: I've created a nice-looking outlook-esqe calendar, with the purpose that people can access it and write in...

Hi Guys, I've only been on this forum for a short while but already the answers I have gotten on other questions have been excellent! I've asked two questions now, this is my third, and the only way I'm going to master Access is to keep on asking!!!!!! So my next question :p I have a table...

Hi guys, Can anybody help me with creating something? In a form, I have a drop-down list called Consequence, which as five levels (1, 2, 3, 4, 5) and another drop-down list called Likelihood which also has five levels (A, B, C, D, E). I then have a label called Grade and what I want is that...

Hello Access World Forums! Thanks for hosting me, I've just signed up as this site has helped me out before :-) I need to pick your expert brains, and I apologise in advance if I've cross-posted, but my issues seems to be quite personalised so I assumed a new thread would be ok. My basic...