Delete Rows #2
I would like to be able to delete a row with a name in it based on a
cell with that name from another cell in a different worksheet. Any
That worked great, thank you so much.
How do I run the same macro for another name right after this one?
Gary''s Student wrote:
> This macro:
> Sub remover()
> v = Sheets("Sheet1").Range("A1").Value
> For Each r In Sheets("Sheet2").UsedRange
> If r.Value = v Then
> Exit Sub
> End If
> End Sub
&g...Why do service items need to be assigned to a site?
Why do service items need to be assigned to a site if they're not maintained
in inventory? I can't invoice a service item unless it's been assigned to a
Can someone explain why this would be required?
Bud Cool, Accounting System Manager
HDA, Inc. Hazelwood, MO
GP 9.0, SP2
The simple answer is that the system was designed that way. It's been that
way for many versions, if not from the beginning. It's not something that can
be changed and I'd be surprised if MS changes the system to not require a
Charles Allen, MVP
"Bud"...Line Items skipped in PO Generation
We are currently using Dynamics GP v9.0.
Our Purchasing Agent has been having a problem now for a couple of months
when printing Purchase Orders - As she enters each item, they show correctly
on the screen (1, 2, 3, etc), however upon printing the PO, line 2 (or 3) is
left blank and then becomes 3 or whatever the next line item would be.
The item is not 'skipped' on the PO, just moved down one line item, thus
creating a 'blank' line item so that the vendor then thinks there is a line
Any suggestions? This is happening whether there are two items or 20.
t...Calendar - with Auto Preview
I accidently, I'm guessing, clicked on Day Week Month View with Auto Preview
in the Advanced toolbar. My normal preference is Day\Week\Month.
With Auto Preview selected in the Advanced toolbar, _many_ of my entered
items in Calendar disappeared. That surprised me. They were of course
still in the program, I just couldn't see them.
Before I go any further with this, is this normal behavior? I also did a
scanpst.exe and came up clean.
Thanks, Dave Horne
Ignore my post - I realized after spending a few minutes with this that the
settings for Detail - Low, Medium, High were ...outlook delete message outbox problem
I am seeing that this is not an unusual problem. I have tried working "offline". I have tried disconnecting the internet connection to the computer, restarting, delaying message sending, etc. File still will not delete or be moved. I have noticed same "error" message as some others have gotten, mapi spooling? and "message has already begun transmission
what a joke this has been for 2 weeks and I don't even know what archives this has been pulled from. Does anyone have any suggestions?
...ISV.Config File Nav Item Refresh Problem
I have a refresh problem. I added a new left side tab by
making an entry in the isv.config file. When u click the
tab the url specified is opened but is not refreshed.I
need the url specified to be refreshed each time the tab
is clicked. Any help is appreciated.
Did you ever solve this sarah?
"Sarah" <firstname.lastname@example.org> wrote in message
> I have a refresh problem. I added a new left side tab by
> making an entry in the isv.config file. When u click the
> tab the url spe...Printing Issues when distributing a form to multiple users
I am distributing a spreadsheet to multiple users. The spreadsheet is
being used as a form for data entry.
The problem i am having is that when it is being printed, the users
are getting varying page layouts where the page breaks have changed,
due the changes to the length of the document growing from the free
text they are entering. The page breaks that excel chooses don't seem
to be spaced well, leading to one or two of the pages being very short
(i.e., leaving a lot of free white space), whereas the other pages are
taking up the entire page.
Is there a particular page layout selection...zoom in view
How do I set the default zoom in view for IE7 (maybe 8 - I'm not sure) to
110%. When I close and reopen explorer it reverts to 125%
Is there a way to set a new default zoom? I want the default zoom in
Internet Explorer Web Browser to be 150% and NOT 100%
You will find support for Internet Explorer in this MS forum now:
Always state your full Windows version (e.g., WinXP SP3; ...Re: Inbox subfolder deleted with its contence, can it be recovered?
I have a user at work who has deleted his inbox subfolder, with all it
content. Believing he had a e-mail highlighted that he wanted t
delete, he deleted by using shift delete, so it perminately deleted th
contents but instead he had the subfolder highlighted, did not look a
the warning message saying you are going to delete "hunter folder an
its contents" *sigh* is there any way this contents be recovered? usin
a thirdparty recovery tool? Thanks in advance
Posted via http://www.mcse.m
----------------...Stop Record Deletion
I have a continous form based on a table. The form uses the record selector
function to allow users to easily delete un-wanted data. Some records will
now be uploaded into a differnt system. I have set-up a field to flag which
records have been uploaded. How can I keep the record selector, but stop
rows that have been uploaded (flagged) from being deleted?
"Justin" <Justin@discussions.microsoft.com> wrote in message
> I have a continous form based on a table. The form uses the record
&...Forms in two differant views
Is there a way to use the same sub form showing two differant views within
the same Main Form. For example: Can I show on one tab a datasheet view and
on the other a regular form view.
Create a button on your form and under the "OnClick" event put
'Me.DefaultView = Datasheet
Alternatively you could use a checkbox
If me.checkbox1 = 0 then
Me.DefaultView = 2 ' Datasheet
Me.DefaultView = 0 'Single Form
This should flick the form between datasheet and form views.
> Is there a way to use t...Issue when using Outlook 2003 on Exchange 5.5 SP4
I have seen issues on using Outlook 2003 on MS Exchange 5.5 SP4. Can anyone
guide me on how to handle this?
What issues have you seen?
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"M P" <email@example.com> wrote in message
> I have seen issues on using Outlook 2003 on MS Exchange 5.5 SP4. Can
> anyone guide me on how to handle this?
> M P
It was pretty easy for me to find this in the Microsoft Knowledge Base:
http://support.microsoft...How does one view a document created in Publisher.
I have gotten a document (calendar) in .pub format. Word does not recognize
it. Is there a viewer? What's the link? I have Office 2000 with the
>I have gotten a document (calendar) in .pub format. Word
> does not recognize it. Is there a viewer? What's the
> link? I have Office 2000 with the converters installed.
There is no viewer for Publisher files. Maybe you
could ask the sender to convert it to a .pdf file. Or
you could order the Trial version of Pub2003...
which will still function as a viewer a...Publisher 2000 text moves when viewing in Publisher 2003 and up
I received many Publisher 2000 documents from a client. I work for a
commercial printer and due to problems separating the colors in Pub 2000, I
need to open the files in 2003 or newer. When I open the files in Pub 2003
and 2007 the text reflows incorrectly around some images and even runs
through some images. And in some cases where there are no images on the
page...only text...the text boxes seem to shift up slightly causing collumns
of text not to line up. I am out of ideas for workarounds and my client can
not afford the cost for me to manually fix every single text box in the
hund...Experts Challenge: MAPI is unable to access Public Folder store items
Goodday to all of you,
I have crosspost my messages to several newsgroups.
Reason for this is that my previous posts to different newsgroups did not
solve the problem.
Maybe if I crosspost, there will be an expert that has a solution.
Also I am not sure to which group I should post my problem.
Maybe this post long-winded, do not see at as material for a novel!!! - I am
just trying to explain the exact TERRIBLE situation!
---- ---- ---- ----
I am experiencing a problem with our Public Folder Store.
All my users are not be able to access e-mail items in the Public Folders
using their Outlo...Greying out a menu-bar item
Hi. I wish to greyout a menu bar item, eg "File" or "Edit".
Normally not at problem to grey out things under the menu, eg "Undo" or
"Save". So I go:
void CInterfaceSDIDoc::OnUpdateOptions(CCmdUI* pCmdUI)
But it doesn't work! The menu doesn't work, but it's not greyed out.
You could try getting the m_pMenu out of pCmdUI and explicitly call
m_pMenu->EnableMenuItem(id, MF_GRAYED | MF_DISABLED).
Please do not send e-mail directly to this alias. This alias is for
newsgroup purposes only.
This...Unable to delete public folder in Exch 5.5
I have 2 exch server 5.5 sp3 under same Org and Site container. 1 of the
public folder was created in server b. But server b crashed and left is
server a. Even though in the Outlook we can still see the public folder, but
in the server a, the public folder does not exist coz it was hosted in server
b. I could not delete it and the message says - 'Unable to display the
folders.The contents of this public folder is currently unavailable. Either
the Microsoft Exch Server computer servicing this public folder is down or
the public folder has not been replicated to this site'
Anyone ...Changing Exch5.5 GAL columns in Outlook client view
Sorry if the subject line is a bit cryptic; anyway, in the Outlook client, if
you display the 'Address Book' you get the following columns - name, business
phone, office, title, company, alias, e-mail type, & e-mail address. How do
you change it so you show the display name, business, extension, cell phone,
& internet email address?
Basically, how/where do you change the columnar data the client sees?
Thanks, Mike Lawson
Goto View | Columns and there u can manage views...
"Mike Lawson" wrote:
> Sorry if the subject line is a bit cryptic; anyway, i...Counting items within time ranges and containing text
Hi there! I'm using Excel 2002 and have the following trouble wit
counting items within time ranges
I have in one spreadsheet
Customer Name Aged time
Premiere & Sons Inc. 3:00:53
ABC Co. Inc. 23:10:00
Perfect Inc. 14:06:45
ABC Worldwide Inc. 48:00:20
Premiere Inc. 15:22:30
ABC Inc. 1:25:35
And on another sheet I want to have the following details.
Customer Reports >12h 12-24h 24-48h <48h
ABC 3 1 1 0
Perfe...can't delete DLL
I wrote a very simple dll and through VC++ debug, I can see it has already
call destroy() when my host program exit; But I find I can't delete it in
folder. it maybe means it is still in use. but I have already free it.
Anyone can give a clue, where's my problem?
I use XP + VC++.
static void a()
static void b()
BOOL WINAPI DllMain(HINSTANCE hInst, DWORD fdwReason, LPVOID lpvReserved)
if (fdwReason == DLL_PROCESS_ATTACH)
if (fdwReason == DLL_PROCESS_DETACH)
...Outlook 2000 Closing msg
I have an Issue with Outlook 20000 running on a win2k
The user closes an email he is reading and it "disappears"
completely. Not even to be found in the deleted folder.
It's probably still there - check the view settings. It sounds like he's
viewing only unread messages.
> I have an Issue with Outlook 20000 running on a win2k
> The user closes an email he is reading and it "disappears"
> completely. Not even to be found in the deleted folder.
> Any Thoughts?...Excel Question: How to Delete All Blank Rows from a worksheet?
Hi, I'm brand new, and that is my question. I just spent 2 hour
laboriously mousing along deleting row by row, every other row thinkin
there's gotta be a better way. (I could've done it of course if the
were adjacent, but they were interspersed with my good data). I'm
little behind the times: agile with keystrokes but less so with mous
[think I was quicker in Lotus DOS! (actually "TWIN")]. But I do play
Message posted from http://www.ExcelForum.com
"DaveThePianoGuy >...How do I stop Excel from deleting the Window's Clipboard Contents
Note: This is with the Office Clipboard turned OFF!
For example, If I write the following in 5 cells in Excel.
[Hello ][My ][Name ][Is ][Fred ]
Then I Copy (CTRL+C) the Cells: [Is ] and [Fred ] to the
Then I press [Esc] (there are a dozen other ways to do this, but, this is
Now, I go to any cell, anywhere in my workbook, and press Paste (CTRL+V)...
No Data... If I open up Notepad... Paste (CTRL+V).... No Data...
Excel has *decided* for me, that I want to delete the Window's Clipboard
Although I ha...Item Lookup Security
Is there a way to setup the user security for the item lookup button
(for sales transactions) so that a user is able to see only a selected/
limited list of items and not ALL items?
Currently this doesn’t exist out of the box, but it could be customized in
several ways as described below:
1. If you are familiar with Dexterity you can follow David’s proof of
concept about data level security in his post below:
2. You can create smart-list filtered for the needed...Can I reference a filtered item in the Custom Header
I would like to include the currently filtered item in my custom report
header. For example: "Dummy Bills for Agency xxxxxxxx", where xxxxxxxx is
the currently filtered agency.
Can this be done?
Here's a link that returns the filter criteria via a userdefined function.
It's a procedure posted by Tom Ogilvy (posted by Debra Dalgleish).
> I would like to include the currently filtered item in my custom report
> header. For example: "Dummy Bills for Agency xxxxxxx...