Recent content by chayong91

  1. C

    SQL Query HELP!

    Hello, Can somebody help me on my code it's not working. this two where clause of SQL is working properly. WHERE Hour(TIME) between Hour(#" & Me.cmb_HoursFrom & "#) and Hour(#" & Me.cmb_HoursTo.Value & "#) WHERE DATE = #" & Me.txt_DailyDate & "#" but when i try to combine it is not...
  2. C

    Between Function on SQL via VBA

    Hi guys, I need help on my code. Dim qry As DAO.QueryDef Set qry = CurrentDb.QueryDefs("qry_Report") qry.SQL = "SELECT tbl_Sample.* " _ & "FROM tbl_Sample " _ & WHERE TIME Between #" & Me.cmb_HoursFrom.Value & "# and...
  3. C

    Help on Open Report Where Clause. Noob Here.

    anyway i think i'll been asking too many questions. thank you very much for your help. :)
  4. C

    Help on Open Report Where Clause. Noob Here.

    and how can i do that? sorry am really just new in using access. ._.
  5. C

    Help on Open Report Where Clause. Noob Here.

    holy! thank you very much! im actually having a hard time trying to understand those quotes and stuffs, maybe you got some site i can read to learn more about it?
  6. C

    Help on Open Report Where Clause. Noob Here.

    am just new in using ms access. i'm using ms access 2010. can you please help me fix this open report where clause? whenever i run it separately like this: DoCmd.OpenReport "rptDaily", acViewPreview, , "ReportDate = #" & txtDate.Value & "#" DoCmd.OpenReport "rptDaily", acViewPreview, ...
See more
Top Bottom