Formula Help (to many expresions)
Could one of you give me a hand with this...
I'm trying to put a formula in a spreadsheet that has too many
expressions in it. I understand there is a limit to the number of
equations that can be in a formula but there must be a way around the
Or maybe another way to write the formula?
What I am trying to say in the formula is that if...
If X is less than 09 then B1 = what's in cell C2
If X is less than 25 then B1 = what's in cell C3
If X is less than 51 then B1 = what's in cell C4
The expression I have written looks like this...
=IF(X<10,"N/A",IF(X<...Access 2000 Package and Deployment Wizard problem!
I have created an Access 2000 application that I now wish to distribute to
users as an MDE file. The Access 2000 Package and Deployment Wizard does a
fine job of storing the relevant installation files on a CD, exploiting A2K
However, I would prefer to let users download my application from a website.
The Package and Deployment Wizard offers a 'Web Publishing' deployment option
that appears to address this need. My only problem is that it doesn't work
for me. I get the following error message,
Unexpected error number 48 has occurred: File not found: WebPost.dll
I...SQL Back-end / Access Front-end using linked tables????
I have a backend that contains tables that I pull Driver information,
Customer information , etc. (these are MAS 200 accounting software
tables that are exported nightly to the SQL backend). I also have on
the backend tables that I push information to; information that we
enter on the forms located on the front end. I might not have this
up correctly, but I'm linking all tables on the back end to the
database on the front end. When trying to set up an Auto Lookup off
a query I've created in Access it says I need to go into the table
change Data Type to the Lookup wizard,...autocomplete (like Access)
I'm trying to restrict the entry of data into cells based on values in a
What I need is similar to Data Validation but I want Excel to complete
the entry after the user has entered just the first character.
For example, In Microsoft Access, when creating a new table in Design
view, first you enter the field name, then tab across to Data Type.
Entering a "c" and then tab automatically enters "Currency" as the data
type. Similar for "d", DateTime; "t", Text etc.
So, in Excel, if I have a list, say, New York, London, Sydney, Tokyo.
How do I make my VS.net 2003 software not depend on
Use static linking. I don't know where to set the option in VS7, but it used to be under
Code Generation where you selected the desired C runtime library to use. In VS6 we had a
choice between a dynamically-linked runtime and a statically-linked runtime. I've not had
to make this choice under VS7 so I'm not sure where, in their overly-clever and completely
gratuitous reimplementation of the user interface, this has been hidden.
On Sat, 21 Feb 2004 22:24:56 GMT, email@example.com wrote:
&g...Data from Access query to Excel
To pull data from an Access 2003 database, I have created
the queries in Access, then import into Excel. The
problem is that all the numbers that are pulled into
Excel are text and need to convert them into numbers to
run formulas on. I have converted a few sheets by hand,
but, some have will over 50,000 rows. Is there a
function to select all number colums (the colums are the
same through out the sheets) and convert?
There are instructions here for converting text to numbers:
You can select all the columns, and only the num...Help with ShowFilter Macro
I'm trying to use this ShowFilter UDF written by Tom Ogilvy (see bottom of
post). It says to use...
....in a cell to show the criteria for Column B. For one thing, I don't
understand the cells B2 and B3 business. What is supposed to be in those
I would like this function to appear in the cell directly above or below the
Autofilter menu cell. How do I change the function if the Autofilter criteria
menu is in, cell A3, for example, and I want the criteria (this function) to
appear just above, in cell A2?
After trying all so...Help with automating file name
I have the following code that exports the below query to excell. I would
like the files name to include the month and date. How would I format this?
DoCmd.OutputTo acOutputQuery, "qryShopOrderSqFtShippedSummaryExport",_
mattc (at) saunatec [dot] com
Message posted via AccessMonster.com
> I would
> like the files name to include the month and date.
Uh, . . . the date _always_ includes the month, unless you're r...Please help with last formula for order form.
I am able to accomplish this with 1 column by the formulas below.
Cell H160 is the subtotal: =IF(SUM(H72:H111)>0,SUM(H72:H111),"")
Cell H166 the total: =IF(SUM(H160)>0,SUM((H160*H163)+H160),"")
Cell H163 is for Tax.
I am almost finished creating an order form. I would like to get the SUM
of 3 different columns that are separated. I am not able auto fill
strait down the column, because the information is separated in groups
with titles, and the cells are not identically sized.
I tried varations of this formula:
=IF(SUM(H72:H111)+(116:131)+(135:154)>0,SUM ((H72:H...Custom Menus in Access 2007
I know in VB 6 you can create custom pop-up menu. Is there a way to do this
in Access 2007? Active X? DLL? Hidden command that I can't find? Any
tutorials or direction? Any help or direction that anyone can provide would
In earlier versions, called "shortcut" menus. Right click on menu bar,
customise, show "shortcut menus" tollbar, select "custom".
don't know if that tollbar has changed in 2007.
"Jerry Sheldon" <JerrySheldon@discussions.microsoft.com> wrote in message
news:7431915F-33FF-4534-B5B4-C5E6F...Access 2007 Runtime 10-30-07
1. Can I distribute Accees 2003 applications using Access 2007 runtime?
2. Do I also need the runtime extensions?
3. Will installing the Access 2007 runtime and extensions affect my current
Access 2003 (full version) software, already installed?
...SmartList Restrictions help
I built a SmartList that is based on the Year-to-Date Transaction Open file,
and has the Account Master linked to it. I want to restrict it to accounts
that begin with 36, 38, or 2504. I tried adding a restriction that says
"Account Number:Account_Segment_Pool1 begins with 36 OR 38 OR 2504", but I
got no results when I did it that way. I also set up 3 separate
restrictions, but that didn't work either.
Is this possible? I can't find much information about how to write
restrictions in SL Builder.
...Conditional formatting help #4
My problem is that, that i want to ignore blank i mean i had set a
conditional formatting say
A B C D
24.9 25.9 25 25.8
22.6 23.4 22.5 23.3
If value in ColA is less than value in ColC, cell A1 is shaded blue OR
value in ColB is greater than value in ColD, cell B1 shaded blue.
I have done above formatting but my problem is that if i dont enter
anything in colC then also colA is shaded in blue similarly if i dont
enter any value in colD then also col B is shaded.I mean i want to
ignore the blank.I need , if col C is blank then the Col A must be
normal .& if col D is blank & i ent...help plz
my account has been inactive how to i reacctivate it?
What account and what does this have to do with Outlook?
"heather" <firstname.lastname@example.org> wrote in message
> my account has been inactive how to i reacctivate it?
...Help with queries
This is the first time after school that I am trying to use ms access at
work and i need ur help in creating a query.
Any help will be highly appreciated!!
Here is what I need...
I have relatively small ms acces database with about 1000
I have 3 colums
date ipaddress sitename
12/09 184.108.40.206 A
12/09 220.127.116.11 A
12/09 18.104.22.168 A
12/09 22.214.171.124 B
12/09 126.96.36.199 C
What i need is if an ipadress is recorded more t...What program is trying to access e-mail address information stored in outlook?
I have one user (Vista Business, Outlook 2007 connected to Exchange 2003)
who has today started to see a pop-up from Outlook saying:
"A program is trying to access e-mail address information stored in
Outlook. If this is unexpected, click Deny and verify your antivirus
software is up-to-date."
Anti-virus (McAfee) is up todate, and I'm doing a scan now and afterwards
will do a separate scan for malware. This user tells me that he hasn't
knowingly installed anything recently.
My question is: is there any way to determine what the program is which is
try...Need help to choose loyalty program integrated with website
My name is Alex and I am working for franchise company using RMS
We are looking for loyalty program integrated with web store.
We have 12 franchisee stores using RMS and they are all conneted to
our HQ system in main office.
We want customers to earn point for each sales and redeem their points
only at our website. (not on off-line store)
Can anybody recommend best solution for our plan?
...Can I use oulook from home and have access at work?
When I set up my outlook I lose all my inbox messages online and would not be
able to read my email from work. Is there a way to have my inbox available on
outlook and remain online?
Just to clarify, are you asking how to set up Outlook at home to receive
email from work? If that's your question, you need to ask your IT Admin or
Exchange Admin if you can use OWA and how that's done. That wouldn't have
email coming into your Outlook account but it is a form of Outlook, Outlook
This may or may not be allowed. Your IT staff would of course have all kinds
of securi...Help And Advive For A Novice
HELP AND ADVICE FOR A NOVICE
This Is Not A Question About Using Excell But How To Download E -books
I Have Purchased 2 E-books (a)f1 Excell And (b) Financial Statements.
Encountered Difficulty In Downloading Because The Instructions Were Not
Very Clear For Novice And Message Flagged Up "zip File Corrupted"
I Have Utilised My Permitted Downloads. Therfore I Have Not In A
Position To Use The E-books
Joe Williams's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23...Access 2003 and Sharepoint
My company is moving most of our files into Sharepoint -- however, it
seems no one could explain how Sharepoint is going to affect our
current Access database.
Can someone please enlighten me regarding Sharepoint and how it will
benefit us if our Access database is stored in it? Will it make
accessing the database faster through our network? Right-now our
database is stored in a network drive and depending on where we are
located from the server -- it may take long to accesst the data.
Or any sites that will help explain the process of Sharepoint.
You cannot store your A...Sum of Top Values in Access Report
In an Access report, I'm presenting the top 15 cost values in the detail
section. I have a counter to do start a new print page. That is working,
but I also want to present the group total (=sum[netofreturns]) with the
total of the top 15 values [top15only] and calculate the percentage of the
top 15 to the group total (top 15/group total) in the group footer.
...HELP! Balloon Payments in Debt Reduction
I have had this problem for so long it is getting really
frustrating. When I put a debt into the debt reduction
plan, it always puts a balloon payment on my first
payment. Then, if I don't make that payment, it just
builds and builds and builds with each subsequent payment
I do make.
How do I get rid of this? I removed the debt from my
reduction plan the first time and that cleared it. But,
the moment I started paying on the debt, it returned.
Now, it's to the point that I can't get rid of it at
all. When I remove the debt from the plan, it will do
the same thing w...formula help #42
What formula would I use to search down a column find a name and report the
number in the next column, this would be multiple times, the numbers to be
The added number reported then to be multiplied by another number and then
to be subtracted from another fixed number in a specific cell.
Thanks in advance
You can sum the corresponding cells matched without having a dedicated
column of numbers.
"Boenerge" <Boenerge@discussions...SUMPRODUCT help #7
My question is if I have 3 or 4 criteria that need to be met before
excel acknowledges the row and then once it does it will sum the
accepted rows and return that sum into another sheet.
Category Price Date Customer #
InorgStock $30.00 10/20/2005101643
Inorg CB $415.80 1/23/2006 109597
InorgStock $15.00 1/23/2006 101643
Matrix Mod $50.00 1/23/2006 101643
If I want excel to only add up the extended price for the columns that
met the criteria Customer Number=101643 and Category=inorgstock and
Category=Inorg CB and Category=Matrix Mod and Document Date is
>=10/20/05 but <...Access is Denied error
I have installed the Sales for Outlook. During Online, I can access all of
the Microsoft CRM folders. However, when I am Offline, I can not access all
the Microsoft CRM subfolders. I received the error below on the event
application log. While Offline, I can create contacts, emails, etc.
MSCRM Platform Error Report:
Error: Access is denied.
Error Message: Access is denied.
Error Details: You do not have sufficient permissions or access rights to
perform this operation.