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...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...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=...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...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...Cannot access outlook.pst error
I run Win 98 and Outlook 2002 on my computer. All the
sudden all the mail sent for the last 7 days starts
showing up again in my INBOX. After that I cannot delete
or move anything without the error message "The file
data\microsoft\outlook\outlook.pst could not be accessed.
Access is denied" How can I fix this problem?
...How to get Preview Pane in separate Data File in Outlook 2002
For back-up and portability purposes, we use separate Outlook Data Files.
(File, New, Outlook Data File, ....) Then we use the Organizer Wizard
to move files from the Inbox to the appropriate data file. All of this
The only thing we can't figure out is how to turn on the preview pane on one
of these files. It works fine on the standard InBox or any Personal Folder
that is in the main *.PST file.
We use the described method (View, Current View, Other Settings, check by
Preview Pane) and we don't get any error message. However, we also do NOT
get ...Can NOT access Web-Site, ..... What's wrong with????
From yesterday, I'm NOT able to access the following web-site, as seeing
'X'/Warning in the middle of the screen.
Your help would be greatly appreciated. Thanks,
begin 666 clip_image002.jpg
M_]C_X `02D9)1@`!`0$`8 !@``#__@`<4V]F='=A<F4Z($UI8W)O<V]F="!/
M.SL[.SL[.SO_P `1" &P`C\#`2(``A$!`Q$!_\0`' `!``(#`0$!```````...Problem transfering database from Access 2000 to Access 2003
I am having problems with a database which has been running for
number of years. It was set up in Access 2000 and windows 98se. I hav
now transferred the database to a new machine, running Office 2003 an
Win. XP. The Mail Merge automation now does not work and gives me
Run time error�432� File Name or Class not found during automatio
operation. When I use the debug it points to the following line in th
Set objWord = GetObject("C:\Church Documents\") & strDocName
On further investigation objWord =0 And & strDocName= mail.doc, whic
is the name of the word do...VBA in Access
Can anyone recommend good books or websites illustrating the basics of VBA
programming in Access 2003.
I am talking about simple (??) things like : when a Yes/No box is checked
then hide a textbox on a form, print duplicate copies from a command button,