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. asif79

    Help with Dates

    Hi VBslammer Thanks for the help but can I do this at that table level. Asif
  2. asif79

    Help with Dates

    Hi Goodomens Thanks for the help. It works now. I would appreciate it if you could help me with one more thing. Is there any way, I could use this same function to group by days. I tried using DatePart('d', [Date]) and it works but it displays the day number. Is there any way I could display the...
  3. asif79

    Help with Dates

    Hi All I am trying to design a query which counts the number of records. I want to count all the records in a week. Which Date function do I use to count the records in a week. Any help in this regards will be highly appreciated. Regards Asif
  4. asif79

    Recordset method for a form

    Hi... and thanks for all the help Asif
  5. asif79

    Recordset method for a form

    Hi Actually my query is saved but I am still not sure how to connect it through the property window. Asif
  6. asif79

    Recordset method for a form

    Hi All I am trying to create a form based on a query and I am trying to connect it using the recorset method. I am able to connect the form but it does not allow me to navigate the records. It just shows the first record. Any help in his matter will be highly appreciated. Asif
  7. asif79

    Formatting Date data type

    hi Thanks for the help. I really appreciate it. Asif
  8. asif79

    Formatting Date data type

    Hi all I have a text field in my form which is linked to a text field in my table. The user has to enter Day in this field. What I want to do is that when a user enters a day, it should be saved as a day of a week and not simply as a string. I tried using the Date/time data type in the table...
  9. asif79

    Referencing a quert

    hi scking.. One more thing. I want to populate my form with records in the query and it does not allow me to navigate the records. My code is as follows: Dim rstIN As DAO.Recordset Set rstIN = CurrentDb.OpenRecordset("test") Form_Form1.Text2 = rstIN!studentID Form_Form1.Text0 =...
  10. asif79

    Referencing a quert

    Hi Thanks for all your help and it works now. I really appreciate it. Asif
  11. asif79

    Referencing a quert

    Thanks scking I tried it but it says that it cannot execute a select query. And is there any way that I can open the query as a record set. Asif
  12. asif79

    Referencing a quert

    Hi all This is the first time I am writing on this forum. I am trying to refer to a query in my vba code but it does not work. Do I have to create a connection even though the query is in the current database. Any help in this regard will be appreciated. Asif

Part and Inventory Search

Back
Top