Access Training

Resolved · High Priority · Version 2003

Thu 16 Jul 2009, 09:29 Delegate 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:47 Trainer 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:04 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Label printing

You 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

View all Access hints and tips