Access Form db Query
máx $5 USD
Pagado a la entrega
We have a form that has a list box and a query We need to Dynamically select the field and the string. We have SELECT [url removed, login to view], Parcels.County_ID, Parcels.Parcel_ID, [url removed, login to view], [url removed, login to view], [url removed, login to view] FROM Parcels WHERE ((([url removed, login to view]) Like "*" & [forms]![ListSearchForm]![string] & "*")); and this works to dynamically select the string criteria. We attempted to do the dynamic field SQl SELECT [url removed, login to view], Parcels.County_ID, Parcels.Parcel_ID, [url removed, login to view], [url removed, login to view], [url removed, login to view] FROM Parcels WHERE ((([Parcels].[forms]![ListSearchForm]![FieldToSearch]) Like "*" & [forms]![ListSearchForm]![string] & "*")); But this does not work. This is copied directly from the SQL view from Access
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Access 2K
Nº del proyecto: #2919419