Subform does not print.
I have designed the form the way I want it. Well, almost the way I want it.
I enter the info into the form and then go back and check all my tables to
ensure that all the info is being stored into the tables and that all
functions appear to be working like I want them to work. When I hit the
print preview button the subform does not appear. I had this happen before
and managed to reset the form so that the subform would actually print but I
can't remember how I did it. What am I doing wrong?
...Date format in merged field
I am using Publisher 2000 (from Office 2000 Pro), under W2K.
I am printing membership cards, merging data from an Excel spreadsheet.
One of the merged text fields on the membership card is a date. How do I
control the date format on the printed cards?
When the spreadsheet had a date format of "8/4", the card printed as "August
8, 2004". I changed the spreadsheet date format to "August 4, 2004". Now
the card prints "8/4/2004". I suspect, however, that it was something else
that I did within Publisher that caused the date format results.
- Da...calculated field with conditions
In the query design view I am trying to make a calculated field total
certain amounts based upon the contents of a certain field. The
IIf([recShortName]<>"sm/TRACTORS" Or "sm/WASH ALL TRAILERS" Or
[recShortName] Not Like "bnsf*",Nz([bilUnit1],0)+Nz([bilUnit2],
The field is calculating in each record whether or not recShortName
matches or not. I would like some guidence on how to arrange to
statement with the proper syntax and logic.
The goal is to find to records where [recShortName] does not equal "sm/
TRACTORS" or...Matching function or no match
I am using this formula to compare 2 list to see which numbers are not
included in both column A and Col C. The formula I am using below pulls out
the ones that i do have a match . Is there another function that I could
use that would only pull out the ones that there is not a match?
"Donna" <email@example.com> wrote in message
> I am using this for...Client E-Mail and Web E-Mail not matching
I've got a few complaints from about 4 users where e-mail they see in their
Outlook Client is not showing up in their Outlook Web Client when they check
their e-mail from a remote location.
We're using Exchange 2003 with SP2 installed and all the users have Office
Outlook 2003 with SP1 Installed also.
This seems to only have been a problem since we upgraded to Exchange SP2 two
weeks ago. (Although I can't confirm it, but I wasn't told of any problems
before th upgrade.)
We had to upgrade to SP2 because of the 16 Gig limit so rollback is not an
Best as I can t...Matching cells #3
Here's my spreadsheet:
A B C
1 1 1
2 3 3
3 4 6
4 5 10
5 8 11
How do I get the matching numbers on the same rows, like:
A B C
1 1 1
3 3 3
10 10 10
I would just re-create the columns.
1. Copy column A into D.
2. In E1 put:
3. Copy it over to F1 and then down as far as needed.
4. Select columns D thru F, copy them, and go to Edit >
Paste Special > Value. Press OK.
5. Delete column A thru C.
Can I have more then 1 contakt to contact relationship like contact to
company, manager, assitant
Nope - its not possible to add any new relationship between two "system"
(out of the box) entities
"Paul" <Paul@discussions.microsoft.com> wrote in message
> Can I have more then 1 contakt to contact relationship like contact to
> company, manager, assitant
...Lookup Formula: Return 1st match, then 2nd match, then 3rd match
I have a spreadsheet that looks like the following. Tab 1. Col A=Name. Col B
Bob Reconcile Cash
Tim Do Sales Report
Bob Create presentation
Tim Prepare financial statements
Bob Hire staff person
Now on tab two, I want to create another list that pulls all the tasks
together by person. For example, Tab 2 would look like this:
Bob Reconcile Cash
Bob Create presentation
Bob Hire staff person
Tim Do Sales Report
Tim Prepare financial statement.
I realize I can just sor...Can I have each series be a different field in a Pivot Chart?
I'd like to create a stacked column chart using a Pivot Chart. But each of
the series that I'd like to stack are in different field (columns) in my
source data. Is it possible to do this? I can't rearrange the source data,
because then I'll exceed Excel's 64K row limitation.
I am quite sure you can do it, but need more info about your set up before I
will be aboe to give any recommendations
Where is the data for each series?
> I'd like to create a stacked column chart using a Pivot Chart. But each of
> the series that I'd...Index Match Functions
Has anyone ever combined the Index and Match functions to do lookups?
...Not matching transactions
I have it set to not automatically do anything. I've tried resetting the
account quite a few times with the help of technicians, but it's too long and
involved, and I'm tired of rebalancing the account every time.
I have 3 accounts, 1 works without passport and does fine. One of the
others I can manually download from the web site, and have no problems doing
it like so and decided this is the best way, prior tries it wouldn't work
with passport. But the other still insists they are new transactions, and I
can't download from their site directly. They only allow...data in row didnt match import type 12-30-05
while importing almost 800 accounts , i got the following error for majority
'Data in row did not match the import type'
what is the solution? How can i match it? whats is the way of comparision?
It looks like a data problem.
You need to check if all dates are correct (and filled), if numbers are
numbers (not letters), etc...
Erik van Hoof
Check our weblog at: http://www.cwrmobility.com/weblog
"Aam" <Aam@discussions.microsoft.com> wrote in message
> while impo...Manually matching transactions
Hi, I'm new to Money 2007 so maybe this is an easy question but I don't find
an answer after searching help and recent posts. I have setup a checking
account and a bill for Tuition. My transactions are automatically downloaded
to my checking account. One of these transactions was my Tuition payment,
but the bill still shows as being past due. Can't I simply mark that
transaction as being a Tuition payment somehow? I'm sure I could record
payment from the bill with the same info as that transaction has then delete
the downloaded transaction that wasn't associated ...Referencing From Nested Subform to Parent Table A97
I have a nested subform >
MainForm > TabPanel1 > Subform1 with TabPanel2 > Subform2
Record Source for SubForm1 is my MainTable!ID (MainTable also the
source for MainForm)
I need to link the Subform2 data to the relevant ID of the MainForm record.
I am getting a link to the first record ID in the MainTable but I am
obviously missing something in linking to the 'Current Record' in the main
Any suggestions on how I should proceed to get the reference right (and
where to put it!!)
Keep it Clean now... ;-)
"SteveM" <St...Second Post: Refferencing Nested SubForms
Hi Folks - really struggling to workout how to reference my MainForm from a
Nested Subform. Here's my structure:
>>SumForm1 on TabPanel1
>>>TabPanel2 on SubForm1
>>>>SubForm2 on TabPanel2
(Reason for this structure is because of the need for nested TabPanels)
I need SubForm2 Master/Child references to reference the MainForm
Currently, by simply linking SubForm2!fc_id to MainForm!fc_id I get the 1st
record from the MainForm recordsource regardless where the cursor is in that
I have tried using a reference...Automatic population of a field in an input form
I have been away from Access for a few years, so I am struggling with a
problem which I'm sure is an easy fix. I am working with Access 2003, and my
form has a field for a Customer ID number. When that number is put into the
Customer ID field, the Customer Name is supposed to automatically populate
the Customer Name field as soon as I tab into that field. I am working off
of one table to accomplish this. Is this accomplished with the criteria
section of a query, and if so, how? If now, can someone please walk me
through the steps to accomplish this.
If I unders...This forum does have value!
As year end approaches and I am considering upgrading to Money 2005, I found
the message traffic extremely valuable. After this summers fiasco with the
update to MSN Money locking us out of our local data file, I thought, or was
hoping M$ would make an extra effort to make sure that Money 2005 was a
significant improvement and without the assorted problems that I have found
posted here. Some still unresolved.
I have made my decision and I do not care how much work it is going to take
me, bt I am going back to Quicken after giving Money a two year trial. This
program is just not ready f...How does MATCH handle a Non-Match?
I would like a steer on how the MATCH Worksheetfunction behaves if it
doesn't find an exact match of values in the array it is searching.
I am looking through a series of Dates and instead of picking the
nearest one - which I need and seems most obvious - it seems to pick
the previous one.
I.E. - Searching for 14 Oct 2005
In a list which contains (among others)
15 Sep 2005
16 Oct 2005
And it picks the 15 Sep row!
PS. Cell values are actually 14/10/2005 but formatted as above.
In Excel's Help for the MATCH function, it describes how the values are
> I w...Index, Match, Min and Max question
I'm trying to retrieve a date (in column A) that corresponds with a
Min and Max amount (in columns B:D). Basically I need to know when my
amounts hit their Highs and Lows. Can someone help me with this
Dates in column A; values in B
Returns the date corresponding the max value in B
Is this what was needed?
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
<firstname.lastname@example.org> wrote in message
>...Scatter chart without numerical values
For some time now, when I create a scatter chart from tabulated (numerical)
data, the chart does not display the x/y values, but the serquence numbers
instead. This is similar to a bar chart, but should'nt happen with a scatter
The scatter charts have worked ok in the past. I'm using Excel 2000 in a
company office environment where I have little control over the Excel
Are you really making an XY chart?
If you make a Line chart with two numeric columns AND the first row have
labels, Excel thinks both columns are y-data and uses 1,2,3...version matching
Do both people have to have the same version of Outlook running in order for
Tasks and Appointments to sync up properly when emailed between clients?
I'm seeing some irregularities between someone running Outlook in Office
2000 and mine which is part of Office 2003.
Appointments with reminders sent from Office 2002 or later will show up as
text in Outlook 2000 unless a hotfix is applied to the Outlook 2000
installation. Besides this issue, I am not aware of any others except for
..pst file type incompatibilities, easily solved on the 2003 side.
Milly Staples [MVP - Outlook]
...Matching cells by content then cell fill with color
Thanks to JEM, I am using this routine to color three consecutive cell
a specific color, in this case red:
Public Sub ThreeCellsRed()
ActiveCell.Resize(1,3).Interior.ColorIndex = 3
What I need now is a way for the routine to continue to find all th
similar cells, let's say for sake of disc they are people's names, s
when I execute the above on my name, mrh, I want it to continue in th
worksheet and find all exact matches and color those same cells red.
Another thought, say my name (MRH) is in "A1" and it is also in "D1".
But in "D1" I use "...fuzzy logic matching in Excel
Is there such a thing as fuzzy logic matching in excel?
For example, if I have
Name Addr1 Addr2 Addr3
Davie Kings Road London England
Davie Kings Road - London
This should match as a potential pair. How can I do this in Excel?
Nothing built in.
> Is there such a thing as fuzzy logic matching in excel?
> For example, if I have
> Name Addr1 Addr2 Addr3
> Davie Kings Road London Eng...display fields center
Is there a way to display the fields to be aligned center or right or
left in a grid view. I dont see any
properties to center a fields. Any ideas without changing style sheets
This level of field control is not available in a supported fashion
Microsoft CRM MVP
<email@example.com> wrote in message
> Is there a way to display the fields to be aligned center or right or
> left in a grid view. I dont see any
> properties ...BOM Cost Field
I am trying to create a report that shows Current Costs in the Item
Maintenance form and BOM Cost from the BOM Entry form. Does anyone know what
table holds the current BOM Cost field?
If you are referring to the Manufacturing BOM, I believe that window just
uses the current cost from item maintenance and is not stored in any MFG
tables. I could be wrong though...
> I am trying to create a report that shows Current Costs in the Item
> Maintenance form and BOM Cost from the BOM Entry form. Does anyone know what