 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / April 2008Enter a property that is user defined
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! 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. > [quoted text clipped - 4 lines] > I am fairly new to this and totally self taught - well with a bit of help > from this site! Hi, I have entered this but I get 'Too few parameters. Expected 2' > Field: someField > Criteria: LIKE [Enter beginning of word] & "*" [quoted text clipped - 12 lines] > > I am fairly new to this and totally self taught - well with a bit of help > > from this site! 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, > [quoted text clipped - 16 lines] >>> I am fairly new to this and totally self taught - well with a bit of help >>> from this site! 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. [quoted text clipped - 24 lines] > >>> I am fairly new to this and totally self taught - well with a bit of help > >>> from this site! 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. [quoted text clipped - 45 lines] >>>>> I am fairly new to this and totally self taught - well with a bit of help >>>>> from this site! 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. > [quoted text clipped - 57 lines] > >>>>> I am fairly new to this and totally self taught - well with a bit of help > >>>>> from this site! 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 [quoted text clipped - 67 lines] >>>>>>> I am fairly new to this and totally self taught - well with a bit of help >>>>>>> from this site! 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" > I need to set up a property field for a criteria that is user defined. > [quoted text clipped - 4 lines] > I am fairly new to this and totally self taught - well with a bit of help > from this site! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.