Recent content by ian_ok

2003 to 2010 Form migration problems, not showing records I've just moved my database from 2003 to 2010 and have encountered a few problems. In my 2003 I had a menu and from this I could click on an open form button and it would open the form at whichever record (non specific, but a full...

Thanks Simon always a simple way out, why didnb't I think of that....Doh...!! Cheers Ian

I'm trying to use the following but not sure if I am asking too much. If Me.Ctl2nd_Payment_Payable = "Paid" Or Me.Ctl2nd_Payment_Payable = "Pagado" And IsNull(Me.Ctl2nd_Payment_Date_Paid) Then MsgBox ("Error - Check the 2nd Payment details as it says PAID / PAGADO yet the date paid has not been...

Thanks Paul, works wonders, didn't know Access had that, I knew about in Excel....Doh....!! Ian

I'm trying to highlight a field if the date is less than or even equal to today on a continuous form. This is what I've tried all to no avail.... Private Sub Form_Load() Me.Form.OrderBy = "1st Payment Date Limit" Me.Form.OrderByOn = True If [1st Payment Date Limit] <= Now() Then ' If...

Yep I had to leave that until the end or else you might have done a Coyle and left before you had finished the job....!! Thanks again. Cheers Ian

Works wonders, thanks a million from a Bolton supporter...!!!

Oh well i can't get it to work on the current d/b but when I recreate your code on it own in a new d/b it works fine......probably something simple, will report back soon. Ian

It says check the subkeys and ensure it's got the brackets

To the first reply, where would I put that in a query...? The reason i need it in a query the dates are used later in the report in the dd/mm/yyyy format which I don't need to amend, just in pone section of the report needs changing. To the 2nd reply I'm a tad lost as it's been 15 years since I...

I'm trying to change the month language when I produce a query so that when the data from the query is shown in a report the language of the date is shown correctly. A report is shown in English and the date is 1 January 2011 When the report is for a Spanish client I want 1 enero 2011 I have...

Hi Bob Thanks for that, it now works by removing the lookup in the table, in the form making a combo box to look up the appropriate table (with no ID field) and store that data in the required field in the main table and the unbound field shows the correct info. Also I can run a separate query...

I'm running a report and get the data from a query, the query shows the correct data as does the combo box on it's own (whioch I don't want), but when I add ="some text " & [field] to the control source in the unbound field it shows the ID, what is going wrong here? Thanks Ian

IF & AND statement not working *SOLVED* I'm trying to get a IF & AND statement working together but cannot get it to work when a field is null only. It works when testing has certain data in it, but I want it to work when the date field is empty (null) Working Code if 10/10/2010 is entered If...

Thanks all sorted. ian