Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Mashieman9

    Query as a search function

    It seems to me that using a query as a search function in Access (97) is a great idea. So far Access has yet to agree with me. I've been trying to figure out how to put in a word that will prompt me to enter a value. But of course when I put a word inbetween the quotations (because I want a...
  2. Mashieman9

    Update Query not working

    Ha! It worked, I just needed more references. Cool! -- N.Hunt
  3. Mashieman9

    Date formatting

    try sending it over as a string, and not date. It is probably formatted by microsoft when sending it over. -- N.Hunt
  4. Mashieman9

    Update Query not working

    One problem is that when I run the query... it asks me for a value for OutputTable.NumberRequired, which it shouldn't because there should be a value for it in the table. -- N.Hunt
  5. Mashieman9

    Update Query not working

    The Update Query: UPDATE Components SET Components.QtyStock = Components.QtyStock-(BuildQuantity*OutputTable.NumberRequired) WHERE (((Components.ComponentID) In (SELECT ComponentID FROM OutPutTable))); 'Components' and 'Assemblies' are the static tables, and 'OutPutTable' is the dynamic...
  6. Mashieman9

    Update Query not working

    I have three tables, one of which has dynamicall generated information through a form and a module. The info in the dynamic table comes from the other tables. I'm trying to run an update query to update one of the static tables. I'm trying to use a field in the dynamic table in the expression in...
  7. Mashieman9

    Changing an update query through a module?

    Thanks for all the help... I feel kinda stupid, I found a much easier way to do it. Thanks. -- N.Hunt
  8. Mashieman9

    Changing an update query through a module?

    So far it makes sense, I just can't see how the code is referencing the query. The query's name is "UpdateStock". Thanks again. -- N.Hunt
  9. Mashieman9

    Changing an update query through a module?

    Is it possible to change an update query through a module? I have a variable in the module that I need to use in the query. If so, could someone help me out? Thanks, Nathan

Part and Inventory Search

Back
Top