Search results

https://access-programmers.co.uk/forums/attachment.php?attachmentid=78334&stc=1&d=1578447144 Look at the query all my Changes and in your db even you cant edit fields in query

the foreign key have no meaning i delete it just trying to make a kay for students id to bypass access rule students table have PK on a failed called id(autonumber) studentsnotes have no PK or FK as i explain 3 times the image was a mistake there is no relationship between the 2 tables

First of all I am not a big expert in Access so be gentle with me now i have failed in student table call student id same in studentsnotes table i have a form that base on student table with sub form of studentsnotes When the child fields are linked you edit a record in studentsnotes it gets...

ok now students have PK and studentsnotes have nothing no FK or PK what's next

this is a rule by access you can't edit fields in query that build from 2 tables that doesn't have pk on the same fields the query become read only for the FK i just trayed couple of method with without so on

did that to doesn't work btw im using office 2016 if its have a meaning

yes and the notes table have the student id with a relationship to student id in student table(the relationship is on the query) without pk it wont work https://support.office.com/en-us/article/edit-data-in-a-query-6ca3edfc-6d66-4d90-8219-c2b258d5bed7#bmcan all explain in here

did that as well doesn't work

https://access-programmers.co.uk/forums/attachment.php?attachmentid=78329&sthttps://access-programmers.co.uk/forums/attachment.php?attachmentid=78329&stc=1&d=1578439875c=1&d=1578439858 the to records showing data after i press the plus sign i hope that halp

i have foreign key doesn't work

il try to explain in more details i have 2 tables with same field called "Sid" now i build a query to show data from one table that match the "Sid" of the second table one table have primary key on "Sid" the second doesn't have because duplicate are needed. now such a qure wont let me edit data...

Unfortunately, I can't upload demo of the database i'm talking about the plus icon that appears at the left side of a parent record in spreadsheet view

I created a query from two tables, one of which does not have a primary key because of the need for duplicates. I know that such a query cannot be edited what I am used to do is to create a subform and then create the fields on the main form form![subform]![fieldname]so i can see it in...

I saw some of your videos I didn't know it was you:) What is in this video I know for a long time What I would like is that I can duplicate a control by dragging it anywhere on the form like most software do with shift or ctrl or alt etc'

tanks you theDBguy and vba_php for now i'm using ctrl+c ctrl+v it copies the field and past it below if there was a drag and copy it was much easier

hi: is there any way to drag and copy a field in design view most of the software use "shift" in access copy and paste dropping the field in the upper left of the form

tnx thedbguy Nz([rundate]) did the trick so no #error! show i add some code to mark the record as date error

I thought of such an approach one field is called "rundate" create another field named "nulldate" Which has a default date and use if [rundate] isnull then [nulldate] else [rundate]

its an sql function im working on a field in form not a query

the date is "date field" plog: I'm not trying to fix anything some Employees are missing data entry and the "rundate" Used for a calculated field So if there is no data, the form will give error on loading to prevent that i have to put some date in the "rundate" field I don't care if it's true...