Search results for query: *

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

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

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

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

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

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