Search results

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....

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

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

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...

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

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

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...

Re: Access error -queryW is corrupt Cheers DBg

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

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

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

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?

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...

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 -...

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

Isladogs yes of course :o I've been helping my son with Excel recently for his job and got it mixed up Cliff

Hi Mark The original coding that created the record use the now() function to insert the date and time the record was raised. I changed it to the TODAY() function as the time the record was raised was irrelevant I just didn't use that field too much until now

Thanks for the Help Gasman your a star

it is a possibility sometimes you can override limits with code

Fixed the problem... when I looked at what dates were not showing up all of January and half of February would not work and a few days from the previous year. I looked at the underlying table and found that some of the dates had times attached to them so 02/01/2019 10:32:55. I removed all the...