I just finished the SQL Server class and I'm missing something with queries. I have an Entity form with subforms (ABCD). One of my subforms has a record source that is a query. It's worked fine until I put everything on the SQL Server. Now I can't add new records. There is also a subform on the subform and it works fine.
I have set the bits to not null, checked allow Additions/Deletions/Edits, and googled till I can't see straight. Can you point me to a class that will help me figure this out?
Adam Schwanz
@Reply 3 years ago
Are you getting any errors? Recordset not updateable? Does it let you add a record but then not save it?
JoAnn BrookoverOP
@Reply 3 years ago
No errors, can't type anything in the form, can't check boxes. I can change existing records, but not add new. It's just like in the security seminar when you lock out low level users so they can't change/add fields, I type and nothing happens. I have discovered that union queries don't work in SQL, so I think that is the problem. The record source for the form is a union query. Is there a workaround for that?
Christopher Hankwembo
@Reply 3 years ago
Golden rule:
(1) Never ever base your forms on any native access object, but views
(2) All calculations should never ever be done by access but views
I went through that myself and I learnt a big learson
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access SQL Server Lessons.
