Search results for query: *

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

Ok... I have done this several times with other forms but this one particular one is just giving me fits. I want to be able to choose a name from a drop down list and have the department populate for that particular person. This is the code I used. Me.Dept = DLookup(&quot;Department&quot...

It still isn't doing it immediately. It's not when it's a new record. I want it to update in the current record. Thanks for your help. Maybe it's just not possible.

That fixed the Null problem but I still would like it to update [Risk] while they are on the same record. It defaults &quot;Low&quot; in the [Risk]. They have the option of printing the form (report). If it doesn't update while they are on that record then it will have the wrong risk rating...

Ok that works but it doesn't update the field unless I exit the form or go to another record and then go back. Also, it won't let me do a new record without the message &quot;Invalid use of null&quot; because the value in [Points] hasn't been figured yet. You have been very helpful! Thanks...

chrissie1, I tried your code in the afterupdate event of the textbox [Points] but it still didn't work. Could it be that my form is based on a query that figures the total for the field [Points]? I'm grasping at straws. Thanks!