outlook blocked access to the following potentially unsafe attachments
I am extremely frustrated by the inability of my friends
to send me Level 1 ("Unsafe")attachments, such as URL's,
Access databases and such without having to tell them
they need to zip the file or change the file name
How can I fix this problem?
I'm using Outlook 2002 with no service packs updated.
Steve bashed at the keyboard and said..:
> I am extremely frustrated by the inability of my friends
> to send me Level 1 ("Unsafe")attachments, such as URL's,
> Access databases and such without having to tell them
> they need to...Pivot Table not pulling all fields or data
Without getting too verbose, I have a 900 row by 26 column database I am
applying a Pivot Table to. The code seems to run fine, but it is not
returning some of the fields, and of course the related data. I have tried
reformatting the entire columns I am pulling from but no joy......however,
when I reformat an errant cell from General to TEXT, that row comes
in........and/or, if I change the value in one of the missing cells, it will
bring that row in. The code runs fine, and was mostly derived by recording
a macro in XL2k, but the data cannot be trusted becau...How do I automatiicaly redefinie Source data range for a chart?
I have A Chart Defined by Category (X) values in Collumn B and Y values in
Collumn C. Right now Both are defined by rows 4 to 114.
I would like to be able to have the chart automatically redefine itself so
if I put a value in C115 the chart would automaticaly set Y value range to be
C4:C115 eithout having to manually define chart. Is this possible? If so
how? I've tried OFFSET bu so far no luck.
If you turn your data cells into a List, or Table in xl2007, the chart will
The named range approach will work if you set up the names correctly.
See here for more info...importing into register
I have successfully downloaded files from my bank into my
checking account register. I have one account that that
downloads my account info into a separate checking
account, not the one I intend. I save the file then
tried to import and it still imports into the other
Bank support told me that the download may be matched to
the other account and to turn it off, then re-point it to
the correct account. I do not know how to do this. I
even closed the incorrect account and did the import and
it still imported into this account.
Any suggestions are appreciated.
You'll...Problem importing dll
I have an application that used some external com dlls. So in my application
code i've imported those dlls as
#import "path of external.dll"
and i'm using smart pointers to instantiate those coms as
The problem i'm facing that those external com dlls are not mine so every
time they are modified by thier owner i've to recompile my code too with the
latest dlls otherwise my code does not work and i get Obj = NULL in the
above statement. Actually those external dlls are of a software that i've
provided integratio...Exchange data backup
I'm worried emails backup of the small office.
Does SBS2008 Exchange server has a direct backup capability of whole mail
How to backup every night Emails from server to external harddisk?
Does Exchange server needs to be stopped before backup?
SBS2008 Takes care of it.
look at the comments section
Russell Grover - SBITS.Biz [SBS-MVP]
MCP, MCPS, MCNPS, SBSC
Microsoft Certified Small Business Specialist
24hr SBS Remote Support - www.SBITS.Biz
Question or Seco...Data Save error
GP Ver 6.0. Recently I am facing an error with normal users unable to save
records, where as the system administrator is able to save the same
information. Please advice on this error, what has to be done.
I have disabled the windows user ID of the Database owner. Thinking of this
made Dynasa as the DBO.
Database is having enough free space available.
How big is the company database? Is it over 10GB?
"Matthews" <Matthews@discussions.microsoft.com> wrote in message
> GP Ver 6.0. Recently I...Managing multiple worksheets 03-24-10
Operating System: Mac OS X 10.5 (Leopard)
I regularly create files with 50+ worksheets with interlinked references - mostly historical and projected financial statements. Is there anyway possible to group files in a folder in the tab bar at the bottom of the sheet for ease of navigation? For example, can I group together all worksheets for 2009, 2010 etc in separate folders that can be expanded or contracted for ease of navigation? <br><br>Thank you
On 3/24/10 12:16 PM, firstname.lastname@example.org wrote:
> Version: 2008 Operating System: M...drawing excel like grids on access reports
I want to draw excel like grids on my access reports. The line should start
from the top of each label in the page footer to the bottom of the
corresponding text box in the page footer.(For each text box in the detail
section, there's one unbound text box in the page footer to display totals).
I don't know how to do this. can anyone please help me?
Can't you use rectangle or line controls in your various sections? These
should work unless your sections are set to Can Grow. If this is the case,
you may need to use the Line method ...Why is Excel trying to access the network
I'm pasting some text into a cell - it did come from a website, but
it's not a link or anything.
It's just plain text - why the need to access the network?
Maybe it's another cell, switch to formula view and see
if you see something else. Because the formula view may
not show everything, you might want to copy to another sheet
so you can adjust columns to see your formulas better without
affecting the column widths on the original.
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
...cell range not changing when refreshing linked data- sumproduct fo
The cell range is not updating correctly to reflect the last row in the data
sheet that is being refreshed. 5878 is the correct number of rows and 5824
is not. I can find and replace in my formulas to correct the problem, but it
does it each time the data is refreshed. Any suggestions as to why?
I gave you the INDIRECT option y'day, but received no feedback from you in
that thread. Looks like you're more interested in knowing why? One simple
hunc...Access 2007 Ribbons
I am currently rebuilding one of my Access 2000 applications in Access
On the Access 2000 application I had 2 Tool bars and a shortcut menu
on most of the forms/reports
1. A "Print" tool bar and a "Print" menu for all Reports
2. A "Form" tool bar and a "Form" menu for all main forms
3. A Shortcut menu with Cut, Copy, Paste that could be used where
On Importing to the new Access 2007 database the shortcut menu is
thankfully still available, although how you would rebuild or add to
it is not clear.
But, the toolbars and menus ar...Data vs. forms & Unload/reload questions
A .mdb file seems to encompass both the database and all the 'code' (forms,
modules, and logic) used to CRUD the data in the tables.
1) Is there any way to separate the database from the code into separate
files, eg. the db is mydata.mdb and the 'code is in a separate file, eg.
2) Say you have v1.0 of an app and the tables and attributes are populated
with data. You then go and build v2.0 of the app, adding tables and columns
to what already existed in v1.0, and perhaps moving some of the v1.0
attributes into different tables. What is the recommended way to
unload/reloa...Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in
It is customer ID name and billing info but it is like a long series of
I want to be able to have them listed under captions like company name,
contact, address, city, etc.. so I can use the data.
There is an empty row between each entry. Each entry is 3 or 4 rows.
There are about 500 records so i dont want to manually set them up.
Try tinkering around with these steps
Assuming your list is in col A,
data in A2 down
(If data starts in A1 down, insert a new row for the co...Access 2007 date function not working
I had a database in Access 2003 that I imported into 2007 and all works well
except the date function in Reports. I have tried to go into reports and
repair by adding a date field, but when I try to open the report and error
box comes up asks for update parameter value for the date. The currrent date
will not display in my reports, just (#name?) is in the date field. You would
think trying to put the current date in a report would be easy.
Use this ---
Build a little - Test a little
"Mark K" wrote:
> I had a database in Access ...Can I access the previous version of a saved file?
I overwrote an excel file by mistake, using the save as command to an
incorrect file. Is there any way to recover the previous file before I
"saved as" over it?
I'm using Excel 10 (XP)......WinXP.......
If I have an existing file and open it, make some changes, then do a SAVE AS
and give it a different name, the newly "saved as" file is a completely
*NEW* file and the original is still in tact with the previous file name.
Try looking for the previous file name.
"JCC" <JCC@discussions.microsoft.com> wrote in message
news:9CAD1748-1D5C...Display comments as data #2
thanks a lot , this worked exactly as required, the comment go
converted to data
Now just one more thing . is the vice versa possible i.e if i have dat
in column A can it be shown as comment in column B.
the reason i need this is bcos i am shifting some data with thei
comments to MS access(Hence the need to convert omments to data)
processing them and again converting them to excel (the need to conver
data back to comments
sonika's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...Outlook 03 Startup error msg
Just recently when I started outlook the following error
DDESERVER WINDOW - Outlook.exe - Entry Point Not Found
"The procedure enrty point GetIUMS not located in
MSDART.DLL (2 times)
DDESERVER WINDOW - Outlook Today - Entry Point Not Found
"The procedure enrty point GetIUMS not located in
MSDART.DLL (4 times)
I've tried detect and repair, but that has not repaired
the problem. MSKB doen't have any solutions. Has anyone
else had this problem and found a solution to correct the
...Count invalid data entries
I am using the following macro to identify invalid data entries in
cells with data validation applied.
' Application.CommandBars("Formula Auditing").Visible = True
MsgBox ("Check for Red Circled Invalid Data Entries on" & Chr(10) &
" Configuration and Parts_TakeOff Sheets")
Is there a way to count the number of invalid data entries (red
circles) and write the number to a particular ce...How many recordset can be opened simultaneously for a MS-Access 2000 Database for adding /editing records
Can someone please suggest how many recordset can be opened
simultaneously for a MS-Access 2000 for adding /editing records.
I also want a comparison with MSDE for the same.
> Hey Friends
> Can someone please suggest how many recordset can be opened
> simultaneously for a MS-Access 2000 for adding /editing records.
> I also want a comparison with MSDE for the same.
Uhm... If I remember correctly that would be max. 20 connections.
Successive CRecordset::Open(...) requests would fail.
I don't know this parameter for MSDE. There's a limit in...forms not listed in database contents, yet can add data to them
Hi - there are no forms listed when I open up the database in design view.
All the tables, queries, and macros are there.
When I open up the database to add data, all the forms are there and can be
used. The data is stored. So, it seems that the forms are still there, but
just cannot be seen in design view.
The database, when I open it up in design view, says Access 2000 file object
even though I am using Access 2003 - could that be the problem?
You cannot open an entire database in Design View. Try opening it normally,
selecting a form, and choosing Design View from the V...Bulk Import Owners CRM 3.0
I added an "Owner" column to my import template and put the GUID for
the record Owner in that column. The Owner field is not exposed in the
mapping window when I import it. I remember testing this and having it
Is this supposed to work, or do I have to work around the fact that it
It does not work, as owner field is not exposed for mapping in Bulk Import.
Thanks and Regards.
---------------------------------------------------------------------------------------------------------------------------------...Accessing Analysis Server 2005 64bit
Are there any troubles to expect when using Excel 2007 32bit against
Cubes that are built on Analysis Server 2005 64bit ?
...? concerning administration of Project Workspace access
In addition to having Project Server auto sync roles when team members
are added (read only access to pws) and/or tasks are assigned (write
access to pws), for the purpose of general public access, is it safe
to add read only access to the site for certain AD domain groups?
Not sure what your definition of "safe" is but, yes, you can add AD domain
groups to the site to give them access.
<email@example.com> wrote in message
> In addition to having Project...Data validation doesn't work if contents is added by pasting
I've data validation set so that only the number 1 can be entered, but
even this cannot be entered if an adjacent cell is a certain value.
this works for direct entry, but not if the value is pasted in or added
using the "drag handle".
Is there any way to stop this happening as I just know somewones going
to try and fill all the cells by draging the values down.
You could disable "Allow cell drag and drop" in Tools | Options or...
copy the following code, right click the sheet tab and choose
'view code'. Paste the code into the modu...