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?
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.
> Start Money, Click on "Update Now", enter Pin, get
> " You cannot perform this oper...Solver internal error sensitivity report
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
Any ideas what the cause may be? Any suggestions how to solve the issue?
...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?
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?
Is there a maximum number of subreports that a report can have in Access?
MacNut2004 <MacNut2004@discussions.microsoft.com> wrote:
>Is there a maximum number of subreports that a report can have in Access?
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
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.
>Can anyone help me.
>I'm looking to see if there are any free basic "Business
>for Publisher out there.
>...Cannot perform Autobalance in MS Money 2005
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!
...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?
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
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)
This is a multi-part message in MIME format.
The attached report will do if you have HQ.
Hope this helps
"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.
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
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
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?
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
Reinstalling may not help. See http://umpmfaq.info/faqdb.php?q=104 and
"FL Green" <firstname.lastname@example.org> wrote in message
> 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" <email@example.com> wrote in message
> 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
"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
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...