Reports not opening
The reports created in a MS Access database are not opening. Also the icon to
open a new report in design view is not working either. I think it something
related to the settings, but I can quite figure it out.
I tried to put the security level in Low but it did not work.Any help is
This is almost always due to either not having a default printer defined in
the Windows Control Panel or an old printer driver.
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
...No Data on Form Open
I have the following code on a cmdButton
Dim strwhere As String
strwhere = "[tbl_Reports].[FltPhase] = '" & Me![cboPhase] & "'"
DoCmd.OpenForm "frm_MainView", acNormal, , strwhere
DoCmd.Close acForm, "frm_SearchPhase"
I would like to display a message "No data qualifies" and not open the form.
Not sure what the If statement should read.
Teach me to fish! Thanks for the help.
you can check recordset count on form's open event, and cancel it:
if Me.Recordset.RecordCount =0 then
Canc...Can't find file from Windows 7 on XP
I saved a word document on my flash drive from Windows 7. I do not have a
working printer so I am at the library trying to print it out but I cannot
find the file. Is this because I am on a diffferent OS? I am on XP now. I
should be able to pull up any file I was told regardless of the OS.
Assuming that the computers at the library have a version of Word that can
read the file, you should be able to print it.
Microsoft Word MVP
"mosakitty" <firstname.lastname@example.org> wrote in message
news:7C155E4F-BE70-4A59-9090-2213C0A02DC7...Can macro/userform run depending on HOW workbook is opened?
I'd like to show a userform (and/or run a macro) when I open my
Template Wizard database workbook...but NOT have it run when Excel
opens it in the background to copy new records or update existing
ones...any way to do this?
If you put your code to show the form in Auto_open() (in a general module), then
that'll run when the workbook is opened manually.
If you open the workbook via code, it won't run (unless you run it explicitly,
see RunAutoMacros in VBA's help for more info).
Alternatively, you could put your code behind ThisWorkbook (workbook_open).
This code will run...in Outlook2007 inbox and calander opens simultaneously
When i open Outlook 2007 Client first it opens inbox and also seperate
window for calander simultaneously.
One more issue is that subject line comes in message box
nits <email@example.com> wrote:
> When i open Outlook 2007 Client first it opens inbox and also seperate
> window for calander simultaneously.
Close the Calendar window first and then when you close the Inbox window,
use File>Exit. Outlook should remember you had only one window open when
you close and reopen only that window.
> One more issue is that subject line comes in mes...Rule saving attachments to fileserver
Anyone know how to create a rule automatically saving
attachments for incomming messages to a special folder on
Depending on i.e sender or subject the rule will save the
attached file to a special folder on the fileserver. Not
The rule has to be stored on the Exchangeserver and work
even when Outlook and the client workstation are closed
down. Anyone know how to do?
Thanks in advance.
I want to do something related to this: I wish to globally
remove all attachments from all emails in all Outlook
How is it done?
Thanks a ...Problem with Huge PST File
When I went to start up Outlook 2003, I got a message that my PST file was
not closed properly last time. Outlook went through it's process. Now, my
PST file is 823MB, even though when I do a folder size on it within outlook,
it says the PST file shou be about 10MB.
Does anyone have some suggestions?
Are you checking the .pst file size from the root of your personal folders?
If you search your hard drive for the .pst file, what does Windows report as
the file size?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Sw...Excel not opening
When I double click Excell icon from the desktop, it opens excell without
the default new sheet. when I double click any excell file from explorer,
then excell and the file opens normally.
Why excell is behaving like this? Pls help.
Look at the icon properties and remove the switches such as "/e" or
"/embedded" after "Excel.exe".
> When I double click Excell icon from the desktop, it opens excell without
> the default new sheet. when I double click any excell file from explorer,
> then exce...Opening a query with a filter in Access 2007
Since under Access 2007 reports can no longer be exported to Excel, I'm
attempting to open the query that the report is based on so that I can
export the query to Excel. I'm wondering, though, about the best way to open
the query since I need to apply a filter. It was easy enough to do in the
OpenReport call by using the WhereCondition parameter, but OpenQuery has no
such parameter. What is the best way to filter a query through code?
A fairly simple workaround is to save the query you want to use for
exporting. Then write its SQL property before you do t...Failure to open data files in Access 2000 on a XP machine
I had a Win98 machine on which I successfully opened and ran several datbase
files in Access 2000.
I now have a Win XP machine and after loading Office 2000 Premium on it I
cannot open imported/exported data files from my old PC.
It is driving my nuts. I feel I have tried everything but am probably
missing something easy.
When I try to repair the programme it is coming up with an error message for
4 .dll files (msolap, msmdcube, msmdgdrv and msolapui), it says failed to
...Excel wont let me take an old workbook & save as to make a new 1
For some reason excel will not let me do a save as on an old workbook to make
a copy it just stops responding?....Rik
Did you just update windows?
"Rik" <Rik@discussions.microsoft.com> wrote in message
> For some reason excel will not let me do a save as on an old workbook to
> a copy it just stops responding?....Rik
...money 2005 crashes every time I try to open an account
This happens with only one account I have. Its a checking account
with online banking at keybank. Other online features work fine.
Whenever I try to open the account I get an error message the money
must be restarted. I have tried using the salvage utility and it does
not find anything wrong. I have also tried reinstalling money. I
still get the same error.
My guess is that there is something wrong with the "data" in that
Has anyone else had a similar problem? Any ideas of what to try so
that I can fix this. Its somewhat urgent in that I can't send any of
my onli...Other Program Windows Keep Opening
I don't know how to remedy this problem.
One of the computers in our office tends to open other program windows
at random. Do you know what might cause this to happen.
It seems to have an eradic cursor.
Thanks for any suggestions you can make.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Tools Option General Delete anythign in the box labeled Alternative startup
"Fran" <Fran.firstname.lastname@example.org> wrote in message
news:Fra...XML cannot be opened, try again, opens?
Greetings all, my first post to microsoft.public.excel.
I have created about 30 xml spreadsheets. To create the sheets I
saved a workbook as XML. I removed the "ss:ExpandedRowCount=".
Choppped the XML file into a header & footer & my application supplies
from <row> to </row> in the middle.
Most of the files load okay but about 1 in ten comes up with a 'Cannot
open XML' message from Office Assistant.
The thing is, I go back to File Explorer, press enter to load the same
file & it loads just fine into Excel.
Im running Excel 2003 (18.104.22.16868) SP2 o...Which function find numbers not same.
A range has a lot of numbers, I want to know how much not same numbers is
Without VBA code.
because VBA very slow.
Cactus [������] wrote:
> A range has a lot of numbers, I want to know how much not same
> numbers is occur.
> Without VBA code.
> because VBA very slow.
That function so nice.
But what's it meaning?
COUNTIF(A1:A100,A1:A100) always zero.
And how use "+ - * /" for array?
Thank...Replication with Double-Take for SQL Dynamics DB's & Dynamics file
I am using Dynamics 7.5 and am looking to create a fail-over secondary SQL
Server and replicate all of the Dynamics databases and files to this backup
server using the software Double-Take. If anyone has any experience with the
Double-Take software and Dynamics, please give me your comments and/or any
problems that I should look out for.
Thank you in advance for your comments.
DoubleTake is fine for system level failover, but it does no
application level monitoring. You should look into LifeKeeper from
SteelEye Technology for this.
...How to save a PC Excel file into MAC (it says file is read only)?
I am having troubles with an Excel workbook I created on my PC (using Excel
2000). Essentially I can't save it in a Machintosh computer.
Thanks for your help
...Opening Publisher #4
I work for a company that has got a load of lisenced office disks
One of them is publisher, I have installed this before and never had any problems
I recently had to format my PC, and when I tried to install publisher ( which worked fine ), then run it ( this is where I had the problem ), it is asking for a product key. I have never had to put a product key in before so why is it asking now
It is only asking for the product key when you run the program. Not when you install it
The company hasn't got a product key for this disk, but we have got one for office XP. (Publisher i...I get a file in use message telling me that the file is locked ?
This is a one user computer and the file is not being used. The box
containing the error message says "FILE IN USE". If I reboot I can get into
the file once only before having the same error message. I have tried saving
the file under a different file name but that file acts the same. I have
checked permisions and that is not the problem either .....HELP!
...Outlook 2000 won't open #2
I have MS Outlook 2000. When I click to launch it simply
hangs up and I have to end using task manager. This is the
first time I have had this occur to me but it is happening
every start now.
I have run new virus defs and windows update.
Also, where does outlook store mail on the HDD?
Same thing happened to me. I had to re-install windows
and then Outlook.
As far as your messages, search for the .PST file.
>I have MS Outlook 2000. When I click to launch it simply
>hangs up and I have...Hyperlink to open new window?
I've created a simple Excel file that I use as a project menu.
Each cell in the first column contains the name of a project and a
hyperlink to the file containing that project.
This works great for opening non-Excel project files. But when I
click on a cell hyperlinked to an Excel project file, Excel closes my
"Project Menu" file and opens the new project file in the same window
where the project menu had been displayed. This is a bummer because
most of my project files are Excel files.
Then, the next time I need to access my project menu, I have to first
manually reopen the...Opening POS aslo opens Internet explorer in the background
has anyone encountered this problem? Every time I open POS, Internet
explorer opens up in the background with MSN page. I cannot minimize or quit
the application. I do not see the application listed in the task bar when I
press Ctrl+Alt+Del buttons. Can anyone out there suggest a fix
Hit the "ESC" key
Microsoft Certified Partner
"JD" <JD@discussions.microsoft.com> wrote in message
> has anyone encountered...WMP 12 Problem
I am operating on Windows 7. I have WMP 12.0.7600.16415. Everytime I play a
video and close out the program I cannot re-open WMP again without rebooting
the computer. Any ideas on how to correct this problem?
What's the file type of these videos (AVI, WMV...)? If it's a file type
that WMP doesn't support by default, which codec did you install to play
it? Did you install any codec packs?
WMP probably keeps running in the background after closing. When you
restart WMP again, it immediately exits because it thinks that it's
still running. To force WMP to close...Saving publisher newsletter to outlook's draft folder
Can the newsletter created in Publisher be directed to the drafts folder of
outlook before releasing to email?
using Publisher 2007 - forgot to mention that.
> Can the newsletter created in Publisher be directed to the drafts folder of
> outlook before releasing to email?
I can drag a publication to the draft folder. I can send it from there to
recipients, it will remain a Publisher file and will arrive to an email
recipient as a Publisher file. The file will remain in the drafts folder until
There is no way I have found to send a Publish...2003 docs opened in 2007
every time I open a powerpoint document that was saved as a 2003 version in
2007, the fonts are always messed up -- To the point that the document is
almost unreadable. be above the actual cursor and are difficult (at best) to
edit and correct... my office is still half on 2003 half on 2007 so this is
creating some issues...
is this something that is happening for others or am I doing something
wrong? (or both :) ) is there a quick fix?
nevermind... found advice on print driver and changed default to my other
fixed it immediately.