Importing

Resolved · Low Priority · Version 2003

Mon 14 Apr 2008, 16:47 Delegate Kimberly said...

Kimberly has attended:
Access Introduction course
Access Intermediate course

Importing

Can you import data from all microsoft packages

Mon 12 May 2008, 01:34 Trainer Tracy said...

RE: Importing

Pretty much, simply go to File>Get External Data> and choose the file you want to import. You go through a wizard (a series of boxes). Obviously MS Powerpoint isn't something that holds the type of information that you would normally want to import so just keep that in mind
Good luck
Tracy

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.