AP Credit Memos on checks
Does anyone know of a solution to ignore Credit Memos (selectively) while
selecting checks? I have an issue where there are large amounts of credit
memos (hundreds) on a few select vendors. When we run the select check
process we want to restrict based on Credit Memo "due date" which in GP does
not apply. Has anyone run across this before and what was your solution?
...Change file selection from "Word Documents (*.doc)" to "All files (*.*)"
When I do a mail merge, I merge data to a Word Template (.dot) file, not a
Word (.doc) file. So, every time I want to do a merge I have to remember to
change the file selection filter from "Word Documents (*.doc)" to "All files
(*.*)". Is there any way to change this to make "All files (*.*) the
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here:
"Fred Boer" <fredboer@NOyahoo...Network Check before Moving from Exchange 5.5 to Exchange 2003
I'm going to be moving from Exchange 5.5 to Exchange 2003 shortly, and
already have a Windows Server 2003 AD environment in place, with a seemingly
happy ADC connecting to Exchange 5.5.
I'd like to make sure that my Windows 2003 environment is optimised before
making the move to Exchange 2003, specifically I want to look at AD
replication, FSMO roles, DC/GC placement and anything else that you can
Does anyone have some tools/scripts/checklists that I could use for my
project. If I have to go through my environment manually I can, but I'm
hoping that there is ...Disable or Lock check box after initial check
I have a check box that, when clicked, adds today's date to a table field.
Private Sub CkBoxCIComp_AfterUpdate()
Me!CIComp = Now
After the initial check in the box, I would like the check box to be
disables so they cannot check again and change the initial date that was
entered on the initial check.
I also need a msg to contact the admin for assistance.
Can anyone tell me how this can be done?
This will not work in a continuous form, but in single form view, try
Private Sub CkBoxCIComp_AfterUpdate()
Me!CIComp = Now
Me.CkBoxCIComp.Locked = True...Forcing WMP to use the file names I have used
How can I force WMP to use the names I have given my sound files, like
"Lecture on Dystopian Futures" or "Rain sounds" rather than the original
names they did have like DS400789? It's very irritating of WMP to ignore me
In WMP's Options, make sure "Rename music files using rip music
settings" (on the Library tab) is checked.
Tim De Baets
> How can I force WMP to use the names I have given my sound files, like
> "Lecture on Dystopian Futures" or &...linking with cells of others excel file
I have 1100 archives excel of a same structure, but with different data and i
want create summary excel file, by the amount of archives and data desire to
automate this task
...Outlook password checking
For some reason my Email account information changes. I
find out it has been changed when I send/receive. A
dialog box with a username/password pops up and the
server is changed to localhost and the username is
changed to <username>/<servername>. Also, once my mail
has been sent and received successfully it still asks me
for this password.
It is not Outlook that is doing this but your AV or firewall that you have
set to check incoming mail. Uncheck this option and the annoying behavior
will go away.
Milly Staples [MVP - Outl...checking if an item exists in a custom collection
I have a custom collection and I will add to it few class objects.
How can I double check, through code, if an item has been added or not to
...Check for Alpha characters
I would like to check if the first three characters are alpha, if so
remove them. The alpha characters will be any combination.
BEFORE - ABC123
RESULT - 123
The alpha will not be the same or I would use:
Thanks in advance for ANY assistance
TimE's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=213
View this thread: http://www.excelforum.com/showthread.php?threadid=48363
It would help if you posted a larger representati...Macro to open file bypasses Auto_Open
I have the following code.
Workbooks.Open Filename:=vOpen, UpdateLinks:=3
But when I run this it does not process the macro Auto_Open.
Why is this?
I would like for code to run on the opening of the file regardless of how
the user opened it. (ie. If they opened it using File / Open on the menu
then yes, the Auto_Open would run. But I also want code to run even if
they write their own macro to open it.)
That's the way excel was designed to work.
Lots of times, developers want to open the workbook without having that macro
run (maybe they&...Add the option to delete files in FRX report Launcher
The option to delete the FRD files after the report has been viewed, printed,
or sent is availible in the report designer. This option is not availible int
he report launcher and leaves the FRD file in the I/O Data folder. This can
be a security risk for companies with multiple divisions if the user
generating the reports forgets to set a password on the report, as anyone
will be able to browse to the I/O data folder and view the report.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, c...I need to get Excel to check dates for membership expiration and flag member if
Well ive came up with another problem that i need solved again so i have
come back to the message boards.
If none of you guys remember me I am the secreatary of a Bass fishing
club in my area. My members are all supposed to be members of the
B.A.S.S.. What I would like excel to do for me is check their
expiration dates on their B.A.S.S. membership to see if they are still
good. If not then flag their name on my standings sheet so i can remind
them to renew their membership. All I have done is put the expiration
date of each member in another cell beside their name. What i would
like it to do ...Help File
My help function for Office 2000 seems to be disabled or non-existent? Can I
download this file? Where from?
Thanks for any "help"
...Printing my own checks
Has anybody printed their own checks with MS Money?
I'm thinking about getting something like Versa Checks.
MS Money is supposed to have some but I haven't seen it yet.
Have there been any problems with this?
I'm paying most of my bills online.Any suggestions are very
...Send different reports to different printers
how do i make my report in Access go to a selected printer
"Lloyd" <Lloyd@discussions.microsoft.com> wrote in message
> how do i make my report in Access go to a selected printer
Open the report in Print Preview. Then open the Print dialog (Print button
on ribbon in A2007, or Print on the File menu in previous versions.) You can
now choose the printer to send it to.
If you always want it to go to a specific printer rather than the Windows
Default, open the report in design view, open the Print dialog...comparing 2 files with Vlookup possible?
I have been asked to use Vlookup to flag similar entries in two files using
vlookup. Is it possible? Thanks
An easy way to do this is to start your formula and then select the other
area and then touch the enter key.
now open the other file >goto the lookup range>highlight it>touch the enter
key>complete the formula.
"dindigul" <firstname.lastname@example.org> wrote in message
>I have been asked to use Vlookup to flag similar entries in two files...Check rules on record before update
I am designing a layer of classes for database access. I want to implement
functionality to have a record checked against database integrity rules
before I am actually writing it to the database.
I would want to do something like this:
recordset.Edit(); // or Add, whichever
if( !recordset.WouldUpdateBePossible( mydata ) )
MessageBox( "you now already typed something illegal" );
....; // Some time goes by
Edit(); // or Add
....; // actually write the fields
Obviously I would want to do this to evaluate what a user enters in the UI
and...Office 2007 Excel opening a file question
Office 2007, XP-MCE
Clicking on a file's name opens Excel's frame only, no spreadsheet, no
empty spreadsheet; must drag the file's name to the frame to open.
What basic function, Excel setting am I missing? Thank You! Wayne
On Mon, 18 Jan 2010 07:52:16 -0500, email@example.com wrote:
>Office 2007, XP-MCE
>Clicking on a file's name opens Excel's frame only, no spreadsheet, no
>empty spreadsheet; must drag the file's name to the frame to open.
>What basic function, Excel setting am I missing? Thank You! Wayne
Having been...Activate check box
Is there a way to activate a check box on a double click? Or have a
confirming statement "are you sure you want to check this?" Just seems a
single click can activate / check it too easy, so easy that you may not
notice that you selected it.
Let me know
On Tue, 2 Feb 2010 05:46:01 -0800, CB <CB@discussions.microsoft.com>
Typically it is counter-productive to want to change the way Windows
works in all applications except yours.
In your <checkbox>_BeforeUpdate event you can write:
if <checkbox>.Value = True then
Cancel ...button to check if checkboxes have been checked
I know how to create checkboxes and buttons, etc. I am okay with VB bu
never tried Excel VBA. I want to create a column full of checkboxe
with no code. At the bottom of sheet1, I want a button that onc
clicked, will check column 1 to see which checkboxes have been checke
then take the corresponding value in column 2 and 3 and copy them t
another sheet. Can this be done? Thanks for your help. This is lik
creating a sub-list from a master.
Message posted from http://www.ExcelForum.com
You will need to link the check boxes to cells. Then if a box isn't checked the ...transferring inbox files
I have saved all my OE mail files on a different computer. I then installed WIN XP home on my machine. Of course I have a new installation of OE6 n the machine. How can I transfer my old mail files like inbox, sent, to new OE6 installation. I would prefer to rename inbox to inbox-old etc. and haveboth the new inbox and the old inbox.I placed in inbox-old in the identities folder with inbox.dbx that the installation created but when I open OE6 I do not see indox-old.dbx. The inbox-old.dbx is coming from an installation of WIN98
This newsgroup is for support of Outlook 97, 98,...how do I make an excel file(created on a mac) readable on a pc?
Roberto Gibbons Gomez -
You do not need to do anything special.
An XLS file from the Mac (Excel 98, X, or 2004) can be opened on Windows
(Excel 97, 2000, XP, 2003).
The XLS file format is the same (except for a few recently-introduced
features, which will be ignored on earlier versions).
...Different display for same file
I sent an Excel file to two co-workers via email. One opened it and
could see all numbers as I would see on mine. The other saw some
numbers as xxxxxx.. as in the case column width is not wide enough.
Using format or manually fix the column width would solve the problem.
However, I've checked the spreadsheet on both monitors and found that
the font type, font size, and column widths are the same as in the
original one. Has anyone seen similar problem? And what in the
spreadsheet has triggered this display problem? :confused:
Thanks for your advice.
--------------------...printing checks with description on check
I'm trying to print checks with the description on the check. I fill in the
description box with the appropriate account number when editing the checks.
When I print out the checks the description is not on the check.
The field to change is StndCost in IV00101. After resetting the values, make
sure to make the appropriate GL adjustments to the Inventory Asset Accounts.
You can get information on how Dynamics GP and GreatPlains works from books
available at www.AccoladePublications.com.
Richard L. Whaley
Senior Business Consultant
> I'm trying ...File, Send To, Mail Recipient slow
In Word, we choose File, Send To, Mail Recipient as Attachment. On some PCs
it takes about � a second to open the Outlook Mail message, on others it
takes about 30 seconds, and we don't know why?
Outlook related? Word related? All machines running Office 2003 SP1. We
can't see any differences. Tried turning "Use Word as email editor" on and
off, no joy.
Can anyone help?