ACCESS FEED: RE: [MS_AccessPros] Re: Drop Down Selection in Read Only

Jumat, 29 Juni 2012

RE: [MS_AccessPros] Re: Drop Down Selection in Read Only

Mike-

Then that should be editable unless Allow Edits is set to No on the form.

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/> http://www.viescas.com/

(Paris, France)

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mithomas48
Sent: Friday, June 29, 2012 6:41 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Drop Down Selection in Read Only

John and Clive, I did a correction post and the corrected Select stmt for the
Record Source is this...

> Record Source: Select stmt in standard module.
CODE:
Forms(FNAME).SUBLIST.Form.RecordSource = "SELECT RID, RESULT, RESULT_DATE,
COMMENTS, CL_ITEM, CL_CATEGORY, CL_ITEM_ID " & _
"FROM LMVMGR_MOD_LOSS_MIT_QC_RESULTS " & _
"WHERE (((ROW_ID)=" & rID & "));"

Thanks again - Mike

--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , John Viescas <JohnV@...>
wrote:
>
> Mike-
>
>
>
> You should only be able to modify the LOAN_NUMBER, MOD_TYPE, and
> MOD_EFFECTIVE_DATE and perhaps the RID and ROW_ID fields if they're not
> AutoNumber. All the other fields are "calculated" and thus not updatable.
>
>
>
> 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/> http://www.viescas.com/
>
> (Paris, France)
>
>
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of mithomas48
> Sent: Friday, June 29, 2012 4:49 PM
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: [MS_AccessPros] Re: Drop Down Selection in Read Only
>
>
>
>
>
> Clive, see below info as requested...
>
> > Row Source Type: Table/Query
> > Row Source: Select stmt in On Got Focus event
> CODE:
> Me.DTL_RESULT.RowSource = "SELECT LOOKUP_DESC
> FROM LSDMGR_MOD_LOSS_MIT_LOOKUP
> WHERE (((LOOKUP_TYPE)='PASS_FAIL'));"
> > Control Source: Set to the field in the table
> > Bound Column: 1
> > Column Count: 1
> > Record Source: Select stmt in standard module.
> CODE:
> strSQL = "SELECT A.RID, A.ROW_ID, B.LOAN_NUMBER, B.MOD_TYPE, " & _
> "B.MOD_EFFECTIVE_DATE, Format([A].[CREATED_DATE],'mm/dd/yyyy') AS
CREATED_DATE,
> " & _
> "(SELECT [USER_FIRSTNAME]+' '+[USER_LASTNAME] AS [USER] FROM
> LSDMGR_USERS_PASSWORDS_USERSPLUS " & _
> "WHERE (((LSDMGR_USERS_PASSWORDS_USERSPLUS.GID)=[A].[CREATED_BY]))) AS
> CREATED_BY, " & _
> "(SELECT LSDMGR_MOD_LOSS_MIT_LOOKUP.LOOKUP_DESC FROM
LSDMGR_MOD_LOSS_MIT_LOOKUP
> " & _
> "WHERE (((LSDMGR_MOD_LOSS_MIT_LOOKUP.LOOKUP_TYPE)='QUEUE_STATUS') " & _
> "AND ((LSDMGR_MOD_LOSS_MIT_LOOKUP.LOOKUP_VALUE)=A.QUEUE_STATUS))) AS
> QUEUE_STATUS, " & _
> "(SELECT [USER_FIRSTNAME]+' '+[USER_LASTNAME] AS [USER] FROM
> LSDMGR_USERS_PASSWORDS_USERSPLUS " & _
> "WHERE (((LSDMGR_USERS_PASSWORDS_USERSPLUS.GID)=[A].[QUEUE_ASSIGNED]))) AS
> QUEUE_ASSIGNED, " & _
> "Format([A].[QUEUE_STATUS_CHG_DATE],'mm/dd/yyyy') AS QUEUE_STATUS_CHG_DATE" &
> SQLCOND & " " & _
> "FROM " & dSource & " A " & _
> "INNER JOIN LSDMGR_MOD_LOSS_MITIGATIONS B ON A.ROW_ID = B.ROW_ID " & _
> "WHERE (" & WhereCOND & ") " & _
> "ORDER BY " & OrderCOND & ";"
>
> 'LOAD FORM
> Forms(FNAME).RecordSource = strSQL
>
> You'll notice that I am using some sub queries to capture data for the
> recordset. The drop down loads and lists fine, and when clicking on the drop
> down the option list is displayed fine. The form loads the record source fine.
I
> just can't make any changes to any of the fields in the records.
>
> Thanks in advance!
> Mike
>
> --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "Clive" <zctek@> wrote:
> >
> > Hi Mike,
> >
> > We need more information.
> >
> > Please give more details about the ComboBox properties,
> > Row Source Type:
> > Row Source:
> > Control Source:
> > Bound Column:
> > Column Count:
> >
> > And also the Form properties,
> > Record Source:
> >
> > Regards, Clive.
> >
> > --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> , mithomas48 <no_reply@>
> wrote:
> > >
> > > Also, if I debug.pring the select statement used to load the subform, and
> copy that to a new query object, I can edit any field in a record. So I would
> think the query is updateable.
> > >
> > > Thanks again!
> > > Mike
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> , mithomas48 <no_reply@>
> wrote:
> > > >
> > > > None of the fields can be changed, and none are locked and they are
> enabled. The only one that needs to be edited however is just the drop down
> field. How can I check if it updateable?
> > > >
> > > > Thanks again!
> > > > Mike
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "sarmbraugh"
<sarmbraugh@>
> wrote:
> > > > >
> > > > > Make sure the "locked" property for the dropdown is set to "no." If
> that's not it, I would check to see if you can edit other fields on the
subform,
> and if the form's record source is updateable.
> > > > >
> > > > > --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> , mithomas48 <no_reply@>
> wrote:
> > > > > >
> > > > > > I have a subform set as "Continuous" view, and a drop down (dd) in
the
> detail section. The dd will display the rowsource fine, but will not allow a
> selection of any of the items listed. It acts like its in read only mode or
> something. The dd's control source is set to the field in the table. The
subform
> is set to allow edits.
> > > > > >
> > > > > > Does anyone know why an item cannot be selected from the drop down?
> > > > > >
> > > > > > Thanks in advance!
> > > > > > Mike
> > > > > >
> > > > >
> > > >
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]