I am trying to set up a database on Access that Monitors incoming and
outgoing email traffic for specific group addresses in an Exchange Enviroment.
This only needs to be a simple culmulative count with a date stamp.
Not too sure how I would start this.
Many thanks in advance for any help that can be given.
My guess is to use MAPI to connect to and interact with the server. From
there, there should be code available to read the traffic.
> I am trying to set up a database on Access that Monitors incoming and
> ...Estimated Data size for 3-5 years
I was looking for a document that give me an idea or talking about how to
estimate Microsoft Dynamics GP database Growth and size. Any one could help
me in this?
I found an article on MSDN but it is about SQL server and it needs to go
throw all GP tables and finde the size of each field and calulate that number.
I have the following GP system:
And Financial Module
It really depends on the number of transactions that go through your system.
If I had to guess at an average, I would say a database in use for 3-5 years
would ...scale to page error in Excel 2007
somehow something has changed in my Excel 2007 setup where my "fit to scale"
does not work appropriately. When I choose print preview, the preview screen
changes to a very small preview and my document is a few thousand pages.
This document used to print fine on one page. Even on my other computer it
The funny thing is, when I change it back to 100% scale the preview is large
again but still cuts off a few columns.
I must have changed some setting that I need to reset but cannot find it.
Any help is appreciated.
Have you checked your setting of print ...Conditional Formatting Question.
I've set up a work evaluation workbook with multiple worksheets. For
explanation sake I'll stick with my first worksheet titled "Jan". I
have set it up where I have a name column, month column, shift column
an various other columns for evaluatin purposes. below the names and
under each column I've set up my evaluation formulas. What it does is
calculate each column individually and determine the average.
(example: absenteeism-it will figure out the average hrs of sick time
used by employees that given month) It will also calculate 10% above
& below average as well...Excel chart-y axis title question
Everytime I have a y axis title and it will not show up the end of the title.
I tried to use small font but it doesn't help. Does anyone ever have similar
Many people have reported this problem, and the following post by Jon
Peltier may help you:
> Everytime I have a y axis title and it will not show up the end of the title.
> I tried to use small font but it doesn't help. Does anyone ever have similar
> problem? Thanks.
Ex...additional exchage in a shared address space / install question
I am about to run out of space on my exchange server, so I came here for an
I have 3 physical locations
Location 1 - Headquarters (50 Users in the workgroup environment)
Location 2 - Remote Site (10 Users Domain Environment with Exchange)
Location 3 - Remote Site (7 Users Domain Environment)
I have a Gateway to Gateway VPN tunnel between Location 2 and 3. I am in a
single Active Directory 2003 forest with a single domain (mycompany.local)
DC at the location 2 holds all 5 FSMO roles. Exchange 2003 Enterprise is
configured on the same server.
Users from 2nd location run...Data base
I need to know as the table is called where registo keeps from the TPV
HI I think you are talking about the Configuration table which store the
information of store also there is table name called "register" please
describe your main purpose and what exactly you are asking.
Hope this will help you.
> I need to know as the table is called where registo keeps from the TPV
...Simple Question-How to create more than one transaction on the Acc
If there is a question already posted let me know. The question is: I created
a bank account information on the Account list icon and want to have more
than (one)transactions listed and see each payee displayed separately on
each page so i could have all the months posted with due dates and total
listed. Thank you.
In microsoft.public.money, a.j. wrote:
>If there is a question already posted let me know. The question is: I created
>a bank account information on the Account list icon and want to have more
>than (one)transactions listed and see each payee displayed separately ...Past Questions and Answers
How can I find out past questions and answers for a specific topic? I lost
the answer to my question, which was posted here last week?
I'd use google. Give it enough information (keywords/author/subject):
> How can I find out past questions and answers for a specific topic? I lost
> the answer to my question, which was posted here last week?
> thank you
...Page numbers restart with continuous page break
This happens in 2007, 2003, and 2002. My doc has 2 "next page" section
breaks within the first 3 pages. After each break, I've requiested that the
numbering restarts at "1" and that works fine. After several pages I need 2
"Continuous" page breaks so I can use a 2-column format within a page. I use
the Insert Page Number Format command to have it CONTINUE numbering.
However, it restarts the numbering. If I do this as a test with a doc that
does not have regular section breaks at the beginning it seems to work. Best
case, I would like to ma...Getting Rid of "Ghost Field" on Access Report
I'm hoping you can help me with a puzzling behavior exhibited by an Access
report. When I attempt to run it I receive an error message asking for a
value to a field that is not on the report or the underlying query.
I have a report, which I will refer to as MyReport#1. It runs off of a
MyQuery#1 without any error messages. I used MyReport#1 as the basis for a
second repot, which I will call My Report#2. Everything, in MyReport#2 is
identical as MyReport#1 except for one field. MyReport#2 runs off of a
different query which I will call MyQuery#2. If I run MyQuery#2 by itsel...Access as a Front-End
I am wanting to use either MySQL or SQL Server as a back-end to a MS Access
front-end. Furthermore, I need to be able to use this front-end over a
Wireless router. I know that by default MS Access does not leand itself to
wireless connections but have been told it can be done if changes are made...?
Can someone give me a little guidance on the matter. Perhaps refer a good
article or site that covers this subject to get me going in the right
In the 18 years that I have been working with Access, I have helped clients
fix 8 data corruptions. The f...Transferring email addresses from Access to Outlook address book
Is there a way of transferring a list of email addresses with their contact
names from an Access Database Table to my Outlook?
...How to Trap Rogue Data ?
I have an application that generates hourly system performance
logfiles which I graph to look for long term trending.
The metric I use gradually varies from 1% to about 15% depending on
various external factors - such as time of day and day of week.
My problem is that the logfiles sometime hiccup and generate bad data
resulting is huge spikes in my curve. I have trapped for the big ones
> 20% in my source data but I need something smarter so I can catch
large deviations from the curve.
Unfortunately I do not have the option to fix the application that
generated the bad data.
Are ther...Converting Access 2002 to Access 2003 Database
My company has just updated to Window Xp professional ( Operating System )
and Microsoft Office Xp professional. Previous version were Window 2000 and
Microsoft Office Xp professional.
I have quite few Access database design in Access 2002 ( ie Office Xp )
When I try to convert this database to Access 2003, it gave me error, saying
I need to download and update " Microsoft Jet 4.0 service pack 8".
I downloaded and updated my systems.
When I try to open this database, I get following error
" Security Warning : Unsafe expressions are not blocked. Microsoft jet 4.0
service ...Copying portion of page
This was discussed a while back, but for some reason, I can only access back
to June. There was some sort of little "camera" icon in Publisher, and I
have used it (to copy only part of a page), but now I cannot find the icon.
How can I restore/find it? (I have MS Office 2003). TIA
> This was discussed a while back, but for some reason, I
> can only access back to June. There was some sort of
> little "camera" icon in Publisher, and I have used it (to
> copy only part of a page), but now I cannot find the
> icon. How can I restore/find it...Toolbar dropdown question
Office XP and Outlook Express will automatically display the double arrow
indicating that there are more buttons on the toolbar when the window is
resized to the point it hides a few buttons of the toolbar. When we click
on this double arrow, a dropdown containing the hidden buttons will pop up.
Does CToolBar have this capability? I have taken a look at CToolBar but it
did not imply anything to the trick. Anyone has a good suggestion? Thanks
> Office XP and Outlook Express will automatically display the double arrow
> indicating that there are mor...XLS2000 IE6 No Data Sort
I've got users with IE6 and Office 2000 who are opening
XLS sheets from the web. From the IE browser the Data menu
appears but is not functional.
I attemped to unlock the toolbar and move it so that none
of the menus were covered up thinking this might help.
Office XP (2002) with IE 6 works just fine, problem is I
have 1500+ users on Office 2000.
Can anyone offer any suggestions? I've check permissions
on file, users rights on PC and Office/OS updates.
...Opening file question
When opening a file direct from my documents excel opens
but the sheet does not get displayed. Although if you then
click print preview the content of the sheet is there.
Tried opening excel and then opening file and this works
fine. Not a major problem but annoying.
Any one shed any light?
I think xl is trying to help you.
Excel wants to keep the window settings the same way as they were previously.
If you saved your workbook in less than a full window, then the next time you
open it (via double clicking with no existing xl instance running), it will open
it the same win...Can't see any data in Workflow Monitor
Have been finalising my server install and re-adding
Opportunities to the newer Workflow. But as doing this I
now cannot see any data records whatsoever in the Workflow
Monitor. It tells me how many items are
Active/Paused ..etc in the Summary creen, but when I got
to have them listed no data appears and claims that there
are no Active/Paused ..etc records?
No idea as to why????????
...Access word document from external app while it is open
I open a text file with ms word 2003 (i.e. a common txt file) and I need to
edited from ms word which is ok, but I need also in parallel access it by an
external application and I cannot (I get a message permission denied). I
imagine that ms word lock the file. So what I can do to override this
setting? in order to edit the file from another application while the file is
opened in word?
There is nothing you can do. Word will lock the file. Word is not a
<>>< ><<> ><<> <>>< &...Journal Entry Data Dump
Our auditors want a data dump (into Excel preferably) of all Journal Entries
made during our fiscal year. Does anyone know of a way to accomplish this?
You can do this in SmartList, under Account Transactions. Limit the
transaction date range to get just your fiscal year. Remember to change the
number of transactions SmartList brings back, since by default it's only
1000. Also, if you get more than about 65,000 transactions back, you will
run into Excel limitations, so you may want to break this up further - maybe
one export per month.
Hope that helps.
Vict...Read Only Access Second time opening
I am having errors while modifying a spreadsheet.
I am running Win Xp and Office 97, and can open and
modify the file once but if I close it and open it again
it wont allow me write access, but only read access to
Try cleaning up your windows temp folder and then reopen your workbook.
You may have to reboot.
> I am having errors while modifying a spreadsheet.
> I am running Win Xp and Office 97, and can open and
> modify the file once but if I close it and open it again
> it wont allow me write access, but only read access ...Tad confused about remote Admin access.
Do I use RWW, RDP or another method. I'm using 2008 standard. What about
happyhacker's Profile: http://forums.techarena.in/members/188993.htm
View this thread: http://forums.techarena.in/small-business-server/1358122.htm
On Mon, 16 Aug 2010 01:55:49 -0500, happyhacker
>Do I use RWW, RDP or another method. I'm using 2008 standard. What about
Depends wha...sharing an item across pages in word
i have a document in which i have the same table on 5 different places.
so now if i have to update this table then i have to update it on 5 places.
is there any solution so that if i update that table on one page, then all
other tables will also get updated.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> &...