Search results

Hi Guys thank you for your suggestions. I had a bit of a brain wave insomuch as I created the percentages as a subreport and placed them at the bottom of the Chart with the totals in. Once again thank you for your help Cliff

I will try to get an hour or tow over the next few days to have a real good think and see what I'm doing wrong

Hi DbGuy Yes I've added them however my Maths is a bit messed up as I keep getting 100% or I'm referencing the field incorrectly. I'm going to be busy for a day or 2 doing image analysis so it doesn't mean I have forgotten you...

Hi DBGuy I have created a second query based on the crosstab with just the row totals, but I really want the percentages to put on a bar chart - does the charting tool allow you to do that when you make a chart?

Hello Everyone My main customer repairs database has a table for cameras with information like serial number, series, model, sensor type, memory and any additional configuration. I've made a crosstab query below (not got much experience in these) that gives me the result of the camera series...

The problem is you are binding your forms recordsource to the query. I normally use a list box and requery the list box for the search like the alterations to your form attached. Its simple and works to a point or searching on the first name only. Hope it helps

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