Update Query question

  • Thread starter Thread starter Stephen Rockower
  • Start date Start date
S

Stephen Rockower

I'm trying to move 1 record from 1 table to another. The table structures
are identical

INSERT INTO PATIENT
SELECT PATIENT1.*
FROM PATIENT1
WHERE (((PATIENT1.IDNUM)=[Enter Patient Number:]));


The error states "Function not available in expressions in table level
validation expression"

What does this mean, and how do I get around it???
 
I detest parameter prompts in queries. References to control values on forms
are much better. However, have you tried setting the query parameter data
type?
 
I'm first trying to get the query to work, before I incorporate it into
actual code.

Interestingly, the noted code works on my XP machine, not on my Vista
machine. I'm using A2K. The Vista machine has been updated to SP3, but the
XP has not (I know, I'm lazy & stupid), and is at SR-1a(?). Perhaps that
makes the difference???

Steve

Duane Hookom said:
I detest parameter prompts in queries. References to control values on
forms
are much better. However, have you tried setting the query parameter data
type?

--
Duane Hookom
Microsoft Access MVP


Stephen Rockower said:
I'm trying to move 1 record from 1 table to another. The table
structures
are identical

INSERT INTO PATIENT
SELECT PATIENT1.*
FROM PATIENT1
WHERE (((PATIENT1.IDNUM)=[Enter Patient Number:]));


The error states "Function not available in expressions in table level
validation expression"

What does this mean, and how do I get around it???
Click to expand...
Click to expand...
 
I don't know if the SPs would make a difference.

--
Duane Hookom
Microsoft Access MVP


Stephen Rockower said:
I'm first trying to get the query to work, before I incorporate it into
actual code.

Interestingly, the noted code works on my XP machine, not on my Vista
machine. I'm using A2K. The Vista machine has been updated to SP3, but the
XP has not (I know, I'm lazy & stupid), and is at SR-1a(?). Perhaps that
makes the difference???

Steve

Duane Hookom said:
I detest parameter prompts in queries. References to control values on
forms
are much better. However, have you tried setting the query parameter data
type?

--
Duane Hookom
Microsoft Access MVP


Stephen Rockower said:
I'm trying to move 1 record from 1 table to another. The table
structures
are identical

INSERT INTO PATIENT
SELECT PATIENT1.*
FROM PATIENT1
WHERE (((PATIENT1.IDNUM)=[Enter Patient Number:]));


The error states "Function not available in expressions in table level
validation expression"

What does this mean, and how do I get around it???
Click to expand...
Click to expand...
Click to expand...
 
Back
Top