By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,985 Members | 2,877 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,985 IT Pros & Developers. It's quick & easy.

Updating a table in Acess Automatically

P: 1
Hi,

I am wanting to make an asset management system to display PCs and their users.

The thing i am trying to do is:

When a user leaves, I want to be able to delete the user, then it will somehow automatically insert their PC (which is related to them) into another table called spare PC's

I havn't had much experience with access, especially in the last couple of years. I am running Access 2007

thanks
Jan 30 '08 #1
Share this Question
Share on Google+
1 Reply


Jim Doherty
Expert 100+
P: 897
Hi,

I am wanting to make an asset management system to display PCs and their users.

The thing i am trying to do is:

When a user leaves, I want to be able to delete the user, then it will somehow automatically insert their PC (which is related to them) into another table called spare PC's

I havn't had much experience with access, especially in the last couple of years. I am running Access 2007

thanks
Just a suggestion...You can do this Mike but why not simply have a field maybe a checkmark that denotes that the user has left. You can always raise a query then based on that field that determines who is active and who has left and retrieve PC's or other info via a query? Saves having to manage your synchronisation between two tables or am i off the mark according to the design?

Welcome to the Scripts!

Jim :)
Jan 30 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.