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!

Register Log in
  • Congratulations Rhinorhino 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. missyu

    I would like to hide a label for a

    Don't know if this could be the problem but I noticed that you're also checking for an empty string (""). You could also check for NULL. Ex.: If IS NULL (Leaving_Date) then Hope that helps Miss Yu
  2. missyu

    Customize Project 2000 Reports

    I want to create some kind of summary report, basically like the Who Does What report but with subtotals of each project. So, I would like a report that will show each Resource, list the projects they are working on, the hours they have worked so far (Actual Hours and not Assigned Hours)and a...
  3. missyu

    Access Reports

    petermeachem; Thank you that worked great. Using the IIF as the control source did the trick!! Thanks to everyone but a big kiss to you! missyu
  4. missyu

    Access Reports

    I'm using Access 97. Isn't the "Can Grow" property only so that a field can expand if the contents are bigger than the set size? Then, the "Can Shrink" will shrink if the field is smaller, but it stays a BASE size doesn't it?
  5. missyu

    Access Reports

    Yes this has been done and it doesn't fix my problem. Thanks anyways:)
  6. missyu

    Access Reports

    These are Fields in a table. There isn't any code to show you unfortunately. Basically, I inherited this database and they want a custom report. So I just went in and used the report wizard and generated this report. There are 10 table fields where I want to display the field name if that...
  7. missyu

    Access Reports

    Hi, I am trying to show a list such as: Groceries: Apples Oranges Bananas Where all the listed fruit is actually different variables (ex. Fruit1=true, Fruit2=true, Fruit3=true). I know this is not the best way to do this however, this is the way it is set up and I must find a way to...
  8. missyu

    Use Project Central to process company's time sheets - Comments?

    I am still reviewing this as an option. So far, I find it's ok as long as everybody is on a project. Since there is customizable "Non-working" (name is misleading, am currently using as Non-Project time) time, this helps but it seems cumbersome.
  9. missyu

    Needing browse capability WITHOUT access to the Common Dialog Control

    Katerine (& Rick), You are AWESOME!! This worked beautifully. Rick's instructions were great but it was your step by step instructions that helped me set this up properly! Thanks a million!
  10. missyu

    Report is not getting focus

    Thanks Gord, But that did not work. The reason I don't close the form until after I open the report is because the form is passing values to the report. By closing the form and then opening the report, the report runs and then the dialogue box looking for parameters doesn't open up. The way...
  11. missyu

    Report is not getting focus

    Hope someone can help me. I've done this a million times but for some reason, it's not working. My code: ************************************************* Private Sub cmdOK_Click() If DCount("*", "qryRptAppsPerDept") = 0 Then MsgBox "No data to report&quot...
  12. missyu

    Needing browse capability WITHOUT access to the Common Dialog Control

    Katerine, Did this work for you? I'm using Access 97 and I'm having problems trying to use it. Do you just put the code that Rick provided above behind a button? (I'm trying to use it so that On_Click, I can browse for a file - is this the intent?) All I did was paste the code On_Click of a...
  13. missyu

    Access 97 Querys & Reports

    Disappearing Report! Prompts user for date parameters, and then generates the report but then doesn't set focus to the report? I use docmd.openrpt and then docmd.close form and this generally works but for some reason it: 1)opens the report, 2) closes my popup window and then 3) brings the...

Part and Inventory Search

Back
Top