RE: Cannot edit form

From: Alicia (anonymous_at_discussions.microsoft.com)
Date: 03/24/04


Date: Wed, 24 Mar 2004 01:06:08 -0800

It is definately the form that is causing the problem!
The macro and table are fine.
I just really don't know what to change, think it is possibly to do with the bar along the LH side of the form?

     
     ----- Art wrote: -----
     
     Can you add or edit data directly into the table itself?
     If so, then it is not the table but the form which is
     causing the problem.
     
     Hope This Helps
>-----Original Message-----
>Again this does not work. Is it something to do with my
     Recordset defined as Dynaset?
>Alicia
>> ----- Art wrote: -----
>> Hi Alicia,
> Turn the filter off and try to edit again.
     It
> may be a conflict between the filter code and the
     edit
> which is trying to make changes or add a record in
     spite
> of the filter.
>> Hope This Helps
>>-----Original Message-----
>> I cannot edit one of my forms. I do not know why.
>>I have some more information however:
>>Data entry Yes
>>Allow Edits Yes
>>Allow Deletions Yes
>>Allow Additions Yes
>>Recordset Type Dynaset
>>Record Locks No Locks
>>The Macro performs a filter on the table.
>>Also, it is a linked table.
>>Any other ideas?
>>Thank You, Alicia
>>>.
>>>.
>



Relevant Pages

  • Re: access crashing after filter
    ... You have the Debug.Print line after the line that is causing the problem. ... What happens if you comment out the line that is causing the crash? ... using an ADO recordset and SQL server, the definition of variables (we can't ... recordset without specifically applying the filter. ...
    (microsoft.public.access.forms)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... in the criteria cell in the graphical query builder. ... use as the source in the routine. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ...
    (microsoft.public.access.formscoding)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... should build the SQL, using a query, then paste it into your code. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ... Set MyRS = MyDB.OpenRecordset" ...
    (microsoft.public.access.formscoding)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... and have the query point to the combo box to get its value. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ... Set MyRS = MyDB.OpenRecordset" ...
    (microsoft.public.access.formscoding)
  • Re: Problem reading text box dynamically
    ... The wacky text selection behaviour. ... If the user manages to enter a filter that results in no matched ... records (an empty recordset), the form blows up and fails to repaint. ... I was not sure "filter the subform" was ...
    (microsoft.public.access.formscoding)