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

  1. Weendigo

    How change the "Flages" ?

    http://www-2.cs.cmu.edu/afs/cs/user/ralf/pub/WWW/files.html
  2. Weendigo

    SQL query doesnt works probably bcz i dont know how to associate str's

    'rsta is a SQL query that returns (i check by myself using msgboxes) 'rstb also returns (i also check it by myself using msgboxes) 'this .findnext only works when i type the text returned by <rsta!LINHA> by myself, but i need to put it on a variable ! Could you help me ? The code is this...
  3. Weendigo

    Problem with UPDATE query

    Hi all, First of all, thanks and I am still learning VBA... I am having some problems with this UPDATE query, access give me errors with <CurrentDb.Execute &quot;UPDATE CAMPOS SET HODDIF = TempB> I have done it to update my DataBase after a certain field is included. The code is below...
  4. Weendigo

    associate the result of a query into a field in a form

    Thats all ok... I think a bit more and found... This way it works.. Thanks very much everybody here... Private Sub txtPlaca_Exit(Cancel As Integer) Dim rst As Recordset Set rst = CurrentDb.OpenRecordset(&quot;SELECT * FROM FROTA5 WHERE PLACA = '&quot; & txtPlaca & &quot;'&quot;) rst.MoveFirst...
  5. Weendigo

    associate the result of a query into a field in a form

    Thank You TrojanRabbit, it is almost working... but access give me some error (3061 - insufficient parameters) while i am trying to run this code: Set rst = CurrentDb.OpenRecordset(&quot;SELECT PLACA FROM PLACA_E_ID WHERE PLACA = Forms!INCLUIR_VC3!PLACA;&quot;) rst.MoveFirst Me.IDENT =...
  6. Weendigo

    associate the result of a query into a field in a form

    I am doing a query using a macro, that gets the parameter using a filter (it is a typed field by a user in a form). The macro opens a query that pop up on the screen (always one line and two fields) , and i need to associate the text of one of these fields (of query that pop up) into the field...

Part and Inventory Search

Back
Top