AntonRSL2016
Last Activity: Aug 16 '19, 11:49 AM
Joined: Jan 13 '17
Location: Ashburton, Devon, UK
-
It's ok, I've worked it out, there were entries missing in the sub table! -
Problem with Form which contains two Subforms
Good morning,
I have the following structure:
Form Frm_Production_ Main which has two Subforms
SbFrm_Productio n_Sub_MLCD and
SbFrm_Productio n_Sub_TB.
These forms are linked to tables:
Tbl_Production_ Main
Tbl_Production_ Sub_MLCD
Tbl_Production_ Sub_TB
The Record Source for the Form is the following:
...Code:SELECT Tbl_Production_Main.* , Tbl_Production_Sub_TB.BC_IDLast edited by NeoPa; Aug 18 '19, 05:36 PM. Reason: Tidied up SQL to make readable as well as added [CODE] tags that are required on this forum. -
Thank you very much.Leave a comment:
-
Good morning NeoPa,
I would like to select a currency symbol in one control, and have this currency symbol apply to two other controls. Referring to the jpg, Frm_Purchase_Or der_Request (the form, which is tabular rather than columnar) I select £, $ or € in the 'Currency' control, and I would like the control 'Line Value' to have the same currency symbol shown.
Does that make sense?
AntonLeave a comment:
-
Sorry for reply daley.
Hello, my appologies for leaving this reply so long, distractions.
The underlying table has ten fields, most are text entry-type. This problem concerns three of the tables fields, shown in the Tbl_Purchase_Or der_Foundation_ Level.jpg. I feed data into this table from Frm_Purchase_Or der_Request, see Frm_Purchase_Or der_Request.jpg , which also populates a report.
I am happy for the...Leave a comment:
-
Thank you. I entered this code, withthe control names updated as belo:
Private Sub txtUnit_Price_A fterUpdate()
StrPrice = cboCurrency & Format(txtUnit_ Price, "General Number")
End Sub
Unfortunately it didn't have any effect. Does the format of the cboCurrency combobox matter? Currently it is a number format because it is the currency ID number being stored in the field (of the underlying table)...Leave a comment:
-
Exactly....is it possible? I am quite experienced now using Access but I am by no means an expert!Leave a comment:
-
Set 'units' of controls, using another controls selection
I have a table, form and report set-up for an order form. One of the controls on the form allows currency selection from a combobox, three other controls are numerical controls for prices. Is it possible for the three price controls to take the currency selection from the currency selection control?
All help much appreciated.
Anton -
Thank you very much for all your help. I replicated the name changes in the active database and all the circular references are now resolved. I have tweaked the DLookUp slightly, to the form:
=DLookUp("[Sub_Set_Descrip tion]","Qry_Serial_N umbers","Serial _ID=" & Forms![Frm_NCR_Main_Qr y_Fed]!Serial_ID)
which now is definitely allowing the child fields to be driven by the selection made in the ID field....Leave a comment:
-
Good morning, thank you very much for your time and expert advice. I have followed your advice and removed the - and ? from all the various occurrences. Unfortunately the DLookUp statements taking the form:
=DLookUp("[*]","Qry_*"," *=" &[*])
return a circular reference error. The only one with the format:
=DLookUp("[Sub_Set_Descrip tion]","Qry_Serial_N umbers","Serial _ID="...Leave a comment:
-
Possibly progress
I got carried away with your suggestions of the DLookUp route. I tried to build expressions into one of the queries, but my syntax was incorrect and they didn't work, so I decided I would step back the query to its original format and post a copy of this database for your perusal.....I opened the form just to check it out and now the fields are updateable! However the queries no longer drive the child fields. This...Leave a comment:
-
Thank you very much indeed for your advice. I have followed your instructions line by line and I can report the following:
I can edit the queried data if I open the query seperately.
The form is open in 'form view' as opposed to layout or design.
AllowAdditons and AllowEdits are both set to Yes (True).
RecordsetType is Dynaset (I also tried Dynaset (Inconsistent Updates to no avail).
The field is Enabled and not Locked....Leave a comment:
-
The Recordset is not updateable
Hello,
I am a relatively inexperienced Access user running Access 2013, I have done some baasic training and been shown how to avoid some of the common pitfalls of poor database design. I have created a database from scratch containing a range of tables with relationships.
I have now started creating forms to input data. One form has fields that I am populating automatically, via queries, based on the input chosen from another...
No activity results to display
Leave a comment: