Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. juliesmomma

    Date appears on first page but not following pages

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

    Date parameters not pulling all data

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

    Suppress Query Boxes

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

    Word Margins are not being saved

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

    Report using totals query not calculating on report

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

    Time parameter query not working

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

    Error when using afterupdate to populate

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

    Update a combo box from a value in a text box

    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 &quot;High&quot;. If [Points] is between...
  9. juliesmomma

    Saving a calculated field total in a table

    I have a form based on a query. In that query, I have a calculated field. How do I get that field to be saved in the table? Thanks!
  10. juliesmomma

    Want a label to display current time

    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!
  11. juliesmomma

    Word: Fixed table row height question

    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!
  12. juliesmomma

    Restricting combo box values

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

    Calculating totals on a report

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

Part and Inventory Search

Back
Top