Reply:

Report based on form value
I have a report based on a table. The table contains an ID# which is unique to an individual, but the ID# may appear more than once in the table. I also have a form that displays one ID# and has a command button to print the report. I use the DoCmd.OpenReport command in the OnClick function of the command button, but am having problems with the criteria part. strCriteria = "[ID#] = " & Me.ID where ID# is the field in the table and ID is the field on the form, returns a dialog box asking for the ID#, though the current ID# is displayed in the dialog box. I'm pr...

Multi-Currency aging report displaying incorrect totals
I hope someone can help. I recently modified the “MC RM Trial Balance Detail Report” by adding a fifth bucket. When we run the report, the Grand Totals and Functional total always display 9,999,999,999,999.99. I’ve checked the bucket setup and that seems correct. The Aging buckets are all defined and shows correctly on the RM TB Detail Report. Has anyone seen this before, we are currently on version 9 with the latest service pack. ...

Using categories, task, etc to create reports
I would like to summarise/quantify information from Outlook, using existing fields. For example: the # of tasks and phone calls that belong to a particular Category; or, the amount of time spent for a category or for a contact, using date ranges. Is there anything existing in Outlook? is there a way to do this in Outlook? Any suggestions? ...

Why does Money access I'net when first starting?
Start Money, Click on "Update Now", enter Pin, get " You cannot perform this operation right now. There is an online operation in progress. Try again later." What is Money doing? Why is it doing it? What is it downloading? What is it uploading? Is it doing something evil? Thanks, C. Check if you are auto updating stock quotes and etc. I have those updates turned off and only to bank acct updates when I log in, log out, and manual. -123 "Smif" wrote: > Start Money, Click on "Update Now", enter Pin, get > " You cannot perform this oper...

Solver internal error sensitivity report
Hello, I use the solver add-in in the German version of Excel 2007. When I try to generate sensitivity reports I get an error message: unexpected internal error. The generation works once when I uninstall and re-install the add-in. Obviously it is not an option to re-install the add-in for each sensitivity report... Any ideas what the cause may be? Any suggestions how to solve the issue? Thanks. Patrick ...

importnat dates money small business 5
I cannot seem to get the important dates module to stick to the home page, and even if I could how on earth do I put information in it ...

Real strange symptom.. Big Exchange bug of 2005?
Current setup: Exchange SBS 2003, Outlook 2003 Setup date: around Sept this year Hi all, i face a really really strange situation. I have some rules setup already to put dedicate user, e.g., Michael Jordan, to a folder "Jordan". Therules work well that put email from MJ to folder Jordan but today i found 3 emails from MJ sent few days before is not work. Instantly i trigger the rule manually "Run rule now" so that the email from MJ put back to folder "Jordan" although i m not sure why email does not follow the rule. BUT, the strange is, even i "Run rule now...

Installing Money 2007 #2
I have Money 2003 on my computer and I just purchased Money 2007 Deluxe. Do I need to have the latest version and where can I find them so that i can use Money 2007. Everytime I try to install, I get a message telling me that I need the latest version or the Service Pack. Can someone tell me what I need to get this Deluxe installed. Thanks! In microsoft.public.money, JMacon wrote: >I have Money 2003 on my computer and I just purchased Money 2007 Deluxe. Do >I need to have the latest version and where can I find them so that i can use >Money 2007. Everytime I try to inst...

Money 2006 Ignores Back / Forward Mouse Buttons
A while back, I noticed that MS$ 2006 quit responding to my forward / back mouse buttons. I now have to select the back / forward arrows at the top left of the window. Obviously, not earth-shattering; just exasperating. All of my other applications respond normally to the mouse buttons. I don't recall having done anything out of the ordinary to my configuration, so could it be that this is a side effect of one of MS's Windows updates? - John In microsoft.public.money, John Miller wrote: >A while back, I noticed that MS$ 2006 quit responding to my forward / back >mo...

Maximum Number of Subreports in a Report?
Hello, Is there a maximum number of subreports that a report can have in Access? Thank you! MN MacNut2004 <MacNut2004@discussions.microsoft.com> wrote: >Hello, > >Is there a maximum number of subreports that a report can have in Access? > >Thank you! >MN There is no specific limit of the number of subreports. The limit on the number of *nested* subreports is 7. The number of controls and sections you can add over the lifetime of the report is 754, so I guess that you cannot have more than 754 subreports. Type "Access Specifications" into the "Type a...

Report Templates
Can anyone help me. I'm looking to see if there are any free basic "Business Report" templates for Publisher out there. I'm not looking for anything complex, but a simple design to turn a long 60 page text document into something much more readable. Thanks -- ************************************* Colin McDonald colmacd@btinternet.com ************************************* >-----Original Message----- > >Can anyone help me. > >I'm looking to see if there are any free basic "Business Report" templates >for Publisher out there. > >...

Cannot perform Autobalance in MS Money 2005
Hi, Does anyone know why I cannot do an autobalance for my credit card bill in MSMoney 2005 std edition? Keep getting a pop error for every credit card account that says: " Your information is being updated. Click OK, wait for a few moments, then try again. If the problem continues, close and reopen Money. If you are using MSN Money, close and reopen Internet Explorer." I could previously use this feature in MS Money 2000, until I upgraded to 2005 version. Pls help. thanks! -- rgds, ben ...

Control Source for text box on a report
I have a table with only 2 fields. One is the name of Department and the other is the total number of positions in that department. On my report I have a label for every department. Next to that label I have a text box that counts every record on my report for each department. Next to that I want to add another text box that contains the corresponding number in the table for that department. How can I easily do this? Thank You, CEV I forgot to mention that I would also like to add yet another text box that adds the total of all the other text boxes that contain the total number of ...

Error when selecting reports in CRM 3.0
I have a fresh install of CRM 3.0 on Server 2000, and when I view reports on the server, the reports page show up correctly. However, when I try to view reports on my pc I get a "The request failed with HTTP status 401" error. In going through previous questions posted, I have looked at all possible solutions and everything seems to be set up correctly. I have verified everything in the documentation (Additional Setup Tasks Required if Reporting Services Is Installed on Different Server), and I am using System User as the service account, yet it still gives me the error. An...

Tender Summary report combining all registers and tender types
Hi, I know the Z report breaks down the tender type totals. Is there any report template to combine all registers into one total for each tender type (Visa/MC, debit card, Discover card, American Express, check, cash, etc) thanks This is a multi-part message in MIME format. ------=_NextPart_000_0118_01C8B095.F2EA34B0 Content-Type: text/plain; format=flowed; charset="utf-8"; reply-type=original Content-Transfer-Encoding: 7bit David, The attached report will do if you have HQ. Hope this helps Regards, Don "David Moffatt" <DavidMoffatt@discussions.microso...

Ganhar umas massas/Earn real money !!! #3
Se queres ganhar uns Euritos s� tens de instalar esta barra de publicidade, que podes at� minimizar ou fechar em caso de utilizar programas de ecr� completo. N�o incomoda nada, nem consome recursos. Apenas d� dinheiro, �ptima para quando deixas o comptdor a sacar a noite toda... Recebes o dinheiro na tua conta PayPal. http://www.eurobarre.com/index_fr.php?p=373093897695 100% seguro by CrashOverride If you want to earn money just by sitting in front of your PC, just install this Bar that shows some publicity now and then. 100% safe, no malicious ware. http://www.eurobarre.com...

Performance difference between SQL Server 2005 and 2008
Hello! I realize this give questions might be too generic, but hopefully somebody will point me into right direction. We in the process if migrating our SQL Server 2005 database Active/Active cluster to 2008. We have setup and configured SQL Server 2008 cluster and I started testing/comparing performance between old and new clusters. Database in question has been copied over to 2008, upgraded, statistic updated and compatibility level changed to 100. I noticed that very same stored procedure generated different plans in 2005 and 2008. It ran slower on 2008. Did anyone ...

MS Money 2003 #2
I am trying to load MS Money on my PC running Win 2000. All I get is a menu bar that is minimized in the bottom of my screen. Nothing else. I have close virus check and zonealarm, but I can't get the software to install. ...

running difference between adjacent records in report
I need to calculate the "in-between-time" for two records. Example: process 1 starts at 11:00 a.m. and ends at 11:15 a.m.; process 2 starts at 12:30 p.m. and ends at 12:45 p.m. I need to calculate the difference between the end of process 1 and the beginning of process 2 in an Access 2003 report. This is sort of the opposite of a running sum, but I cannot figure out if I can manipulate the running sum function to find the answer. You can do this by declaring a variable to hold the ending date/time from the previous record, so you can compare it to the starting time from the...

SRS (CRM_Locale) is set to false (Error when trying to view report
Hi When a user including CRM Administrator tries to access any report from reporting services they get the following error: "The property 'nullable' of report parameter 'CRM_Locale' is set to false. However, the corresponding parameter (default) value is null or contains an empty string. (rsProcessingError)" I can open the reporting server's site in a browser seperate from CRM and view the list of reports but I get the same error. But my CRM reports properly functioning at CRM clients Any usefule suggestions? Cheers Pareek Hi, I have exactly the same issue...

Money 2003 Crashes
Whenever I change the portfolio view from "standard" to "performance" the Money 2003 Standard program crashes and closes. Do I reinstall the program after backing up my data, or do I first uninstall before doing the reinstall. Thanks, FL Green Reinstalling may not help. See http://umpmfaq.info/faqdb.php?q=104 and http://umpmfaq.info/faqdb.php?q=85. "FL Green" <anonymous@discussions.microsoft.com> wrote in message news:1922101c44c83$d4b5fda0$a101280a@phx.gbl... > Whenever I change the portfolio view from "standard" > to "performance...

Microsoft Money #4
I am trying to load Microsoft Money 2004 Standard on my computer. However, it is telling me that Norton Antivirus may cause the setup to not work correctly. Can anybody help me with this issue? Yes. Disable or uninstall NAV, install Money, then re-enable and/or reinstall NAV. See http://umpmfaq.info/faqdb.php?q=119. "Linda" <lkbrown@aristotle.net> wrote in message news:7cc501c4774c$700a2770$a601280a@phx.gbl... > I am trying to load Microsoft Money 2004 Standard on my > computer. However, it is telling me that Norton > Antivirus may cause the setup to not work ...

total return numbers with money market funds
Since updating I am getting large negative total return numbers for my money market funds over the last 4 week and 3 month periods. Am I doing something wrong or is this a quirk that others have noticed? Thanks I'm getting same thing. It appears the 7 day yeild is going in as the price rather than the 1.00. The interesting thing is this seems only to happen to historical prices AFTER the current date. For example I'm sure I woulld have noticed almost a 5 fold increase in my money market when viewing my portfilio four days ago, but now if I select an as of date of four days m...

Money04 -voided billpay tranactions in money ---PLEASE HELP
Ok I have something weird. I tried balancing my Credit Card and it kept saying the starting balance was incorrect. Throwing off by $110 the account list balance is greater than the register balance by 110 which doesn't make any sense. I have located the bad transactions in my bank account. They were two transactions using billpay one for 80 and the other for 30 that are VOID. The thing is I have not had any problems balancing this account. So my question is how do I fix these transactions so that they stop screwing with the credit card? Should I just delete them? Deleting them does n...

Problems restoring back-up file
I am configuring a new PC at home and was restoring my Money 2005 back-up file onto the new machine. When I try to restore, I get the message, "Money cannot locate '<location of your Money data file>' or cannot open it, possibly because it is a read-only file or your disk drive is write protected." I cannot see any problem with disk space or write-protection. I did copy the back-up file to hard disk [from a flash drive]. Also, I opened the sample.mny file, backed it up, and restored that back-up successfully. Both my old PC and the new PC are running XP SP2 and th...