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 Chris Miller 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 ?

    Can any body help me to do this issue ?
  2. 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.
  3. monoDeveloper

    Try to append data from another table

    Another modification & it's error 'Append data to Temporary table DoCmd.RunSQL = " INSERT INTO SupplyOrderDetails_Temp " & _ " ( Supp_Order_SN, ItemID, Sup_Ord_Item_ExDate, Ord_Old_QTY ) " & _ " from ( SELECT Supp_Order_SN, ItemID, Sup_Ord_Item_ExDate, Sup_Ord_QTY " & _ " FROM...
  4. monoDeveloper

    Try to append data from another table

    Erro is: Run-time error '438': Object doesn't support this property or method
  5. 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...
  6. monoDeveloper

    delete statement dosen't work on Form

    I already did remove the spaces , thanks
  7. monoDeveloper

    delete statement dosen't work on Form

    It works now just delete space between Single quotes to have exact string : )
  8. monoDeveloper

    delete statement dosen't work on Form

    That is what I see in "Immediate window" Delete * from SupplyOrder Where ( Supp_Order_SN =25 and From_Supplier_ID=9 and Supp_Order_Date= 4/19/2013 and Receive_U_ID=4 and Supplier_OrderSN=' 521/2013 ')
  9. 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 " & _...
  10. monoDeveloper

    SQL query Run & stop without reason

    thanks for your answers [pipe]
  11. monoDeveloper

    SQL query Run & stop without reason

    Yes " supp_Req_Date" declared as a Date I added the [highlight #FCE94F]"#"[/highlight] & it works now, but I have question why I didn't get error or problem at insertion SQL statement using same quot without formating or using the [highlight #FCE94F]#[/highlight] ?
  12. 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 = " &...
  13. monoDeveloper

    Unknown VBscript error reason

    Thanks, It works now .
  14. monoDeveloper

    Unknown VBscript error reason

    Debug.Print strSQL , gives me nothing
  15. monoDeveloper

    Unknown VBscript error reason

    I define "supp_Req_SN" as number in Database
  16. 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