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!

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

  1. ZeuBug

    date and cdate

    hi i ve got a little problem i do the request SELECT Contacts.Nom, Contacts.Prenom, CDate([Historique_commercial].[Date_prochain_suivi]) as [Prochain suivi], Historique_commercial.Identification_suivi FROM Historique_commercial INNER JOIN Contacts ON Historique_commercial.Identification_client...
  2. ZeuBug

    Save as

    hi, i used the <a href> to save a document but in this case, the document is openned by the explorer in a html page. i just want to do the 'save target as' function. thx Raph rchene@rockefeller.univ-lyon1.fr
  3. ZeuBug

    replace in all the application

    Zeubug Thanks for all the answer but i just want to say if i could do a sort of keypress evenement but applied to the application so i have done a simple function which replace the single quote by the chr(180) which is similar to a single quote to vb400, sure, you have undertood my problem and...
  4. ZeuBug

    replace in all the application

    thanks vb400 but in the sQL querystring there are some ' inside and i cant replace when i have done the querystring and i don t want to test each textbox example : sSQL =&quot;select * from table where id_client = '&quot; & textbox.text & &quot;'&quot; i just want to remove the ' which coudl be...
  5. ZeuBug

    replace in all the application

    Hi just one thing, i want to do a keypress but i want that it worked for all the application example : i do some request in SQL and the char ' is forbidden, so i want that when a user press the key ' , i want to return the chr(180) but i dont want to test all the textbox i have, i want to...
  6. ZeuBug

    recordset and vb, the faster ?

    i have a temporary recordset with 1000 records and i want to put all records in a access records, not an update but an insert,what is the faster and can i send the recordset directly to the access record thanks <p>Raph<br><a...
  7. ZeuBug

    left and right unknown

    the problem is simple i have a string, i want to do left(string,number) but now left is not recognized by VB. In the refernces a ve got visual basic for application which is checked and vb6 library. if somebody can answer to my question, it will be great for me cause i dont want to install vb6...
  8. ZeuBug

    request and fields

    High everybody<br>i want to make a request and i need help:<br>i have two fields number1 and number2 in a record<br>i want to search the higher number2 of a specific number1<br>my problem is how to search the higher number2<br><br>thanks for help !<br><br>pour ceux qui comprennent le francais et...
  9. ZeuBug

    SubForms and main Form

    thanks doug , i didn't think to get the focus on the subform.<br><br>but i had a problem, an error came when the line<br>DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70<br>was executed<br><br>so i used the command DoCmd.RunCommand acCmdDeleteRecord<br><br>and that's all...
  10. ZeuBug

    SubForms and main Form

    Hi,<br><br>the problem is :<br>i have a main form, on this main form there is a control tab.<br>on each page of control tab, i have one subform.<br><br>I want to put a button on the main form, this button must delete the current record of the visible subform.<br><br>I don't want to put the...

Part and Inventory Search

Back
Top