Search results

right I have tried putting the text on the subform still code doesn't work if I have expiry date 01/04/14 and then make this true the textbox goes blank and doesn't so the next due I even try removing the null no different:confused: cheers shane

yes your right both fields are on my subform yes id is the data type the "link" between the forms thanks shane

sorry typo! error:banghead: =IIf([ExCourse]= False, DMin("Expirydate","tblcourses","[ID]=" & [empID]), Null) right that's not working as my text box that display's next due course date is on the main form frmemployee so there no reference I 'm guessing for excourse :confused: thanks...

hi vbainet right I have tried =IIf([Forms]![frmlcourses subform]![ExCourse]=False,DMin("Expirydate","tblcourses","[ID]=" & [ID])) but with no success:( thanks for the help shane

hi all right.. I have main form call frmemployee and subform call frmlcourse subform the main form hold's employee information e.g. first name addresss the sub form hold's all the training courses that the employee has been on right..... now my problem I have a text box called...

It's exactly like that and working :confused: Oh well Thanks Shane

hi , Vbaineti god knows what I was going on about hadn't had much sleep!!!! after reading your last post again!! today and a little more awake and fresh eyed :) I got the logic behind it so I removed daysover field and done it by unbound text box using control with...

THANKS!!!!! Vbainet worked a Treat:D:D only one more question how can I make the dayover Textbox invisible if the expiry date has passed and only on the records that have passed cheers shane

hi all right .... I have a report that displays on a continuous style report. What courses the employee have been on and when they expire right I have field call expirydate and another call dayover showing the number of days till that course has expired also I have made a label called...

thanks Gina didnt know i could use the dmax function in a text box :) something new i have learnt :D THANKS AGAIN GINA!!!!! YOU STAR !!!!!:D:D:D:D:D:D Shane

hi all right.... I have a form call "frmemployee" that holds employee's details. I have page tabs with sub forms on and the one I'm now concentrating on now at the moment is a Sub form called "medical Sub form" this holds data regarding the last medical the employee has had on continuous...

right I have found what was wrong I was running my combo box from a table but when I was selecting a year it must of been taking its record ID not the Year Field value so I change it to field list box and boom! it worked!!! Thanks Gina YET AGAIN!!!! YOU LEGEND!!!!:D:) shane

right I change the combo name to combo3 for temporally and it work's but didn't export any records it was blank but there is definably record's in that criteria:confused::confused: I set my combo box to =2014 If [Forms]![frmexportexcel]![Combo3] <> "" Then strWhere = strWhere &...

thanks Gina still get Microsoft access can find field 'cboexportyear' reference in your expression and its highlighting this row If [Forms]![frmexportexcel]![cboexportyear] <> "" Then thanks shane

sorry gina im confused where to put this now :banghead::confused: strWhere = strWhere & "([tblExposure.Dateexposure] = " & [Forms]![frmexportexcel]![cboexportyear] & ") AND " thanks shane

I have made sample of what I have done thanks shane

right tblExposure.Dateexposure holds the date for each record im dbs As DAO.Database Dim qryDef As DAO.QueryDef Dim strWhere As String Dim lngLen As Long Set dbs = CurrentDb Dim strSQL As String strSQL = "SELECT tblemployee.Id, tblExposure.Dateexposure, [Valuef/cm]*[Durationofexposure] AS...

hi Gina good idea!!! so if make a form call frmexportexcel and combo box with years called cboexportyear so what would the where string be :confused: thanks shane

how to add another strwhere criteria hi all I have some code that exports data to excel overwrites old data on the same sheet every time call "exspose Data" but I now need to add another string to only export current year data how it works it creates a temp query then exports to excel and...

hi irade92 you could try this myDir = "FILE PATH\" myFile1 = [TEXT BOX NAME ] & ".PDF" DoCmd.OutputTo acReport, "Report Name", acFormatPDF, myDir & myFile1 hope this helps shane