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
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
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
