Is it possible to have an area in one of the spreadsheets that is always
sorted according certain rule and to make changes in the other spreadsheets
and that any change will be affecting the sorted area
I have a field named Field213 that holds (CASETYPE) from the database. When
I open the form, I want it to look at that field and make field163 visible
depending on what it stored in Field213. Right now it only becomes visible
if I manually change what is in field213, then field163 becomes visible. I
should mention that I have field163 as visible no and display always, the
same as field PBISUB, Field382 and Field163. Probably something simple, but
I can't seem to see it right now.
I have the following:
Private Sub Field213_BeforeUpdate(iC As Integer)
If Me!CASETYPE = &qu...Trigger Macro on Open Spreadsheet
How can we force a macro to execute whenever a spreadsheet
is first opened?
do you mean the file? If yes either name your macro
or put your code in the workbook event
Beckie Davis wrote:
> How can we force a macro to execute whenever a spreadsheet
> is first opened?
...Manager Assist ...... Field Service Module
Hi to all,
I wnat to ask about Manager Assist, that is used to manage the calls on the
service call module...... is it a GP module or it is a separate software
thank you in advance,
ManageAssist is a seperate VB application that connects to the GP Field
Service tables. It allows for both viewing of schedule calls as well as
updating of certain records (i.e. Unavailable time, sick time, etc.)
Field Service Series Designer/Architect
"Eng. Tareq Sabri" wrote:
> Hi to all,
> I wnat to ask about Manager Assist, that is used to manage the calls on th...Multi-field search form
I am rather new to this place, so I would like to thank you all up front
for any and all assistance you may provide. :)
It has been a while since I worked with MS Access last. What I am trying
to do is create a multi-field search form, where any of the fields can
be filled which will display a result set. Preferably if no selection in
the fields is made, the entire resultset should be shown - this is not a
I seem to be a bit at a loss on how to procede with this task or to find
any resources to help me get along.
Again, thanks for any and ...Edit the Auto Fill in the To: field
On the Send new message window, is there a way to edit the
auto fill list for the To: Field. when i start to type in
a name in the To Field the auto fill will provide a list
of names to choose from. the one i most use is on the
bottom of the list. How do i edit the list to get the one
i use most to the top?
Do you use the others as well? Editing the list will remove them from the
list. If you again use the names, they will be added back to the same
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-...display the value of an unbound textbox in a field within a table
I created 3 textboxs to calculate the number of business days between 2
dates. The 3rd textbox contains the value. I now want to have this value
displayed in a table field. I'm sure this is easy but I'm a complete novice
and have spent far too much time on this already. Can anyone help!
The general concept of tables is that they are for storage of data in
the background. They are not for display of data. That is what forms
and reports are for. Therefore, the appearance of the data in the
tables is not normally relevant, and the display of calculated values is
Hi, I have two questions:
- I had data in time like this:
ITEM T1 T2 T3 ...
item_A a1 a2 a3 ...
item_B b1 b2 b3 ...
item_C c1 c2 c3 ...
item_D d1 d2 d3 ...
and I want to find for every period the average of the 3 minimum values of
items (and the averages should skip negative values and average only
- Same data, I need to find for every period the items for these 3 minimum
:-) I'm sorry if the problem is somehow complicated, but if someone knows
formulas or guide to do this, please tell me.
Assuming your d...sorting dates in Excel 97
Running a worksheet that lists all medical expenses and am not able to
always insert date, expense, who to, in correct sequence. Some postings just
come in on time. Is there a sort formula that will allow me to sort these
entries in sequence? Will the sorting move up the entire row that lists
date, amount, payable to, etc. also? Thank you, Steve T.
I wouldn't use any formulas for this.
I'd select the range (all the columns in that range, plus the last row of
headers, plus all the data) and do Data|Sort
If you include all the columns that should move with the sort, you'll ...Money 2006 Deluxe Bills Summary Sorting
When in the Bills Summary view and I sort on Account, not all of the line
items with the same account are grouped. Upon further review, it appears
that duplicate line items with the same Payee, Next Due, Amount, etc are
being created and not properly sorted by Account. When I resort based upon
Next Due, these duplicates go away and the line items are properly sorted by
Next Due (ascending or descending).
When i've seen this before, it can mean corruption in the file. Because you
can see those additional bills, you have the opportunity to delete these
duplicates if you are seeing ...how field name output same as input
Thanks for any help.
I have a query from a couple tables, and one of the field names in the table
is 'IGP' and I have a field in the query that was
and now I changed to
IGP: iif(blah IGP blah)
which gives me a circular error.
The table is used by a bunch of other things, so I don't want to change the
field name there, and the field name for the output is used by a bunch of
things, so nor do I want to change the name there. I am using Access 2007. I
thought about changing the output field to IGP_, and I could change the
embedded queries in Excel that use it, but...passing non-field value into vba
I need to pass the line item sequence number (lnitmseq) from the sales
item detail entry window into vba. This isnt a visible field in the
window, so i cannot "add field to vba" using the TOOLS --> customize
toolbar window. Anyone have any idea how this can be done?
Using the Modifier you can make the field visible, add it to VBA and then
remove the modified window or make the field invisible again.
While in the Window Layout mode, make sure that the Invisible fields are
shown (Layout >> Show Invisible Fields) and then change the Visual Property,
Visible = true and mov...Derived Field
I'd like to add a derived field to this situation:
Parent Table : Shipments
Child Table : Shipment_Inspection
Shipment_No (connected field)
Number_Out_Tolerance (bad ones in the shipment)
I'd like to make a derived field "der_percent_good" that takes the
shipment size that the inspection belongs to and does
(1 - Number_Out_Tolerance/Shipment_Size)*100 to find the percent of
the shipment that is Good.
...Date/Time field calculation
i am trying to make a sum calculation on a field that keeps duration of
time. How can i do this? I get errors or zero as result.
On Jun 21, 10:02 am, Stathis <s_paraske...@hotmail.com> wrote:
> i am trying to make a sum calculation on a field that keeps duration of
> time. How can i do this? I get errors or zero as result.
You need to do the calculation at a level at least 1 level below what
you want the answer to be in.
msgbox DateDiff("h", #6/20/2007 1:00:00 AM#, #6/20/2007 1:30:00
will give an ans...Rule not matching "from" field
I want to set up a rule that will match words in the "From" field.
Sometimes I get mail like this:
From: email@example.com [firstname.lastname@example.org]
I want to match "email@example.com".
I can't figure out how to match it. I can't pick "from people or
distribution list" because it won't let me match arbitrary email
addresses. I can't pick "with specific words in the sender's address" it
just doesn't work. So far as I can tell, it will only match the part in
Anon E. Mouse <firstname.lastname@example.org> wrote:
&...Excel: how to merge data from 2 workbooks with 1 col. in common?
I've got two separate workbooks. Each workbook contains unique columns except
for one, which is a "key" column, or an id field.
Example: I have a client # column in both workbooks. In the first workbook,
I also have first name and last name columns. In the second column, I have
phone number and address columns. How do I merge the two workbooks into one
so that for each client # I have their first name, last name, phone number,
Well, I think I'd start by getting all the data into one workbook. With both
workbooks open, select the worksheet with the phone n...Sort column with first and last name by last name
I have a mailing list with 10,000 names. The first cell has first an
last name in the same cell. First name is listed first. Is there
formula to sort and/or separate text in a cell. I would like to sort o
separate the first name from the last in the cell to allow for a mai
merge by name. Using Excel 2002. Thank you
Message posted from http://www.ExcelForum.com
If you have just first and last names separated by a space, Data>Text to
Columns would be the easiest method to split into two columns.
If more than that, like names with van or von or de etc. you may need a
different m...Hide a field in a report
I am building a report using fields that are in tables. One of the
fields in the report is "Do Not Use". I want to build an expression
that says if "Do Not Use" is marked "1" in the table, then remove that
line from the report. If "Do Not Use" is marked "0", keep that line
in the report. Please help! Thanks!
In your query use a calculated field like this --
Hide_Field: IIF([Do Not Use] = 1, Null, [Do Not Use])
Then in the report set the textbox Can Grow property to Yes and drag the
size of the textbox to a hairline. If the output is...Bug? Multiple values in merged cells
I found that merged cells can contain multiple values.
Steps to reproduce:
Type 1,2,3,4 in a1:d1
type sum(a1:d1) in e1
Select a1:b1 and merge
Warning : MultipleData, overwrite?
Say yes to merge
Select the merged a1:b1 cells
No warning.. no overwrite.
c1:d1 are now merged
BUT d1 still contains a value...
and the SUM of a1:d1 = 8 !!
Also happens with FormatPainter etc
Behaviour observed in xl97,xlXP and xl2003
Error checking will find no fault in the sheet...
and you can spend ages to find out WHY your cross
sums dont match!
(although now that i fou...wrapping text in a query field
I set up the field in table to memo and tried entering a lot of information
but when I open the report that field does not expand to show all of the
entries. Can this be done in query and reports both.
Thanking you in advance.
On Dec 12, 12:06 pm, MaryLou <Mary...@discussions.microsoft.com>
> I set up the field in table to memo and tried entering a lot of information
> but when I open the report that field does not expand to show all of the
> entries. Can this be done in query and reports both.
> Thanking you in advance.
> Mary Lou
Go to the p...Inserting word 'merge field' into Excel
I have data in Word merge fields that I need to put in an Excel table. Each Word file is exactly the same and there are a few hundred files. If I can't do this direct to a spreadsheet, can I do it through Access?
...Integration Manager sorting
I am trying to upload an excel file into GPv9 using IM (sales transaction).
The integration is set up properly and works.
The problem is that the details (line items) of my integration on my
spreadsheet are sorted a,b,c,d, etc. When I look at the order in GP after
the integration is complete, there is no order to the sorting c,d,b,a etc.
I have gone into source properties and chosen to sort based on the item
field and it still results in the items showing up in a random order (after
testing the same order a few times with various sort orders, it still
integrates using the same sort...Inquiry Return Sort
Just upgraded to 10 sp3. Sales Order Processing Item Inquiry returns values
in a dislogical order. Well, I am sure it is logical but not overly
worthwhile. Anyway, my users are telling me it would sort it previously by
date. Right now if they select a single item for the search, the list
returned does not sort by document number or by date from what we can tell.
This makes it very difficult to find the last sale of an item. Can anyone
tell me how to change this? I am guessing the sort order is defined in a SQL
Stored Procedure that processes the redisplay/update for this window?
Allen...Sorting PivotChart data
In excel 2007 I want to sort data in the chart I made from pivot. I want
them to be sort in descending order. The reason is, I need bar Pivotchart
diagram to use as Pareto chart.
I'm also using this new function in excel 2007 , "drill-down" or
"drop-down" to multiple levels/layers in PivotChart. I want also those
sub-level data to be arranged in descending order.
I'm doing stratification(sequence of Paretos) of data in my plant so I need
it desperately. It would make my life easier.
Thanks in advance,
...Printing a two spreadsheets front and back
I have clicked select all sheets and selected two sided copy in print
options. It gives me a message that 1 page has been printed, when I hit
print, but when I go to the printer, there are two sheets of paper. Each
spreadsheet on its own piece of paper. i have done this before, but when I
do I print several copies, and months go by before I have to print the two
sheets front and back again. Help.
technically all excel does is send the data. seems to me the problem may be
in your printer, not excel. make sure that you are printing to a duplex