Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jsgs

  1. jsgs

    Dropdown list does not show all items

    Thanks Skip. Exactly this mistake of mine. Solved.
  2. jsgs

    Dropdown list does not show all items

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

    Count number of occurences of values

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

    Button for mail merge

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

    Count number of occurences of values

    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?
  6. jsgs

    Button for mail merge

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

    Button for mail merge

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

    Remove frame around textbox

    ok got it. thanks a lot andrew.
  9. jsgs

    Remove frame around textbox

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

    Remove frame around textbox

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

    Remove frame around textbox

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

    Remove frame around textbox

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

    Remove frame around textbox

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

    Remove frame around textbox

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

    Prevent new entry

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

Part and Inventory Search

Back
Top