printing error handling issue? (when clicking cancel get 2501 error)
I have a report that when it is closed the
DoCmd RunCommand acCmdPrint occurs ... but of course if the user clicks
cancel, it gives me
a 2501 error.
How & where do I put code to surpress this error. I would just the close
even to run the
DoCmd RunCommand acCmdPrint and if cancel is selected just continue to close
I understand that I have to do this, I actually don't understand HOW to do
it, and where to put code to accomplish this??
1) What code do I use?
2) Where do I put the code?
"Duane Hookom" <duanehookom@NO_...Centralized data
I have a main costing work sheet that needs to be populated by individual
costing sheets that went out to all of the buyers to populate.
Main Costing Sheet
A. Item # B.Desc C. QTY D. Cost E.....F.........G......H (all
contain irrelevant information to costing activity.
There are 5 buyers (Nick, Tanya, Doug, Skip and Forrest) that I have divided
up the main costing sheet and sent them thier individual items to cost, now
that I am getting the individual costs back, I need to populate my "Main
Costing Sheet" with each cost, however, the items are all to...Transfer data from XML to Stream?
I have a COM component that receives XML documents from MSMQ. Before I
process the final documents and pass it to my application, I want to modify
the format a bit, as in create a name/value pair structure from an element
structure or rename certain fields. I'm using XmlTextReader to read over
the original doc and I'm using XmlTextWriter to create a new XML file that I
essentially need to load up again into an XMLDocument object.
I'd rather write the modified XML to a stream local to my running instance
of the COM component rather than create another physical file then ...outlook blocked access to potentially unsafe item, archive .pst
Tried to open archive in outlook 2003 said file was enormous.
"Egro" <Egro@discussions.microsoft.com> wrote in message
> Tried to open archive in outlook 2003 said file was enormous.
As far as I can tell, there is no error message in Outlook 2003 that states a
file "is enormous".
You should zip a PST before sending or rename it to, say, ".psx" or ".ps_"
before you send it. The recipient can undo the steps you took to send it.
Brian Tillman [MVP-Outlook]
...Access Mulit users in form keep stumbling over each other
I've got a front end Access database that has the form and a backend
Accessdatabase that has the data. I would like mulitple users to be able to
enter information into the form but they keep stumbling on each others work
when they are doing so. My database is very simple, the table has 2 columns
one has the account number of customers and the other is where the workers
will fill in Yes or No. The users open the form copy the account number,
enter it into a program, and review it. If they account is positive for what
they are looking for, they mark yes or no and go onto the next record....Outlook blocked access to the following potentially unsafe attachment blah.url
How do I lower security settings in order to receive all attachments??
What version of Outlook?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer:
Googy <email@example.com> asked:
| How do I lower security settings in order to receive all attachments??
Me to. I have Outlook XP and getting quit tired of not being able to get need attachments. I hope somebody has the answer.
OL 2000 SP-3 Corproate/Workgroup with security update
"Milly Staples [MVP - Outlook...Toggle Data Label "Value" On and Off
Is there any way to toggle the "Value" label for a chart on and off
using a button linked to some VBA code. I'd like to be able to have
the label formatted (i.e. color, size, etc) so that the user just has
to click a button for the values to show on the bars of the chart.
Thanks for any help you can give!
Found my own answer through recording macros. Here is the code I used,
applying it to a toggle button.
Private Sub ToggleButton1_Click()
Application.ScreenUpdating = False
If ToggleButton1.VALUE = True Then
ActiveSheet.ChartObjects("Chart 1").Ac...Exchange 2000 data store size does not shrink
We have an exchage 2k store that is ~16GB. We have archived ~ 5GB (PST
files)and did an offline defrag but the db has shrunk by less than 2%.
Currently it will not mount even with the evn when we set the temp size
increase registry switch. Any ideas?
KCHobson <KCHobson@discussions.microsoft.com> typed:
> We have an exchage 2k store that is ~16GB. We have archived ~ 5GB
> (PST files)and did an offline defrag but the db has shrunk by less
> than 2%. Currently it will not mount even with the ...Copy a word doc to excel and hyperlink data between the 2.
I have a chart on an excel document and a long word document explaining the
data in the chart. I would like to place the word document under the chart in
excel. Then I would like to hyperlink the data from the chart to specific
places in the word document. Help.....I have been trying to figure it out for
days. Thank you.
...Attaching an email or a scanned document to an Access Report
In my original database (now two years old), I added a paragraph of text in a
memo field in a record.
Now, after a group reorganization, I will be getting additional e-mailed
information and/or hard copy that has to become part of that record. I am
planning to scan the hard-copy to create an attachable document and/or open
the email and somehow include the attachment to the Access record. Does
anyone have any suggestions or examples? Would hyperlinking be the way to go?
Sorry, I meant to mention I'm using Access 2003 and the documents are usually
2-3 pages long.
"Help Elimin...Query to Access : does'nt see tables
Office 2000 SP3 FR
From Excel / MS Query, I want to read data in Access tables.
I choose the mdb file and so MS Query displays this error message
"This data source does'nt have any visible table".
Original in French : "Cette source de donn�es ne contient aucune table
I transfert my data to a new mdb file : it work's few times (!), then the
error message appears again.
How to resolve this problem ?
MS Query does'nt accept a file name with 2 dot inside !
MyFile.mdb --> Ok
My.File.mdb --> "...Need to extract data mid-string.
Here's what I have: \\lavaur4\PHIWEBEurope\SWAN_Swissco\Default.htm: 754And here's what I'm trying to get back: Swissco\Default.htmThe number of characters from the left will always be the same, 28. And thestring will always be trimmed after the ":" (colon). I'm struggling with how to use mid, left, right to get out what I need. Thanks in advance!Kellie-- Message posted via http://www.accessmonster.com On Mon, 26 Mar 2007 21:19:27 GMT, KFox via AccessMonster.com wrote:> Here's what I have: \\lavaur4\PHIWEBEurope\SWAN_Swissco\Default.htm: 754> And here&...RMS needs to add an Import Utility to the program
I think I speak for alot of people here. RMS should add an import Utility to
the program. Every body needs to import some type of file from time to time.
You pay enoght money for this and they know from the start that you will be
importing data from your old POS system.
Or like in my case, every year I have new items or a new supplier. and for
me to get an Add in that may or maynot work is not good enoght.
I agree totally but, for me, the main attraction of RMS over similar
solutions was the open SQL Server database and the ability to customise. You
can downlo...Re: Data Summary
Can we do the summary by defining a macro?
The difficulty with the suggested solution :
1.I am not able to advance filter the unique data to a separate
2.Every day the data gets changed, so have to repeat the exercise
daily and is very time consuming.
Subject: Re: Data Summary
From: "Ardus Petus" <firstname.lastname@example.org>
In summary sheet, you can get the totals with a formula like:
See example: http://cjoint.com/?fmkJhzVi8q
To automate the production of ...Add more than one series to a pivot chart using VB MS Access continued...
I'm trying to programmatically create a stacked bar pivot chart.
Using "Programming Microsoft Office Access 2003" by Rick Dobson, I've
created the chart. However, it doesn't distinguish between the
different values for the series. Does anyone have any suggestions on
how to create a chart using one column containing three values for the
Essentially, this is a continuation of a previous post:
Any help is greatly appre...Import into Access from Excel, passing a variable as the field...
I have an Excel spreadsheet with a header that contains the exact same
30 names as the corresponding 30 fields in an Access DB table, and Row
2 below the Header contains the data I want to import. Instead, of
physically typing all 30 fields in the code, I have a macro that loops
through each "field" name that it got from the spreadsheet header.
When I run this macro I get "run-time error '3265' Item not found in
this collection', however, when I specify the actual field Name
manually it works. This what I have:
Dim iColumn As Integer
Dim FieldName As ...Randowm data corruption Money 2002
I use Money 2002 Deluxe & Business to manage 6 business
bank accounts and 2 petty cash accounts. All of a sudden,
Money has started to randomly change some of the entries
in the petty cash accounts. It changes them in increments
of $50, $100, $150 or $200. For example, one entry that
was originally $200 on Jan 1, now reads $400. One on
2/2/04 for $70.40 now reads $170.40. Conversely, on 4/17,
the amount was $800 and it is $600!
There are some 20 such changes that I have detected so
far. I am the only one using this program. I can't see
any pattern to the changes (payee, ...Outlook Web Access
Outlook Web Access has been rolled out to my
organization. It's particularly useful in areas where
PCs are shared among numerous people and are logged onto
the network with generic IDs.
The problem I'm experiencing is that when an account is
ready for a password change, there is no notification to
the user before logging into Outlook Web Access. This is
a problem because after three checks of their email, they
can no longer get into their email.
Now I'm not an Exchange server person, but I need to get
some ideas to present to the Networking Staff. Does
anyo...Pulling Data from one worksheet into another
I have a question regarding pulling text from one worksheet into another.
Please can you help me?
I need to duplicate the information (text only) on one worksheet to another
one as it is typed. Is there a formula I can use that will allow the data
typed in one worksheet to appear in the other one immediatley?
I have a formula that the person before was using but I don't know how to
apply it to the whole sheet. Any advice would be greatly appreciated.
The formula is =IF(ISBLANK(OFFSET(OFFSET('Design
Schedule'!$B$8,$A15,$B15),0,H$7)),"",OFFSET(OFFSET(&...Try these important update
Content-Type: multipart/related; boundary="ovpxzxjley";
Content-Type: multipart/alternative; boundary="prvgddqc"
this is the latest version of security update, the
"October 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to protect your c...Excel 97 on Windows XP data sort error
I have had sorting errors using Excel 97 running on
Windows XP. Is there a fix for this? I check Excel
updates and the microsoft website says I already have all
Please tell what sort of errors.
"Steve P" <email@example.com> wrote in message
> I have had sorting errors using Excel 97 running on
> Windows XP. Is there a fix for this? I check Excel
> updates and the microsoft website says I already have all
Sort errors are almost always data problems. You might have numeri...Probably a hardware issue, but...
....it only seems to happen while using Outlook 2003.
Basically it has to do with mouse/pointer losing the focus. For example,
While a mail message is selected in any mail folder, the selected message is
"blue". But without warning or any action on my part, the focus will "go
away" and the seleceted object becomes "grey". I must them go back and click
on that object to make it active again.
This also seems to happen when I am in a dialog box of some sort. Even right
in the middle of typing, the focus on the dialog box gets lost and I cannot
continue typing ...Is Access the right program for our needs?
My company is in need of a data storage program that can merge information
into Microsoft Word documents. We need a few different libraries with contact
information for clients, companies, and third party contacts.
Next we either create a Word document or scan and convert a PDF to Word in
order to insert the Client's and/or Company's information in the designated
We are hoping that we can import the Client's and/or Company's information
from a database(Access), and that we can set up the word doc (or template) so
that a different Company and Client can b...Access is Denied in CRM 3.0 after upgrading from 1.2
After an upgrade of Microsoft CRM 1.2 to 3.0 without any errors, I can
not log into the Microsoft CRM web page. I get the following error
"you do not have enough privileges to access the microsoft crm object
or perform the requested operation"
I have searched everywhere for a solution for this but i am now at a
During the install i recieved two warnings
1. verify domain user account spn for the microsoft crm asp .net
application pool account
2. setup was unable to verify that the "trust for delegation" property
is enabled for the computer object.
If I create a new...Collect data for a SQL Server DB via Infopath
Can anyone direct me toward information that discusses using InfoPath forms
as a means to capture data for a SQLServer database?
**please reply to the newsgroup so others may benefit**
"David C. Holley" <David.C.Holley> wrote in message
> Can anyone direct me toward information that discusses using InfoPath
> as a means to capture data for a SQLServer database?