Recent content by canjfn

Thanks for your response. This seems to work fine If Me.Text42 >= Me.CalibrationDue Then Me.CalibrationDue.ForeColor = vbRed ElseIf Me.Text42 + 30 >= Me.CalibrationDue Then Me.CalibrationDue.ForeColor = vbGreen Else Me.CalibrationDue.ForeColor = vbBlack End If

We have instruments that are calibrated yearly, I have written a small database to keep the records. On my report I have written the following to change the font colour to red if the calibration due date has been exceeded, this works fine. Private Sub Detail_Format(Cancel As Integer...

Thank you, now works fine

I have a table with a number of yes/no fields; this table is used as a source for a query, Now when writing a report based on this query, the respective fields return -1 for where I have said Yes and 0 for No, how can I make the fields on the report say “Yes” or “No” I was trying to do...

Thanks, I feel a right idiot now, was racking my brains for a simple solution

If I have a tabbed from of say 3 tabs, can I use each tab to populate 3 different tables or can each tab only populate one table, hope this is clear. I have 3 tables a) General b) Process Design c) Mechanical design By putting the tabbed form on a plain master form, I have to select one table...

Thanks for the response but that doesn't do it. I have attached the example, On the enter New Job form, note the purple sub form, after using the combo "Fabricator" after update would like the cursor to jump into Application ENG on the green sub-form

I have a parent form called "frm_job_enter" and two sub-forms called "frm_fabricator" & "frm_engineer" On the sub form "frm_fabricator" I have a combo box and after updating this combo box (called fabricator) I would like the cursor to jump into a field called “ApllicationsEng” on the other...

When pressing F11 to access the data base window, somehow I have docked it in an awkward position on the screen where as the top of the box containing the minimise, maximise and close button are not visible, how can I drag the data base window to the position I want i.e in the centre of the...

On My form I would like to have code to limit what can be put into a field e.g If Me.Myfield is not = to A, B or C then message "You must enter A, B or C in this field" EndIf Any help please ?

Cheers for your thoughts, you were right with what I am trying to do, although not completely as your suggestion (a little too complicated for me using temp tables), I have managed to be able to copy the purchase order line items into a new purchase order, by means of a mirror form of the...

Scenario frmpurchaseorder, for entering the supplier’s details, name address etc frmpurchaseordersub, for entering the items to be purchased frmpurchaseorder, populates the tblpurchaseorder frmpurchaseordersub, populates the tblpurchaseordersub Obviously, when the form frmpurchaseorder is...

Thanks very much.

I have 5 users who raise documents and am trying to construct an if statement to put their user name on the report without them having to enter it manually, I am picking up their network login name using a function from here If Me![LoginName] = "Fred" Then Me.Text89 = "Jack" Else Me.Text89 =...

I have field (SupplierID) set as Text and the field limited to 5. I want the users to enter the first three digits as text e.g "ABC" and the last 2 digits as numerics e.g "01", thus the input would be "ABC01", I can validate it to 5 digits but cannot get the validation working on the numerics...