minimalist wants to know: is it possible to get a single bar on IE
on IE6 I had my menus, commands, & address window all on the same bar. Why
can't I do that with IE8? why is there a 'favorites' button next to my tabs
(even with fav bar disabled) when i have a drop-down favorites list from the
menu bar anyway? ...& why do I need a search window when my home page is a
too much redundant crap that I cant turn off.
I want to get rid of the favorites button, the search box, & put the rest on
a single bar... I'd go back to IE6, but Vista wont allow me to view or
remove installed MS prgs like XP did.
...Merging Fields in a query
I am self-taught on Access, so please forgive my ignorance here.
I have a subform that allows for multiple selections from a table, one
line/field per selection. So when I run a query that selects for that
information, I get an entry for that person for each item that has been
selected in that subform. I understand why it is doing this, but am
wondering if there is a way to write the query so that it can combine any
items selected into one row.
Example of how the query works now:
Col1 col2 col3 col4
NameA choice1 otherinfo etc
NameA choice2 otherinf...Re-arranging table using pivot-table?
I have a worksheet with data organized somewhat like this:
New York New York
New York Albany
California Los Angeles
California San Diego
I need to convert this to a list of states and each city in the columns to
the right of their corresponding state. Something like this:
New York New York Albany
Florida Miami Orlando Tampa
California Los Angeles San Diego
Any help is greatly appreci...Copy formula from one worksheet to another to get value in 2nd wks
Hi, I have several worksheets where I have totaled certain columns. I want to
take that total and copy it onto a summary worksheet (not adding these
formulas together) just need the value of the formula from worksheet B to
show up on worksheet A and be able to change as totals on worksheet B change.
I tried simply doing a copy and paste but I get a REF! error. I then tried
to copy and paste special for formula and format and got same error.
What do I do? Help!
Worksheet B has formula- =sum(f1:f22) which equal 395
Worksheet A needs the total of 395 to show up and...Criteria in Query
I have set criteria in a query to pull 9 specific names (no matter how many
times they are listed) from a field in a table. I also have a date criteria
to choose those records only from 2008. (1/1/08-now)
My problem is my query will pull all records containing those names but also
from past years.
If I delete the names from the RMID field cell then my date expression will
What can I do? TIA
I'm not sure, but it sounds like you want the rows that satisfy both
conditions (one of these 9 names, Year([YourDate])=2008).
In a query design view, you need both conditi...setting text result set more then 8192
I am building system which take procedures from one place, displaying the
script of store procedure and then i taking it and run it in a different
But if the procedure script is more then 8192 it cutts it in the result.
Is there a way not to cut it?
On Thu, 8 Jul 2010 17:24:54 +0300, "Roy Goldhammer" <firstname.lastname@example.org>
>I am building system which take procedures from one place, displaying the
>script of store procedure and then i taking it and run it in a different
>But if th...Re-install Outlook 2002
I am trying to re-install Outlook 2002 for my palm pilot
after a crash. The installation will run until I get the
message - "another version is already installed and must
be uninstalled". The previous version was corrupt and I
was unable to uninstall it. Now when I go into the control
panel to add/remove the uninstall is no longer in the
...Re-Enable CRM User
I am trying to enable a disabled CRM user and I received the following error
message. Any thoughts or suggestions would be greatly appreciated.
String UserId) +0
Microsoft.Crm.Application.Platform.SystemUser.Activate(String id) +38
sender, DataEventArgs e) +127
eventId, FormState state, User user, String objectId,...How to get to my e-mail acct., check own mail?
Just signed up with Micrssoft S&T 2003 Edition and had to get a Net. Passport
e-mail address! Need to get to that E-MAIL account and verify so I can start
using my 2003 Edition. I was told on signing up to do this "next". And how in
the future to check my e-mails (what site to enter, example: Yahoo/mail.com)?
Go to www.hotmail.com and sign in with your net passport. You should have set
up the Hotmail acct. first, but you can probably do it now. Just use the same
info. You might have to go back and redo the activation for MS S&T (?)
"minnesota deer hunter" wro...How to get rid of the gridline?
How to get rid of the gridline in the worksheet?
I once filled all the sheet with white color but it seems not th
proper way to do it.
slamm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1501
View this thread: http://www.excelforum.com/showthread.php?threadid=26636
go to View - Toolbars. activate Forms toolbar.
there is an icon for Toggle Grid.
that should do it
icestationzbra'...RE:Excel will not open from a web link
When opening a link on a web page that has an Excel
Spreadsheet embedded in it, the spreadsheet will not open
up Excel but opens within another browser as an Excel
file. Programming on webpage is correct, opens up on
other machines just fine.
...Query not found in Dataviewer Business Portal 3.0
I am new to BP...and working my way through it.
I was in the INVENTORY section and was modifying the queries to show all
rows and no "Pick a Task" section.
When I clicked "apply" I was returned with "One or more errors have
occurred....Can not change Web Part Title due to a save error on the foler.
/DataViewer/Item List-Item List".
NOW I cannot get ITEMS>view Inventory Information to work. Dataviewer shows
a folder marked Item List-Item List/Item List but the whole thing doesn't
appear to work.
I need to help in fixing.
Thanks ...Thanks Ken Wright but one more question RE saving data from circular references
Thanks heaps for that macro Ken Wright .
I have run it and it works.
However it loops forever. Can I set it up so that it could save dat
from a certain number of iterations?
Thanks again Michae
Message posted from http://www.ExcelForum.com
If you stayed within your thread and did not change the subject
Ken would see your reply as a reply to his reply and would see
it a lot faster than when you start a new thread. Ken would
probably see your post highlighted in RED. Also someone other
than Ken might have been able to help you. (not me I avoid
anything that hints of circul...Re: exmerge error
I am getting the following error when trying to use exmerg
can anyone please help
Microsoft Exchange Mailbox Merge Program, v4.00.02
Start Logging:February 27, 2004 20:04:3
[20:04:31] Logging Level: Non
[20:04:31] Reading settings from file 'C:\Program Files\Exchsrvr\BIN\EXMERGE.INI'
[20:04:32] Error 8007203a opening an LDAP connection. ('LDAP://EXCHANGE/rootDSE') (CADRoutines::GetNamingContextData
[20:04:32] Accessing Domain Controller 'PROFI...query help plz
hey i have been given a set of data which i have set my relationships and
everything is going well,but (now this is when it gets tricky) i have been
given two name fields one for forename and one for lastname,but i havebeen
asked to display the members first intial,but havent been given seperate data
for it (its too go on a labels in reports)how would i go about searching for
jus the first letter of theri first name ? for loadz of entries??? cheers
Use the Left function in the query. It would look something like this in the
Jerry Whittle...Ron Bovey re: "Trim Selection" in ExcelUtilities
Cells in my Excel spreadsheet appear to be empty. However, when I use
Edit/Go To/Special/Blanks, I get "No cells were found".
In the past, Ron Bovey suggested going to the WWW.APPROS.COM website,
download ExcelUtilities and then use the "Trim Selection" utility to
remove the characters that are making the cells not empty.
Since then, I've gone to the WWW.APPROS.COM website and downloaded the
ASAP Utilities. However, I can seem to find the "Trim Selection" nor
any utility that will do the same thing.
Try going to Rob (not Ron) Bovey's site:
...How do I get invisible lines & borders to re-appear?
In Publisher 2003, table grid lines, text box borders and autoshape borders
have become invisible on-screen, although they do print out. Any ideas on how
to remedy this?
Recently installed Adobe PDF Maker which seems to have precipitated this,
although it could be entirely co-incidental.
Try updating your video drivers.
MVP Microsoft [Publisher]
"Ackerman & Co" <Ackerman & Co@discussions.microsoft.com> wrote in message
> In Publisher 2003, table grid lines, text box borders and auto...re re re ????
...Reports not updating with changes in query
I created a tabular report from a crosstab query and I have since
deleted certain rows, added a column and changed some things but the
report has not changed at all. I don't quite understand why.
1. All your changes didn't make a difference to the report.
2. The report isn't based on the table where you made the changes.
2.1 Check the report's record source to find the exact query.
2.2 Open up that query and make sure it's based on the table that you think
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager ...Getting rid of #VALUE!
I'm using excel 2000
I have a spreadsheet for calculating Overtime
A = Hourly Rate
B = Single Time Hours
C = Single Time Cost
D = Time and a Half Hours
E = Time and a Half Cost
F = Double Time Hours
G = Double Time Costs
H = Total costs
In columns C,E and G I have the following formulae
C > =IF(B3="","",SUM(B3*A3))
E > =IF(D3="","",SUM(A3*D3)+(D3/2*A3))
G > =IF(F3="","",SUM(F3*2*A3))
which calculate the cost of overtime, but leave the cell blank if n
hours are enterr...Re:
...Re: Where should be the best place to stored Applcation Data Files?
"Giovanni Dicanio" <gdicanio@_NOSPAM_email_DOT_it> ha scritto nel messaggio
> BTW: this post by John Robbins is very interesting reading:
copy-and-pasto - the correct link is this:
And then there's this Vista security discussion from last Friday (cool
On Fri, 8 Aug 2008 18:50:23 +0200, ...test 05-05-10
Am unable to post queries, just testing
...Re-enter payee information
I have been using MS Money to pay bills and frequent
annoyance is when I type in the payee, the selection list
never shows the payees. I type it in and have to re-
enter the account number and everything. Doesn't make
sense that i have to keep putting this in. Anyone know
what I am doing wrong? I've checked these boards and
found help with my passport problem but no entries on
Money has two kinds of Payees. Explicit--those on the explicit list that
shows in Accounts & Bills|Categories & Payees|Payees--and implicit--those
that are recorded somewhere in a tra...MS Query instead of "Edit OLE DB Query"
I am having a problem with editing some existing queries within Excel
2003 workbooks. When clicking on the "Edit Query" button from the
External Data toolbar, I now get the "Edit OLE DB Query" dialog box,
instead of MS Query, which was the interface that I previously would
get. Is there a way to switch this back?
I have been using Office 2003 on Windows XP Pro SP2. I recently had
Microsoft Update upgrade my version of Office 2003 from SP2 to SP3.
The problems appear to have started after that.
I can still create new queries in Excel using MS Query, which is...