Recent content by juliesmomma

Thanks Knicks. I did check my spelling and it is correct. Sorry for the type-o in my thread. Before I did this thread I did find that I had a type-o in one of those fields but that didnt' fix the problem I'm having. Vic I did not have my Report Dialog form set to Modal. I did that but that...

Let's see if I can answer all the questions. 1) Report Dialog is a Popup form. 2) On my Report dialog form, when I click the Run Report button, the first item of business is for the click event of that button is Me.Visible=False. I have code in my report for Report_Close() event to close...

I have a parameter form (Report Dialog) where the user enters the date range in 2 text fields. In the header of the report I have 2 text fields for the date range. The From date field has this code: =[Forms]![Report Dialog]![txtFromDate] The Thru date field has this code: =[Forms]![Report...

That didn't work for me. I wrote an update query and fixed the dates so that they didn't have times. Worked like a charm. Thanks for your help!

I went back and looked at my table again. I clicked in the [Date] field and it IS capturing the time. I'll work on that and see if that corrects the problem. Thanks for pointing that out.

I have set my [Date] field to short date. In my query, my criteria for [Date] is Between [Enter From Date:] And [Enter Thru Date:]. I have had this same thing happen in several of my databases so I'm not sure what I'm doing to cause the problem. dhookom: I looked in my table and it is only...

I have a report based on a query with "Between to and from dates". I want to pull a report for May, 05/01/05 thru 05/31/05. I have records on 5/31/05. However, when I enter those dates in the parameter, I missing the records from 05/31/05. Why does it do this? Any info would be appreciated...

Hey THANKS a million! That worked like a charm!

I have macro to run several queries (update query, append query, delete query...). When it runs, the query prompts the boxes that tells you what it is doing. Is there a way to suppress those pop up boxes that tells you it is updating rows, appending rows, deleting rows....? Any info would be...

Does anyone have any information on this? I would appreciate your input. Thanks!

I have a user who designed and saved Word Documents. We installed a new PC. Using the same printer and same version of Word. Now, when the user previews and prints her documents, they are cut off on the left and bottom. I can view those same documents on my PC and they are just fine. Can...

Thanks for your replies. I used the crosstab query and that worked like a charm. Thanks again!

I am creating a report to calculate total number of patients per month and it will look something like this... April May June 1 1 9 I did a totals query where it counts where it is grouped by [Month] and counting Record# (CountOfRecord#]. The query calculates just fine. I get...

Nevermind. I think I figured out what I was doing wrong. Thanks anyway.

I have up a query to pull records between 7p - 7a (nursing shift with a date range. The one I wrote for 7a - 7p is working fine. On the Time field this is my criteria: >=#7:00:00 PM# and <=#7:00:00 AM# Why isn't this one working? I used this same criteria for the other query just opposite...