Does anybody have a suggestion on the following issue? My customer
They printed a batch of checks. The checks jammed. We allowed
Duplicate Checks on that checkbook and reprinted the checks on the good
We processed SafePay like normal. Now the bank is generating an
exception report because we send duplicate check numbers to them, one
with a void and one without.
Any suggestions on how this should be handled? Maybe I should just
push harder for them to print on blank check stock with Mekorma. ;-)
Microsoft SBF Specialist
www.landiscomp...Date format issue when submitting from a userform to a spreadsheet
I have a userform that I've generated which routes dates onto a spreadsheet
based on the users input. I am having a bit of a frustrating time with the
dates, it would appear that in the process of moving the date from the
userform to the spreadsheet some dates are switched/transposed. I'll give an
example. If someone enters 09/02/2004 on the userform excel seems to look at
09 and assume it is a month and transposes the dates to 02/09/2004(this does
not appear to be a US/UK format issues as I have already gone down that
road). However, if the date 13/09/2004 is entered i...Recipient policy not working for OU
Exch2003 sp2, win2003 sp1
I want users created in one particular OU to get a different primary SMTP
address. I've created the Recipient Policy with a filter for the OU and
Apply this Policy now, but users created in that OU still get the Default
Policy SMTP addressing.
Doesn't seem like it could be any easier. I ran Update Now on the RUS. Not
sure what else to even check. Why isn't it working? Any suggestions?
A recipient policy filter based on the OU won't work. Try using populating
the company or department attribute with a value and then using that.
On my dialog I have a CEdit control. When I type some text in the CEdit
control and then press <ENTER> the dialog closes. I don't want the dialog to
close. Can anybody help me?
You need to override the PreTranslateMessage(..) Virtual
function into your dialog using the class wizard.
Your can implement this function as shown below, this
should solve the problem. You'll just have to change
IDC_YOUREDIT with the name of your CEdit object and
CYourDialog with your dialog box class name.
BOOL CYourDialog::PreTranslateMessage(MSG* pMsg)
...SUMIF function not calculating from closed worksheet
We recently upgraded from Microsoft Office 2000 to 2007. Prior to the upgrade
each department would access a spreadsheet that would load data from a
common lookup spreadsheet
The loading process was performed as follows:
The lookup file and each department file would be opened to update the link
for that month and then saved and closed. When the department head would
open the department file, a question would appear asking if they wanted to
update the link, if they answered no the spreadsheet would open and display
the calculated data. If they answered yes, the file would o...Contract Administration/SOP Issue
When the inovoice is transferred to SOP I am not getting the item description
to populate correctly. Item number populates the Item description field. It
needs to pull the item description from the contract line.
I can work around this temporarily by modifying the invoice to print the
item description from the item maintenance card.
Any suggestions to have the SOP window display properly
This is how it's supposed to work. If you would enter in the item in sop as
the normal item from contract maintenance, you would be selling one of these
items from your inventory ...Clip art works on first try from web then doens't.
Alright I am back. I got something to come up for the web collections
clip art now but it seems to only work the first time I do a search
right after I open the program, after that I either get a bunch of
picture symbols with the little globe in the corner or I get nothing.
This clip art thing is really driving me crazy. Anybody know what is
ridergroov <firstname.lastname@example.org> was very recently heard to utter:
> Alright I am back. I got something to come up for the web collections
> clip art now but it seems to only work the first time I do a search
> right after I ope...Is SQL 2000 tran working with VS2008?
I code a store procedure mySP in SQL 2000 in which using transaction.
I used two ways to test after saving sp.
1) rename one table
2) rename column name
If I use "exec mySP" in SQL 2000 query window, error will catch but ASP.NET
try-catch will catch nothing, it always return no error.
Is SQL 2000 tran working with VS2008?
Message posted via DotNetMonster.com
On Feb 5, 10:15=A0pm, "aspfun via DotNetMonster.com" <u53138@uwe> wrote:
> I code a store procedure mySP in SQL 2000...toggling between open work books
Re EXCEL97 under WinXP-Pro w/SR-2
Microsoft Windows allows you to easily toggle between applications using
Alt-Tab. Is there a similar key board to toggle between two open
workbooks in Excel? One can use Alt-W to display list of open
workbooks, but you can�t just blinding hit the up or down arrow, because
the most recently accessed workbook is not always at the top or bottom.
I realize that I could get around the problem of opening two copies of
Excel and then toggling using the Alt-Tab keys, but typically I�ve got
two workbooks open in one copy of Excel before I realize I need the
f...Prices and cost Set to zero when exporting a new store
When I export a new store with 1.2.085v from headquarters all the cost and
price information is set to zero. I have seen that there is a fix for 1.3v
but i cannot seem to find any other fix for our version. Any suggestions?
Just run worksheets to update the cost and price.
Tiber Creek Consulting
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.
Joe Gonzalez wrote:
> When I export a new store with ...SECOND TRY< WHY NO ANSWERS ??? WINXP PRO,OFFICE 2003PRO not working write. WHY ?
> I bought a Windows XP upgrade disk from a friend and it
> installs ok, but has this dumb key on it that starts out
> with "XXXXX-640-blah-blah-blah" (why does it use
X's ?????) Whats the matter with it,
> is the installer or the software no good ?????? I paid
> good money for this crappe and get this and it cleaned
> all my email and Kazaa.
> Next MS mess, how come Outlook 2003 (has almost the same
> bozo key number) does not send my messages to the forums
> and I have to use this way ? Is it not working too ?
> do they check a...z-order of various lines and bars in an Excel 2007 chart
What is the procedure for changing the z-order of various lines and
bars in an Excel 2007 chart, such as drop lines, high-low lines, up/
down bars, and error bars?
I observed that when I add drop lines to an Excel 2007 chart, they
appear in front of the underlying data -- in my case, the underlying
data is displayed as a plotted area. I want the plotted area to be
fully visible with no lines over it.
I would like to send the drop lines to the back and keep the plotted
area in the front, but there is no option to do this.
So, is there a procedure for adjusting the z-order of drop...Issues Template
Hi i have downloaded the issues template to work in a vet office, but am not
sure what the Add related issues is for on the Issues details form. i jus
want to know what it does and its benefits
It's unlikely that you'll get any help that requires anyone to
download and analyyse someone else's guickie application. You'd do
better to use the sample databases and tools that are provided with
Access and ask questions based on them, instead.
"Amin" <Amin@discussions.microsoft.com> wrote in message
news:1B20F4FC-2696-4724-8615-49...DLookup not working
My code is
If DLookup("Mechanic", "PartSuffixTbl", "Mechanic = " &
CLng(MechanicList.Column(0)) & "") = MechanicList.Value Then
MechanicBox.Value = ""
MessageBox = "This Mechanic cannot be modified because"
MessageBox2 = "there are Wheels assigned to it"
This is to look in the Mechanic column of PartSuffixTbl and if the
MechanicList.Value is found, the following code takes place. I have and else
also but the problem is...keyboard doesn't work
The keyboard works to type in the password but doesn't work when the desktop
appears. I whent thru the hardware trouble shooter. The keys beep when you
Type of keyboard?????
"Carol" <Carol@discussions.microsoft.com> wrote in message
> The keyboard works to type in the password but doesn't work when the
> appears. I whent thru the hardware trouble shooter. The keys beep when
> press them.
On Wed, 10 Mar 2010 10:2..."Error on page" and error report on entity close
We have CRM 4.0 rollup 6 implemented from a CRM 3.0 upgrade about a month
ago. Recently, my users have been reporting an error report being generated
when they try to close (or save & close) any entity they have open. The
entity is closed (or saved and closed), and I have asked them not to send the
error report, but of course this needs to be resolved. I have noticed that
once the record is open, "error on page" will appear in the bottom left of
the dialog if you will receive the error report dialog, which doesn't happen
every time. Also, if I do an IIS...Media Center Screen Scaling Issue
I have a desktup running 2 screens. My main runs at 1650x1080 and the second
is 1280x1024. I always run my media center in a window streched to the max
size on the second screen.
The problem is that I can't get it to go to 4:3 in windows 7. In Vista I was
able to do this by dragging the media center so it was overlapping both
screens and then maximising it. That used to make it 4:3 when it was restored
but that doesn't seem to work in vista.
The first week I was using 7 I did get it to behave but I have no idea how,
now it's stuck and I can't seem to fix it.
...Password not working
I have been using my default folder set with a password for many years. Of
late, i realised that I am not being asked for the password even when I
restart the system. When I reset the password, my old password is being
required for that. But again when I open Outlook, I am not being asked for
What could be the problem be? I recently installed YahooPop to have POP
access to my Yahoo account. Could that be a possible reason for this?
Thanks for any help.
...Work spreadsheet issue
If I have multiple rows of data on a worksheet and on another worksheet
I want various counts of rows that have certain things in common, how
would I do that? Thanks.
jenrenea's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23098
View this thread: http://www.excelforum.com/showthread.php?threadid=373900
Can you provide a sample of your data along with your expected results?
Domenic's...Outlook 2003 process doesn't shut down on closing
When I close down Outlook 2003 SP3, the outlook process continues to run and
the Outlook icon remains in the Taskbar. Windows XP Pro SP2 fully patched.
Do not multi-post. See your answer in m.p.office.misc.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After furious head scratching, Maincat asked:
| When I close down Outlook 2003 SP3, the outlook process continues to
| run and the Outlook icon remains in the Taskbar. Windows XP Pro SP2
| fully patched.=20
| Any ideas?
| Thank...vlookup not working #2
I use vlookups constantly, but sometimes (seems kind of
random) when I try to vlookup a value on another workbook,
the function does not work. For instance, today I copied
data from an Access table into a new workbook. I then
tried to do a vlookup function in the new workbook to
another workbook. After getting to this point [ =vlookup
(A2, ] I switched over to the other workbook, but the
formula disappeared from the formula box, and I couldn't
select the range I want to do the vlookup on. The
workaround for me has been to copy the worksheet I'm
trying to vlookup, and paste...Importing Purchase orders with integration manager.
When I import a purchase order in Excel, GP creates a
separate po for each line item. How do I get the line
items under one PO number? I notice that the SQL option
does not allow you to have a query relationship.
You will need two source tables, one with PO header info and one with line
information. Use two sources in Integration Manager and relate them by a
common field (like PO Number)
If I remember correctly, there is a sample integration provided just like
Richard L. Whaley
Author / Consultant / MVP
Documentation for Software Users
For help learning and better using Dyna...auto hide toolbar in Excel won't work
I have the toolbar at the bottom of the screen set to 'autohide' but when I'm
in Excel sometimes it does 'hide' until the cursor is moved over it, but
mostly it won't autohide so that I cannot see the Sheet names at the bottom
of the screen. I am running Windows XP Home and Microsoft Office Professional
2003. Can anyone help please?
Every time you move your cursor too far into the bottom area, the toolbar
will pop up. Normally it disappears when you move your cursor up again. If
it does not, try clicking on you spreadsheet. If you right click o...hide/close/delete shared account
(bear with me. i'm new and although this is my second time trying to set up
money, i've run into the same problem and have yet to find the answer in the
i have four bank accounts and one is shared with a family member. i don't
want this account to show up at all in money essentials. i tried "closing"
it. i tried "hiding" it. i tried "deleting" it. but each time i go back to
"categorize my transactions," transactions from that account are still there.
The problem here is that Money is designed (and Money Essentials (MEss) even ...VBA code (rules) won't work after reboot
First off I am not very knowlegeable about Outook or VBA coding so I
apologize in advance for missing the obvious.
I have created some rules in outlook (actually exported/imported from a
functioning account). The rules basically:
-look for an email with an attachment and with a specific word in the
-move the email to a different folder
-copy the attachment and place it in a shared system folder (done with VBA
The problem I have is the rules will only work until Outlook is closed down
or the server is rebooted. After that the rules partially work (the VBA...