Re: Pass criteria in Microsoft Query

Where are you querying from? (Access, as400 etc.) Are you using MS
Query?

If you can edit the SQL statement directly substitute a question mark
for an explicit value.

Cliff Edwards

.

Relevant Pages

  • Re: Keeping Tracking of whos adding new data..
    ... Macro to open the form in Add mode, but no edit mode. ... You should be able to use your form query to set the RC criteria to... ... Not sure what you're doing with the TempLue. ... Candia Computer Consulting. ...
    (microsoft.public.access.formscoding)
  • Re: DB Result Wizard Error
    ... open the hidden folder /_fpclass/ and edit the ... > For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... > to display the new equipment information. ... > is in the table was added to the query. ...
    (microsoft.public.frontpage.programming)
  • Re: Modifying the current record in code
    ... You should be able to modify the current record, ... I think that iterating ... > )) I think the best thing to do is run an update query and the ... >> You should remove the Edit and Update also. ...
    (microsoft.public.access.formscoding)
  • RE: Link Excel To Access
    ... You could then use the Links command to edit the file paths (very handy if a ... A query is a one-step data dump from an outside source. ... promtped with "enable automatic refresh" or disable automatic refresh" is ... Then, edit again under Import Data - Edit Query, setup your query to ...
    (microsoft.public.excel.misc)
  • RE: Select Query to create a Total field
    ... What is happening in your form when you edit a field value? ... Do I have to close and rerun the query or will the ... The calculation will update when the record is updated. ... The query works and returns the totals I require in a column Expr1. ...
    (microsoft.public.access.queries)