Dear All,
This form is contains fields from three tables that are linked “relationship” by “Subj_num “ field.
It will be mainly used to search for subj_num from the main table that is “ID” table.
So, there is not going to be any data entry, update or delete records.
However, after...
Changing Data entry to no,
and click on “Find records “button, then I get the following error:
Run-Time error '3326'
This recordset ins not updateable:eek:
Abrahim
Hi All,
I have a form that I like to behave this way:
1. I have a form that has some fields like subj_num , Subj_date and etc….
2. Ideally I like to have the form to be open blank.
3. In this form I have a text field called “Text21” that is not bounded to any table’s fields.
4. Also I have a...
Dear All,
I have a form called P_I_H that has two fields "ID" and “Subj_num".
I’m Trying to run a search for a Subj_num, if more than one subj_num was found, then show each record every one second.
Can Ms Access do such a search?
Thanks for any help.:D
Regards,
Abrahim
Hi All,
In MS ACCESS I have a table with three fields:
ID_DATE_START
ID_DATE_END
ID_AGE
Both ID_Date_Start and ID_DATE_END property are Date format, and ID_AGE property is Number.
I like to subtract ID_DATE_END from ID_DATE_START
And insert the result in ID_AGE field.
Let’s say ID_Date_Start...