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: *

  • Users: hmm2
  • Order by date
  1. hmm2

    Labels - Wrapping, Alignment Problem

    I have a report set up to print name tags (labels) for invitees and their guests. The invitee prints in the left column, the guest in the right column. If the guest name is too long, causing it to wrap (CanGrow property set to YES), it causes the invitee fields to print further down on the...
  2. hmm2

    What is the Packaging Wizard SUPPOSED to do?

    Thanks, Fancy. I appreciate the information. -hmm -Using AccessXP
  3. hmm2

    What is the Packaging Wizard SUPPOSED to do?

    Can someone explain what the Packaging Wizard is supposed to do - and what it does NOT do? I've been trying it out for the first time over the last couple of weeks. I was under the impression that by creating a run-time application, regardless of whether or not the recipient's pc has Access...
  4. hmm2

    Packaging Wizard Error

    Found an answer which works (so far): Microsoft Knowledge Base Article Q321000 http://support.microsoft.com/default.aspx?scid=kb;en-us;Q321000 Interesting thing is, the article states: This problem may occur if the package that you try to create is in a language that is different from the...
  5. hmm2

    Packaging Wizard Error

    I did upgrade from Office 2000 to XP, and I've tried every disk I've got, including the Office 2000 disks. It wouldn't accept any of them. (Error message stating the disk is not an "Office CD 1" disk.) -hmm -Using AccessXP
  6. hmm2

    Packaging Wizard Error

    -hmm -Using AccessXP
  7. hmm2

    Packaging Wizard Error

    After the second step of the Packaging Wizard process, I'm getting an error. (Step 1 is Identify Application and Package; Step 2 is Application Information.) When I click NEXT after Step 2, I see the program briefly opening (and closing) the database chosen in Step 1, then I get the following...
  8. hmm2

    Adjusting Percentages in Excel

    I understand what you mean, LeKirk. Unfortunately, the 'powers that be' will not accept anything other than the final printed percentages actually adding up to 100.00% on the bottom line. -hmm -Using AccessXP
  9. hmm2

    Adjusting Percentages in Excel

    That's a possibility, but not very likely for the figures I work with. If/when that ever happens, it will be easy enough to spot, and I can adjust it manually. Thanks again for your help. -hmm -Using AccessXP
  10. hmm2

    Adjusting Percentages in Excel

    Thanks a million, iGrant! Your tip will save me loads of time pacifying the 'powers that be'. I really appreciate your help. -hmm -Using AccessXP
  11. hmm2

    Adjusting Percentages in Excel

    yes, your method of rounding to 5 digits causes the displayed value in the last cell to equal 100.00%, BUT when you manually add up the three percentages (21.05 + 30.26 + 48.68), the total is still 99.99%. (Excel sums up the actual values in each cell regardless of the 2-decimal display...
  12. hmm2

    Adjusting Percentages in Excel

    Example of Problem: COL-A COL-B VALUE % SHARE ROW1 16 21.05% [Formula: ROUND(B1/B4,4)] ROW2 23 30.26% ROW3 37 48.68% ROW4 76 99.99% [SUM OF ROWS 1-3] Question: Is there any way of automatically adjusting percentages so that the total equals...
  13. hmm2

    Record Creation Date, Last Modified

    Can someone please tell me how to retrieve the date that a record was created (added to a database table)? Also, same for the date the record was last modified? (Using AccessXP) -hmm -Using AccessXP
  14. hmm2

    ACCESS/VBA TRAINING

    Thanks, Raymondo. My next question was going to be regarding books/materials as you've described. I appreciate your input and will be adding to my library soon. -hmm -Using AccessXP
  15. hmm2

    Access / VBA Training

    I'm trying to find a GOOD training course, preferrably in the Houston area, that provides in-depth instruction regarding database design, multi-user environments, security, VBA programming/customization, etc. I've seen too many programs and classes that only touch the surface of Access -...
  16. hmm2

    ACCESS/VBA TRAINING

    I'm trying to find a GOOD training course, preferrably in the Houston area, that provides in-depth instruction regarding database design, multi-user environments, security, VBA programming/customization, etc. I've seen too many programs and classes that only touch the surface of Access -...
  17. hmm2

    Linked Tables

    While in the Visual Basic Editor, go into the help files and search for "SourceTableName Property". Has example code on how to set the sources (linked tables) using VB. Could build in some If/Then code to determine if the other user's computer is accessible; hard-code the path to an...
  18. hmm2

    Linked Tables

    Do you mean - change the path by some other method besides using the Linked Table Manager? If so, no clue. The location of the Linked Table Manager depends on which version of Access you're using. In 2000 and XP, it's under Tools, Database Utilities. -hmm -Using AccessXP
  19. hmm2

    undesirable space in label report

    Set the CAN SHRINK property for each of the fields on your report to YES. (But make sure the CAN SHRINK property of the DETAIL SECTION is still set to NO.) That worked on my labels. Hope it helps. -hmm -Using AccessXP
  20. hmm2

    Report Based on Crosstab Query - SLOW

    The issue in question is NOT the processing time when RUNNING the report, but rather when in DESIGN VIEW (working on the report structure/format, etc.). I have found that when the report is based on a crosstab query, and the table is of a substantial size (say around 500,000 records or more)...

Part and Inventory Search

Back
Top