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 wOOdy-Soft 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. monoDeveloper

    Main form with File menu ?

    Hello everybody Can any one tell me how to create menu as File menu in windows OS inside MS.Access 2007 Form to run as main form & link all forms throw it's menu & sub menus ? Thanks in advance.
  2. monoDeveloper

    Try to append data from another table

    Hi everybody I run SQL query to add dat from another table based on form object data, it works when i save as separate query but failed when i run inside VBA script command : 'Append data to Temporary table DoCmd = " INSERT INTO SupplyOrderDetails_Temp " & _ " ( Supp_Order_SN, ItemID...
  3. monoDeveloper

    delete statement dosen't work on Form

    Hello everybody This delete statement dosen't work on Form , but works from Saved Query: Supplier_OrderSN is Text Supp_Order_Date is Date remain columns are Numbers DoCmd.RunSQL ("Delete * from SupplyOrder " & _ " Where ( " & _ " Supp_Order_SN =" & [txtReceiveNumber].Value & " and " & _...
  4. monoDeveloper

    SQL query Run & stop without reason

    Hello I wrote this SQL & it was working properly, but when I added extra search parameter always return no result in search even table data is exist ....I want to know the reason please: strSQL = " SELECT supp_Req_SN FROM SupplyRequest " & _ " WHERE( supp_Req_SN = " &...
  5. monoDeveloper

    Unknown VBscript error reason

    Hi everybody I write this script to insert then check insertion done or not But I get error message " "Data type mismatch in criteria Expression" on line [highlight #FCE94F]Set rs = db.OpenRecordset (strSQL) [/highlight] When I try to run the select statement as you will see in coming code...

Part and Inventory Search

Back
Top