Search results

That makes sense now. I didn't have data that matched in the first row so i didn't notice that it was missing it out.

Thanks for this i will see if I can sort it out. I have deliberatly taken out the header rows, I will find a way to clear the destination sheet or copy one header across. As it is going to pull data from about 20 sheets i didn't want to confuse the copy to just take one header.

I have found an example and modified that a bit. I have it working for a single button on an active sheet for 1 column of the data but it shouldn't be to hard to get the other section of the data. Can anyone help with putting this code onto any other sheet so that it loops round all the...

Hi, I am trying to get exel to copy data from several worksheets and place the data in another sheet. In this case there are 2 parts. I want to copy data from all of the sheets that begin with stdy based on the following I want to copy the data in cells A:H based on the value in cell G and...

I'll have a play with queries later .. in the mean time thanks for the code .. it works great.

I am trying to use DMax to sort out some number issues i have. Here is what i want to do. I have a field (Text) made up of a 4 letter code (AAAA) then a number. WHat i want to do is grab the highest number from this. where the code matches what is in a text box. I have got the following...

My name is Bloody Davy Flint All ready to go pillagin', plunderin' and consumin' o' the rum!

We'll be needing one of these then.

He followed it up rather well with his performance on the pitch afterwards. Not sure throwing up is such a good celebration. However ... bring on portugal (minus 2 players :D )

YAY ... That at least would mean less politicians.

Me and my GF are currently in this position. And i assure you that the desicion is not an easy one to make (in fact we have not made it yet even after 2 weeks extensive scans and an MRI). I would say that our decision is not based on any arbitary govermental limit at all. Purely based on our...

The government has limits in place for the lateness of any abortion (24weeks in the UK). It is up to the person to justify to themselves their reasons for the termination. Most that are this late are for valid medical reasons. Not just because the person has decided that they do not want the...

I agree with the sentiments of you jeremie. Choice is just that ... a persons right to choose.

Thanks Thanks all. I now have it sorted. I think that something must have got a bit corrupted along the line with the database. I imported all of the forms / tables etc and reset the startup as I had it and Rich's code works a treat. Thanks for all your help. Sorry to be a pain. Steve

When using your code Rich I was still able to get all of the toolbars to hide. However I still cannot get my custom toolbar to unhide using the docmd.showtoolbar ... Again I think that there are some start up issues here as I cannot get the toolbars to appear or dissapear using code except at...

Yes: But as mentioned previously I was still able to select from the menu and print. All the toolbars were gone though. Steve