I have a fairly large access database that was working fine for a long period of time. Then after a compact and repair was completed, I receive this message after opening an access page "You can't add or delete an existing record because the recordset for this page is read-only." The page that...
In my database I currently have 2 different tables which are linked to my database and each contains different information with the exception of Job Numbers.
The one table (lets call this TableA) contains all of the job numbers as single numbers 105, 231, 321 ect.
But the second table (TableB)...
OK I used this criteria
Like "*" & [Queries]![COATING MASTER]![ENTER JOB NUMBER] & "*"
and it basically works fine but the parameter prompt reads as [Queries]![COATING MASTER]![ENTER JOB NUMBER]
and I would like it to read ENTER JOB NUMBER.
I have created a Query in which a user must enter a value for Job Number, But I am unable to get my query to find all values containing that entered value.
For example if a user enters 5 I want my query to retrieve 5, 55, 15, 3/4/5 etc.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.