Search results

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

Hi all, Well it's been hell of a long time since I last did a database and used this forum way back in 2003/4, so Hi to all the newbies and Hi to all those who are still here from 7 or so years ago. I'm struggleing to get what I want from user input selection. For ease I want to use an...

2 x Nokia 3310 and wait for this...... ....Nokia 7110e Just great the battery still charges but it loves to turn of the moment you close the keyboard cover. I've got a digital camera, so don't need one on the phone. Also have a computer so don't need one on my phone. Ian

Hi all. It's been a while since I was on here. Hi to Rich, Pat and the other regulars. I'll be running a website that needs a d/b and need some feedback. What are the main pros and cons with access What are the main pros and cons with Mysql I know access and think I could get what I want a...

Using Win2k Access and I've got quite a lot of VB code that I know isn't linked to any buttons etc.... Is there a way to route out this code, instead of going though each button 1 by 1? Ian

What is wrong with this code, is won't verify the date entered correctly? txtCheckInDate is an unbound field Ian Private Sub txtCheckInDate_LostFocus() 'Validate data entered' If txtCheckInDate.Value < Date Then MsgBox "The arrival date must be today or later!" txtCheckInDate = Date...