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?
...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...How to export VBA source code as text
I have an Access 2003 application with over 100 VBA code modules.
Short of calling up each one in the VBA interface and ^A^C then ^V to
a text editor, is their a faster way to dump all the source code into
a text file on disk?
The "print-to-file" feature appears to create a massive file of laser
printer commands, which is not usable.
Thanks in advance,
Look on the File menu: there's an Export module option.
There's also an undocumented SaveAsText command you can use. Check my
February, 2005 "Access Answers" column in Pinnacle Publication's "Smart ...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...Having trouble using LINEST in Excel 2007 VBA
I'm trying to run regressions in VBA using the code
ols = Application.WorksheetFunction.LinEst(Y, x, True, True)
As I understand it the second TRUE generates the stats for the regression,
but I only get the coefficients. (It shows NA for the stats).
In this usage of Linest I get the same in Excel and VBA, eg
Dim i As Long
Dim Y(1 To 5) As Double
Dim x(1 To 5) As Double
For i = 1 To 5
Y(i) = 2 * (i ^ 2) + (3 * i) + 4
x(i) = i
ols = Application.WorksheetFunction.LinEst(Y, x, True, True)
Range("G1:H5") = ols
Range(&qu...Minimize a Pane via VBA
I know that the following statement can be used to hide or show a panel, but
how would you minimize it? The article below is most certainly a genuine
Microsoft article as is obviously omits the relevant information.
objExplorer.ShowPane 4, False
If Visible=True/False is all you can do, does the article then contains all
the relevant information?
Michael Bauer - MVP Outlook
: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en&g...VBA Password Recovery
I have a question on an old method on unlocking access to VBA Modules.
I am following the process as follows:
1. Create a new simple excel file.
2. In the VBA part, set a simple password (say - 1234).
3. Save the file and exit.
4. Open the file you just created with a hex editor.
5. Copy the lines starting with the following keys:
6. FIRST BACKUP the excel file you don't know the VBA password for,
then open it with your hex editor, and paste the above copied lines
from the dummy file.
7. save the excel file and e...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...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
...Duplicate records in report
I have a daily sales report which is built from a query pulling from 5
tables. I built a report based on the query and am only grouping on the
"payment date" field from one of the tables. Here is my
problem...........when I run either the query or the report.........some of
the records are being duplicated. Not all, but only some. I'm lost!
Look at your report's RecordSource query in datasheet view; I'm sure that
you'll see the same duplicate records there, too. This duplication is caused
by one of the tables being joined having more than one reco...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 ...Reduce publication size and duplicate on page
I have created a color flyer in Publisher with photo, graphics and text that
is on letter size paper. I would like to reduce the size to 25% and put 4
duplicate designs on one page so I can cut it in four equal quarters. Is
there a way to do this?
> I have created a color flyer in Publisher with photo, graphics and
> text that is on letter size paper. I would like to reduce the size
> to 25% and put 4 duplicate designs on one page so I can cut it in
> four equal quarters. Is there a way to do this?
Here's one ...VBA Command to Deselect a Shape
I've written a VBA program that drops shapes (from a stencil I created) on a
page, but at the end of the exercise the last shape is selected (it has a
dotted line surrounding it). Is there a VBA command that will deselet this
shape (or select the page on which it sits?
On Fri, 22 Sep 2006 12:16:02 -0700, MikeM
>I've written a VBA program that drops shapes (from a stencil I created) on a
>page, but at the end of the exercise the last shape is selected (it has a
>dotted line surrounding it). Is there a VBA command that ...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...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 ...Does Live.com HAVE to keep a duplicate of my folders?
Running OL2007 under Vista Home Premium SP2.
I'm sure I've seen an option to (not) leave my email on the server, but now
that I'm looking for it, it's nowhere to be found. It's my understanding
that leaving stuff "out there" makes synchronization necessary, and it also
clogs up sending/receiving (stop me when I go wrong here). We don't need to
access our mail folders from other computers, so having said that, I think I
could streamline our operation here by "moving" rather than "copying" stuff
from the remote folders, espe...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 ...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 ...Duplicate Problem
I inherit an excel spreadsheet which contains the course schedule for a
college. It contains fields like course number, subject, section number,
days, times, room, instructor and credits. There is a unique number
assigned to each course offered. However, it sometimes happens that a given
course might have the same number listed more than once. For example, if the
class meets accross two rooms, it would be listed twice, yet have the same
course number. Or a course might have one listing for a lecture period and
another for a lab, and since it is the same course, it has the same course
number...Budget: MM04 duplicates entries??
When I check "review yor current budget status", under "current month"
budgeted column, I have a line called "Debt", wich includes my "debt
reduction plan" plus mortgage payments. It should total $1500 or so, and it
is shown that way on the "actual" column. But under "budgeted" shows $ 4,250,
inflating the current month budgeted expenses.
When "next month" aproaches, the "correct" amount on "budgeted expenses"
becomes inflated again. When I check on "edit budget" page, the actual amount
on...Payables TRX With Check Amt Post W/out Printing Check
Yes we are new to GP.
Ok here is a scenario. I am creating a new Payables Transaction Entry
(Invoice) I fill in the Vendor ID, Purchases Amt Vendor Doc Number, And I
also enter Check Amt then I select the Check BookID. And there is No Batch.
I Post this Transaction immediately without clicking on the "Print check"
button. So what did just happen-?
The Transaction with voucher No "xxx" just got posted with a check Number.
BUT I didn't get a chance to print the check. So now I am looking all over
the place I can't find that Document number...check if ocx is installed
I have a dialog with an activeX control on it. If the control is not
installed properly, the dialog fails to display even with "no fail create
selected. Is there any way I can programmatically check wether
"mycontrol.ocx" is installed?
You could try using the GetClassFile API...not really sure if this will do
it for you though. The only other way I can think of is to check the
registry for the CLSID in the HKEY_CLASSES_ROOT\CLSID branch.
Thanks Frank, checking the registry did the tric...Check this out
are you a dot net developer.
If yes... then please visit
This website is dedicated to most commonly asked questions in dot net
please feel free to leave your comments and reviews
another general blog of my liking is