Recent content by hmm2

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

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

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

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

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

-hmm -Using AccessXP

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

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

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

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

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

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

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

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

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