Search results

Haha guess it's an eager group! Thanks for the support everyone, will give a few things a try and see how they turn out! If anyone else has some ideas the more the merrier! Cheers!

Hi RuralGuy, All of it! Have no idea where to start! Any help would be greatly appreciated!

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

Pat, Thank you very much! This: Age: IIF(IsDate([Died]) = True, (DateDiff("d",[DOB],Died))\365, (DateDiff("d",[DOB],Date()))\365) solved my problem :) it works perfectly! And sorry for not being specific. Pr2-Eugin - it was on a query, yes, sorry for not specifying - though I've kept...

Hi pr2-eugin, long time no speak! I have tried the following, (with one change - "Died" in place of "deceased" as per my control name): Age: IIF([Died] = -1, "", (DateDiff("d",[DOB],Date()))\365) and it did not work :( I then tried changing "Died" to "Check136" (the checkbox - bad...

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 plog, This worked exactly the way I was hoping :D thanks so much! I'm beaming with joy! Thanks again, N

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

Cheers, Trevor. I've had a look at the website and I'll look through the videos. I'm hopeful I can get this sorted as it would really help me out a lot with something I'm working on. I don't use CRM or outlook, but the template I have at the moment is what I'm looking to adapt. Once again...

Yes lived literally on the back of Cannock Chase so can't complain! Stafford is beautiful too. Your second VBA worked a treat also :-) I really can't thank you enough! As for the calendar, any ideas or examples you know of please pass along as I really want to keep the idea of having that...

Trevor G - as far as I'm concerned, you're a genius :-) but I expect nothing less from a fellow Staffordshire dwellar :D (Stafford now, formally Cannock!!!) this worked wonderfully!!!! :-D any idea of how to do my 'permission' box also? I'll have a crack at it based on this VBA you have...

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

I very rarely ever re-read something I have written before I send it; I think now I'll make sure when I write something its 100% clear :-) bot no worries. I got worried there that I might suddenly become an enemy to Access World Forums!!!! I'm glad that's all settled! The calendar demo I...

Sorry, yes I do mean 'utilise' and not create, hence why the VBA is so good and I'm here asking for help :eek: how very embarrassing :S "i may be wrong but i doubt it" = that actually really hurt me to read it!!!!! I don't make a living taking credit for others hard work!!! Hope this clears...

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 Pr2-Eugin! I realise that noew; I jumped the gun before reading :-S How embarrassing!!!!! It works wonders :-) thanks again, see you tomorrow lol

Damn Comboboxes!!!! I've only been tampering with Access for two weeks and already they are the bain of my existence! When I first saw them I thought, 'Ah I get it, thats a very simple premise...'. Famous last words, eh? I actually discovered how to form groups in reports and this looks a...

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