Steve-
Is the user closing the form, or are you doing it in code? It's closing the
form with the dirty record still on it that's causing the error. What code do
you have behind the DONE button?
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 11:40 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Attachment control
John -
That works, but I get a "You can't save the record at this time" error
message asking the user "Do you want to close the database object anyway?"
How can I suppress the error message and return the user to the screen
so he can make corrections?
Steve
On 9/27/2011 4:15 PM, John Viescas wrote:
> Steve-
>
> Set Cancel = True to stop the save.
>
> 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 10:06 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Attachment control
>
> John,
>
> If during the BeforeUpdate event I do field validation and find
> something wrong, how do I stop the record from being added to the table
> and keep the form on the screen for the user to make corrections?
>
> Steve
>
> On 9/27/2011 10:33 AM, John Viescas wrote:
>> 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
>>
>>
>>
>>
>>
>> ------------------------------------
>>
>> Yahoo! Groups Links
>>
>>
>>
>>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar