[forms]!

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

I've set up a number of forms with filter based on forms in access such as ID
= [Forms]![form]!id. however i have been trying to migrate this the access
project, and this seem to cause an error. can anyone tell me how to get
around this ?
 
G> I've set up a number of forms with filter based on forms in access such
G> as ID = [Forms]![form]!id. however i have been trying to migrate this
G> the access project, and this seem to cause an error. can anyone tell me
G> how to get around this ?

Should be forms!form1.form!id

Though, I'd think it should be so in MDB as well.

Vadim Rapp
 
There are many ways of implementing a filter in an ADP project. I'm sorry
to say that but with the information provided in your post, I cannot really
tell you what's the answer to your problem. Taking a look at the previous
posts in this newsgroup could also give you the answer that you are
searching. (Or at least, provide you with some good pieces of information
about ADP in general.)
 
sorry about the lack of detail. it was late when I composed the last question.

I am building an ADP Project, which is connected to SQL Server Express. I
have a button on one from which uses a macro to open a second form and filter
it. I have arguments of "Modify Project, Form, ,
[Project_ID]=[Forms]![Projects]![Project_id], Edit, Dialog".

however this returns an error of 2950, and an error message of incorrect
syntax near '!'

I can't see why this is failing. Any help appreciated.


Greg McLandsborough


Sylvain Lafontaine said:
There are many ways of implementing a filter in an ADP project. I'm sorry
to say that but with the information provided in your post, I cannot really
tell you what's the answer to your problem. Taking a look at the previous
posts in this newsgroup could also give you the answer that you are
searching. (Or at least, provide you with some good pieces of information
about ADP in general.)

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


Greg said:
I've set up a number of forms with filter based on forms in access such as
ID
= [Forms]![form]!id. however i have been trying to migrate this the access
project, and this seem to cause an error. can anyone tell me how to get
around this ?
Click to expand...
Click to expand...
 
Try something like:

"Modify Project, Form, , [Project_ID]=" & [Forms]![Projects]![Project_id] &
", Edit, Dialog"

Also, if Project_ID is not a number but an alphanumeric, then you must
enclose its value between single quotes (and double any in-between single
quote). Finally, I'm not sure that this macro will work if you are using a
stored procedure as the record source of your form.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


Greg said:
sorry about the lack of detail. it was late when I composed the last
question.

I am building an ADP Project, which is connected to SQL Server Express. I
have a button on one from which uses a macro to open a second form and
filter
it. I have arguments of "Modify Project, Form, ,
[Project_ID]=[Forms]![Projects]![Project_id], Edit, Dialog".

however this returns an error of 2950, and an error message of incorrect
syntax near '!'

I can't see why this is failing. Any help appreciated.


Greg McLandsborough


Sylvain Lafontaine said:
There are many ways of implementing a filter in an ADP project. I'm
sorry
to say that but with the information provided in your post, I cannot
really
tell you what's the answer to your problem. Taking a look at the
previous
posts in this newsgroup could also give you the answer that you are
searching. (Or at least, provide you with some good pieces of
information
about ADP in general.)

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


Greg said:
I've set up a number of forms with filter based on forms in access such
as
ID
= [Forms]![form]!id. however i have been trying to migrate this the
access
project, and this seem to cause an error. can anyone tell me how to get
around this ?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top