Search results for query: *

Hi all. I'm doing a family quiz for Xmas, one of the rounds is blockbusters (you know - "I'll have a P please Bob") anyway, I can design the grid etc, but I just don't know the best way of creating the changeable letter tiles. I thought each hexagon could be a button, the button then glows...

Thanks Tony that's it exactly, i opened two separate instances of excel and it didn't clear the original data, but then opened 2 workbooks in the same instance and it did clear the original cell. thank you very much you've answered my query. cheers kev

Hi all, I have a quick question which you might be able to help me on. My boss says he used to "cut" some cells from excel file 1, and then paste them into excel file 2. After pasting the cells into file 2, the cells in file 1 would disappear because they were "cut". When i try to reproduce...

hi all. i need some help in excel as i cant figure out how to arrange my data correctly i have attached the file to look at. on the print sheet, when i put the customer number into cell E2, the details for that company display fine. however, at the same time as displaying all the customer...

Hi there, In an excel document, is there a way to keep track of how many times a document has been printed, so that on the printed sheet it would say something like "Print Number 3". Then if i printed it again the sheet would read "Print Number 4" etc Many Thanks Kevin

Hi there PHV. Thanks for your response, It's not through lack of trying or lazyness but i just dont understand :O( I already found the first link prior to coming here and is the reason i gave up on lookup fields. I also have already read the page at the second link (as it's been mentioned...

Hi there, I have a problem with my brand new database. I was quite excited and actually proud of the database until i found a serious flaw in it. I can't filter or search through most of it because many of the fields refer to lookup tables, and when i search a field referencing a look up I get...

Hi all, in Outlook 2000 I was sent an email that Cc'd about a hundred other people, I want to save all these addresses to my contacts or just even print a copy of the addresses. Half of them display the actual address, and half display the name, so I would have to view the properties for each...

Hi Peeps, thanks everyone for their help, that what I was after normalization (I couldn't think of the word earlier). The only trouble with Geoff's layout is would I have to now have 52 rows PER customer. Customer | Week | Sales | Profit Osda | 1 | £500 | £20 Osda |...

Hello there, I want to know if there is a better way to lay out my friends Excel Spreadsheet table as it's difficult to make formulas from it. At present it looks like this: Customer | Sales Week1 | Profit Week1 | Sales Week2 | Profit Week2 .... Sales Week51 | Profit Week51 | Marrisons Osda...

That is a good idea, someone else did mention a transactions table, but I didn't really understand what they meant. But yes that does sound good, plus it keeps intact the original purchase details as well. I'll give that a try. Thanks again mate much appreciated Kev

thanks for your help mp9, originally i was going to do it that way as it's easier to get my head around it that way, only it would take a lot lot longer to enter all the data into the database, 10 is just an example as say we after lambing we sell 500 lambs, entering 500 new lines would take...

Lespaul, I think I see what you're saying. Breaking it down into different areas. Randy700, That was help on a different query. But Remou and someone else did help me before on tables - the resulting table is the "tblSheep" table. ie one combined table of everything. I'm REALLY confused now. I...

thanks Dhookom, after reading the fundamentals thing I can see that making more tables is probably the "correct" way to go about it, but I just wanted to keep it simple really. I'll look at this transaction table, not sure how i'll get it to work on my current model tho, thanks again.

Lespaul, Thanks for the documents, I read the fundamentals thing, and to be honest I didn't really understand any of it, my brain for some reason just won't pick any of it up about 1st normal forms, and normalisation etc. I can understand what i'm reading, i just don't have a clue on how to...

I'll certainly give it a read (I was trying to avoid going into to much "depth" but I guess i'll have to if i want it working correctly) Regarding the calculated fields, I didn't think they are calculated are they? The new record is added, and an old record adjusted based on the added field...

Hello. I need help with a query. I found out about query types (Ie Append query/select query etc). What I need is one query that will create a new record using append, but then edit the selected record at the same time. Ie. Name Lollipops Kevin 5 John 4 Peter...

I hope my thread is in the right forum this time. Anyway, I need some advice regarding my sheep stock database. At the moment, say for example I buy 10 sheep. I create 1 new line and in the quantity field I put 10 And change the status to "Current Stock". That's how Defra like it, simple...

Hooraay. It's all now working, I removed the status column from the sheep table and just left the StatusID in the sheep table. The reason I didn't do that before is I wanted to display eg "Sold" and not "2". But all i did was set the statusID to display the data field, column widths - 0cm,3cm...

Sheep table (there are some other fields, but i didn't have enough space to put them in) SheepID | Breed | Category | Cost | SellPrice | SoldTo | Status | StatusID 1 | Texal | Ram | £30 | | | Current Stock | | 2...