[AccessD] FW: Form changing behavior after changing record source

[Charlotte Foust]

You didn't mention the attachment fields.  I've never played with them, so
I can't help there.

Charlotte Foust
(916) 206-4336

On Thu, Mar 26, 2015 at 11:40 AM, FW Salato Center <Salato at ky.gov> wrote:

> It's a single table with no criteria expression in place. I'm just using
> the query instead of a form to more easily control the save and cancel
> process during data entry.
>
> I read about the Unique Values property and in testing found that I
> couldn't change it to Yes because of the Attachment fields. The table has
> several and I noticed last fall that the query added several additional
> fields for each Attachment field -- FileName, FileType, etc.
>
> I removed all the extraneous fields and the query is now updateable (New)
> record and the form is opening in data entry form as it was before.
> However, the (form) control bound to the Attachment field no longer works.
> I've lost all that new functionality.
>
> I'm still playing, but if anybody knows a work around, I'd appreciate some
> more information.
>
> Susan H.
>
>
> ​Is the query itself updateable?  It doesn't sound like it, and in that
> case there will be no New button on the navigation controls.​  If the query
> cannot be updated when you run it, there is no way to add or edit records
> in a form.
>
>
>
> Charlotte Foust
> (916) 206-4336
>
> On Thu, Mar 26, 2015 at 10:01 AM, FW Salato Center <Salato at ky.gov> wrote:
>
> > I am still struggling with this. Here's what I've found so far.
> >
> > I created the query wizard to create a simple SELECT on one table.
> > When viewing the query in Datasheet view, there's no New button on the
> > Navigational toolbar. This seems to be why the form is ignoring the
> > Data Entry property.
> >
> > I don't work with Access much anymore, but I don't recall ever running
> > into this before. I can't figure out how to enable new records so the
> > form can honor the data entry property. If someone can tell me how to
> > do that, I'll probably be fine.
> >
> > Susan H.
> >
> >
> > From: FW Salato Center
> > Sent: Friday, March 20, 2015 1:11 PM
> > To: 'accessd at databaseadvisors.com'
> > Subject: Form changing behavior after changing record source
> >
> > Using a menu form, a button opens a form in data entry view - empty form.
> > The same form is also used for browsing and editing at different times
> > - clicking the button sets the properties when opening the form:
> >
> > DoCmd.OpenForm "Enter New Animals", acNormal,,,acFormAdd,,"New"
> >
> > I changed the form's resource source from a table to a query that I
> > based on the table - same fields. Now, clicking the menu button to
> > open the form in data entry view opens the form filled with data. I
> > have no idea why this should matter. Editing and browsing mode are still
> working fine.
> >
> > Any idea why changing the record source is inhibiting
> >
> > Susan H.
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>