Search results

Hello Guys, I have a Table to store the Total of Expenses in a Financial Year. I have created queries to break down the Expenses by Month (April, May and June). Then I have created another query to combine these. This is my Query Result: I want to transpose this Query Result like: Could...

Thanks a lot

Thanks a lot. It worked Perfect

Hello Guys, I want to sort entries in my Form by Entry Time. So I have created a new field in the Table and set the current date and time as default value. Then I have make this Text invisible. I want to display the latest Record when I open the Form. Could you please let me know how to set...

Sure

Thanks a lot. Let me test this

Hello Guys, May be a very stupid question, But is there any way we can add Fields in a Query on fly? There are 5 Fields in my Query and in a Form all the Fields I am showing in a Check Box when a user select 3 Fields from the Check Box and click on Run Query Command Button, I want to just show...

Thank You

Thanks a lot

Sure.

Sorry it is my Fault. As Gasman suggested I changed my Code Text120= instead of Text120.ControlSource, my apologies

Thanks a lot It worked Perfectly

Thanks. Your clues Helped me a lot Sir. But scared VBA Codes :)

Thanks a lot for your Reply. To find a sum based on criteria, I am using DCount Function. The criteria I am adding in the Control Source Property of a Text Box. I wan this in an Event. So I put this Code in the Lost Focus Event of a Text Box Like: Private Sub Review_End_Time_LostFocus()...

Hi, I have changed Code Text120.ControlSource = DCount("*", "[tblReviewed Hours]", "[Review Start Time] > #" & TimeValue([Forms]![frmReviewed Hours]![Review Start Time]) & "# AND #" & TimeValue([Forms]![frmReviewed Hours]![Review End Time]) & "# < [Review End Time]") and this time I am...

Sorry I didn't get you. I have to put # around where?

Hi, I changed code to Text120.ControlSource = DCount("*", "[tblReviewed Hours]", "#[Review Start Time]# > " & TimeValue([Forms]![frmReviewed Hours]![Review Start Time]) & " AND " & TimeValue([Forms]![frmReviewed Hours]![Review End Time]) & " < #[Review End Time]# ") But still getting Error...

Thanks a lot. This is the Error Message I am getting when I put the Code in the Lost Focus Event of Review End Time Text120.ControlSource = DCount("*", "[tblReviewed Hours]", "[Review Start Time] > " & TimeValue([Forms]![frmReviewed Hours]![Review Start Time]) & " AND " &...

Hi, This is my Code: =DCount("*","[tblReviewed Hours]","[Review Start Time] > " & TimeValue([Forms]![frmReviewed Hours]![Review Start Time]) & " AND " & TimeValue([Forms]![frmReviewed Hours]![Review End Time]) & "< [Review End Time] ") I am getting #Error Thanks

Thanks a lot. I think I can add another criteria like Between [Forms]![My Form]![Start Date] and [Forms]![My Form]![End Date] May be a very bad Logic. Thanks