I have a query which I can run via Query, however, when I build an SQL string using the query and try to run it (via ADO connection), I get a message saying it does not exist.
I tried renaming the query - same thing. I even tried creating a new query and copying in the query text - same thing. All my other queries work, this is driving me crazy and has had me stuck for hours. Anyone got any ideas?
Re: Translation of SQL for VBA ... Not knowing what the criteria are in the SQL string,... > Append Query.... >> Dim strSQL as String ... (microsoft.public.access.modulesdaovba)
Re: Retrieving data from user input. ... I ran the query by itself to test ..."Carl Rapson" wrote: ... What does your SQL string look like in the Immediate window? ... I used my control name instead of the 'txtPro_ID' but still nothing ... (microsoft.public.access.formscoding)
Re: Cascading combo boxes ... >> is the Parameter in the Query / SQL String which doesn't have a value until ... >>> RowSource should be set to Alpha field in Table ... >>> the ConstituentsForm and select the dropdown list I have ... >>> The query would have fields LastName, FirstName,and ... (microsoft.public.access.forms)
Re: dynamic query help ... Write a query that does what you want. ...rstOpen function....SQL string in a variable, like strSQL I showed you, and check that it is ... (microsoft.public.access.queries)
Re: query Group by ... Here is my sql string and the message is "No ... "INSERT INTO masterdype (activeyear, dypeid, hospitalid, degrees, served, ... entered and the qrmasterstatlinked is the query which is a group by. ... >> No value given for one or more required parameters... (microsoft.public.access.queries)
