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...
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...
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...
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...
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...
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("Department"...
Hi All!
What I am trying to accomplish is updating a combobox with a value that is in a text box.
The text box [Points] totals points from a survey for Cardiovascular Risk. If the number is >39 I want the combobox [Risk] automatically populated with "High". If [Points] is between...
I want to be able to display current time in a label (lblTime) where it is updated every second. I have a Timer control on my form set to 1 second interval. Thanks for any help!
I am wanting to make a table row in Word a fixed height. I know how to set the row height in Table Properties. My problem is I want to make the cells where you can't type beyond the fixed row height. Got any suggestions? Thanks so kindly!
HI!
I have a form called Quote Information where we can quote items for our internal customers. On this form, I have a combo box from which I select a Vendor. I have another combo box that has Products. I have restricted the products field based on the vendor chosen so that I only see active...
I have a survey database with questions much like the following:
Very Poor Fair Good Very
Poor Good
-----------------------------
Were you plesantly greeted: 1 2 3 4 5...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.