What do you mean? I did check out the link. Why would I be embarassed?
- Ok so I needed delete the linked table then re-link the table but this time choose the "id" field as a unique identifier.
Catalyst159
Last Activity: May 14 '13, 02:04 PM
Joined: Sep 20 '07
Location:
-
-
I am getting the following message:
"This recordset is not Updateable."
Is there anyway to make it updateable?Leave a comment:
-
How could I make sure that the underlying recordset is updateable?
I have checked the AllowAdditions and AllowEdits options and they are indeed set to True, but still I am unable to enter or edit the note.Leave a comment:
-
Is AllowAdditions found under the forms properties?
Is AllowEdits found under the forms properties?Leave a comment:
-
Form for entering data into linked Table
I have a linked table called "dbo_tblNot es".
dbo_tblNotes has the following fields:
id (Data Type = Number, Indexed = No)
note (Data Type = Memo)
addDate (Data Type = Date/Time)
uid (Data Type = Text)
private (Data Type = Number)
I am trying to create a form that I can use to enter notes and comments. Any notes that are entered would be stored in the "dbo_tblNot es"... -
Yes the table is listed on the database front screen.
I have set the Data Entry property to True, but no change.Last edited by NeoPa; Feb 15 '12, 05:11 PM. Reason: No need for a post per sentence - It just makes the thread unmanageable.Leave a comment:
-
I want to have a text box to add notes. This would only be for input. I do not want to display notes in this text box. Only use it for entering notes.Leave a comment:
-
I put a subform on the Problem Details Form. The subform is named "Child43".
When I try to set the source object for "Child43" dbo_tblNotes is not listed as one of the choices.
Why would that be?Leave a comment:
-
OK..I will give it a try.Leave a comment:
-
How would you use a subform?Leave a comment:
-
Sounds like the right path for me. Thank you for the resourceful links. I will check them out, have a better understanding and then post my thought on it. Thanks NeoPa
Regards,
CatalystLeave a comment:
-
How should the SQL look?Leave a comment:
-
Form with text box for adding Notes using linked table
I have a form called "Problem Records Details" which contains a Text Box called "txtNotes".
The Record Source for the "Problem Records Details" form is a linked table called "dbo_proble ms". However all Notes are stored in a linked table called "dbo_tblNot es". The "ID" field in the "dbo_tblNot es" table references the "ProblemID" field in the "dbo_proble ms"... -
Rabbit, thanks for all your help. The following seemed to work as you indicated previously:
I think I have a better understanding now. Thanks for being patient.Code:Private Sub Form_BeforeInsert(Cancel As Integer) Me.ID = DMax("ID", "dbo_problems") + 1 End SubLeave a comment:
-
Can I accomplish that in a macro?
I understand what you are saying but, then anytime that form is opened it will assign that value. There is instances where the form is opened to view details of an existing record from another form by click the "ID" which is a hyperlink.Leave a comment:
-
I have a form called "Problem Records List" with a button on it called "cmdNewItem ". The On Click event for "cmdNewItem " is a macro called "Detail list".
The "Detail list" macro contains the following:
...Code:Action: OpenForm Arguments: Problem Records Details, Form, , 1=0, , Dialog Action: OnError Arguments: Next, Action: Requery
Leave a comment:
-
Hey ChrisPadgham,
Thanks for the input. Looks good. It is a multiuser environment. How could I accomplish doing a save of the record immediately after. Also where would you put the following code:
Would you just put it behind the form or the control?Code:Me.ID = DMax("[ID]","dbo_problems") + 1Leave a comment:
-
To Test in immediate window I used:
This does work.Code:? DMax("[ID]", "dbo_problems") + 1
How can I assign this to the control on the form that I want the value to go into though?Leave a comment:
-
How can I assign it to the control you want that value to go into?Leave a comment:
-
How can I test thatis getting the correct value using the Immediate Pane to test it?Code:DMax("ID", "dbo_problems") + 1Leave a comment:
No activity results to display
Leave a comment: