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!

Recent content by abbottboi

  1. abbottboi

    Using PHP to display calendar of events

    Thanks everyone, i got it to work!!!!
  2. abbottboi

    Using PHP to display calendar of events

    Hi Smart People, I would love to take an existing excel document and upload it to the web and have it displayed. This document currently shows row by row different events my not-for-profit organization holds with who's speaken etc. The value in having it display online would mean greater access...
  3. abbottboi

    Software like excel that allows you to open more than 65000 records?

    Does anyone know of a software that i could use to open files more than 65000 records? Mostly I only need to be about to clean up lists with sorting and deleting. I currently have to open them in ms Word and break then up into several files to use with excel. Any advise?
  4. abbottboi

    forms not behaving.

    Hi there, It doesn't need to store those names at all. It would just be used as a reference to ensure that i am entering the donor information with the right ID. I have reports that pull information based on ID. this is how i had planned it. what you think?
  5. abbottboi

    forms not behaving.

    This worked great, the thing is that this way i can select the persons name from the combo box and it filles the donor_ID field and the first name and last name. which is great. The small modification i would be awesome is that i would like to select donor_ID and then populate the first name...
  6. abbottboi

    forms not behaving.

    JOEATWORK For the second part (autopopulate) my field names are first_name and last_name and the table containing that info is called Propects Could you write that bit of code again using that thanks. Also, should my new autopopulate fields be fields in a new table or can they be fields from...
  7. abbottboi

    forms not behaving.

    k, i have two tables, one for prospects and one for donations(transactions) now. since i'm setting this up for someone who won't be that computer savvy so i created two froms that are linked to the two tables. This way the person entering data will not have to be in the tables but only the...
  8. abbottboi

    forms not behaving.

    Hi there, I have a 2 tables and 2 forms and while the tables are behaving the way i want them too.. ie. with the validation tables relationship etc.. when i try to use the forms to enter the same data there's no pull down menus etc. Also, when i type in the id in the form i would love the name...
  9. abbottboi

    Check all boxes as yes!

    Thanks! worked like a charm!
  10. abbottboi

    Check all boxes as yes!

    maybe have a default value of yes? how do i do that? lol.. sorry not an expert in access
  11. abbottboi

    Check all boxes as yes!

    Hi, I have a table of 2000 records and i have a yes/no box for each of them. I want to check all of the boxes as Yes but don't want to go through them all. Any ideas? Thanks
  12. abbottboi

    Append Query!

    You my friend are a genius! Thanks!
  13. abbottboi

    Append Query!

    INSERT INTO Prospects ( old_ID, donor_type, prefix, first_name, last_name, re_address1, re_address2, re_city, re_prov_state, re_nation, re_postal_zip, bu_company ) SELECT Sheet1.old_ID, Sheet1.donor_type, Sheet1.prefix, Sheet1.first_name, Sheet1.last_name, Sheet1.re_address1, Sheet1.re_address2...
  14. abbottboi

    Append Query!

    Hi, I want to append 1500 records to an existing table i have. So one table to another. The problem i'm having is that when i make the append query run it duplicates my records 576 times making me have far more duplicates than even one should ever want. I do look at datasheet view and it too...
  15. abbottboi

    Appending in Access

    Hi, I want to append 1500 records to an existing table i have. So one table to another. The problem i'm having is that when i make the append query run it dubplicates my records 576 times making me have far more duplicates than even one should ever want. Does anyone know what it creates...
See more

Part and Inventory Search

Back
Top