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 » Access Training
Access Training
Resolved · High Priority · Version 2003
Thu 16 Jul 2009, 09:29Delegate Anita said...
Anita has attended:
Access Introduction course
Access Intermediate course
Excel Intermediate course
Excel Advanced course
Effective Communication Skills course
Access Training
2 questions:
1) Creating a form. When you have created a form from a tables fields, then subsequently you add a field to the existing table, how do you get that field added to your Field List under forms?
2) The form. If you copy an existing layout of a form from excel to act as a background for your form (i.e. just adding the fields as boxes on top of the copied template which sits in the background), how do you expand the form parameters to show the whole form if it is bigger than the screen. When i go into Design view I can see the whole form, but when I switch to 'Form View' it cuts out half the form.
Thanks,
Anita
Mon 20 Jul 2009, 14:47Trainer Stephen said...
RE: Access Training
Hi Anita
Thank you for your question
Question 1
Once you have added the field to the table, go to the form that is bound to that table. Open the field list for the form by selecting the shortcut on the tool bar. The new field will appear on the lst and you can then just drag it onto the form.
Question 2
Could you clarify for me the nature of the excel document. Are you copying from an excel form or spreadsheet; if the latter, then how are the controls (text boxes, buttons created?)
Regards
Stephen
Thu 23 Jul 2009, 15:04Trainer Stephen said...
RE: Access Training
Hi Anita
Further to your first question, I have had some additional ideas.
In order to test them I would need to have access to your database. If this is possible could you please email it to me at stephen@micrsosfttraining.net and i will investigate further.
In addition, did switching the toolbars on in the forms property sheet solve your second question?
Regards
Stephen
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:Label printingYou can create a report in Access for printing labels All you have to do is is click New under the Reports object and then select Label Wizard and follow the steps |
