what is the use of this #3
hi iam chinnu i now that what is the aim of the community
...Account list has incorrect amounts in MS 2004
Using Microsoft Money 2004, the dollar amounts on my "Account List"
page do not match the dollar amounts on the individual account
register. I saw this referenced as a problem over a year ago, but I
never saw a resolution. I've tried the FileRepair, but that didn't
How can I fix this?
Is this a problem with the Money software or the file?
If it's a problem with the money software, will the file work properly
with MSM 2006?
...Using Access for Microsoft Navision Reporting
I am curious if there are companies that have used Microsoft Access to
produce reports from Microsoft Navision 2009 (SQL-Server version) data and
are willing to share their experiences with this approach.
"Brad" wrote:subed going to jail
> I am curious if there are companies that have used Microsoft Access to
> produce reports from Microsoft Navision 2009 (SQL-Server version) data and
> are willing to share their experiences with this approach.
...Using the windows firewall
I plan to open up one of the interfaces on my Excahnge 2003 box to the
internet so that I can use OWA. I plan to use the built in firewall in
Windows Server 2003. What ports do I need to leave open to allow OWA to
HTTPS = 443
Or if no SSL, then HTTTP = 80.
Is this the only firewall between your server and the internet?
> I plan to open up one of the interfaces on my Excahnge 2003 box to the
> internet so that I can use OWA. I plan to use the built in firewall in
> Windows Server 2003. What ports do I need to leave open to allow OWA to
>...Using the wildcard with IF
I'm trying to set up a message that will generate from an IF formula. At the
moment I'm at:
=IF(E3="*C3","","Please check that you have chosen")
The content of C3 is a part of the content in E3 e.g. E3=161426 oxygen and
C3=oxygen. I want to check that what is in C3 is also in E3 and, if not, put
up a message. All help appreciated.
Try it like this:
=IF(COUNTIF(E3,"*"&C3),"","Please check that you have chosen")
Microsoft Excel MVP
"DamienO" <DamienO@discussions.microsoft.com> wr...Additional Patches of DPM 2010
Recently one of our site need to use dpm 2010 on a 64bit server.
I've not been coming to this forum, therefore i wish to find out :
a) i will get dpm2010 media from microsoft, but are there additional kb to
b) any latest doc or issue i need to take note.
This issue is already discussed at:
Praveen D [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
DPM Newsgroup will be deprecated very soo...[MS Graph] Cannot edit in the datasheets
We have a problem with Microsoft Graph (Office 2004 on Mac) opened by
PowerPoint 2004. Sometime, it's impossible to edit the graph : I cannot
modify the value in the datasheet. I can delete or paste a new value with
the clipboard, but I cannot write anything with my keyboard.
Sometime, closing MS Graph solve the problem, sometime no. Same thing with
a system reboot. When restarting MS Graph or rebooting doesn't solve the
problem, the only solution is... waiting. Yes, waiting.. It will works
later when I will retry some hours later.
The bug appear at least on 2 Mac on OSX...Problem when using send to -> as attachment and having the email NOT use the exchange server
We are using Outlook 2003 with both a POP3 account (the main email
address for my library) and an exchange account that is only used for
town communications. When we go into an office document and pick send
to -> email as attachment the email always sends through the exchange
account. We have set the POP3 account as default, gone into tools ->
options -> send/recieve -> group accounts and told the exchange account
to NOT send emails, and in the email itself we tell it specifically to
use the POP3 account and it still sends the email with the exchnage
server. Does anyone know how...Using a parameter
I have a form (FormA) which has a subform(FormB). One of the listboxes on
FormB uses a query using a field from FormB as part of the where statement.
I've tried various versions of [forms]![FormA]![FormB].Form![PD_Date]
in the where statement. The query prompts for the value and if I enter it,
the query runs fine. When I try to run it on FormB, it prompts for the
Can anyone let me know what I'm doing wrong?
Likely the name of the subform control that is holding "FormB" as the
subform is not named FormB. Open your main form in design view, clic...Using previous record to perform calculation
Here's my query:
CONum PONum POTotal COTotal RevTotal
1 18 $855
2 18 -$11,645 $30,000
and so on...
I want to know how I can copy the previous record value of RevTotal to
POTotal to subtract COTotal and keep this going. This is really simple
but I'm having hell of a time getting this right.
Any help would be appreciated.
could you generate a report based on this query with a group header for
create an unbound field for RevTotal in the ...I need to use area code to determine time zone
Can't use nested if, too many entries, does anyone have any suggestions?
There is a similar request at http://tinyurl.com/77tq7
"Dick" <Dick@discussions.microsoft.com> wrote in message
> Can't use nested if, too many entries, does anyone have any suggestions?
...BUG in typed dataset generation, when using maxoccurs and Simple Types??
I've looked all over for any information about this, and either this is
a bug that I cannot find reported or I've misunderstood something.
Lets say, in the XML Designer in VS.NET 2003, you drag over an element
(call it MyElement) and add another element of type string (call it
NormalElement) as a member. If you look at the generated typed Dataset
code there should be just one table ("MyElementDataTable"), with one
If you set maxOccurs to something greater than 1, or unbounded, then
the dataset has to contain an additional table to allow for more ...Which is easier to use for this project?
I currently have a spreadsheet that lists the following fields.
· User Name
· Number of Request
· Total Time
· Total Time Per Request
With these fields I would like to create a database that will give me an
average of the number of request received, times the total time spent on each
request, ending with the total time per request.
Also, I would like to be able to run reports that will allow me to see the
totals and averages by user, date, and by group.
Which one of your programs would be easy to use to cre...Using a combo box in an Excel form
I'm experienced with Excel & VBA, but new to using Excel to create a form.
I would like to simply use a cell as a drop down. Not knowing if that is
possible, I have added a combo box to the spreasheet, but I am unclear how
the data entered/selected in the drop down will be stored. Is it stored as a
VB variable associated with the control or do I link the control to a cell to
store the data? To define the values in the drop down/combo box, do I have
to use cell references or can I write in the values in the properties
(writing them in hasn't worked for me)? Finally, what ...Merge with MS Word
I am merging my location field from Access with Word. In Access, I have the
location filed look the location to a separate table then store the locations
as a number to the corresponding location. In Word, I would like the
location names to show instead of the numbers. How would I best accomplish
Create a query that includes the table you are working with and the location
table. Include the name of the location from the location table in the
query. Merge the query with Word rather than your working table.
"WG" <WG@discussions.m...[Q] Managing Family Finance with MS Money
Is it possible to manage accounts of all household members (i.e.
husband and wife) together with MS Money?
For example, if the husband and the wife both have credit card
accounts with Discover, MS Money doesn't allow to set up online
services for both the accounts. It only enables to access a single
account through online. I wonder if there is a way to access both
accounts with the online service.
If this(managing two accounts with the same institution) is not
allowed by MS Money, what is the good way to manage the whole
household finance? Is there any other software which does this?
...Generating Multiple MS Reports
I have two tables in MS Access and would like to generate a master
report separated on individual pages for eahc user.
Table 1: PeopleID
Fields: NameID, Last Name, First Name
Table 2: Contributions
Fields: NameID, Date, Amount
I would like to be able to generate a report that would print a page
for each NameID so they can use for tax purposes that shows their
contributions to a fund.
Any help on writing this query and report would be helpful.
>I have two tables in MS Access and would like to generate a master
>report separated ...VBA in Access or Outlook
I have a table containing email addresses and other data that I need to email
out to each recipient in the table. Each email will contain in the body of
the message only the data relative to the particular recipient.
My question is which application Access or Outlook is the best one to code
the module in to do this?
I am using Access 2003 and Outlook 2003.
Use the SendObject command in Access VBA.
> I have a table containing email addresses and other data that I need to email
> out to each recipient in the table. Each email will contain in the body of
...How do I use C# to build COM addin?
I would like to build COM component add-in using C# instead of VB.NET.
Since QSRules.dll is not strong named, I cannot reference it directly in C#
Here is what I did.
1. Create C# Class library.
2. sn -k AddInTest.snk
3. Add this line [assembly: AssemblyKeyFile("AddInTest.snk")] in
4. Declare Entry Point.
public bool Process(QSRules.SessionClass session)
Unfortunately, it cannot be compiled because QSRules is not strong named.
So it give...Using sheetname variable in a formula #2
Yes that WORKS!!
One minor glitch however.
My *desired* sheet name is *A-325* and the like (A-490, etc)
Your code does not work for that name, however if I change it to *A325
Any ideas why this is happening
mms's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1653
View this thread: http://www.excelforum.com/showthread.php?threadid=31386
should work. Have you included the apostrophes ' in the formula. Post
the exact formula you have used
Fr...Outlook and MS Journal (TabletPC)
Under Office XP if you had a tablet you could load the Tablet PC extentions
and get a hook between Outlook and MS Journal (e.g., calendar to journal and
tasks to Outlook).
Under Office 2003 this hook is lost (unless you upgrade from XP to 2003).
Has this feature been dropped or just forgot?
...MS CRM 4.0 Performance Issue
Are there any ways with which we can monitor MS CRM performance? Or how MS
CRM performance can be increased?
(Considering opening a new record, save and close etc).
As we have deployed MS CRM for one of the client and where MS CRM is
supposed to do all the processing’s in a second or two.
Help highly appreciated.
...use same cell w/in a function in a entire column.
I want to be able to create a entire column in which every cell in the column
pulls a data point from the same cell. If I high light and paste from my
initial, lets say B1 to b2 through b100. It changes the A1 data in each cell
to the next to a2 a3 a4 a5 a6 a7 a8 ect.. i know this is simple but thanks
Put a $ in front of the row reference (ex: a$1 instead of a1) to keep the row
from advancing as you fill down. (Similarly you could put a $ in from of the
column reference to keep the column from advancing as you fill right). Check
Excel's help on 'cell and range re...MS Money 2000 Business Edition
I am looking for a way to use the customer addresses in Ms Money 2000
Buisness to do a mail out using MS Word.
...All Office 2004 application no longer start after applying Quicktime patch
I have applied the Quicktime update issues yesterday and since then,
Office 2004 Application will no longer start up. I click the
application icon, it jumps a bit in the dock and than quits. Strangely
I was able to run the Microsoft AutoUpdate which applied the Office
update released a couple of days ago, but did not fix the apps. The
Console does not seem to display anything.
This is killing my productivity... Does anyone know a fix or
PS: I am running a fully updated 10.4.10 MacBook Pro / Intel
On Jul 12, 10:00 am, mik.lern...@gmail.com wrote:
> I have applied the Qui...