Problem with error 53
I've got a small loop that looks for data in 1 of 4 places. If it doesn't
find a valid path it should create an error 53 which should then be
In most cases, the path to the desired file will be invalid and Error 53
The code is this:
PictureNum = 0
PictureNum = PictureNum + 1
If PictureNum = 5 Then Exit Sub
On Error GoTo Error53Check
If PictureNum = 1 Then FilePath = ("N:\Casefiles\" & [CASENO] & "\" &
[CASENO] & "-dp0.jpg")
If PictureNum = 2 Then FilePath = ("N:\Casefiles\"...sorting columns with more than 2 text entries
Data>Text to Columns>Next works well if all entries have a "single" first and
last name, eg, "Joe Smith". However, if there is a "Mary Joe Smith" listed,
how do I put only the last text entry into a new column? I am downloading
payment information from a PayPal account and want to sort by last name for
our lunches. Unfortunatley the "name" information (first, last, etc...) is
contained in a single cell.
Use this formula to extract the 1st name in cell A1: =LEFT(A1,FIND(" ",A1,1))
Use this formula to extract the l...Smtp problem #2
I have a window small business 2003 server and whenever i start the smtp
service , it send a lot of email to the same person.
All the machine are spyware free, no virus.
The relay of the smtp service on the server is set only for internal
What can it be help
I'd be asking at this point if you are sure that you are a) relay-secure -
do you really need to list *any* IP addresses in the allowed to relay list?
I suspect no. and b) how are you sure that you are virus free? You may
consider doing a network sniff to see if there are any internal clients
atte...#Name? error in Formula
As I mentioned in the subject line, I am currently getting a @Name? error in
The formula I have is
I noticed that the field should be [Date of Birth] but when I try to edit
the formula, the formula change does not stick.
How do I get the formula to stick?
Thank you for your help in advance.
What is the name of the text box in question? Is it DateofBirth? If so, try
changing it to txtDateOfBirth. Then see if Access wi...data type mis match error
I am getting a Compile error: Type-declaration character does not match
declared data type
Private Sub optMH1_Click()
Sub SelectMHform(a As Integer)
.optMH& a&.value = 1
.txtPicture.value = "MH" + Str(a)
.cmbBoxMaterial.value = ""
.txtBoxLength.value = ""
I tried some other things too but I am still getting an error due to .optMH&
a&.value = 1 How do I use a variable in this situation?
"dannie" <email@example.com.....NET and XSLT id() #2
I must be an idiot because I STILL cannot coax .NET to
successfully execute a transform which uses the XSLT id()
function. Here's the bare-bones code:
XmlValidatingReader xvr = new XmlValidatingReader(
new XmlTextReader( @"s:\data\test.xml",
new NameTable() ) );
xvr.EntityHandling = EntityHandling.ExpandEntities;
xvr.ValidationType = ValidationType.Schema;
new ValidationEventHandler( this.veh );
// this.veh() simply echos any validation errors.
XslTransform xsl = new XslTransform();
xsl.Load( @"s:\data\test.xsl" );
XPathDocumen...Mail Merge 2 up
Is it possible in Publisher to do a mail merge on a page the is setup for
printing 2 up?
Specifically, 8.5x11 is split in half (8.5x5.5) using grid guides, and i
want to merge a different address block on each part. I seem only to be able
to get the same address block in each text box per page.
You have to setup your page for 8.5 x 5.5.
In page setup, click custom, type 8.5 width, 5.5 height. Publisher will say it
will print two per sheet. Your merge should work correctly with this setup.
Print preview will show both the same, this is a bug in the program. Print a
sample if ...RMS Version 1.2 DB question
How big can this database get ?
1) As big as your Hard drive is.
2) 2 gig
The limitation is imposed by the version of MS SQL server that you're
running,not by the RMS version.
MSDE (The version that shipped on the CDs through 1.3) is limited to 2GB
MS SQL Server 2005 Express Edition (Ships with RMS 2.0 and is compatible
with 1.3R1) allows up to 4GB Database
The 'full' versions of SQL Server 2000 and 2005 are limited only by
The most likely case based on version 1.2 is that you are limited to 2GB
because MSDE is part of the default in...Data Validation
How can you get an audio sound when the error alert message displays in Excel
By default, Excel will make a sound when the error alert is shown. Turn
up/on your volume :)
"Help" <firstname.lastname@example.org> wrote in message
> How can you get an audio sound when the error alert message displays in
...How do I set up a cell which should be suggested as file name to s
How do I set up a cell whitch should be suggested as the file name to save
when "SAVE AS" is clicked?
For example on a worksheet
B2 is a date,(AUG-1-05)
A1="SCHEDULE FOR "&YEAR(B2)&MONTH(B2)&DAY(B2)
A1 will be "SCHEDULE FOR 200581"
On the window that opens after clicking on "SAVE AS", how I can do, to bring
"SCHEDULE FOR 200581" to the box of the suggested file name to save.
You need code
Activeworkbook.SaveAs FileName = Range("A1").Value
(remove nothere from the email address if mailing direct)
...On Error of an On Error
How do I write an On Error of an On Error? For example, if an error
occurs when trying to open a linked table, I would like to open up the
linked table manager for the user to link the tables properly.
However, if that is not installed, I would like to give the user a
error message that I will write. At the moment, my code which errs
out is as follows:
Private Sub Form_Current()
' Checks to see if all table is there
On Error GoTo TableMgr
If (DCount("*", "qReport") > 0) Then
MsgBox "This should not be 0.", vbOKOnly,...Exhange2003 errors
the MESbpat reports i have the following errors, on a SBS2003 server;
1.Domain Naming FSMO role failed to respond.
2. Schema FSMO role failed to respond.
AD Server named:
1. DNS name resolution failure.
1. Infastructure FSMO server role failed to respond.
2. PDC emulator FSMO role failed to respond.
3. RID FSMO server role failed to respond.
what and how do i go about fixing this?
Fix your domain controller and DNS server.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"BrianMultiLanguage" <Bria...IF help #2
Hello, I am trying to do some IF statements within a larger macro.
What I want to do is delete certain sections of a worksheet dependin
on whether they have quantities in them or not. I got an IF statemen
to work, but it carried what it needed to do if it was true whether i
was true or false. Right now I have it set up to just change th
background color until I know for sure it works because it helps m
keep track of what is working & not working while I am building th
macros. Below is an example of the IF statments that I can't get t
work the way I want. This is my first attempt ....dll errors
Does anyone know how to resolve the following errors:
The Add-inn "omowui32.dll" could not be installed or
loaded. This problem may be resolved by using Detect and
REpair on the Help menu. You may be out of memory, out
of system resources or missing a .dll file.
The procedure entry point?Copy@OMStringArray@@QAEXABV1@@Z
could not be located in the Dynamic link library
Tools-Options-Other-Advanced-COM Add-ins or Addin Manager - uncheck the item
that refers to this uninstalled program.
If that does not work, close Outlook, find and delete extend.dat. Reopen
...strange div by zero error
ok here goes. when running this querry on data that is formated as
double, and includes positive and negative numbers with 3-4 decimal
places i get a divide by zero error. can anyone recreate this or have
any suggestions on how to work around it?
SELECT Sum(IIf([ext_ppv]<0,[ext_ppv],"0")) AS goodppv
I don't know whether this is related to your problem, but there shouldn't be
quotes around the 0 in the IIf statement: you want a number, not text.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"nj...probably 2 basic for here
I am trying to copy data from an email to an excel spread sheet using vb. I
have not been successful either way so I tried to copy from the clipboart to
excel spread sheet just to get ideas and use the macro. When I create the
macro (using the record macro function), the data gets copied and then I use
the text wizard to format the data (it is seperated by spaces). This works
well. When I got to just run the macro, it stops and the data is still in
the raw format. How do I populate the row/cells like it did in the text
wizard? Any help (or code) would be appreciated. Thanks
1. Ca...Plugged in USB 2.0 HD Not recoginized in Windows XP
I have a USB 2.0 HD enclosure with a 100 GB HD. I can plug the HD into a
Windows 7 machine and the HD is displayed properly in windows explorer.
However in windows XP the device is recognized and listed by the hardware
manager, but windows XP can not see the HD. What should I check in WinXP SP3
to see why the USB HD is not being mounted in windows? BTW, the HD is
formatted in NTFS format.
Best Regards, Keith
Tired of Google Groups?
On 02/09/10 3:57 AM, Keith wrote:
> I ...timeout error with activeX component
I'm using an ActiveX interface to a 3rd party application from within my
MFC application. 90% of the functions available from the 3rd party app work
great, but the other ones, typically those which display a dialog asking for
input, cause a "server busy - This action cannot be completed because the
application is busy" error to be displayed after 10s or so if the user
respond to them quickly enough.
I have searched MSDN, but all the references I can find relate to VB. In a
VB application there is a parameter OLERequestPendingTimeout which y...Error help
When I try and create a form through the wizard I get to the page where I
choose the layout of the form. When I hit next I get the error that says,
"Application-defined or object-defined error" What does this mean? How do I
...Data-Filter and "Number of records" message
Can someone tell me why when using Data-Filter-Autofilter I only sometimes
get the message in the Status Bar showing that I have filtered 15 out of 25
records. I am using Excel 2000 and other colleagues also report similar
erratic behaviour (in relation to Excel, that is)
When your list has many formulas, the Status Bar may show "Filter Mode"
instead of a count of the visible records. You can use the Subtotal
function to count the visible rows.
The following MSKB article has some information:
XL2000: Excel AutoFilter Status Bar Message Shows "Filter Mode&...spell check #2
I have spell check as an option but it is greyed out and
I can not use it.
>I have spell check as an option but it is greyed out and
>I can not use it.
This newsgroup is for support of Outlook 97, 98, 2000 & 2002 from the Office
family for Windows PCs. For Outlook Express (OE) support try posting in one
microsoft.public.inetexplorer.ie4.outlookexpress for OE 4.x
microsoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.x
http://support.microsoft.com/newsgroups/default.aspx?ICP=GSS3&NewsGroup=microsoft.pub...2 CListCtrl with one hor. scrollbar
I've two listctrl with same coloumns & same col-width.
i need a function to scroll list2 with list1 scrollbar.
On Sun, 10 Sep 2006 15:51:24 +0200, Johann Obermayr
>I've two listctrl with same coloumns & same col-width.
>i need a function to scroll list2 with list1 scrollbar.
Handle WM_HSCROLL and WM_VSCROLL as necessary and forward the messages to
the 2nd list control. To keep the controls in sync, you will also have to
watch keyboard navigation; for example, paging down doe...check those received message without showing the email receipients
how we can check those received message (or similar messages without showing
the email recipients) is addressing to which of our email addresses from
client (receiver) side. This kind of emails is getting more and more. Right
clicking the message(s) and then selecting the "message options" to view is
still not successful.
"RachelYung" <RachelYung@discussions.microsoft.com> wrote in message
> how we can check those received message (or similar messages without showin...PB Errors
This is the error mess am getting while i trying to build my win ce.
BUILD: [01:0000000156:INFO ] makefile.def: Including C:\WINCE600\public\
BUILD: [01:0000000157:INFO ] makefile.def: BUILDROOT is C:\WINCE600\PLATFORM\
BUILD: [01:0000000158:INFO ] makefile.def: Including C:\WINCE600\PLATFORM\
BUILD: [01:0000000159:ERRORE] C:\WINCE600\public\common\oak\misc\makefile.def
(156) : U1023: syntax error in expression
BUILD: [01:0000000160:INFO ] Stop.
BUILD: [01:0000000161:ERRORE] NMAKE.EXE WinceTargetFile0 -i -c BU...How do I set up Server Rule to move Emails to a an Exchange 2007 public Folder?
Dear Exchange people,
We are using Exchange 2007 and Outlook 2003 and Outlook 2007. I have
emails that come in every day that need to be moved to an Exchange
public folder based on words in the emails subject. I set up a rule
in Outlook 2003 to move it to the public folder automatically and it
usually works when Outlook is open, but I need it to just run on the
server and not require Outlook to be open to run it. Would anyone be
so kind and friendly as to share with me an example of how to get it
to work on the server and not require the Outlook client to process