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!

  • Congratulations Chriss Miller 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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?
  3. 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...
  4. jsgs

    Remove frame around textbox

    How can i remove the frame which surrounds a textbox? Using Quark 8.1. Thanks in advance.
  5. 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...
  6. jsgs

    Spaces in Word

    When you justify a text, Word automatically adds spaces between words. Sometimes the number of spaces it adds is just too many and it is obvious when looking at the text. Is there any way to prevent this?
  7. jsgs

    Graphics performance

    Is it necessary to have a dedicated graphics card for using software like the latest versions of Photoshop and Quarkexpress? In the same run would a desktop be better than a notebook?
  8. jsgs

    Use data from one form in another form

    Hi to all! I have a form (let's say form1) with 10 command buttons on it. When I click on any one button, another form (form2 - similar to an inputbox) appears asking to input a name. Form1 is the main form and all my code are in form1. Form2 is just there to get the name and validate it...
  9. jsgs

    Importing a Word doc into Quark

    Hi to all! I'm relatively new to Quarkxpress. Using PC version 8. Problem is: I need to create a book. It's already typed in Word. I want to import that into Quark so I can set it to its appropriate page layout. I've tried to do that. For one thing I can't get Quark to set up a page layout...
  10. jsgs

    How to do the connection?

    Hi! I hope I'm posting this thread in the right forum. Situation: I have one PC which is connected to a livebox via the network port for access to the net. I have a second PC which is connected to a heavy-duty printer via the network port. The PCs are around 25m away from each other. They...
  11. jsgs

    MDAC error

    I'm trying to install the IC3 training program. I get the following message: Whether I click Yes or No, it ends up saying installation has finished. I've downloaded MDAC from Microsoft's site and when i try to install it i get this error: I'm using XP Pro with SP3. But I got this problem...
  12. jsgs

    Burning a CD ISO file to DVD

    I'm having a problem with my DVD drive on my Dell 630m laptop. It's refusing to read CDs while having no problem with DVDs. I need to burn an ISO made for CD. But since me drive's gone beserk am not being able to do it. I've tried burning it on a DVD with Nero but getting the message that disk...
  13. jsgs

    Find duplicate values in Excel

    Hello everybody! I have a column with 900 User Ids. Is there any function in Excel that allows me to find all duplicate Ids there are in the list and point me to them? (Using Excel 03)

Part and Inventory Search

Back
Top