Search results

Ive base my subforms recordset on a query which uses the datediff function to find the total days. I have added a unbound field in the footer of the subform to calcuate the no of records greater than 60days and then pass the calculated value to another bound field on the main form. All I need...

I have two unbound fields on a form that I would like to display the result in the following way, similar to the record navigation at the bottom of a form. ------- of ------- Field names txtOf = ? txttotal = Count(*) Any help on how to do this would be...

Can someone please convert this to A97 for me. I'll will buy you are beer!!

When I initially created the DB i didnt formalise it correctly. Now I understand the importance to do so. I know it needs to be normalise further but at this stage want to get the data matching correctly before normalising further. tblclient holds information on the client and jobs forwarded to...

Hi, Im using the following on a form (frmEmail) This work well but I was wondering if it was possible to make strLastName value carry over to email in Bold. Private Sub cmdEmail_Click() Dim strEmail As String Dim strMailSubject As String Dim strMsg As String Dim strLastName As String Dim...

I have a unbound textbox on the parent form to show either VACANT OR OCCUPIED depending is a chkbox is yes in a field on the subform. Im using a continueous subform to that is automatically checked when a dateout is entered. How can I get the textbox to show Vacant if the yes/no is has a tick in...