Recent content by newbieaccess

Thank you for your help :) Question how do I say in the query update if there's already a member. Would I do I join on the new temp table with the master table? So I would have 6 total queries? 3 update and 3 append then I put in 1 macro? Thanks again :)

Hi all - I'm working on an access db that contains 3 tables 1) Member Table 2) Address Table 3) Contracts Table Then I have a form that pulls them all in together with subforms as the Address & Contracts attached to the Member Each week someone goes out to another source and pulls in new...

Thank you - I think I got it :)

Is there a way for us to hide all of the tables, queries to only show the form for the person doing data entry? Thank you

this is probably a really stupid ? but how do I know the name of the control? I just went to property sheet at the form level and put in the code from the ... next to On Got Focus

Thank you, I tried it but it's still black. I went to properties On Got focus then Code builder and copied in: Private Sub Form_GotFocus() Me.ControlName.ForeColor = 65535 'Yellow End Sub Private Sub Form_LostFocus() Me.ControlName.ForeColor = 0 'Black End Sub But, it's not working? Am I doing...

The links you sent were really helpful - I appreciate it :)

Is there a way to change the highlighting in a form when the user tabs thru their choices to yellow rather than black? Thank you!!!!

Thank you - I'll go thru them now :) I appreciate your help

thank you - there are relationships built, but they are just one -to - many? Do we need any cascading or referential integrity? -- thanks again!

I think he created the relationship but doesn't appear to have created a parent-child link? Can you do this after the fact?

how do I know where the primary keys and foreign keys are? I didn't create the form? When we tried to test it by changing the name in the master section it didn't change it in the other two?

Thank you for such a quick reply. I'm still a little confused. Here's an example: Company A is in Master, Funding & Contacts the Funding and Contacts tables have a 1 to many relationship with the Master because they can have multiple records. So, Company A down the road gets acquired or they...

Sometimes a Company can be acquired and we move to the acquired name so in the Master we would change it and would like to change it in the other 2 tables as well?

Initially we added in the autonumbering but how do you pull in information from the other tables using that logic because there is a 1 to many relationship Example Master Table only has 1 row per Customer then there's a funding table with many events occuring per customer and another table of...