Search results

Ah I see ok my apologies for the misunderstanding!

Thanks for the reply, RuralGuy. Must be my mistake then, just pbaldy had put 'regarding the button' but I've obviously misread. Sorry!

Thanks for your response, pbaldy. Have I got no choice then regarding a button? As I'd really rather not have a cmd button. I was hoping that as each field has data entered then the bar would progress, which is where the afterupdate comes into play. I'm pretty stuck with this whole issue as...

arnelgp! You are a coding genius! This has worked in everyway I hoped! And I am sure you are relieved to finally be done with me! I have added reputation and you thoroughly deserved it! Thank you very much for all of your kind help! :cool::cool::cool:

Thanks for passing this on to me, jdraw. Problem is, like so many posts, this relies on a cmd button. What I'm looking to do is have a form with 30 fields, and as you add data to each field the progress bar fills up based on how much you have completed. But this video has gave me insight into...

Thanks for the reply pbaldy - no I haven't, as I'm unsure what this is but I'll do some research :) thank you!

Thank you for taking the time to do this, arnelgp! I can confirm it works! There is however, still one small thing to iron out if possible! If date is added to Field1, the countdown timer begins, (excellent!), if a second date is added to Field2 the countdown timer stops, and displays the...

Thank you arnelgp. Still no luck :( perhaps I will have a flash of inspiration tomorrow and solve it. Not a problem, thank you for all of your help today, really appreciate it. Have added to your reputation for your insight. All the best, Nick

Thank you, arnelgp Certainly not giving up, just now feel like I'm taking advantage of your kindness! Still it only shows number of days for approval. It just doesn't seem to change when I add a date into Field2. Very peculiar. Thank you

Thanks once again for your help. The message of "x days before approval" still shows, even after updating the expression and adding Me.Refresh in all of the AfterUpdate private subs. perhaps this is not possible to do :( Thank you, arnelgp

So at the moment I have no data to input. (Submission Date) Field1 - Date __/__/_____ (Approval Date) Field2 - Date __/__/_____ (Timer Message Box) Field3 - Text (this is where the expression is, in the control source Expression works (i.e. no error messages) but simply does not 'update' when...

Thank you for getting back to me! Unfortunately I'm not as skilled as I feel this level of knowledge requires: How do I do what you have mentioned above? Thank you!

Thank you for your help and apologies for the mix-up. Unfortunately, this is still not working :( it still says 'x days before approval). I just can't figure out why - I'm no whizz but I see how your code makes sense. It's a tough one :( any thoughts?

My apologies! I did not explain correctly! I have two fields, and another field which displays the messages. So I have a date in Field 1 (starts the timer) and a date in Field 2 (which effectively 'stops' the timer). In another field I utilise the control source and would wish to have...

Thanks for all of this help - but this does not seem to work I'm afraid :( regardless of what date I enter into field 2, it says '30 day target achieved'. Any thoughts? Do I need to add the expression to any of the afterupdate sections? At the moment it is just in the control source of a text...

Hi again all! So I've been reading up on progress bars but I'm still unsure... I have added one to my form via activex, but am unsure of how the form interprets my 30+ fields as a whole. I thought about doing 30 labels and assigning each as hidden, and enabling them visible once data...

Thank you again arnelgp! I notice it works great, except that in my Field2 I tested a few months in the future, and it still says 30 day target achieved...any thoughts? Does it require some form of Date() expression?

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

Brilliant, thank you so much! I've only just seen this post, so sorry for the delay!

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