Search results for query: *

Thanks everyone, i got it to work!!!!

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

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?

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?

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

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

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

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

Thanks! worked like a charm!

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

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

You my friend are a genius! Thanks!

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

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

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

Thanks! i will keep it off ;)

I Don't know what i did but i really liked this ralationship in my database that showed all records in a different table connected to this id. like these little plus signs that when clicked on shows the other info. How do i get this back?

Hi, I have a form that updates an existing table. The problem is when i would like to create a new record based on a existing ID i would like the first_name and last_name field to auto-populate based on when i select the user_id in the pull down menu. So, when i select ID '1' i would like it...

Sorry.. I'm a newfie (from Newfoundland) so i say guys for everyone.. Thanks Guys and Gals!!

Yessssssssssss! THANKS GUYS!!