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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jsgs
  • Order by date
  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...
  16. jsgs

    Prevent new entry

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

    Graphics performance

    Thanks Martin. Will take note of that.
  18. jsgs

    Graphics performance

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

    Graphics performance

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

    Spaces in Word

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

Part and Inventory Search

Back
Top