multiple CD's, same bank
I've got multiple CD's opened up at the same bank. They are all under the
same account number, but each under a separate heading. Each of the CD's
mature at a different time, and they will be rolled over into new CD's over
the next 18 years. Futhermore, my bank provides online banking services
directly within MS Money, including automated download of statements.
So...what would be the best way to set up these accounts in Money? Should
I create one account named CD and then make a cash transaction for each CD?
Should I set up each CD as an individual investment accou...Update one table from another
I am trying to update one table that has one record for each employee(table
1) with available vacation time. The other table records every time off
request(table 2) and how much time they want off. I have the update query
and it works fine. The problem is that everytime it is ran every requested
time off amount(from table2) is subtracted from the available time(table1)
again and again. I want the records for requested time(table2) to update the
employee available time off(table1) only once, but keep the records on the
table as that is the basis for a report.
----=...Creating a table
There's probably an easier way to do it but...
I have a series of numbers in column A (150 in all) and a series of letters
in column B (22 in all). In total there are 4800 rows.
What I am trying to do is create a table with the number down the left hand
side and the letters across the top. In each cell within the table I need
to count how many times the combination of number/letter appears. Eg:
A B C
201 0 2 2
202 3 0 1
203 3 6 4
I tried combining the number/letter into a single text field using the
CONCATENATE function then filtering ...what is the function and name is of the symbol in each table cell.
Under Paragraph I clicked the Show/Hide Symbol icon so I can now see a
symbol at the end of each text within a table cell.
I wondered what that is so I tried to use Help to find out.
I did find help that mapped a word (like paragraph) into a symbol.
But I can't find anywhere where if I know the symbol it will tell me the
Can you tell me how to find such info?
Or maybe you can tell me what the function and name is of the symbol in each
I'm sorry, I meant to sent this to the Word group.
Of course, I wouldn't mind getting the info...One Entry to Multiple Rows
I have data that looks like this:
X1 | Y1 Y2 Y3 Y4
X2 | Y4 Y5 Y6 Y7
And I need to get to:
X1 | Y1
X1 | Y2
X1 | Y3
X1 | Y4
X2 | Y4
I can change the 2nd row's entries to more columns, but that doesn't seem to
get me much closer to the needed format (and there are thousands of lines so
I'd rather not do it manually). Any ideas?
should do it. change mc to suit
Dim mc As Long
Dim mr As Long
Dim i As Long
Dim lc As Long
mc = 3 'col c
mr = 1
For i = 1 To Cells(Rows.Count, mc).End(xlUp).Row
lc ...Array Formula #7
I have an array formula that works correct up to the 20th row. It quit
running on row 20 or it does not pick up any information after row 20.
Any help out ther
pete5761's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2961
View this thread: http://www.excelforum.com/showthread.php?threadid=49427
Rather impossible to tell...
What's the formula, and what cell(s) is it entered into? What type of
data is in any referenced ranges?
In article <pete5761.205n5a_1134773401.141...Downloading multiple messages
All of a sudden outlook has started downloading multiple
messages from my pop account (ie 22 of the same)
It is also sending out 22 of the same message.
How can I resolve this issue?
What version of Outlook do you have? Does it download duplicates of *all*
messages, or just of one or two messages?
This posting is provided "AS IS" with no warranties, and confers no rights
"GW" <email@example.com> wrote in message
> All of a sudden outlook has started do...Finding all queries which use a table
Does anyone know of a tool that can scan all queries in a database and find
if a certain table is used? I have a table called tblCustomerRollup which is
old and outdated. I want to see which of the 500 queries in my database use
this table without opeing every single one of them?
Sounds like a variation on Search/Replace. Try searching online for
"Database Documenter" as a starting point.
A couple of the commercial tools I've used include FMS, Inc.'s Total Access
Analyzer and Black Moshannon's Speed Ferret. There are a lot of fr...How to write a new entry in a combo box to its underlying table
Dear Access 2007 VBA Gurus,
I have a assets database (rather uncreatively named "Assets"). I use a form
(named "Asset Acquisition Input Form New") to enter new assets. The
"Manufacturer" field (combo box name "Manufacturers_ID) on this form is a
lookup to a Manufacturers table. What I want to happen is when I enter an
item that is not in the lookup list, I want a message box to prompt me to add
the new entry to the underlying table, or to cancel and select an item from
the list. I have no trouble with the MsgBox command itself. What I don&...Keeping a table in a form editable and checking that fields are filled in before allowing a save
Firstly apologies if this is the incorrect forum but I was looking for
a general word forum and could not find one. Please point me to one if
I am trying to create a form where I want to specify what items need
to be filled in. (Review minutes from design reviews). I want to make
certain fields mandatory like the date, attendees and check list used
and want to block saving of the document with a warning until they are
filled in. Is there a way of doing this?
Also as a part of the review actions are filled in to a table.
depending on how many actions there are the table...Right click in Pivot Table or on Entire Column
I have added items to the right-click menu that popups up when you have a
cell or cells selected. But when you are in a Pivot Table or have an entire
column selected the right-click popup is different.
Is there a way to add an item to the right-click popup menu when you are in
a Pivot Table or have an entire column selected?
Thank you for your help.
Never mind. This one was right in the help section. I should have looked
> I have added items to the right-click menu that popups up when you have a
...FP: Couldnt close table
We have been receiving this error on two separate PCs
after a recent upgrade to 7.5. Our version is 7.50g43
(service pack 5). At first we thought it was isolated to
one PC now a second PC is having the same error. On the
first PC, I ran new network cable, installed a different
network card with no help. This PC is Win98, 64MB RAM,
600Mhz. The second PC has 128MB RAM also Win98. I don't
believe switching to XP is an option right now. This
message has appeared in the payables module on both
machines. But it has also appeared in receivables as
well. Not in GL or Payroll. I...Same Table cannot be the child table in two nexted relations...
I've been setting up a schema with the XML Designer in VS .NET 2003.
The designer lets me set up a lot of things including a complex type that
contains an unnamed complex type called modified.
When I try to preview the dataset, I get an error described as "The same
table (modified) cannot be the child table in two nested relations.
I've run into this before with a different complex type, and I've changed
the name of the instance of the type in the various elements it's used, and
the problem goes away.
In this case, problem is an unnamed complex type, so it only a...Pivot tables and Macros
I was looking to be able to manipulate (ie change selections from the
drop downs, not change the fields in the table or anything)and print
from a pivot table using a macro.
So how do I go about doing that?
When I set up a macro by recording the actions that I want to do, I
always get an error message when I try to run it as a macro.
What specific steps are you recording, and what error message do you get?
Can you click the Debug button, and see the line of code that is causing
Dust For Eyes wrote:
> I was looking to be able to manipulate (ie change selections from the
>...How to copy aQuery to a new Table?
I have a database in a Table, a report based on that same Table and a Query
based on that Report.
After two months or so I like, after some new data input, to save the Table
into a new Object Table. What is the best way for the Report and Query to
follow the new Table whitout recreating the original Report & Query?
Thankyou for your comments. I use MS Office Access 2007.
>>I have a database in a Table, a report based on that same Table and a Query
based on that Report.
Your phrasing is wrong when it comes to the elements of an Access database.
A dat...Calculating Correlation using arrays
I have a sheet full of data for many products in chronological order.
Column A is Date of manufacture
Column B is time of manufacture
Column C is the product
Column D is a measurement from the automatic control system
Column E contains occasional manual measurements for calibratio
Up till now I have split the data out by grade and checked calibratio
using pivot tables and also checked slope and offsets. After gainin
exposure to all kinds of clever functions via this board I now wonde
whether it would not be possible to automate these checks in some way
ie on a separate sheet I list t...Pivot Table in Excel
I have a problem using the pivot Table in excel 2000.
Earlier the location of the pivot table in excel was
pointing to say c:\sales.mdb. Now the location has changed
to D:\Sales.mdb. someone please tell me the place to
change in the excel to reflect the same. So that upon
refreshing the document i can see the latest data.
Currently i am getting a error message when i try to
refresh, but its not prompting to change to alternative
location. If i edit the excel file in a notepad...i can
see the location pointing to c:\sales.mdb.
Thanks in advance for any help regarding this..expect...obtaining data in text form from a table
I like to be able to obtain the dates in a text format from the table
Test6 4-Feb,5-Feb, 9-Feb
Do I need to do this by macros and if so, any help would be appreciated.
Care Recipient Surname 4-Feb 5-Feb 8-Feb 9-Feb
Test5 4-Feb 8-Feb
Test6 4-Feb 5-Feb 9-Feb
Vlookup should do what you want, as in:
Adjust the ranges t...Multiple Language Issues
Has anyone successfully manually updated a non-English supported 5.5 to
2003? (The reason for the manual update was a broken admin account.)
Mail and contacts were all exported to PST files, and then imported to 2003.
However, although the text of the messages is fine (English and Russian),
the text for contact names and message subjects gets gorched if they
contained any Russian text.
Does anyone know the correct sequence to follow to take messages and
contacts in Russian (or other languages) from 5.5 to 2003, while retaining
the non-English subject lines and contact names?
...Multiple Sales Transaction for Same Work Order
I am in the process of trying to create a store level report by department,
catagory, and item of the moneys received in total by both deposit on work
orders and on direct sales that are not work orders. We require a 100%
deposit (of a single tender type) on work orders. I then need to break this
deposit down by department, catagory and item. Then I must add that to the
same break down for direct sales. Thereby getting a total of all moneys
received during a specified period for the store across all registers.
So basically I am trying to figure out the data structure and org...Multiple Report Dictionaries
We just acquired another company and some of the modified reports will need
to be different than the ones we currently use. There are a few people that
will need to work with both companies in Great Plains. Is there a way to
change which reportws dictionary a company uses - or a user uses - without
editing the launch file?
You could have two installations of the client on the workstation. Each
installation would have a different dictionary file. The user would have to
pick the right one.
"MikeW" <MikeW@discussions.microsoft.com> wrote in message
news:...in Publisher I want to merge/send email with multiple attachments
Using Publisher 2007 I know how to do a merge and then email out from a list.
Publisher gives the option to attach multiple attachments to the email but
when the send actually goes out it only carries the first of the attachments
and discards the others.
Is there a trick to making multiple attachments stay attached? or is this a
Thanks to anyone who can clear this up..
Since you already know how to do email merges in Publisher 2007, you're
probably the ideal person to answer my question...I have been trying to do an
email merge using an existing publis...pvt table field settings!
i am receiving data every day from 10 different places as under.!
TOTAL NUMBER OF RECEIPTS 10
TOTAL OF RECEIPTS AMOUNT 1000
TOTAL NUMBER OF RECEIPTS 50
TOTAL OF RECEIPTS AMOUNT 1500
TOTAL NUMBER OF RECEIPTS 15
TOTAL OF RECEIPTS AMOUNT 1000
TOTAL NUMBER OF RECEIPTS 10
TOTAL OF RECEIPTS AMOUNT 1000
-likewise i'm receiving daily data from all the 10 places..!
what i want is a pivot table report on a...how to convert a CString variable to unsigned short array one?
In my unicode VC6 app, how to convert a CString variable to unsigned short
unsigned short strOleChars;
strOleChars = strRst; //???
Is ConvertStringToBSTR() what you are looking for?
"David" <David_Wang_Xian@hotmail.com> wrote in message
> In my unicode VC6 app, how to convert a CString variable to unsigned short
> CString strRst;
> unsigned short strOleChars;
> strOleChars = strRst; //???
> Thank you.
...Storing distinct values in an array
in the speadsheet, i have a column containing a series of numbers
maybe of them repeated multiple times...
i would like to store all distinct values in an array
any ideas on how i could do that ...
eg , if these were the numbers going down column then 1 3 5 7 5 3 5 7
5 4 3 4 5 7 8 5 3 .. store 1,3,5,7,9,4,8 in an array, in no specifi
shimeel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1583
View this thread: http://www.excelforum.com/showt...