Microsoft Access provides the ability to insert pictures into forms and reports. The use of pictures can improve the appearance of the generated forms and reports. For example, it is possible to include a company logo in reports, and in the form provide the ability to view not only data about company employees, but also their photos. Special controls are used to insert pictures into forms and reports - free and attached object frames (Unbound Object Frame, Bound Object Frame), as well as a control Drawing (Image).
How you insert a picture depends on how you intend to use it.
- An OLE object can be stored in one of the fields in an Access table, for example, the Employee table in the Northwind database stores pictures of employees. You can also store Word documents in fields in an Access table. In this case, you should use the (Bound Object Frame) control to display these objects on forms or reports.
- OLE objects can be stored not in Access tables, but directly in a form or report. Using this method, a company logo can be saved in a form or report, for example. In this case, to display the OLE object, use the control Free object frame (Unbound Object Frame) or Drawing (Image).
- You can also use the property to add a picture to a form or report. Drawing (Picture) of this form or report. This is usually done when you want to include a background image (background) that occupies part of the window or the entire window of a form or report.
To add a background image to a form:
- Open the form in Design mode.
- In the form properties window on the tab Layout (Format) find property Drawing (Picture). In the input field for this property, enter the path and name of the image file. To do this, you can click the Builder button and select in the window Selecting a pattern (Insert Picture) required picture file (fig. 15.1).
Comment
Several standard wallpaper files are located in the MICROSOFT OFFICE \\ OFFICE \\ BITMAPS \\ STYLES folder.
- Set property value Pattern type (Picture Type). There can be two values: Rooted (Embedded) or Connected (Linked). If the picture is embedded, it is saved in the database file (mdb). The linked picture is stored in a separate file on disk. We have already discussed the advantages and disadvantages of both methods above. If the same picture is inserted into many forms or reports, then embedding it will cause the mdb file to "swell", since as many copies of the picture will be stored as the number of times you have embedded it. If you decide to make it linked, you need to take care not to accidentally delete it or move it.
- Use the following properties to customize the display of the wallpaper.
- Property The scale of the drawing (Picture Size Mode) has three meanings: Fragment (Clip), Fit to frame (Stretch), Fit to frame (Zoom). Value Fragment displays the picture at its original size. If the size of the picture exceeds the size of the form window, the picture is cropped. Value Fit to frame resizes the picture to fit the form window. Using this value may distort the picture. Value Fit to frame resizes the picture so that it fits the form window in either width or height. Using this value will neither crop the picture, nor distort its proportions.
Figure: 15.1. Dialog window Selecting a pattern
- If you are inserting a picture that does not occupy the entire form, the property Aligning the picture (Picture Alignment) allows you to define its position in the form: Top left (Top Left), Top right (Top Right), Center (Center), Bottom left (Bottom Left), Bottom right (Bottom Right), Center of the form (Form Center).
- Property Mosaic filling (Picture Tiling) allows you to display a repeating picture of a pattern.
An example of using a picture as a background in a form is shown in Fig. 15.2.
The background image is inserted into the report in the same way. An example of using a picture as a background in a report is shown in Fig. 15.3.
The picture can be inserted into the form and as a form control. There are two types of controls that can be used for this: Drawing (Image) and Free object frame (Unbound Object Frame).
Figure: 15.2.
Figure: 15.3.
If you do not need to directly change the picture in the form or report, then it is better to use Drawing (Picture) (the form will run faster). If you plan to change the picture frequently, you need to insert it using the free object frame.
To insert a control Drawing (Image), you need:
- Press the button Drawing (Image) on the Toolbox (the Toolbox Master button must be pressed to launch the Picture Wizard).
- Select the place in the form or report where the picture is placed and left-click on it.
- In the opened window Insert a picture (Insert Picture) select the name of the file containing the added picture and press the button OK. A control element will be created in which the picture is placed (Fig. 15.4).
- Set property values \u200b\u200bthat affect how the picture is displayed on a form or report. These properties are similar to the corresponding form properties.
Figure: 15.4. Using an element Drawing to insert a picture into a form
To insert a picture into a form or report using a free object frame, you must:
- Open a form in Form Design mode or a report in Report Design mode.
- Press the button Free object frame (Unbound Object Frame) in the Toolbox.
- Select a place in the form or report for the inserted object and click on it with the left mouse button. A wizard dialog will appear Inserting an object (Insert Object). Using the wizard, you can insert a ready-made picture from a file, or first create it in the appropriate application and then insert it. Therefore, further steps may be different.
If you have yet to create a drawing, follow these steps.
- In the dialog box Microsoft Access select switch Create new Object type (Object Type) select the application with which the drawing will be created (Fig. 15.5).
Figure: 15.5. Window Microsoft Access, used to insert a picture using a free object frame
- An object can be displayed as an icon, which is useful when it contains information that should not be displayed all the time. In this case, you just need to check the box In the form of an icon (Display as Icon).
- Press the button OK.
- Create an object using the application you selected in step 1.
- Close (Close) on the menu File (File) applications to return to Microsoft Access. Microsoft Access creates a control Free object frame (Unbound Object Frame) and displays the picture in it.
If you already have a file with a drawing, in order to insert it directly from the file, you need:
- In the dialog box Microsoft Access select radio button Create from file (Create From File) and then specify the path to the file. If you do not know the exact path, use the button Overview (Browse) (fig.15.6).
Figure: 15.6. Window Microsoft Access when inserting a picture from a file into a report using a free object frame
Figure: 15.7. Insert a picture Microsoft Paint into the report using a free object frame
- If you want to display the object as an icon, select the checkbox In the form of an icon (Display As Icon).
- To find a connection with an object, check the box Communication (Link). If the checkbox is cleared (default), the object will be embedded.
- Press the button OK.
An example of inserting a picture created using Microsoft Paint into a form using a free object frame is shown in Fig. 15.7.
After inserting an object, you can change its dimensions and proportions using the property Setting dimensions (Size Mode). In most cases, changes to a free object can be made in the Design view of a form or report. In order to be able to modify an object in form mode, you must set the property Access (Enabled) the free frame of the object to Yes, and for the property Blocking (Locked) - value No (No). To edit an object, double-click on it. To do this, it is only necessary that an application be installed on your computer in which a file of this type can be edited. An example of editing an embedded bitmap is shown in Fig. 15.8.
Figure: 15.8. An example of editing a bitmap using Microsoft Paint
To exit the editing mode, just click outside the picture.
Unlike other controls on a form that relate to records in the source table, the free-framed picture of the object does not change as you move through the records in the form — it is associated with the form itself, not the data that is displayed on the form. Pictures that are stored in table records are displayed on the form using an attached object frame.
Access tables use a special field type to store pictures and other OLE objects: OLE object (OLE Object). Control element Attached object frame (Bound Object Frame) is created in one of the standard ways:
- moving with the mouse the required field from the list of fields of the source table. In this case, the control associated with the field in the table will be immediately created;
- using the button Attached object frame (Bound Object Frame) in the Toolbox. In this case, a control will be created for which you need to immediately set the property Data (RecordSource) - the name of the field containing the OLE object (Fig. 15.9).
Figure: 15.9.
You can insert a picture into a table field both in a table opened in Tables mode and in a form. For this you need:
- Open a table in Tables mode or a form in Forms mode.
- Go to the record where you want to insert the picture and select the OLE object field.
- Run command An object (Object) from the menu Insert (Insert).
- In the dialog box Microsoft Access (see fig. 15.5) select the radio button Create new (Create New) and then in the list Object type (Object Type) select the type of application in which the object will be created. If the file with the picture is already ready, then you need to select the radio button Create from file (Create From File), and then specify the path to the file.
- To display the object as an icon, select the checkbox In the form of an icon (Display As Icon).
- Press the button OK.
- If you are creating a new drawing, then you need to create it using the application selected in step 4.
- After finishing creating the object, select the command Close (Close) on the menu File (File) applications to return to Microsoft Access.
The picture will be inserted into the record in the table. In this case, in the Shape mode, a drawing or other object will be automatically displayed on the screen. In Table mode, only the type of object will be displayed, for example Bitmap drawing.
Graphic files are inserted either directly or using separate graphic filters. These filters are installed when Microsoft Access is installed. You do not need a graphics filter to insert Enhanced Metafile (EMF) files, Windows bitmaps (BMP, RLE, DIB), Windows Metafile (WMF), and Icon (ICO) files. However, such filters are required to insert all other graphics file formats listed below:
AutoCAD Format 2-D (DXF) Computer Graphics Metafile (CGM)
CorelDRAW (CDR) Encapsulated PostScript (EPS)
Graphics Interchange Format (GIF) JPEG File Interchange Format (JPG)
Kodak Photo CD (PCD) Micrografx Designer / Draw (DRW)
PC Paintbrush (PCX) Portable Network Graphics (PNG)
Tagged Image File Format (TIFF) Targa (TGA)
WordPerfect Graphics (WPG) HG Graphics Language (HGL, PLT) Macintosh PICT (PCT)
To add a background image to an Access form, for example, to the main button form, you need to start the database ("Student performance" with the main button form) and click on the Database Window button on the toolbar. The Access Database Window opens, in which open an Access button form in Design mode.
To add a background image to an Access form, you must open the Button Form Properties dialog box, which you can open in several ways. Let's consider one of the ways: open the Properties window by right-clicking on the button form, and select Properties from the context menu. The Picture: Picture window opens on the Layout tab.
Figure: 1.
To enter the path and name of the picture, click on the browse button, the Select Picture dialog box will open. In this window, you must specify the name and type of the file. By default, Microsoft Office Access supports the .bmp, .dib, .wmf, .emf, and .ico file formats. Therefore, select a picture with one of the specified extensions and click the OK button in the Select Picture dialog box. I chose the .bmp extension for the picture.
Next, in the Picture: Picture window, specify the type of picture, it can be embedded or linked. The main differences between binding and embedding (embedding) are where the data is stored and how the data is updated after it is placed in a document. The embedded drawing is an integral part of the Access form; will be stored in the database, increasing its size.
A linked object is data (an object) created in one file and pasted into another file with support for file-to-file communication. The linked object is not part of the file in which it is inserted, but is stored in the original file in one of the PC directories, without increasing the size of the database. If a picture or company logo needs to be placed on each form and in reports, then it is advisable to insert the picture as a linked object.
I chose the embedded image, since it is an integral part of the Access database, which allows Internet users to copy (download) the database file from the site.
The next step is to set the dimensions of the picture. The scale of the picture has the following meanings:
- Fragment;
- Fit to frame;
- Fit to frame.
Choose one of the values \u200b\u200bdepending on the purpose. In the button form Access Student_Progress I chose the scale of the picture - Fragment, alignment - Center, the result is shown in the figure
Figure: 2.
After closing the Picture: Picture and Button Form: Form windows, double-click the Button Form button, the following Access Main Button Form with a background image will open.
Figure: 3.
Inserting graphics, photos, and logos into forms or reports can help improve their appearance and personalize your Access database.
Hello! In this article I will show you how to create a button in Microsoft Access database.
The creation of buttons on the form is independent of which version of Access you have installed (2003, 2007, 2010, 2013, or 2016). In this article, I will show you 2 ways to create buttons on a form in the Acceess database: using a wizard and using a macro.
How to do it?
Step 1. Create the form
If you don't have a form, you need to create one. You can see in more detail how the forms are created. Go to the "Create" tab, the "Form Wizard" item. Next, select a table or query on the basis of which the form will be created. Next, select the required fields and click "Next".
Choosing the appearance of the form.
Set the name of the form and click "Finish".
Open the form in design mode. How to create a button in Microsoft Access database will be described in the second step.
Step 2. Create a button using the wizard
On the toolbar, select the "Button" item and place it on the form. The Button Wizard window appears. Here you need to select the required category and set a specific action. Select "Previous entry" and click "Next".
Choose what is displayed on the button: text or image. We leave the picture by default and click "Next".
Set the name of the button and click "Finish".
Now let's create a button with text. Let's go to the master of buttons again, select "Next entry".
Step 3. Creating a button using a macro
On the toolbar, select the "Button" item and place it on the form. The Button Wizard window appears. Click "Cancel".
Double click on the created button to open the properties window. Go to the tab "Events" item "Pressing the button". Press the button with three dots.
Select "Macros", click OK.
Access 2010 has the ability to add objects to a field with data type OLE... In the case when the data type is specified as OLE (Object Linking and Embedding- linking and embedding an object), then Access keeps the external an objectin a common database file, allocating as much space for storing it as this object takes as a separate file. Under objectsshould be understood as files created as applications in graphics editors, video clips, in MS Office applications, etc. When the table is filled with data that are objects, a message about the program with which you can open this object is generated in the corresponding position of the field with the OLE data type. Object display will be carried out only in forms and reports.
For embedding an object in the field with oLE data type you need to open the table in mode "Constructor".Add a new field like "Product photo".Select data type OLE Object Fieldand then save the table.
Then in the "Table" mode in the line for data entry, right-click, in the menu that opens, select the line with the command, which will open a dialog box (Fig. 3.38, Fig. 3.39).
Figure: 3.38 Inserting an Object
Figure: 3.39 Dialog box for adding a new object to the Access table
Remember that there are two ways to embed objects as data. The first option provides for the use of standard applications for creating a file that Access supports, the second option for inserting an object, which allows you to use any file as a data source (Fig. 3.40).
Figure: 3.40 Adding a new object to an Access table from a file
1. Creating an object from a file.
When it comes to data, which are objects for the database, and are external files, then you need to have these files. Therefore, you will need to create several files in order to later see their display in the database, as well as try to modify these files. For example, if you have a photo of an object in the file Monitor.jpg (jpg is a universal photo format). In order for this file to be saved in the database, in the window (Fig. 3.40) check the box "Create from file" , after which a window will appear, which is shown in Figure 3.41. Using the button "Overview" select the required file.
Figure: 3.41 Finding a file when creating an object in the database
In the corresponding line for the field e.g. "Product photo" a word will appear "Package", this means that the file is linked to the application with which it was created. Therefore, when viewing the database, whether it be a query, a form or a report, the user will see the image of the file as an icon, and when double-clicking on this image, the system will first find the application and then display the contents of the file in it (in this example, this is a photo) ... The only exceptions are image files saved with the extension .bmp (bit map format). However, it should be recalled that files created in Microsoft applications will be displayed immediately in forms and reports. The conclusion is simple, photos can be inserted into applications such as Paint, Word, Power Point, saved as separate files, and then connected as an object to the database. Try to create multiple files with photos and text using different Windows editors. For example, you can open a Word document, insert a photo from the file, add text, and then save as: Monitor.docx(fig. 3.42).
Figure: 3.42 Photo file created in Word
2. Creation of new objects.
The creation of new objects in the database should mean the use of the application in which the file is created and then connected in the field describing the type of this OLE. To start the mode of creating new objects, you must open the table in mode "Table", choose an option "Create new" in the dialog box (Fig. 3.39), and then select in the list "Object type" (required application). The list of applications that Access supports for creating an object are in the list (Fig. 3.43), which will open after running the command "Insert Object" .
Figure: 3.43 List of Access Object Types You Can Use to Create Files
The convenience of using applications for creating objects in the form of files lies in the fact that in the future these files can be used autonomously or corrected in the database.
Consider object creation option for the database using with paint applications.
For example, you need to create an object with an image of a company and text, which the user of the database can later replace or correct. To do this, select from the list bitmap Image object, further technology for creating an object is shown in Figure 3.44.
1. Open the Paint app
2. Insert photo from file.
3. Add text (if necessary).
4. Save as file.
5. Close the application.
Figure: 3.44 Object creation technology in Paint
The task 3.11
1. In the table “ Products"In the mode "Constructor" add a new column named "Product photo", data type " OLE Object Field ", save your changes.
2. In the mode "Table" in field "Product photo" select the line "Insert object from file", select (dot) "Create new" and from the dropdown list microsoft Word document... This will open a text editor MS Word, here you need to insert a picture corresponding to the product in this line. Select pictures from the list stored directly in the editor ("Insert" tab, "Picture" icon, "Start" button in the dialog box on the right), or insert a picture from other programs. You can use the Paint application (Bitmap Image object), where you draw the product yourself. Close the created file, it will automatically be linked to your database, to the line in which it was inserted.
3. Follow this procedure to all lines your "Products" tables.
4. Save your changes.
Control questions
1. What objects can be inserted into a database with the OLE data type?
2. How can you insert a photo into a table in the "Table" mode?
3. Where in the database will the photo be displayed?
4. What is the difference between the "Create new object" method and the "Create from file" method?
5. How to put a product photo file into the database if it has the extension .png?
6. Is it possible to edit a file that is inserted as an object into the database directly in the computer's file system?
7. How to insert a presentation into the database?
8. What application objects can be inserted into the database?
Attachments can be used to store multiple files (including different types) in one field. For example, in a business contact database, you can add one or more resumes and a photo to each contact record.
Attachments also allow you to store data more efficiently. Earlier versions of Access used Object Linking and Embedding (OLE) technology to store images and documents. By default, OLE technology was used to create a raster equivalent of an image or document. These bitmap files can be too large - sometimes 10 times the size of the original file. When viewing an image or document from a database using OLE technology, the bitmap was displayed instead of the original file. When you use attachments, documents and other non-image files open in their respective programs, so you can find and edit these files directly in Access.
In addition, OLE technology requires the use of programs called OLE servers. For example, if an Access database stores JPEG image files, each computer running the database must run a separate program registered as an OLE server for JPEG images. In contrast, Access saves attachments in their original formats without any supporting images, and no additional software is required to view images from the database.
Attachments and Database Development Rules
By default, each field in a relational database contains only one piece of data. For example, if the address field contained several addresses, it would be difficult or even impossible to find the correct one. Therefore, at first glance, it seems that attachments violate database design rules, because you can add multiple files to a field, that is, several pieces of data. However, design rules are not violated, because when attaching files to a record, Access creates one or more system tables and uses them invisibly to normalize the data. You cannot view or work with these tables.
For information on viewing other system tables, see the Navigation Pane Guide. For more information on database design, see Database Design Basics.
Ways to use file attachments
When working with attached files, the following rules must be observed.
You can attach files only to databases created in Access that use the ACCDB file format. Attachments cannot be exchanged between Access databases (ACCDB) and older format databases (MDB).
You need to create a field in the table and set the Attachment data type for it. You cannot change the data type after it is set to Attachment.
It is possible to store several files in one record. For example, you can store images and files created with word processing programs and spreadsheets.
You can attach data up to two gigabytes (the largest size in an Access database). Individual files cannot exceed 256 megabytes in size.
To add, edit and manage attachments use the dialog box Investments... This dialog can be opened by double-clicking from the attachment field in the table. If you want to manage attachments from a form or view them from a report, you must add an attachment control to the form or report and associate that control with the desired attachment field in the table.
By default, the attachment control processes images and displays program icons that correspond to other file types. Suppose you have a photo, resume, and Visio document attached to your post. As you navigate from one attachment to another, the control renders an image and displays program icons for Word and Visio documents.
If you open a dialog box Investments from a spreadsheet or form, attachment files can be added, deleted, modified or saved. If you open a dialog box Investments from the report, you can only save attached files to another location.
Attachment files will be compressed by Access if they were not compressed originally. For example, JPEG files are compressed by the graphics program that creates them, so Access does not compress them.
If the program that you used to create the attachment is installed on your computer, the attachments can be opened and modified using that program.
Attachments can be managed programmatically.
The following sections provide instructions for adding and managing attachments.
Adding an attachment field to a table
To use attachments in Access, you must first add the attachment field to at least one of the database tables. There are two ways to add an attachment field to a table: in table mode or in design mode. This section describes both methods for adding a field.
Adding an attachment field in table view
Add an attachment field in design mode
Attaching files directly to tables
After you add an attachment field to a table, you can attach files to the records in that table without creating a data entry form. You can also view attachments without using a form, but remember to view directly from tables using the programs that created the files or programs that support this type of file. For example, when you open a Word document attached to a table, Word starts and the document is viewed in that application, not Access. If Word is not installed on your computer, a dialog box prompts you to select a program to view the file.
Adding an attachment to a table
Opening file attachments from a table
In a table open in Datasheet view, double-click a cell in the attachment box.
In the dialog box Investments double-click the file you want to open.
Select the file and click the button Open.
The file will open in its associated program - Excel files open in Excel, and so on.
Some image files can be opened with Windows Picture Viewer. If you need more than just view the image, you can right-click and choose Edit... This will launch the program with which this file was created, if it is installed on the computer.
Saving changes in an attached file
Using attachments with forms and reports
If you need to use attachments with a form or report, use the attachment control. As you navigate from one database record to another, this control automatically displays the image files. If other file types are attached, such as documents or charts, the attachment control displays an icon that matches the file type. For example, if a presentation file is attached, a PowerPoint icon appears, and so on. This control allows you to see which files are attached and open a dialog box Investments... If this dialog is open from a form, attachments can be added, removed, modified, and saved. If you open it from a report, you can only save attachments to your hard drive or the network because the reports are read-only.
The following sections provide instructions for adding a picture frame to a form or report, navigating between records, attaching files, and viewing attachments. Remember that moving between attachments is only possible if the record contains multiple attachments.
Add an attachment control to a form or report
This section describes how to add an attachment control to a form or report and bind it to the Attachment field in the appropriate table. The procedure for adding an attachment control is the same for a form and a report. The first step is to make sure that at least one database table has an attachment field. For more information on adding an attachment field, see the section above.
Designing a form or report can be complex, so this section assumes that you already have a database with at least one table and one form or report. For information on creating tables, forms, and reports, see the following articles:
Adding an attachment control
Managing attachments using a form
After the attachment control is added to a form, attachment files can be added, modified, deleted, and saved directly from that form. If a record contains several attachments, you can scroll from one attachment file to another by scrolling (this is not possible when working with a table).
Note: The user who created the form can make it read-only. In this case, the dialog box Investments can only be used to save attachments to your hard drive or network.
File attachment
Scrolling through attached files
Note: The steps in this section apply to forms and reports.
Click the arrow to scroll through the attached files Back to (left) or Forward (to the right). To see the file names, click View attachmentswhich opens the dialog box Investments... The names of the attached files will be shown in the list Investments .
Save attachments elsewhere
The steps in this section apply to tables, forms, and reports. Any or all of the files attached to a given entry can be saved to your hard drive or network. Remember that if you choose to save all files, you cannot save individual files — you can only save all of them. To selectively save files, save them one at a time.
First open the table, form or report containing the attachments, and then open the dialog box Investments.
Opening a dialog box Investments from the table
Open the table in table view and double-click the field that contains the attachment you want to save.
Opening a dialog box Investments from a form or report
Open the form or report that displays attachments.
Navigate to the entry containing the attached files.
Click the Image control that displays the attached files.
The mini toolbar will open.
Click the button View attachments.
Saving an individual attachment
In the dialog box Investments press the button Save as.
A dialog box will open Save attachment.
Use the list Foldersto navigate to the new file location and click Save.
Save all attachments
In the dialog box Investments press the button Save all.
A dialog box will open Saving attachments.
Use the list Foldersto navigate to the new file location and click Save.
Removing attachments
The steps in this section apply to tables and forms.
Removing an attachment
Double-click the attachment field in the table to open the dialog Investments.
In a form (Layout View or Form View), navigate to the record that contains the attachment you want to remove, and on the mini toolbar, click View attachmentsto open a dialog box.
In the dialog box Investments select the file you want to delete and click Delete.
Using attachments without using a mouse or other pointing device
The next section describes how to use the keyboard to set focus in the Navigation Pane and open a table, form, or report that contains file attachments. It also provides step-by-step instructions for viewing file attachments and opening a dialog box. Investments.
Opening a table, form, or report from the Navigation Pane
Press the F11 key.
Note: If the Navigation Pane is closed, pressing F11 will open it and focus on that area. If the Navigation Pane is open, pressing F11 will close it. Press F11 again to open the Navigation Pane and move focus to it.
Use the UP ARROW and DOWN ARROW keys to select a table, form, or report to open.
Press Enter to open the selected object.
When you open a table, the insertion point will be placed in the first field of that table. When you open a form or report, the focus will be on the first field.
View attachments from tables
You can use the arrow keys to move the cursor to the desired nesting field.
Press the SPACEBAR.
A dialog box will open Investments.
To navigate between buttons in a dialog box or from buttons to a list of attachments Investments use the TAB key.
Note:
OK Press the Tab key or the UP ARROW and DOWN ARROW keys, and then press Enter.
Move between attachments by scrolling from a form or report
These steps are only possible if you have a Microsoft Natural keyboard and the entry contains multiple attachments.
Press the application key.
A context menu will open.
Please select Forward or Back to
Repeat step 2 as needed to move to the next attachment.
Opening the Attachments dialog box from a form or report
These steps are only possible with a Microsoft Natural keyboard.
If necessary, use the Tab key to move focus to the attachment control. By default, Access selects this control and its associated text box, if it exists.
Press the application key.
A context menu will open.
Select item View attachments by using the Tab key or the arrow keys, and then press Enter.
A dialog box will open Investments.
Press the Tab key to navigate between buttons in a dialog box or from buttons to a list of attachments Attachments (change - double click).
Records can contain multiple attachments. If you want to select an attachment from a list of multiple files, use the Tab key to navigate to the file list, and then use the arrow keys to select the desired file. After that, press the Tab key to return to the buttons and select the desired action.
With the desired file and button selected, press Enter.
When finished, select the button OK by using the Tab key or the arrow keys, and then press Enter.
Attachment Reference
The following is a reference for attachments, including the supported image and document file formats, file naming conventions, and some information about how to attach files to recordings by programming.
Supported image file formats
Access directly supports (that is, displayed using an attachment control without using additional software) the following graphic file formats:
BMP (Windows Bitmap)
ICON, ICO (icon)
WMF (Windows Metafile)
EMF (Enhanced Metafile)
Supported document and other file formats
As a rule, files created in any Microsoft Office program can be used as attachments. In addition, you can attach log files (LOG), text files (TEXT, TXT), and compressed ZIP files.
File naming conventions
Attached file names can contain any Unicode characters supported by the NTFS file system used by Microsoft Windows NT (NTFS). In addition, filenames must comply with the following rules.
Names must not exceed 255 characters, including the filename extension.
Names must not contain the following characters: question mark (?), Quotation marks ("), left or right forward slash (/ \\), angle brackets (< >), asterisk (*), pipe (|), colon (:), paragraph mark (¶).
File types that Access compresses
When you attach any of the following file types to your database, Access compresses the file if it was not originally compressed.
File extension | Compression | Cause |
|---|---|---|
Blocked file formats
Access blocks attachment of the following file types. The attachment of such files cannot be unlocked at this time.
Attaching files to recordings by programming
Access allows you to use the Object Model and Programming Interfaces to attach files to records programmatically using VBA (Visual Basic for Applications) code. For more information, see the articles "LoadFromFile" and "SaveToFile" on MSDN
