Recent content by swan717

Thank you John!

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

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

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

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

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

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!

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

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

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

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

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

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