control type - attachment

C

chill

hi
when im adding a new control attachment into a form , appears some other
controls like ...controlname.filedata ,controlname.fileflag, controlname.
filetimestamp ,controlname.fileURL etc....

whats all these , r these usefull and needed ?

thanks
 
A

Allen Browne

This occurs only in Access 2007, and only for multi-valued fields.

The example you gave is for a field of type Attachment. One record can have
multiple attachments. In a query, you can get at the information within each
of the items in the multi-valued field. For example look at the FileType to
see if the attachment is a picture (e.g. JPG), Word document, or whatever.

If you do choose these sub-field elements in a query, the record repeats on
as many rows as it needs to. You generally don't want that in a form.
 
C

chill

thanks Allen

may i ask one more question pls ....

in a simple form that comes from a table , how can i achive scroling
between records using the mouse? there is a key (taskID) and the second value
(task_type) which is a combo box. Using the form wizard i can move from a
record to record pressing the buttons.
thanks
 
Top