Recent content by funk44

Yep, that makes sense. I think i'll go with a button to load the form rather than the PDF for the purposes of this program Thank you very much for your assistance, much appreciated

Thanks for that it does work, the issue is that i need to call that to load the pdf in the activex object Are you aware of any work around for this or am i stuck with calling the form through a command button? Cheers

Thanks for the quick response It doesn't change anything unfortantly, it just refreshes the Acrobat ActiveX object as it was before, again, if i mash the mouse button for long enough the event eventually fires

Hi guys Hopefully this is the right place to put this I have an issue with the dblclick event not firing immediately from my listbox. It does eventually fire if i mash the mouse button for long enough but obviously that is not an acceptable solution.The listbox also has an afterupdate event...

Hi After a bit more headscratching i solved my problem and learnt a bit in the process The final statement is below IIf([Type]="Onlist",Abs([EP_DETAILS_ON]*0.15+[REF_DETAILS_ON]*0.2+[GEN_NOTE_ON]*0.2+[APP_LINE_ON]*0.25+[SPEC_INS_ON]*0.2),IIf([Type]="Aged...

Thanks for the quick reply Its used in a table to calculate a quality score depending on type I am unable to upload my db as i believe i don't have enough posts. I use 2010 as well

Hi all After posting in another thread it was identified that my original table structure had a few issues I've now since moved everything into one table but i need some help with the formatting of my calculated field (I'm new to all this) Below are the 3 expressions working independently of...

Thanks Pat Each does contains the same 5 fields which i need to appear in the list box but they also contain several others which are used for weighting in a calculated field depending on the type, which are all different

Hi all, first time poster, long time lurker who has found plenty of answers to my questions from this forum so thank you all in advance I am quite new to Access, Im fairly competent in VBA but an absolute novice using SQL, so bare with me and hopefully this makes sense Im building a quality...