98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Microsoft access - copying a form on our database to update for
Microsoft access - copying a form on our database to update for
Resolved · Urgent Priority · Version 2007
Mon 27 Oct 2008, 10:31Delegate Lizanne said...
Lizanne has attended:
Access Intermediate course
Microsoft access - copying a form on our database to update for
In our access database we have a form that we use to store all the information required such as contact details etc of our service users as they apply to us. This form is known as our 'active form' on the database and is linked to the main database that stores all of the individual forms we enter.
However, the active form we are using for 2008 will end 31.10.08 and we require a new form, exactly the same as the 2008 form but in a separate file and dated 2009.
How can I copy this form, save it and use it as a 2009 active form/file on access ?
I would be grateful for an email or call regarding this matter in order to set this up before the end of this week.
Thank you for your time
Lizanne Denness
Grants Administrator
01892 860207
Mon 27 Oct 2008, 12:11Trainer Stephen said...
RE: Microsoft access - copying a form on our database to update
Hi Lizanne
Thank you for your question
Can you clarify some points for me please.
1. Why will the active form end on the date specified?
2. Will the new form enter data into the same table/query as the old, or will it write to a new one? If the later, is the new table in the existing database or in a new one
Thanks
Stephen
Wed 29 Oct 2008, 16:09Delegate Lizanne said...
RE: Microsoft access - copying a form on our database to update
Hi Stephen, sorry for the delay replying, i had a day off !
Our administration for this programme runs from 1/11 to 31/10 yearly. We begin the 2009 programme on 1/11/08 and this needs to be a new table. At present i have on my access system a form for contacts in a table for 2007 and one for 2008. if I run queries etc I can then be specific to that table year.
I am relatively new here and this work was done for us by an old employee. The information was not passed on to us as to how to copy this form and make a new table.
A further question on this, if I want to begin from scratch and set up a new formfor a separate contact base, how would I go about that ?
if you do have the option to contact me by phone I would be grateful, 01892 860207. I am due to begin the 2009 new contact base on the new form next monday, so I am a little concerned about time !!!
Thanks for your help
Lizanne
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:How To Display An '&' In A Label In A FormTo have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as: |
