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 SkipVought 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: *

  1. swan717

    Remove Duplicates Records

    Thank you John!
  2. swan717

    Remove Duplicates Records

    Hi: I'm trying to figure out a way to remove duplicate records (rows) from a large Excel spreadsheet. If there isn't an easy way to do this in Excel, maybe there is a way in Access. Example data: 1236 - Tom Jones 1696 - Jim Smith 1788 - Aimee Hunts 1236 - Toms Jones (duplicate) 1966 - Billy...
  3. swan717

    Auto Populate a field

    Hi: I'm trying to create a database that will automatic populate a field when I enter something in the prior field. For example, the table has the following four columns: vendor, address, town, and date of service. The vendor's contact address and town will always be the same, so I want to...
  4. swan717

    Auto Populate a box

    Thanks for the tip, but I'm not really sure how to apply it to Microsoft Accss. Any suggestions?
  5. swan717

    Auto Populate a box

    Hi: I'm trying to create a database that will automatic populate a field when I enter something in the prior field. For example, the table has the following four columns: vendor, address, town, and date of service. The vendor's contact address and town will always be the same, so I want to...
  6. swan717

    PowerPoint Header

    Hi: I'm trying to create a presentation that will have the same header on every page except for the title page. I've tried everything that I know how to do, I even tried drawing a white box over the text that's appearing on the title page, but it looks really bad when I print the presentation...
  7. swan717

    Add New Record Command Button?

    Hi: I've created a simple data entry form in Access and added a command button to add a new record. The button works, but I want the cursor to go back to the top of the page. Can anyone help??? Thanks!
  8. swan717

    Sum function is not updating

    Hi: I have a spreadsheet that has a sum function that does not update until I save the spreadsheet. Can anyone help me figure out why? Thanks for your help, Swan717
  9. swan717

    Linked Spreadsheet

    Hi: I am trying to figure out how to change a negative linked number to a positive number, without having to manual change it. Can anyone help? Thanks
  10. swan717

    Access Charts

    Hi GingerR: The main report is running off of tables, queries, and subreports. Everything is based on the community name which in the report is in the header as =[community_name] & " COMMUNITY PROFILE" The subreports are created so that Community name is listed as the "link...
  11. swan717

    Access Charts

    Hi: I am creating a report (template)in Access that has several charts, table, and text. The template has all the same charts, but each page corresponds to a different town and therefore has different numbers. The problem is that I am missing data for some years for some of the towns (not the...
  12. swan717

    Should I use Trim or Len?

    I've copied and pasted some information (3 columns) from a pdf file into Excel. I pasted the information and everything appeared in one column. So I used the Convert Text To Columns - Delimited - by a period (as the text has periods to separate the three columns. However, some of the...
  13. swan717

    Submit (mail to) command button on Access forms

    I am in the process of designing a form to act as a user interface. The form is for internal requests for information/project assistance. Basically the person will enter the criteria for the project or information that they need and will hit a submit button. I would then like the information...

Part and Inventory Search

Back
Top