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 TouchToneTommy 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: sirace
  • Content: Threads
  • Order by date
  1. sirace

    Exchange 2000 and Outlook XP connectivity

    I have a strange problem that I've been trying to fix for the past two weeks. I've seen posts here (did a search) that have the same problem, but none of the solutions thus far offered have worked in my case. I'll try to explain the full scenario in details and hopefully it will neither be too...
  2. sirace

    Premiere Pro, BetaMAX and DVDs...

    Ok. quick question. I had some old betamax tapes (vacation tapes from the 70s/80s and I wanted to convert them to DVD. I got my hands on a Betamax player, hooked it into my standalone DVD recorder (GoVideo) and made a DVD from 3 tapes. Now, I don't really like the DVD/titling options that...
  3. sirace

    Top 50 List Revisited...

    Ok, so I figured out how to get my Top 50 Report going. It works great. However, because my file has nearly 100k records, whenever I want to open the report, it takes roughly 10-15 minutes. Secondly, if I need to print any portion (the report is approximately 10000 pages total). Each page...
  4. sirace

    Finding the Year End Date

    Is there an automated way to have Excel find dates from a date that is specified only to the last day that year which is not specified? For instance, I bought a stock on February 1, 2002. I then bought more stock that year, and some in 2003. However, I only want to see any stock I bought...
  5. sirace

    Calculating dates

    Is there an automated way to have Excel find dates from a date that is specified only to the last day that year which is not specified? For instance, I bought a stock on February 1, 2002. I then bought more stock that year, and some in 2003. However, I only want to see any stock I bought...
  6. sirace

    Dynamic Address lines

    I have a database of clients in which there are 6 fields set aside for address lines. There is also a field called "namelines" that has a value of 1 to 6. This value shows how many fields are actual names of clients and not address portions. Is there a way to have my report show...
  7. sirace

    Dates, Phone Numbers, and reformatting...

    I had to import a CSV file for a new project I'm working on. I did everything I needed to do and my report came out fine, except that the reps are claiming they need the dates and phone numbers in a standard format. I could easily fix this in Excel, but I can't because the CSV file has 95,000+...
  8. sirace

    Making a "Top 50" list

    I have a database with over 90000 records. It contains many fields, but the pertinent ones for my query are as follows: rep_no, account_no, value, address_1, address_2, revenue, ACH I need two reports from this data. One report will use the data as is. The other report needs to show the top...
  9. sirace

    Camcorder -> Premiere 6.5

    Hey everyone, I'm using Adobe Premiere 6.5 and am having problems importing video from my Camcorder (not digital) into Premiere. I bought a TV capture card (ATI TV Wonder). I have the camera set up properly. I can record video/sound perfectly with ATI's software, however Premiere doesn't...
  10. sirace

    User entered data on form to search for data.

    Hi, I have a form where I'd like a user to be able to enter some data and have it pull up related records based on what was entered. For instance, if I have an inventory of products dealing with fruit, my data would look something like this: item ---- Apple Sauce Apple Cider Orange Juice...
  11. sirace

    Form to lookup/search for data

    Ok, here's my dilemma. I have a database with 350000 transactions. Each transaction is linked to an account number. There about 64000 unique account numbers (field: account_no). How can I make a lookup box that will only include unique account numbers. Currently, I have the look up box get...
  12. sirace

    Simple Column Totaling

    I have a query called "manager_total" which has 6 columns: manager, rep_no, count1, count2, count3, count4. Sample data will looking the following manager rep_no count1 count2 count3 count4 ---------------------------------------------------------- john doe 1...
  13. sirace

    Excluding data from one query using another query

    Hello everyone, Here's my dilemma. I have two queries, "mailing_list_full" and "officer_search". The fields in "mailing_list_full" include account_no, address1, address2, address3. The fields in officer_search include account_no, address1, address2, address3...

Part and Inventory Search

Back
Top