Attachments are stored within the Access database, which is nice beacuse alot of the overheard is taken care of. However Access is limited in file size to 2 Gb, if you are storing images and PDFs, you may be better off using linked files..
What is your application?
Take care,
Michael From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, September 27, 2011 7:33 AM
Subject: RE: [MS_AccessPros] Attachment control
>
>Steve-
>
>Why not just open a bound form in Data Entry mode? You can still validate stuff
>in the BeforeUpdate event of the form. Let Access do all the work.
>
>John Viescas, author
>Microsoft Office Access 2010 Inside Out
>Microsoft Office Access 2007 Inside Out
>Building Microsoft Access Applications
>Microsoft Office Access 2003 Inside Out
>SQL Queries for Mere Mortals
>http://www.viescas.com/
>(Paris, France)
>
>-----Original Message-----
>From: MS_Access_Professionals@yahoogroups.com
>[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Steve
>Sent: Tuesday, September 27, 2011 3:51 PM
>To: MS_Access_Professionals@yahoogroups.com
>Subject: Re: [MS_AccessPros] Attachment control
>
>Hi John,
>
>Why unbound? Well, it seemed a good way to gather the information needed
>for a new table record. When the user clicks the DONE command button, I
>do some error checking in the command button click event procedure and
>then an SQL INSERT INTO is used to add a new table record. Maybe that is
>not the best or even a good way to add a record to a table?
>
>Unbound or not, shouldn't double-clicking the attachment control bring
>up the Attachments panel?
>
>The attachments will typically be one or two files, most often pdf's or
>pictures.
>
>Thank you.
>
>Steve
>
>On 9/27/2011 8:42 AM, John Viescas wrote:
>> Steve-
>>
>> Why unbound?
>>
>> An attachment control is useless unless bound. What sort of attachment, and
>how
>> many? You could provide a command button to open a File dialog to locate the
>> file or files that should end up as attachments. Then to add the attachments,
>> you'll need to first create the record with all the non-attachment data, save
>> it, then open up the Recordset2 object of the attachment field to load the
>> files. I can dig up some sample code if you need it.
>>
>> John Viescas, author
>> Microsoft Office Access 2010 Inside Out
>> Microsoft Office Access 2007 Inside Out
>> Building Microsoft Access Applications
>> Microsoft Office Access 2003 Inside Out
>> SQL Queries for Mere Mortals
>> http://www.viescas.com/
>> (Paris, France)
>>
>>
>>
>> -----Original Message-----
>> From: MS_Access_Professionals@yahoogroups.com
>> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Steve
>> Sent: Tuesday, September 27, 2011 2:29 PM
>> To: MS_Access_Professionals@yahoogroups.com
>> Subject: [MS_AccessPros] Attachment control
>>
>> I have a table with about a dozen fields, one of which is the attachment
>> data type.
>>
>> I am developing a form with unbound controls which the user will
>> populate with information, click the DONE command button and add a new
>> record to the table.
>>
>> The form is working OK except for the attachment control. Double
>> clicking does not bring up the Attachments panel. Right clicking the
>> control brings up the context menu, but the Manage Attachments selection
>> is grayed out.
>>
>> What do I need to do to get the Attachment control to work?
>>
>> Thanks.
>>
>> Steve
>>
>>
>> ------------------------------------
>>
>> Yahoo! Groups Links
>>
>>
>>
>>
>>
>> ------------------------------------
>>
>> Yahoo! Groups Links
>>
>>
>>
>>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
>
>
[Non-text portions of this message have been removed]
Selasa, 27 September 2011
Re: [MS_AccessPros] Attachment control
__._,_.___
MARKETPLACE
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar