Search results for query: *

Thanks Skip. Exactly this mistake of mine. Solved.

Greetings to everybody! I've created a dropdown list using data validation in Excel 07. First I've typed the Names in a different sheet. There are 15 rows. I've named the range of Names as Team. Then I created the list on another sheet. Problem is the list is displaying only 12 names instead...

Thanks for your help guys! I've used the CountIfs and it's worked perfect.

Actually I'm not very at ease with Access and writing code to do the things which you've mentioned Seethru and Max is way too advanced for me. I'm still beginning with Access. Am gonna investigate a bit to see if I can do these without having to write any code. Will come back to you should I...

Hi everybody! I have a range of values. I need to count how many occurences of the values 4, 5, and 6 there are in the range. I've used the following formula but it is not working. =SUM(IF(AND($L$3:$L$36>=4, $L$3:$L$36<=6),1,0)) What's wrong with it?

Actually it's a parameter query. I've tried to do it from Word but when it displays the dialog box for selecting the source data, the query which I want to use is not in the list. Now I've tried to do it from Access by using the Office Links option. Again I get the error message "Word cannot...

I need to add to my form a command button that on the background runs an existing query gets the results and merges the names and addresses in that query with a word document that also already exists. I know how to do it manually, using tools in the database window but I want the form to be...

ok got it. thanks a lot andrew.

All of the above done. Thanks a lot for your help guys. One more question. How do I put press marks? I've seen there is a crop mark available in the Print dialog, but when I select the option nothing appears on my layout.

Problem sending to PDF solved. Please help for the others.

I've justified text in a text box. Quark adds much white space on the last line to justify the text. How can I remove this white space? I've exported 3 different layouts to PDF. All 3 layouts have coloured background and text. But when I opened the PDFs all the backgounds are black and all text...

I did not print it but exported the layout as PDF. The frames did not appear. You are right. I was just looking at the guide for a frame. But when I choose Hide guides the frames don't disappear. Does it exist some way for me to look at the layout like it will appear when printing? Like Print...

I've tried that IMacQuarker, but the frame still appears. It's just the thickness of the line which has reduced.

How can i remove the frame which surrounds a textbox? Using Quark 8.1. Thanks in advance.

Thanks all for your help. I managed to do the dlookup and it does find those customers that already have a pending rental. But now I've got 2 new problems: 1) All my forms are bound so when I enter data it gets automatically saved. Now I've put the Dlookup code in the BeforeUpdate event of my...

Problem is about a boat rental system. I have a main form for customers, frmCustomer. It contains a subform, fSubRental, to record rental transactions of the customer. To record a rental, I choose the customer from main form, then I enter his rental details (boat, time out, etc.) on the...

Thanks Martin. Will take note of that.

Martin, following your advice I'll downgrade to Q8200 and 9400GT. But Antec PSUs are not available in my country. The only alternative I have is iCute 650W PSU. I've done a search but didn't find any reviews on it. Are iCute PSUs ok? Simon, I'll sure use 64bit OS. And the deal I've got is a...

Decided to go for a desktop. Now in my country I don't have much choice available as to the hardware I can put in my PC. These are the specs that I've chosen. Intel Q9400 processor MSI P35 Neo mobo 2 x 2GB ddr2 RAM 250GB SATA hdd Geforce 9600GT 512 PCI Express Viewsonic 22" LCD Nzxt Trinity...

I'm disillusioned. Non-Breaking Space doesn't work. Using it does reduce the space between the words but it tends to break the line ending words to make it fit. For example, if a line ends with the word "together", depending on the number of words in the line, it's going to break down to...