Deleting records off Inventory Transfer/Pick List
Is there a way to select multiple records for delete off of an inventory
transfer worksheet (worksheet 330)?
We are using this worksheet to create a 'picking list' to transfer inventory
from one store to another. When this worksheet runs, we end up with a great
number of items that are value '0' Qty or '-' (negative) Qty at source.
Before the worksheet can be approved, all of these lines have to be deleted,
one at a time. The worksheet window does not allow for selection of multiple
records. This can be hundreds of records and therefore is very time consuming.
...drop down arrow missing on pivot table when refreshed
I used this to get rid of old items in a pivot table.
Dim ws As Worksheet
Dim pt As PivotTable
Dim pf As PivotField
Dim pi As PivotItem
On Error Resume Next
For Each ws In ActiveWorkbook.Worksheets
For Each pt In ws.PivotTables
For Each pf In pt.VisibleFields
If pf.Name <> "Data" Then
For Each pi In pf.PivotItems
If pi.RecordCount = 0 And _
Not pi.IsCalculated Then
when refreshing the pivot table the drop down arrows on the page by
fields disappear. We are runn...How to create report from Pivot Table View of Union Query?
I have create a Union ALL Query. I want to generate a report from it.
The Pivot Table View of this Union Query shows exactly what I want (having
Row Heading, Column Heading and Detailed Data), so how can I make it as a
I have tried to create new report, but there is no options of making a pivot
(something like Crosstab Query and Pivot Table View of the Union Query).
Also tried to export to Excel, but it shows only count of records.
I want all detailed records.
Message posted via http://www.accessmonster.com
I tried to create a crosstab qu...comparing lists #2
I have two lists, placed in two different sheets in the same workbook. Now
we want a new list that does only contain those items that are in both
Is there a way to do this?
Thanks in advance!
Check out this site of Chip Pearson.
Scroll down to "D", and see all the options referring to duplicates.
Please keep all correspondence within the Group, so all may benefit!
"Prixton" <firstname.lastname@example.org> wro...Outlook 2003 opens multiple instances
When I double click the desktop icon for outlook it opens
twice or has two instances available in the task manager
window. Once I disable or end these and reopen outlook it
is fine. Also, we are currently running Viewmail and
Viewfax from Active Voice. Any help would be grealty
Charles Garcia wrote:
> When I double click the desktop icon for outlook it opens
> twice or has two instances available in the task manager
> window. Once I disable or end these and reopen outlook it
> is fine.
This happens randomly for me too. In fact, for a long time it used to
a...Calculate As of Date Check Book Opening Balance
Is there any way to calculate as of opening and closing balance of a given
check for Payments and Deposits Listing report
Module = Banak Management
...Multiple workbooks open -- closing workbooks
Dear Clever People,
I hope this is not the "silly question of the day".
We were wondering (when you have multiple workbooks open and you close one
workbook) why are all other workbooks forced to be closed, too?
Is it possible to ever close one workbook and leave all the others open?
Close it by going to file>close or by pressing Ctrl + F4 or by clicking the
smaller X below the big red X
"Janet Panighetti" <JanetPanighetti@discussions.microsoft.com> wrote in
message news:1C9BC30B-BE1A-4605-B215-99C07CB1D366...Backing up open database
Two part question: can an open database be backed up (by the user who has it
open) and if so, are there any issues associated with doing so?
I have an Access 2000 database through which we crunch payroll data from a
Progress database for the purpose of printing information not stored in the
Progress database on check stubs. The Access database is not set up such
that the users open it exclusively however, I have code in place that
prevents a second user from opening the database if someone's already in.
As part of the payroll processing, I have the payroll clerks notify me...Power Point Viewer 2007 won't open ".pps" files
Using Windows 7, Home Premium, 32 bit. No Office 2007 installed. Using
Microsoft Works. Have experienced several issues with Office PPT Viewer 2007.
Cleared them, but additionally each time I try to open a .pps file, either
from the Desktop or Windows Mail, I receive the following:
of Mustangs and Legends2007.pps is not a valid Win32 application".
I have opened this file many times on another computer, so don't think it is
an issue with the file. The software has be...Why does a drop ship PO need a Site ID for the line items?
What line item Site ID would I use on drop ship POs? On a normal PO, the Site
ID is where the product will be inventoried; for a drop ship, it will never
come into our warehouse so I'm confused why I would need to enter something
The address to which the vendor ships the product is put into the Shipping
Address ID (which makes sense)....I just don't get why you need a Site ID.
Bud Cool, Accounting System Manager
HDA, Inc. Hazelwood, MO
GP 9.0, SP2
The Site ID is a required field and you will be asked to enter one, even
when entering a drop-ship PO.
Best rega...Counting no of days of a specific range of days from a list
I have a date range from month first to end of month. I want to count no of
entries from that list which range from 10th to 15th. For eg. a list starting
from 01.11.2009 to 30.11.2009. I want to count no of entries of date range
from 15.11.2009 to 20.11.2009.
Please help me....
Assume that you are having the Dates in A Column and do you want to get the
number of days between 15.11.2009 to 20.11.2009.
In your example the dates are entere...Distribution lists won't expand?
Beginning two days ago, local distribution lists on one of our workstations
no longer expand into individual emails. By this I mean there is no longer a
'+' beside the list in the "To:" field. Also, the server rejects the email
with the following message:
The following recipient(s) could not be reached:
'1st Year Candidates 2009' on 2/26/2010 12:39 PM
501 <1st Year Candidates 2009>: "@" or "." expected after "1st"
I can open these lists and view each of the individual contacts, update them
and e...Excel Lists Dependencies
i have a problem to solve:
I want users to be able to pick a project from a list (no problem) and
then i want excel to pick the project number according to the project
name automatically from a list. To make my problem clear let's say a
user picks Project A from a drop down list in cell A1, then I want
excel to display the correct project number in cell B1 automatically.
Not all employees know projects by name in our company hence this
idea. The best would be to store the project number in a list similar
to a list used for drop down menus. The projects change and so do the
projec...Problems in viewing Report
Hi we have installed the SQL and CRM in 2 different servers, running on win
2003. I face a problem when viewing reports as it keeps popping up dialog box
for username and password which when not given gives a "page cannot be
displayed" error. can anybody let me know why the logon request for report
section is prompted. I tried to fiddle around with report section datasource,
by selecting various options and it works only when a AD user is given in the
credential section, since the user's password is prone for expiry, it will be
risky to give that option.
This is because i...Microsoft Outlook 2000 Error Report
Just to get helps on the following :
I've the Microsoft Outlook 2000 (come with Ms Office 2000
Premium with full installation) installed on the Windows
XP Professional with Service Pack 1. Had configured the
corporate Internet Email as well.
The problem is when sometime trying to type a new or
replied or forwarding of email which is going to be send
out, then will prompt the error report message. After i
click on do not send, then it will straight away closed
the whole Outlook 2000 application & the mail without
saved the message. So i've to re-open again and re-type...Error - Did not CLose Before Exiting
I'm receiving an error..
"...did not close the file before exiting"
Money needs to verify the information in your file
When I click Yes I then recevie the error....
"The email address or Password is in correct"
....if you are opening an existing file, sign in without access to online
I know the password is correct as I have not changed it and it works with an
older version of this file(from 1-month ago).
I've tried to repair the current file, but was unsuccessful
How can I sign in offline?
My recommendation is to restore a ...color list view
can i use thread to change the color of the list view with the
OnNMCustomdraw and how can i do it ùthanks
All this should be done on the same thread where the control was created.
Why would you want a separate thread anyway?
Ajay Kalra [MVP - VC++]
"mido1971" <email@example.com> wrote in message
> can i use thread to change the color of the list view with the
> OnNMCustomdraw and how can i do it �thanks
i need an another thread because i have in the list view lo...distribution list #6
While in my "in-box" folder is it possible to create a
distribution list from all the e-mail addresses that
are ;ocated in the "to" field without copying or typing
each ail box one by one?
Not natively. There are probably some third party apps that can do this.
"james" <firstname.lastname@example.org> wrote in message
> While in my "in-box" folder is it possible to create a
> distribution list from all the e-mail addresses that
> ar...opening multiple blank documents on start-up
I'm trying to figure out how I can open multiple blank documents on my
(MDI) application's startup. (using VC++ 6.0) I've looked at the
commandline info stuff, but it looks like I can only tell it to do one
FileNew. Basically I just want, say, n new documents created (along
with their views, presumably) when I start my program.
Anyone have any ideas on how I might do this, or can suggest where I
should look for answers?
make the doc template a member object in your app.h
use this pointer in the .cpp temp...CRM Report Issue
I designed a custom report to run pending activities & assigned
activities of current loggin user.
This report is running in report server and showing current user's
assigned activities. i am passing current user name in parameters as
@User Name from sql query. After deploying this report into crm. its
throwing an error message like this.
"An error has occurred during report processing.
The Value expression for the query parameter =91@UserName=92 contains an
error: Index was outside the bounds of the array"
The current user name passing from crm report as "...crystal report question 05-04-04
is it possible to use my own sql statement to build the crystal
reports in crm 1.2? I want to use some functions i.e. count(*) to add
some statistic on the reportings.
Thanks in advance
...Activities by Business Unit Report
Our implementation of CRM uses multiple business units created under the top
level organizational business unit.
We are trying use the existing activities by type report as a basis but to
add a grouping by business unit. This report would only show activities by
a specific business unit. Currently our security model is configured such
that all activities are viewable across all business units. Any of the
default reports will not achieve our segration requirement.
Has anyone attempted a report similar to this? Where and how should we be
applying the business unit filter? Crea...Uninstalled 2007 Trial, now all docs don't open
I used the 2007 Trial and uninstalled it, and now my docs do not open in the
2003 Version that came on my computer from the beginning. Any ideas? I do not
have the original CD.
Did you save your files as .docx or .doc? If it's the former you need to go
to Microsoft's site and download the 2007 compatibility pack for 2003.
"Don't pick a fight with an old man.
If he is too old to fight, he'll just kill you."
"JenLy" <JenLy@discussions.microsoft.com> wrote in message
...Embedded images not printing in reports
I have built several reports in Visual Studio and when I preview them there,
the graphic (our logo in this case) displays fine. But when I pull them
into CRM 4.0, and the graphics show a red "x" as though they aren't there.
Do I need to do anything different other than embed them? Anyone else have
this problem that can enlighten me as to a solution?
...Create a Group Mailing List
I have created mail groups in the past, but now cannot. I have also read all
the directions on this message board, but nothing works for me. Help!
Why can't you? Are you missing the buttons on the toolbar?
Missing buttons from the Windows Contacts toolbar
Vista - "New Contact" and "New Contact Group" Button Missing
Imperial Beach, ...