Search results

Ok - thanks I think I've got it now Also reading up on how to better ask questions :o

I'm sorry - I was referring to your suggestion from your previous post... "Onto this issue--I would create a field called 'EditDate' in the Contact table to hold the date the last edit was made to that record. If you would like to note what was edited you could add a field called...

Unable to find 'Record Creation'...is it a built-in expression?

Drats...I wanted one less thing to remember to enter

Access help seems to be saying that the default for EditDate =Date() would be the creation date of the record and a macro is required for ModifyDate...or am I missing something?

Plog - I'm open to and appreciate your constructive criticism! The Contacts table has over 2000 contacts for 132 companies The company table has those cool little plus boxes next to each company name so I can quickly look up or edit the contacts from just that company without having to scroll...

Duh...of course...hmmm, now which table or maybe both need a date field? Not really sure how to post my tables but here are the fields for each: Company table fields: CompanyID / Company / Parent Group Contact table fields: ContactCompanyID / Company Name / first name /last name / address /...

Hello - I used to keep my list of company and contacts in an excel spreadsheet, which are now in Access. Each month I have to send the company/contact list to the contacts with the current month's changes/updates highlighted. In excel I could color-code the row (required to bring attention to...

I see - thank you so very much - Cheers!

Ah ha!...you are correct. Found that setting and changed it to none - thanks! Out of curiosity, how could those be utilized?

Here it is larger

Too tiny...will redo

Oh maybe I was using the 'Quick reply'...duh Attached pic - hopefully it's readable - thanks!

Trying to post pic but keep getting message too many characters no matter how small the pic is...suggestions?

Ok, found that setting...thanks to another of your posts with a very nice image of the properties box ... Changed it to neither (didn't have a 'none' option) Closed it, saved the changes and they still remain on the form? Any ideas how to remove?

I've created a fill-in form to add new 'contacts', ie: firstname lastname username password...etc On each line of the form to the right of the fill-in line is an up & down arrow. They don't seem to do anything...can anyone tell me what these are for? thanks!

Hi Pat - I see your point...will recreate the tables per John's diagram but still not getting how the 2 tables coincide ...I need to split the excel spreadsheet into company and contacts and import each? Do I let Access assign primary key for each? (For the 132 companies and over 2000...

Simon, Ok I've made the contacts table...and made several queries. It seems uneccessary to create a Companies table as I can acquire all information from the Contacts table...unless I'm still missing something...:confused: Melinda

Simon...thanks for the reply...think it's starting to sink in now. Could you please expound a bit more on your last sentence 'aggregating' CompanyID? ... such a newbie :o

John & Pat - thanks for the input! :D I'm sure there's something simple I'm missing here... Understand the 2 tables and PK for company_tbl, (which will be their account number) and that company_id will be FK in contact_tbl In short, the excel sheet is set up like this...