Recent content by jsgs

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