Re: can't get more stupid then this..

Tech-Archive recommends: Fix windows errors by optimizing your registry

Have you checked the spelling? The name of the form field must exactly match
the value you type in in the Custom Query.

Also, you are submitting a form with this form field to execute the query,
right? It won't work if the form field is simply on the same page.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

"News" <tuurtje2000@xxxxxxxxxxx> wrote in message
news:df81uv$gs5$1@xxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
> When i use the "INSERT" into statement in DBRW in
> a custom query-string and type in the proper
> values ('::naam::') the result would that i get an
> error specified as "Unable to find operator in query string.
> Query string currently is Insert into invoer (naam) Values('::naam::')"
> So it doesn't insert anything into my table, (=problem no1, the major
> problem)
> Now when i change the Values to ('naam') without the :: then it
> does insert "naam" into my table but not the value that came from
> the insert -form field. It inserts the word "naam". So the Insert
> statement seems to work it only inserts the wrong value.
> It actually inserts the values name. So it appears to start working
> a bit ( i get no error messages like above) but now the right values.
> Is there a way i can solve these (2) problems, i've been
> looking at Microsoft MSDN, KB, FPsupport, but without
> any positive result, Pls do help if you can.
>
> Thanks in advance,
> Arthur
>
>
>
>
>
>


.

Relevant Pages

  • Re: Database Search Results Are Incorrect
    ... only problem now is creating a custom query that works. ... >satisfy the criteria. ... >(Your Company form field is blank ... ORed conditions must ...
    (microsoft.public.frontpage.client)
  • Re: Database Search Results Are Incorrect
    ... It sounds like you're using a wizard to build your query. ... (Your Company form field is blank ... AND means that BOTH conditions meet the criteria. ... > Karen - I am pulling data from a database management ...
    (microsoft.public.frontpage.client)
  • Re: Database Search Results Are Incorrect
    ... offhand for constructing the query. ... someone else here knows Excel ... >>satisfy the criteria. ... >>(Your Company form field is blank ...
    (microsoft.public.frontpage.client)
  • Error 3061: Too Fee Parameters
    ... form field as a parameter. ... Dim qdf As DAO.QueryDef ... Here the SQL for a query that the OpenRecordset method would try and open: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Multiple If statements in the criteria of a query
    ... Since you need to map from one visit type value in the form field to ... Are you saying you've typed that into the criteria cell in the graphical ... What I want is the query output to modified based on the value in the ...
    (microsoft.public.access.formscoding)