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 IamaSherpa 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: *

  • Users: jakar
  • Order by date
  1. jakar

    Inputting data in forms and updating tables with a button

    Hi there When adding records to a table using SQL you have to use: INSERT INTO target [(field1[, field2[, ...]])] VALUES (value1[, value2[, ...]) Hope this will work for you Happy eastern Jan Karlsson janne@karlssons.net
  2. jakar

    Creating A Query With Combo Boxes

    Hi Lee I think the easiest way to do this is as follows: 1. Let your report be based on a qeuery that selects all the the records that is as if they have selected <all> in all combo boxes. 2. On the form when they click on Ok or whatever create a filter string (As the where clause in a...
  3. jakar

    RunSQL doesn't delete

    Hi, the syntax for DoCmd.RunSQL is DoCmd.RunSQL sqlstatement[, usetransaction] so try writing your statement as: [b]DoCmd.RunSQL[b] &quot;DELETE * FROM tbl_Ctr WHERE Status = 99;&quot;

Part and Inventory Search

Back
Top