Enter a property that is user defined

[Leanne]

I need to set up a property field for a criteria that is user defined.

I need it to be 'Like' (begin with) and I know that I would need to [Enter
the information here]

But when I put these together it does not work. Please can someone help as
I am fairly new to this and totally self taught - well with a bit of help
from this site!

 

[John Spencer]

Field: someField
Criteria: LIKE [Enter beginning of word] & "*"



John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

 

[Leanne]

Sorry I think I meant Parameter not Property

And I did not explain - The field they would enter is a site name such as
"Marchwood ERF" - I want the user to be able to enter "Marchwood" and get the
resultes. If there are duplicates then that is fine - the user can re-enter
the data if they do not want to see the other sites starting with "Marchwood"

 

[Leanne]

Hi,

I have entered this but I get 'Too few parameters. Expected 2'

Field: someField
Criteria: LIKE [Enter beginning of word] & "*"



John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

I need to set up a property field for a criteria that is user defined.

I need it to be 'Like' (begin with) and I know that I would need to [Enter
the information here]

But when I put these together it does not work. Please can someone help as
I am fairly new to this and totally self taught - well with a bit of help
from this site!

 

[John Spencer]

If you are getting that message, I suspect that you are trying to run the SQL
using VBA. IN which case you need to show us more of what you are doing.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Hi,

I have entered this but I get 'Too few parameters. Expected 2'

Field: someField
Criteria: LIKE [Enter beginning of word] & "*"



John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

I need to set up a property field for a criteria that is user defined.

I need it to be 'Like' (begin with) and I know that I would need to [Enter
the information here]

But when I put these together it does not work. Please can someone help as
I am fairly new to this and totally self taught - well with a bit of help
from this site!

 

[Leanne]

I am running the query in Excel using the Wizard. After selecting the data
source and columns required I am editing it via the wizard.

I set criteria on Visit Date field - is not null so that I dont get any
blanks. I set criteria on Cell address to contains C as there could be B
cells also in this field. And finaly I want to set criteria on Site Name -
so that the user can determin which site he wants to see the visit history
of. The sheet/source contains only 4 columns, 3 as mentioned above and a
column which is for date changed. The sheet is to record changes to a
specific column in another sheet so records the data changed, when it was
changed and what cell plus the name of the site for that record.

I am not sure what other information you need so if I have not given
something please just let me know. I am really new to queries and do not
know where to go from here.

A point that just occoured to me is that the sheet is currently empty. Not
sure if that will have an impact or not but thought it best to mention.

Thanks

If you are getting that message, I suspect that you are trying to run the SQL
using VBA. IN which case you need to show us more of what you are doing.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Hi,

I have entered this but I get 'Too few parameters. Expected 2'

Field: someField
Criteria: LIKE [Enter beginning of word] & "*"



John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Leanne wrote:
I need to set up a property field for a criteria that is user defined.

I need it to be 'Like' (begin with) and I know that I would need to [Enter
the information here]

But when I put these together it does not work. Please can someone help as
I am fairly new to this and totally self taught - well with a bit of help
from this site!

 

[John Spencer]

Sorry, I can't help you. I never run queries from Excel.

I do suspect that you can't use a parameter query if you run from Excel, but I
could be completely off base on that.

Have you tried posting this problem in an Excel news group?

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

I am running the query in Excel using the Wizard. After selecting the data
source and columns required I am editing it via the wizard.

I set criteria on Visit Date field - is not null so that I dont get any
blanks. I set criteria on Cell address to contains C as there could be B
cells also in this field. And finaly I want to set criteria on Site Name -
so that the user can determin which site he wants to see the visit history
of. The sheet/source contains only 4 columns, 3 as mentioned above and a
column which is for date changed. The sheet is to record changes to a
specific column in another sheet so records the data changed, when it was
changed and what cell plus the name of the site for that record.

I am not sure what other information you need so if I have not given
something please just let me know. I am really new to queries and do not
know where to go from here.

A point that just occoured to me is that the sheet is currently empty. Not
sure if that will have an impact or not but thought it best to mention.

Thanks

If you are getting that message, I suspect that you are trying to run the SQL
using VBA. IN which case you need to show us more of what you are doing.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Hi,

I have entered this but I get 'Too few parameters. Expected 2'

:

Field: someField
Criteria: LIKE [Enter beginning of word] & "*"



John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Leanne wrote:
I need to set up a property field for a criteria that is user defined.

I need it to be 'Like' (begin with) and I know that I would need to [Enter
the information here]

But when I put these together it does not work. Please can someone help as
I am fairly new to this and totally self taught - well with a bit of help
from this site!

 

[Leanne]

I already have some parameter queries in Excel so I know that can be done but
they are for equal to or greater than and run fine - just having trouble with
begins with and contains being user defined.

I haven't posted this in Excel - I thought I would try the masters of
queires first but I shall copy this thread over to excel and see what
response I get.

Thanks anyway.

Sorry, I can't help you. I never run queries from Excel.

I do suspect that you can't use a parameter query if you run from Excel, but I
could be completely off base on that.

Have you tried posting this problem in an Excel news group?

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

I am running the query in Excel using the Wizard. After selecting the data
source and columns required I am editing it via the wizard.

I set criteria on Visit Date field - is not null so that I dont get any
blanks. I set criteria on Cell address to contains C as there could be B
cells also in this field. And finaly I want to set criteria on Site Name -
so that the user can determin which site he wants to see the visit history
of. The sheet/source contains only 4 columns, 3 as mentioned above and a
column which is for date changed. The sheet is to record changes to a
specific column in another sheet so records the data changed, when it was
changed and what cell plus the name of the site for that record.

I am not sure what other information you need so if I have not given
something please just let me know. I am really new to queries and do not
know where to go from here.

A point that just occoured to me is that the sheet is currently empty. Not
sure if that will have an impact or not but thought it best to mention.

Thanks

If you are getting that message, I suspect that you are trying to run the SQL
using VBA. IN which case you need to show us more of what you are doing.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Leanne wrote:
Hi,

I have entered this but I get 'Too few parameters. Expected 2'

:

Field: someField
Criteria: LIKE [Enter beginning of word] & "*"



John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Leanne wrote:
I need to set up a property field for a criteria that is user defined.

I need it to be 'Like' (begin with) and I know that I would need to [Enter
the information here]

But when I put these together it does not work. Please can someone help as
I am fairly new to this and totally self taught - well with a bit of help
from this site!

 

[John Spencer]

You might consider posting the SQL of the query that is not working.
Perhaps someone will spot the problem.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

I already have some parameter queries in Excel so I know that can be done but
they are for equal to or greater than and run fine - just having trouble with
begins with and contains being user defined.

I haven't posted this in Excel - I thought I would try the masters of
queires first but I shall copy this thread over to excel and see what
response I get.

Thanks anyway.

Sorry, I can't help you. I never run queries from Excel.

I do suspect that you can't use a parameter query if you run from Excel, but I
could be completely off base on that.

Have you tried posting this problem in an Excel news group?

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

I am running the query in Excel using the Wizard. After selecting the data
source and columns required I am editing it via the wizard.

I set criteria on Visit Date field - is not null so that I dont get any
blanks. I set criteria on Cell address to contains C as there could be B
cells also in this field. And finaly I want to set criteria on Site Name -
so that the user can determin which site he wants to see the visit history
of. The sheet/source contains only 4 columns, 3 as mentioned above and a
column which is for date changed. The sheet is to record changes to a
specific column in another sheet so records the data changed, when it was
changed and what cell plus the name of the site for that record.

I am not sure what other information you need so if I have not given
something please just let me know. I am really new to queries and do not
know where to go from here.

A point that just occoured to me is that the sheet is currently empty. Not
sure if that will have an impact or not but thought it best to mention.

Thanks

:

If you are getting that message, I suspect that you are trying to run the SQL
using VBA. IN which case you need to show us more of what you are doing.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Leanne wrote:
Hi,

I have entered this but I get 'Too few parameters. Expected 2'

:

Field: someField
Criteria: LIKE [Enter beginning of word] & "*"



John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Leanne wrote:
I need to set up a property field for a criteria that is user defined.

I need it to be 'Like' (begin with) and I know that I would need to [Enter
the information here]

But when I put these together it does not work. Please can someone help as
I am fairly new to this and totally self taught - well with a bit of help
from this site!