Search results

So i've got some nice buttons that when clicked take the results of qry_certissued and drop them into the appropriate word document, GroupRecord.doc works fine, because it's just a table, and each new row has a <<next record>> at the start so Word knows to take the next record from Access and...

That's the one, thanks =o)

at the moment, the OnClick event procedure for a button is Private Sub btn_certificate_Click() Application.FollowHyperlink "C:\<filepath>\FAWR Certificate.doc" End SubThere are three different certificate files, EA Certificate, FAW Certificate and FAWR Certificate What I would like is for the...

Here's an earlier anonymised incarnation from an earlier query i had, http://www.sendspace.com/file/ww1qrp just wondering if it'd be simpler to go for a criteria that excludes "EA" when "FAWR" is chosen by cbo_cert something like IIf([Forms]![frm_Person]![cbo_cert]="FAWR",Not...

sorry for being abit limited in my access knowledge, What is the In('EA') (etc) bit meant to mean/be? i've changed combo= to [forms]![frm_person]![cbo_cert]but left the rest the same as your code box, but now no matter what i select in cbo_cert it's coming up with the "expression is too...

It works if cbo_cert is "EA" or "FAW" but when it is "FAWR" and the query is run an error pops up... "this expression is typed incorrectly, or is too complex to be evaluated.....etc etc"

that'll only pull up records with "FAWR" as [certtype] when cbo_cert is "FAWR" won't it? I need cbo_cert="FAWR" to pull up both [certtype] "FAW" and "FAWR"

I have a combo box with three options, "EA" "FAW" and "FAWR" If "EA" is selected i want the query to return results where certtype="EA", if "FAW" is selected i want the query to return results where certtype="FAW" if "FAWR" is selected i want the query to return results where certtype="FAW" or...

Works like a dream, thanks again vbaInet :)

Neither of those work Craig, =o/ vbaInet; could you post up the vba code you used to achieve that results, i checked it last night at home and it worked perfectly, but can't open the uploaded DB through work's firewall.

Been doing a little more playing around with it, and it's bizarre. if txt_coursedate > [certexpires] it should add 36 months onto txt_coursedate * which it does, provided the day value of txt_coursedate is > day value in [certexpires]. eg. [certexpires] = 07/03/2009 txt_coursedate = 08/10/2010...

frm_person is the form in question, selecting a person via the combo box should display their previous certificate info in the subform top right, changing the value in the text box "course date" should then auto populate DMax Cert, DMax Date -3mnths (test boxes I added to check that the Dmax...

I did something similar i think a while back, hopefully you'll be able to pick this apart and pull out the bits you need, in the date colulmn of the query design view, criteria one was Between IIf(IsNull([Forms]![frmquerydept]![txtStart]),0,[Forms]![frmquerydept]![txtStart]) And...

www.sendspace.com/file/ww1qrp

unfortunately i can't upload via my phone or direct from work PC so have had to use sendspace to upload a stripped version. As this is post ten, i'll put the link in the next post.

copied and pasted as below but still #error. =IIf(CLng([txt_coursedate]) > CLng(DMax("certexpires","qry_personcert")), DateAdd("m",36,[txt_coursedate]), IIf(CLng([txt_coursedate]) Between CLng(DMax("certexpires","qry_personcert")) And CLng(DateAdd("m",-3,DMax("certexpires","qry_personcert")))...

Double checked tbl_cert2 all dates are date/time (short date) format, and specified short date format for certexpire in qry_personcert. using the above gives #error

sendspace dot com /file/ww1qrp Afraid I can't find any other way to upload the anonymised DB other than sendspace atm. Apologies, I know it's counter etiquette. :o

No joy vbaInet. Just did some more testing and it seems to be something to do with the day value in txt_coursedate having to match the day value in [certexpires] in order for txt_expdate to give the correct answer? eg. [certexpires] = 17/08/2013 txt_coursedate = 17/06/2013 txt_expdate =...

Just popped two text boxes onto the form, with control sources as =DMax("certexpires","qry_personcert")and =DateAdd("m",-3,DMax("certexpires","qry_personcert"))and both of those are bringing up the correct date, ie. 21/07/2012 and 21/04/2012 respectively. Extra weirdly, I've tried randomly...