Recent content by Cliff67

  1. C

    Change BackColour of Form

    Hi IslaDogs Thanks for that, I selected multiple text boxes and entered the correct expression like you showed above. it works a treat I suppose you get too bogged down with doing things in VBA. Now how do you make a thread SOLVED....
  2. C

    Change BackColour of Form

    Isladogs I've never really used the conditional formatting in access before but I just gave it a try. Can you tell it to set a control e.g. text box a colour based on another text box, because I can't get that bit to work
  3. C

    Change BackColour of Form

    Thanks DBG I was sure I had done it a different way with an earlier release of Access but maybe I was just thinking of something else
  4. C

    Change BackColour of Form

    Hi all I'm not sure if this has been posted before but I couldn't find it. I did try to post it yesterday but it seems to have disappeared. I've done this before but can't get it working and can't remember how I did it before. So I've got a continuous form that I want to colour code based on...
  5. C

    Calendar View Form

    MajP thanks for the tip I was wondering if I had to do some jiggery pokerery to get it to work. I was thinking 2 separate reports however and just print them off together, but a sub report of the second half of the year will do nicely just need to align the reports up correctly
  6. C

    Calendar View Form

    MajP can you install wisdom to me and share your findings with me many thanks Cliff
  7. C

    Add more records in a specific form

    Hello Aym If you are completely new to access and depending on your version, a chap called Steve Bishop has done a number of YouTube video to help with MS Acccess, he takes you right through from your first table up to programming in VBA have a look...
  8. C

    Access error -query is corrupt

    Re: Access error -queryW is corrupt Cheers DBg
  9. C

    Access error -query is corrupt

    Re: Access error -queryW is corrupt I had only one update query in the database so I created a query of the info I wanted to update then ran the update query on that query, a query on a query, not elegant but it worked well
  10. C

    Access error -query is corrupt

    Re: Access error -queryW is corrupt :( two...I guess we just found out then :rolleyes:
  11. C

    Access error -query is corrupt

    Re: Access error -queryW is corrupt It says Microsoft Access 2013 (15.0.5189.10000 MSO (15.0.5179.1000) 32 bit Part of Microsoft Office Professional 2013 I have the product ID if that helps too
  12. C

    Access error -query is corrupt

    Re: Access error -queryW is corrupt :confused: Oh Bugger - the site says the patch is for 10.0.5189.1000 to update to .1002 so you would think if I'm at that version it should be. I don't think it is Click to Run Ms access and office is installed on my local drive :( how would I check that?
  13. C

    Access error -query is corrupt

    Re: Access error -queryW is corrupt Just followed the instructions on MS update page, check what version of access and is it 32 bit or 64 bit, found I'm at version:15.0.5189.1000 which is one of the wonderfully messed up version. I downloaded the correct KB patch (KB2965317 of 32 bit) only to...
  14. C

    Access error -query is corrupt

    isladog - I couldn't find the problematic update however I did you quick work around since it was only 1 query and build an new query of the original table then ran the update query on that query. It now does not throw the error. Many thanks for your hard work researching this problem -...
  15. C

    Access error -query is corrupt

    Guess what!! I've just had the same problem a query that ran yesterday now has an error and it is corrupt, I'm going to look if the update has been done Wow Microsoft tested this update well
Top Bottom