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.
----=...Copying data from one chart to another
I have many graphs - all plotting on similar scales but using different
data. Is there any way I can simply copy one set of data from one graph
and paste it into another graph so that I can avoind going through all
the hassle plotting each curve again? I want to have graphs showing
different combinations of the same data and have hundreds of curves to
plot so this could be a huge timesaver...
Alan_Partridge's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29295
V...Text to columns
Once I use the Text to columns feature in Excel, it seems there is no way to
turn it off.
Anyone know if there is a way to reset this so that newly pasted text will
not continue to get broken up (for example by the space delimiter)
Presently the only way is to exit Excel and restart Excel - then pasted text
all goes into one cell regardless of spaces.
Hope I explained that well enough
I may have been to hasty in making this assumption, it appears that the
problem I described below is only happening on one workstation - this may
indicate that the Excel Registry keys are in need of...Can I abbreviate one value in a data series?
I've got a chart where one value (8,300) greatly exceeds all the others. Is
there a way to abbreviate this value so the other data points show better in
One way is to break the Y axis, have a look at these examples of how to
> I've got a chart where one value (8,300) greatly exceeds all the others. Is
> there a way to abbreviate this value so the other da...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 ...Simple Question-How to create more than one transaction on the Acc
If there is a question already posted let me know. The question is: I created
a bank account information on the Account list icon and want to have more
than (one)transactions listed and see each payee displayed separately on
each page so i could have all the months posted with due dates and total
listed. Thank you.
In microsoft.public.money, a.j. wrote:
>If there is a question already posted let me know. The question is: I created
>a bank account information on the Account list icon and want to have more
>than (one)transactions listed and see each payee displayed separately ...Solver add-in and macros
I just got a new computer with XP and Excel 2003 and
tried to run a macro that used to SOLVER add-in function
and got a compile error. As a test I recorded a macro
using the SOLVER and got the same result when I tried to
run that macro. The Compile Error is "Sub or Function
not defined". On the Knowledge Base it says I need to
add SOLVER to the list of References in the VB Editor.
When I go to the references list, SOLVER does not
appear. When I open Help for VB and search for SOLVER,
it finds nothing. What is going on? Why doesn't VB even
recognize the existence ...How do I add a signature
We have our purchase orders created in excel and we would like to add a
"handwritten" signature" to them. How to I do this?
If using xl2002 or 2003......
Create a graphic with the signature then add it to the Footer when printing.
Gord Dibben Excel MVP
On Mon, 14 Feb 2005 09:03:08 -0800, "Penfold"
>We have our purchase orders created in excel and we would like to add a
>"handwritten" signature" to them. How to I do this?
...How to add new entity?
I'm now researching the customization abilities of MS CRM 1.2.
So I have a small task, which I'm not able to accomplish with SDK.
The main question is how to add additional entity to CRM?
I need to add entity "Pets", and dictionary "PetTypes".
Pets should be linked with Contacts (1:M).
Pets should have 3 attributes:
- Name (string of 150 chars),
- Type (value from PetTypes dictionary),
- Description (string of 1000 chars)
PetTypes should have 3 entries: "Cat", "Dog" and "Parrot"
I expect that i...How do add another code to a current one?
I have this following code to make the rows changed based on the critea in
column 16, and I need add A "Red, Yellow, Green" for status to only one
column 30 at the end of the spreadsheet. How do I add another code? I keep
getting an error..
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range, clr As Long
For Each c In Target.Cells
If c.Column = 16 Then
Select Case c.Value
Case "Analyze": clr = RGB(204, 255, 255)
Case "Build ": clr = RGB(204, 255, 255)
Case ...Office 207 One Note
My One Note has been working fine for at least 2 years. Then a couple of days
ago two pages of my most important information in my main workbook just
I'm not sure but none of the other pages look the same. Does anyone have any
idea what might have happened? Have had no other computer problems recently.
-------- Original-Nachricht --------
> My One Note has been working fine for at least 2 years. Then a couple of days
> ago two pages of my most important information in my main workbook just
> I'm not sure b...Add a blank page separator
How do I add a blank page automatically as a separator after every 15 pages
when printing a document of 250 pages?
Use a macro containing the following code to print the document:
Dim i As Long
Dim blank As Document
For i = 1 To 240 Step 15
ActiveDocument.PrintOut Range:=wdPrintFromTo, From:=i, To:=i + 15
Set blank = Documents.Add
Hope this helps,
Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to obtain my services on
a paid professio...how can I add a signature to my calendar appt requests?
See subject question
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
"tnowak" <firstname.lastname@example.org> wrote in message
> See subject question
...Formula to find last monday (tue, wedn, thu or friday) for a given month
I need a formula to calculate the date of the last monday, tuesday,
wednesday, thursday or friday of a given month.
Can't seem to find the answer anywhere.
day: wednesday (or corresponding nr)
Who can help?
Thank you for reading and eventually answering my question.Back
Microsoft MVP - Excel
"Michele" <email@example.com> wrote in message
> I need a...Bulk sending of emails in Outlook being rejected if one address is wrong.
I am sending bulk emails in BCC and they are all being
returned to me because one or more of the email addresses
is incorrect. Is there a way to setup Outlook so that the
emails go to the correct addresses and the incorrect
addresses are bounced back to me?
I use the Mail Merge feature and send out a newsletter
with over 1000 e-mail addresses (who signed up for the
newsletter so it is not spam). My service provider,
Comcast, just put a limit of 10 at a time. It's real fun
sending these out monthly!!
>I am sending bulk emails in BCC and they a...Add data to cell w/o loosing initial data
I would like to know if there is a way to add data to data without retyping.
For example I have a colum of 18015555555 and I want to add [rfax:(cell
#)@/fn=(phone number)] So I would like to add the brackets - copy from a
cell - @/fn= and not loose the data already in the spread sheet. Example 2.
Add [rfax:company name@fn/=(saved data here) then close bracket.
So I want to add data to cells without loosing the data already in the
cells. I have about 600 of them to do and I really don't want to do each one
Please let me know if anyone knows how to accomplish this.
Tha...one company doesn't show $ amounts in payables for one user
I have a user who has access to multiple companies. The access for all
companies is the same. In one company when she goes to
Inquiry>purchasing>trx by vendor, the display shows $0 for all transactions.
Other companies, she sees the correct $ amount. There are no modified
windows and again her security is the same for all companies. Can anyone
tell me why this is happening?
I am having this exact problem and would appreciate a fix. I have to change
users to have the payables inquiry amounts show. I only have this problem
in one company and I am the only user in our of...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.
...Prevent copy and paste in one column
I am having trouble trying to prevent copying and pasting in one specific
column. The code refers to the specific range, but yet it prevents copying
and pasting on the whole worksheet.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Columns("H:H")) Is Nothing Then
Application.CellDragAndDrop = False
Application.CutCopyMode = False
Application.CellDragAndDrop = True
Works for me in Excel 2003
Gord Dibben MS Excel MVP
On Fri, 30 Apr 2010 11:42:01...how do I turn off journal for one file #2
I have a number of excel files that run regularly. I how can I turn of
individual files so they don't clutter my jouranl in Outlook?
Here is a simple question and I cannot find the answer.
On a report I have a text box [Text301] and when display I see
I would like to add something like 35 other text box so month would
increase by 1
What could be the formula for [Text302] to display Mar-07 or Mar
2007. The formula should be issued from [Text301]
Then [Text303] related to [Text302], [Text304] related to
So the day I change [Text301] for let say Apr-08 [Text302] would give
me May-08 [Text303} would be Jun-08, etc...
I dont realy care with the format; it can be Mar 08 or Mar-08 or
Mar-2...win7; money plus deluxe; monthly report failures
When using Microsoft Windows 7 and Money Plus Deluxe v184.108.40.2065. I'm
trying to prepare my monthly reports. I get the error,
"Money requires Internet Explorer 6 to function properly. Please reinstall
Internet Explorer 6 so these components can be added".
Win7 has IE8. IE8 > IE6. Shouldn't this work? I searched for this error
elsewhere and couldn't find it, or its resolution. Any tips/tricks would be
P.S: I know Win7 is Beta and that with Beta's come issues like this...
I have the same problem and I wish there was a fix for it. Does anyo...Add Item to GP Menu
Does anyone have instructions on how to add items to the GP menu? I believe
it can be done with Dexterity, but I have no idea what file to modify or how
to use Dexterity.
> Does anyone have instructions on how to add items to the GP menu? I believe
> it can be done with Dexterity, but I have no idea what file to modify or how
> to use Dexterity.
Please look at the Integration Guide PDF manual installed with Dexterity.
Part 5 explains the navigation model and how to work with command forms,
commands and menus.
T...Capturing the ItemID from the Add function.
Can anyone tell me how to capture the ItemID (referenced by the Add function):
Dim objAdded As Object
set objAdded = Session.Transaction.Entries.Add(ItemID, ItemLookUpCode, Qty,
0, False, 0).
I tried the following and am getting an error:
Dim itemid as Long
itemid = Session.Transaction.Entries.Element(entrynumber).Item.ID
The itemID referenced in the add function seems to be the itemID from the
database and not the entry ID on the pos screen.
You can do a query on the Database using the ItemLookupCode.
Use the code I posted a couple of days ago then ...Add Actual End Date to Resolved Cases view
We would like to add the actual end date to the Case General Tab or possibly
to the Resolved Cases and/or My Resolved Cases view. I know that the Actual
End Date is available on the Service Activity and Case Resolution but this
field is not available for the Case.
Any workaround for this?