Report writer #17
I have a client that needs to add a field to the Financial and
Payables Edit list... the field they need can't be linked through the
tables in Report Writer. How would be the best way for me to pull in
the information from Segment Description - only segment 5's
The only way I can think of accomplishing this is by using Report Writer with
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
> I have a client that needs to add a field to the Financial and
> Payables Edi...Update of Inter-Store transfer orders
I am at the end of my rope with transfers. I can't understand ho RMS can
have the ability to create and Inter-store transfer at one location, but
changes are not reflected after the order is "placed."
Has anyone found a workaround?
My situation is that a smaller location orders products from the main
location which houses the warehouse. The warehouse crew picks items from the
transfer order, but very frequently the requested items are not available.
They may send a substitute, adding it to thier transfer out order. Tehy may
also send some items that were not requested by ...View one record at a time in a report.
I am new to access.
I created a report from a table using the wizard.
When I view the report, I only want to see one given record at a time - not
How do I do this?
The easiest way is to start from a form, where you bring up the record you
want to see. Then put a command button on the form, to open the report to
just that one record.
Here's the code you need for the command button:
Print the record in the form
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne...Payee Matching using Memo Field?
Note sure if this is specific to BofA, or if I'm just
missing something.I am using MS Money Deluxe 2004, but
also had same prob with 2000
When I download ofx (problems with qif also) statements
the Payee or <name> is truncated to 32 char which
normally I wouldnt care since money only allows 32 char
in the payee feild. Problem is my transactions in the OFX
are like this:
<NAME>INTERLINK NETWORK TRANS ****** O
<MEMO>INTERLINK NETWORK TRANS ****** ON 07-03
CUSTOMER ******** PAYMENT TO ACME
Is it possible to auto match Payees using...Change Regarding Field
Quite often an e-mail thread has been started before a problem in promoted to
Because the regarding file is closed in existing e-mails I cannot link them
to the case.
Any way to change the regarding field or create a copy of the e-mail with an
open regarding field?
...Populate field on resolution of a case
I want to populate a field on the resolution of a case, however when I
created a workflow on the update of status equals resolved, it errors saying
"the record is marked as readonly"
any ideas on how to do this before it is resolved?
On 10 jul, 21:44, "Michael San Filippo" <Mich...@datacubesystems.com>
> I want to populate a field on the resolution of a case, however when I
> created a workflow on the update of status equals resolved, it errors saying
> "the record is marked as readonly"
> any ideas on how to do this before it i...To make fields invisible using Dexterity Utilities
I know we could use Windows propoerties to make fields visible or invisible
on a Window in a form. I understand we could use Dexterity Utilities to make
the fields visible or invisible to user.
Could anyone say how to do it
Dexterity Utilities is not the correct tool to hide fields from a user. You
can do this using Modifier, VBA, Field Level Security or Dexterity.
Dexterity can either use triggers or you can create an alternate window.
David Musgrave [MSFT]
Senior Development Consultant
MBS Support - Asia Pacific
Microsoft Business Solutions
http://www.mi...Report Taking a Long Time to Print
I have a main report with 2 subreports in it. One of the subreports seems to
be holding up the report when it comes to running and printing. When I run
the query and/or report for the problem subreport it returns data within 1
minute. When I run the main report, it takes anywhere up to 5 minutes to run
and about 12 minutes to print. When this subreport is removed from the main
report, running and printing is under 1 minute, so I know this subreport is
I had seen a post similar to this question and I tried the suggestions
(removing page breaks, turning force new page ...Resource Assignments View Filtered on Booked Type Field
I have a project that has been cancelled part way through. To deal with
this, I've set the Booked Type field to be proposed for all resources in this
project. This works great in that the tasks from this project no longer
appear in the resources My Tasks view but they do still appear in the
Resource Assignments views I have and I don't seem to be able to filter
Resource Assignnments on Booked Type. Is that possible or is there another
way I should be going about what I want to achieve? Which is to keep a copy
of the cancelled projects plan in Project Server for refere...Can't see categories in Budget Planner/Won't load Monthly Budget report
In the last couple of days, Money stopped showing the
categories under the budget details. In the "Review your
current budget status" screen, under budget details, it
usually shows each income and expense category and how
I'm doing so far in the month. Now none of that shows.
I have made sure to check View all budget items and show
expense and income in the view menu, but this does not
help. In addition, Money will no longer load the monthly
budget report when I click "Other Tasks, view reports,
monthly budget." I have this problem no matter what
budget I...how do i show text in the data field of a pivot table?
If you put a text field into the data area of a pivot table, it will
summarize the field to show a count, instead of showing the text.
You can place the text fields in the Row, Column or Page areas, where
their text will show.
Excel FAQ, Tips & Book List
...Changing field sze of labels and text boxes independently
I am using Access 2007. I created a report with the wizard. Now I can't
change the size of labels or text boxes without all the fields/labels
changing in concert. What do I do to permit changing these things
individually? Must be simple, but the help function in Acess 2007 I find not
On the arrange tab, look for the button for Remove.
Highlight the controls and click remove.
This will ungroup the controls.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
"gg" <firstname.lastname@example.org> wrote in message
news:92DDB6...Adding field in Scrolling window
I was wondering how can I add a field in scrolling window if it is not
mapped in DB?
Use a local field, and assign a value to it in the Fill script on the
> I was wondering how can I add a field in scrolling window if it is not
> mapped in DB?
...Making pretty reports
I am fairly proficient in the use of formulas to produce data that
need for a fairly complex mortgage and real estate investmen
spreadsheet, but I'm lacking in presentation. I need to be able t
print a presentable report for my clients and I've had a difficult tim
importing the data from my spreadsheet to Word in a reliable manner (
must not be doing something right, because it seems too tedious an
time-consuming). I've tried to format a worksheet in Excel to be abl
to present the data in a professional and eye-pleasing manner, bu
frankly I'm just bombing-out. DOES ANYONE H...Find field in CRM and Case search in CRM
I have a ton of cases with emails attached/regarding each case individually.
How can we search these cases for all cases that have a common element, for
example: I want to search all my cases for the word "disconnect" to see if
it appears ANYWHERE in the case, email, title, or part of this case.
Anyone know how I can do this? FYI: Building a specialized advanced find
won't work because I need the ability to search ANY word -- today I want
Disconnect tomorrow, latency, etc...
Actually, an Advanced Find might be a good way to go, because you can save
your Advanced F...automate sales order fulfillment details received through excel
We receive an excel file from our distribution center every day which has
the order fulfillment details for existing sales orders. How can I load this
into Great Plains? If someone has done this, any examples will be of great
Thanks in advance,
We have a add solution for Remote SOP using Excel interface through GP,
please drop a email.
"Jack Tundra" wrote:
> We receive an excel file from our distribution center every day which has
> the order fulfillment details for existing sales orders. How can I load this...Order Entry Form
I have a form with a subform. The subform only asks for product and
quantity. First time through this form works great. Second entry skips the
product code and goes directly to quantity. I have tried creating this form
from the tables and also a query. I have checked all the tab stops and
everything else I can think of but can't seem to find what is making this
Did you create the subform so that you know that know code is causing this?
If not, then open a module and do a find on the word 'setfocus' (no quotes).
If no results use the word &...Changing the order of page numbers
Example: On a 10 page doc.
you want the first 5 pages to be numbered '1' to '5'
then the next 5 pages to be numbered '14' to '18'
Is there a way of changing page numbers like the above example?
Don't understand why you want to do this but the best way is to record a
macro while you do it manually.
1. print pages 1 to 5
2. go into page setup and change the first page from auto to the value 9
3. print pages 6 to 10. The page count should start at 14.
4 go into page set up and change the first page back to auto.
you'll get so...Format criteria for text field
I am writing an text box expression in a report as follows:
=DLookUp("[BILLINGDATE]","[DATATABLE]","[InDate] =" & [Forms]![Invoices
The field INDATE is a text field. BILLINGDATE is a text field also. What
delimiter do I need to add to the statement to make it work on a text field?
I am getting garbage out. Must I change it to a numeric or date field to
make it work?
One has to ask why you are storing dates in a Text field instead of a
If you must keep the dates in a Text field, the format of the dates nee...Clear all pivot table fields with a Macro
I have a two things I would like to do, ideally with a macro
1. Clear all fields from a pivot table
2. If any of the fields have been filtered - remove the filters
I am hoping there is a simple command or two that I have not yet
To put things into perspective: I have multiple pivot tables (all
copies of the original table, and each on their own spreadsheet).
My plan is to have each table set up for particular queries (that is
with different fields and filters). I will then examine the data on
each, and sometimes alter the fields as needed. But when I am done I
want to press a b...Custom date field and Fill
I have a customer that is using a date/time fill that
isn't calculating the right time. It can be duplicated on
a new spreadsheet. Start with "A1" and enter
in "1/29/2004 7:30:50 AM" and format the column with this
custom type: m/d/yyyy h:mm:ss AM/PM. the fill series
should decrease by 20 seconds every cell. So I manually
put in the first 5 cells as follows:
1/29/2004 7:30:50 AM
1/29/2004 7:30:30 AM
1/29/2004 7:30:10 AM
1/29/2004 7:29:50 AM
1/29/2004 7:29:30 AM
Highlight the series and drag it out past A110. In cell
A103 I have lost a second. the value should ...Report window is so small
Every time I open a report, the window of the report is so small and also I
have to Zoom in every time I want to read it. I also have to drag the window
so it gets bigger.
Is there a way to automatically have the size of the window say 700 x 500
pixels? And also I want to have it
zoomed in so it looks like a word document with font Arial size 10? Aprox.
that size at least.
Any help is very much appreciated.
You can use the event OnOpen Procedure
use docmd.movesize to adjust the position and size
"Jan T." <MyFirstName.MyLastName@hotmail.com> wrote in...WLM Beta
Using WLM latest beta. I had been using messages sorted by conversation
but as many are being "lost" through jumping to lower view I reverted to
sort by "From". Now my incoming messages are all over the place with
respect to date. No matter whether I select descending or ascending there
are some messages that should be at either end but are seen in the middle of
the list or elsewhere.
Perhaps I am misunderstanding the "From" sort. Is it From by date order
or something else?
There does not seem to be a way of just sorting by "date&qu...Internet Order download Improvement
When pulling in an Internet order to RMS via cntl-shift-F10, a basic customer
match occurs. If a match is not found the only choice available is to create
a new customer account.
In addition to the "New" option a "Set Customer" option should be made
available to allow for a more extensive search and match to occur.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
li...inventory aging report #4
What is a good report in GP 9.0 to use if you want an inventory aging
report? The stock status and historical stock status do not offer what I'm
looking for. I want to see transactions in detail and their effect on
oh, and the report needs to also show the valuation affected by inevntory
adjustments. So, the Purchase Receipts report is not good enough either.
> What is a good report in GP 9.0 to use if you want an inventory aging
> report? The stock...