I need elegance.....
I'm stumped and asking for elegance here....
I have a table that doesn't scale in a linear fashion
(it is for use with computing the langolier pool water index)
when I check the water I get a test result to compare to my table,
and I then take the result from the other side for further computation
what I want is for a test result like 35- I'd like to get a formula
response that is .06
so I'd like a formula that finds
which two table numbers it...I need to touch and loop
Very simply, I have a form in a very complex application I've
inherited. On that form is a date field which, if changed, fires off
all the action I need to do (a LOT of it) in the access form. (This is
a Jet database, not real triggers.) It's set by a lost_focus even
that checks the value.
However, I need to do this for several hundred records so I want to
automate it from a separate form. I can change the value, but it
doesn't fire the changed event. I tried creating a public procedure in
the target form to call the update event procedure, but my calling
form can't seem to...2002 vs 2007 MS Office Excel has encountered a problem and needs t
I have an Excel file with VBA code that was running fine in version 2002.
When I switched to version 2007, it now gives me intermittent "Microsoft
Office Excel has encountered a problem and needs to close." My choices are
to Send Error Report or Don't Send. It also has a check box for recovering
the file. I posted this issue before and it was decided that perhaps the
file was corrupted, so I rebuilt the file in the new version from scratch.
No change in the problem...ouch! So I'm going to post this code again in
hopes somebody will have an idea about how t...Need help: The name could not be resolved...
Using Exchange server 2003 as server and Outlook 2000 on Win 98 as client, I
receive an error message titled "Microsoft Exchange" stating "The name could
not be resolved. The operation failed." when I click on Check Name button.
However, I have no problem with Outlook 2003 on Win XP.
The workstation is part of and logged on an MS domain. I can ping the
Exchange server successfully.
Please help me if I am missing anything. Thanks a lot.
Need help: The name could not be resolved...
Mike Cello <firstname.lastname@example.org> typed:
...fill a cell based on another cells value
can i fill a cell with a color based on a value from another cell?
Use Conditional Formatting.
Gary''s Student - gsnu201001
> can i fill a cell with a color based on a value from another cell?
i looked into that but it all seems to be based on your filling the cell with
the value. i need to fill a cell based on a value from ANOTHER cell. if you
know what condition to use, it would be appreciated. thanks.
"Gary''s Student" wrote:
> Use Conditional Formatting.
> Gary''s Student - gsnu2...IE9 needs download folder management.
So it's easy to download to standard folder.
It's like this you cock sucking son of bitches:
Every PC in the world needs it.
And then you simpy make:
Then you give website developers an option to tell you what kind of junk it
is that you downloading
so it automatically goes to the correct folder.
You don't need to be einstein to do that do ya ?!
Son of bitches ! ;)
Option to specify junk fol...Payroll
Has anyone done a conversion from Achieve Payroll to GP? We have a client
that is looking for a reference.
...want to buy microsoft office package and i need your help
I'm new to this amazing group, I need your help
I want to buy the microsoft office package that includes word 2007,
Excel 2007, PowerPoint 2007, and Outlook 2007 from Amazon and the
price really cheap from what I saw
But I want to ask you whether good price should I buy the software
from the site?
On 12/16/09 5:06 PM, in article
email@example.com...Payroll checklist 2008 payroll close
I have a question on the procedures for 2008 payroll close
1. We already created our year end wage file, step 7, step 8 we did our back
up, step 9 is in process, on steps 10 and 12 if I do this does this affect
the year end wage file already created?? We did not print w2s yet, when i
clear in active employees in step 12 does it just affect process going
forward and not the wage file I already created, I am new at this and this
ism our first gp 10 payroll close.
Further to the answer below, I need the following in one formula! Thank you
If Cell A1(Text) = X or Y or Z and Cell B1 is Mon or Tue or Wed or Thur or
Fri then multiply Cell C1(Number) with (£17.00) into F1(£Total) but
If Cell A1(Text) = X or Y or Z and Cell B1 is Sat then multiply Cell
C1(Number) with (£20.00) into F1(£Total) but
If Cell A1(Text) = X or Y or Z and Cell B1 is Sun then multiply Cell
C1(Number) with (£25.00) into F1(£Total) but
if Cell A1 = V and Cell H1 is between time (0001-0700) then multiply C1 with
(£15.0...I need help or an app
I have Office 2007 and I was wondering if anyone knows of a way to physically
sign a document on a touchscreen pda or computer? I know I can write on my
pda with notepad and I know you can esign with adobe but is there a way to
sign a words or adobe file physically?
If you have a graphics tablet or a tablet PC, yes. If not, you could scan in
your signature, save it as a graphic, and paste it into any file.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"redbobo" <firstname.lastname@example.org&g...Vista 64 bit
OK, I am so completely feed up with Vista and have been wanting to
upgrade to Windows 7, but now my external hard drive has completely
failed and was never working correctly with Vista anyway, because of the
64 bit issues so now I need to spend the money on a new external hard
drive instead of upgrading to 7.
So here's my issue: I understand now that the 64 bit issue was a
software/driver issue and not a hardware issue. I was using a Maxtor
OneTouch 4 Plus with an XP machine. The Xp machine died and I got a
Vista machine (right before the free upgrade to 7 started. Dang it!).
I am stuck. I tried so many different things to no avial.
I am getting linker errors when I try to access methods in the .cpp =
It works fine if access the method is in the .h file.
x =3D GetPenthouse()->CallingPenthouse(); //Works because it is a Top =
x =3D GetPenthouse()->CallingMezzanine(); //Fails. Method in =
x =3D GetPenthouse()->CallingBaseInHeader(); //works. Method in Base.h =
*Note that I am using a nifty way of importing/exporting methods from =
I found on Code Project.
The following must be added to the stdafx...I need to pull out a users email from Exchagne 2003 and put it into a .pst
I think I'm supposed to use ExMerge.exe, but when I try to run it, I get
"This application has failed to start because EXCHMEM.dll was not found.
Re-installing the application may fix this problem".
I found the application at:
I installed it into "Program Files\exchsrv\bin"
"Galvanon" <email@example.com> wrote in message
> I think I'm suppose...Allocating Tips in Payroll
In one of the forums, someone asked me several questions regarding tip
allocation using GP Payroll. I posted an article to my blog that goes
through the entire calculation, but now I cannot find the thread where the
question was posed.
So, if you are still out there. . . the article was posted to :
...Help needed with writing files in binary mode.
I need to add writing a binary file to my application and I haven't had much
experience with writing files. I've been trying to understand and use
examples found on the web and here is what I've been working with.
Dim i As Integer
Dim nFileNum As Integer
Dim sFilename As String
sFilename = "C:\Temp.bin"
Open sFilename For Binary Access Write As #nFileNum
' Put data in the file
For i = 0 To 15
'Write #nFileNum, , i
Put #nFileNum, , i
This works but when I look at the file usi...PAYROLL TAXES
I have Microsoft Money 2004 and cannot figure out how to
enter a payroll expense. I need to have gross pay- taxes
and net pay showing as the actual amount of check.
Please help- email firstname.lastname@example.org
Have you tried the special category Paycheck? Look in the sample file or
read in help about Paycheck.
<email@example.com> wrote in message
> I have Microsoft Money 2004 and cannot figure out how to
> enter a payroll expense. I need to have gross pay- taxes
> and net pay showing as the actual amoun...Help needed tweaking the "randbetween" function
I am using the following =93Random Between=94 formula, =93=3Drandbetween
(0,1).=94 As expected, I=92m getting =930=94 approximately 50% of the time =
=931=94 approximately 50% of the time. Is there a way in Excel 2008 that I
can get the results to be a little less random; say get =930=94 53% of the
time and =931=94 47% of the time?
"Ed" <firstname.lastname@example.org> wrote in message
I am using the fo...Outlook 2003 with Business Contact Manager SNAFU
I just installed Outlook 2003 with Business Contact
Manager. My OS is Windows XP, and I'm running Office XP
in addition to Outlook 2003 only (I installed Outlook
2003 over 2002 or XP version). Business Contact Manager
will not allow me to autolink or manually link emails or
other items to my business accounts or contacts. When I
attempt to autolink, an error dialogues says: " An
unhandled exception has occurred in a component in your
application. Click continue and application will ignore
this error and attempt to continue". However, it crashes
every time. Attempt...Need Help Please
How can I CREATE a powerpoint 2003 background (color scheme)?
Can you be more specific about what you're trying to do? A background can be
based on a color scheme, but it doesn't have to be. So I'm not exactly sure
what you're really asking.
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx
"kpickren" <email@example.com> wrote in message
news:6F8849...Need help with Rules
Using Outlook 2000-
One person's email is continually moved to the delete folder... his name is
Jose Cardenas... and I have not been able to figure out what is triggering
it...I do have a rule set up to delete the odd characters that we were once
spammed with (from overseas) years ago, but I do not see any of them in his
name/email address- ex: 'e, etc...
Where can I look further? Thanks!
Delete that rule. The Jose probably has an accent that you don't see. You
should also add his name to the list of Safe Senders.
"Uncle Vinnie"...Forms Based Authentication
This is my second try sending this message. I sent one earlier today, but
for some reason it never showed up? I sent it in this news group around 9.52
AM CST. Using Outlook Express. Bunch of other messages are coming through
after my message, so here I go again, just in case it got lost somehow?
(Even tried to unsubscribe to the newsgroup and add it back but no result.)
We don't use Forms Based Authentication currently. If we turn that on,
will/could it cause problems to anything else? Any reasons to why not to go
with Forms Based Authentication?
We are using OWA, Outlook remotel...Excel 2003: Charting Two Datasets with Different Sampling Rates (T
My problem may seem simple to some, but it has me a bit perplexed.
It has to do with comparing two different sets of financial data (both
already in Excel 2003) on to a single chart, but their sampling rates are
different (time and money).
1) X-axis (Time): One is sampled weekly and the other is monthly.
2) Y-axis (USD): One is in native USDs and the other is in USDs (x1000).
Is it possible to create the chart referencing the datasets thru links or
will I need to bring copies of the data sets into a single file or worksheet?
If so, please tell me how?
How can I simply get these two d...ebook needed
Has anyone here "Microsoft Excel 97 Developer's Kit" in ebook variant? or where
I can buy such version of this book?
You can still get this title at "www.megabytebooks.com" for ?12.50.
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
"Alex Kucherenko" <firstname.lastname@example.org> wrote in message
> Has anyone here "Microsoft Excel 97 Developer's Kit" in ebook variant...Outlook and hosted Exchange for very small business: general advice wanted
I have a very small small business -- three PCs
I have used a POP mail service with Outlook 2000 and used net folders to
I am thinking of upgrading to Outlook 2003, and moving to a hosted Exchange
service for e-mail.
I have never used Exchange for email, and am having a little trouble even
knowing what to ask potential service providers.
One concern I have is about how I would keep email archives. I understand
that Exchange synchronizes what appears in my Outlook folders with what is
on the Exchanger server. One service I am looking at keeps deleted items
for 30 days.