asap utilities question
I have Msft. Excel Vsn 2002 and latest vsn. of ASAP Utilities.
I used ASAP Utilities to merge single rows of data together so that
more than one row will fit on a single line of
My question now, is, is it possible using ASAP Utilities to separate
the data that has been merged back into single rows of data?
All information welcomed! Aaron
...Isinteg Warning Message Question
I ran isinteg -pri -test alltests. I came up with 506
warnings. There are basically 4 types of warnings. They
are below. Are these something I need to worry about? What
should I do?
Warning: MsgFolder 165 (Fid=0001-0000000D1864, Mid=0001-
PR_READ_RECEIPT_REQUESTED(0029000B) prop in Messages table
and MsgFolder table do not match.
Warning: MsgFolder 4 (Fid=0001-0000086DC911, Mid=0001-
00000436F972, Inid=0001-000004A583F1): Error
JET_errRecordNotFound seeking to INID for this ...forward to: field
im looking for the AD attribute in which the 'forward to:' field of the
delivery options is stored.
Thank you in advance
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
Its in the altRecipient attribute.
"Marc Wenger" <haga(at).iesg--nspm-noa9h.gmx.ch> wrote in message
> Hi Everyone,
> im looking for the AD attribute in which the 'forward to:' field of ...custom field for projects with tasks past due
I am wondering how/what formula would be needed for creating a custom field
at the project level to show when a project has at least one task that is
past due. I have a custom field at the task level (IIf([Finish]<[Current
Date] And [% Complete]<100,1,2)) that will show when an individual task is
overdue, but I want to add a custom field to the Project Center > Summary
view to show when a project has any overdue tasks. The PM can then drill
down from there into the project and see exactly what tasks are overdue.
Once I figure out the formula for this I want to assign ...changing values of one field based on another
How can I best change the values of one field in a table based on
values of another field of the same table. We have an existing table
of thousands of entries and I would like to use the following logic to
populate a new boolean field.
If field1 = "Done" Then BooleanFieldCompleted = True
I have some Excel VBA experience but limited Access. I dont want to
do this manually! Any assistance appreciated.
In general, you'd use an Update query. However, in this case I don't see why
you'd need such a field.
Why not just create a query with a computed field that returns True...Setting up a new e-mail account
I'm trying to set up my yahoo account so that I receive
my e-mail messages in my Outlook Inbox. I went to
Accounts, and servers, and put in mail.yahoo.com for
incoming mail (POP3) and smtp.yahoo.com for outgoing mail
(smtp). When I click on the send/receive button I get an
Dave <email@example.com> wrote:
> I'm trying to set up my yahoo account so that I receive
> my e-mail messages in my Outlook Inbox. I went to
> Accounts, and servers, and put in mail.yahoo.com for
> incoming mail (POP3) and smtp.yahoo.com for outgoing mail
&...Getting the BCC field by default.
I would like the BCC field to show by default but cannot find the setting
for this in 2007. Anyone know where this is located?
In a new message window, use the Options chunk to display the "Show BCC."
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, JC HARRIS asked:
| I would like the BCC field to show by default but cannot find the
| setting for this in 2007. Anyone know where this is located?
Thanks Milly. I had...Dotfuscator question
Hello Everybody !!!
When i create programm using C# i must understand that my programm from
exe - module
can be converted to the source file by Reflector.
In Order do not allow do this i must use dotfuscator, but i did not find any
free normal dotfuscator.
May be someone tell me what can i do cause now as think we have interesting
We 've got free technology but if we want to protect our products we must
buy expensive commercial dotfuscators.
You should post this message in a newsgroup which discusses managed
code. This newsgroup does not have much managed traff...question on the rules wizard
When clikcing on the Rules Wizard, Outlook locks up -
consistently. Has anyone got a remedy for this?
Ok, I have two questions:
1. With Thunderbird I can use this with a hotkey manager to compose a
new message with Tbird "D:\Program Files\Mozilla Thunderbird
\thunderbird.exe -compose" -- how can I do the same for Outlook
Express and Outlook 2003?
2. When I go to load Outlook Express I get this error message,
followed by the error message below it: http://i180.photobucket.com/albums/x296/gwar_1/Untitled-3.png
how can I fix this and use Outlook Express?
posted to the outlookexpress newsgroup via crosspost
Please Reply to Newsgroup for the benefit of others
Re...question about Time
How to make the time result for example if it�s ( 1:01 ) or higher shows
only as ( 1:00 ) and if it�s Lower like ( 0:59 ) or less it will show
the same result in this case ( 0:59 )
Any idea & suggestions.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
Using Ron deBruin's google addin and asking for subject round time, I get
"saud" <saud.xgc4...COUNTIF on Summary Fields
Can't use on a cell that "sums" with arithmetic operators "+". Is there a
a bit more explanation?
"DLC" <firstname.lastname@example.org> wrote in message
> Can't use on a cell that "sums" with arithmetic operators "+". Is there a
> workaround, etc.?
...Help about numeric type field. Thanks.
I created a SQL Server 2005 CE DB ( .sdf, version 3.0) with vs2005. And I
created a table which has 2 fields: fld1 - int, fld2 - numeric(38,25).
But I encounted an error messagebox when I tried to insert a record
The msgbox said Conversion overflows.
The setting for my numeric fld2 is (precision=38,scale=25). So why occur
error when to insert 9000000?
Thanks in advance.
...HQ Licensing question V.2
I have a client running HQ client at 8 stores + HQ server at the warehouse.
They would like to be able to use transfers from the warehouse to the stores,
so I would have to setup a new PC running Store Ops and a new database,
however, in order for the transfers to take place, I need a HQ Client License
correct? Do I also need a POS key?
I appreciate any insights you may have.
Thanks in advance
yes - you'll need an HQ Client license so it can exchange with your
headquarters - "export" the wh database as you would any store from HQ
no - you won't need a PO...MS Project 2007 question
I am developing a simple schedule with no resources but 2 tasks out of 100
are hazardous and I would like to make the schedule so that when these tasks
occur, no other tasks can occur. In other words, even though all tasks are
moving around as the schedule is being developed, I would like to make sure
no other tasks can be scheduled wherever these 2 hazardous tasks fall. These
2 tasks are serial to every other task in the schedule. Is there a way to do
Thanks for your help.
Create two milestones. Use milestone 1 as the successor task to all tasks
th...Help! charts disappearing, new charts crashing powerpoint
When i open a presentation the charts vanish...i have restarted, they come
back. I try to edit a chart, and it crashes powerpoint after a few clicks.
What can I do...whole afternoon going crazy!
If you are using v 2007 there is a hotfix which is meant to cure some chart
john ATSIGN PPTAlchemy.co.uk
Free PPT Hints, Tips and Tutorials
> When i open a pres...IM Add New Batch
GP 10 on 2003 Terminal Server.
How do you create a Payables Batch in the IM in preparation for importing to
the Payables Transaction destination? Alternatively, how must GP be set up to
ensure that the “Add New Batch” rule works correctly?
With the Add New Batch rule set the IM crashes (see my post Integration
Manager 10 Crashes). Additionally the characteristics of the Add New Batch
rule do not match the required information which I understand to be Origin
and Checkbook ID.
I figured there might be some default settings for Origin and Checkbook ID
in the setup somewhere but was not a...Combo Box initial values question
Does anyone know how to make a combo box show a value when a sheet opens?
Mine are always blank when I open them until I select a value.
Try something like:
Me.ComboBox1.ListIndex = 0
"teepee" <email@example.com> wrote in message
> Does anyone know how to make a combo box show a value when a sheet opens?
> Mine are always blank when I open them until I select a value.
thanks for trying.
says 'invalid use of me keyword.&...Moving exchange 5.5 to a new server exchange 2003
Good day all... how do I move exchange 5.5 to a brand new
exchange server 2003. The new server will be in a new
organization. Any info would be greatly appreciated.
Microsoft MVP - Terminal Server
>Good day all... how do I move exchange 5.5 to a brand new
>exchange server 2003. The new server will be in a new
>organization. Any info would be greatly appreciated.
...List the UNIQUE certain fields from the database
Please help related to the above subject.
From this discussion, got the following formula which is work well and
faster for small of database.
where $G$1, the first row of DATA.
how to convert it to VBA as this time i have a huge database.
for Tab Data, Advanced, Unique Record only (works well also, but i need the
basically we would like to do similar like this:
B...Hopefully Simple VBA questions
Using VBA, I want to go row-by-row and get the values from certain cell
in each row so I can run some tests on them, then put the result of th
tests back in certain cells.
This is how I am set up so far, can you help me with my questions i
Dim i As Long, c1 As Long, c2 As Long
c1 = 0
c2 = 0
For i = 1 To 120 (HOW DO I MAKE THIS DYNAMIC TO INCLUDE NEW ROW
AS THEY ARE ADDED?)
If Cells(i, 2).Value Then 'start flag is true (HOW DO I MAK
VBA GO TO A DIFFERENT WORKSHEET WITH THE Cells(I,2).Value STATEMENT?
If Cells(i, 1).Value = "E" Then
c1 = c1 + 1
I have a spreadsheet that is little more than a list of PO #'s that shows
what orders are done and ready to ship for a particular customer.
We upload the file every day to a website where the customer can view it
whenever they want.
So far, everything's fine.
I use the "=TODAY()" function so that when I open and modify the listings,
the date gets automatically updated.
The problem is, when the customer accesses the file, the date also updates
on THEIR end and the file looks more current than it really is. Is there a
way to maybe lock in the date ONLY when I save the file...open outlook new email form from a crm form
It would be great to be able to open a New Email form (outlook form) by
pressing a button on the Contact, Account or Opportunity etc. form in CRM.
Customers like to use outlook for email and currently there is a disconnect
in that if you are on the opportunity screen and you would like to email the
Potential Customer (and have regarding on the email linked to the Opprotunty)
you have to leave the screen and start a new email in Outlook and lookup the
opportuninty you already have open again to populate the regarding if you
want to use Outlook. You could use Email button, but browser ema...Sequential Numbering-- question on Stephen Lebans' RowNumber
I found this information on another user's question on sequential numbering,
but wondering how I can save the generated number in a table? Right now the
control source is set to: =RowNum([Form])
Here's the link to Stephen's code:
Message posted via AccessMonster.com
You can append the data into a temporary table, but which will have an
autonumber field in addition to the other fields you have data. That
autonumber field will get the values 1,...#error in the calculated field
I locked the data entered for some users, because their role is just to
input the date of invoice for approval by Prj.Manager.
My qeustion is, is it the reason we see the "# error" in the VAT checking
field??. I tried to ck formula in the qrid query, nothing wrong
Thanks for your explanation
H. Frank Situmorang
On Tue, 15 Jan 2008 23:33:01 -0800, Frank Situmorang <firstname.lastname@example.org>
>I locked the data entered for some users, because their role is just to
>input the date of invoice for approval by Prj.Manager.