Is it possible
I would like to know is it possible to make million dollar in the internet, if you have any suggestions, write on my forumhttp://isitpossible.truemillion.comMark...Inserting Customers into HQ using SQL
We are writing an integration to RMS HQ Customers from an application called
Campus View. I'm trying to write an insert statement to insert into the
Customer table. I first tried inserting a record without explicitly setting
the ID or HQID fields in the script to see if SQL would auto-generate these
key fields for me. I received an error that null values weren't allowed.
I tried manually creating a customer to see what ID values it would assign.
Rather than starting at 1 and auto incrementing it appears to be choosing
very long numbers to assign as the ID fields. For exampl...Personal Folders in OWA
I have just enabled OWA on our Exchange 2003 SP2
through ISA Server 2004. Is there any way to
access personal folders in OWA?
Thanks in advance.
If by personal folders you mean .pst files, the answer is NO! Sorry.
C C wrote:
> I have just enabled OWA on our Exchange 2003 SP2
> through ISA Server 2004. Is there any way to
> access personal folders in OWA?
> Thanks in advance.
"C C" <firstname.lastname@example.org> wrote:
>I have just enabled OWA on our Exchange 2003 SP2
>through ISA Server 2004. Is there any way...Blocking fields to avoid use in formulas
Is there any possibility to block the particular field in order to
avoid users to use invalid fields in formulas ?
You can lock and unlock cells (then protect the worksheet) so that users can't
change certain cells.
But if you allow them to type a formula into a cell, then I can't think of
anyway of stopping them from pointing at A1 when A1 shouldn't be used.
Is that what you meant?
If it is, maybe someone else has a way...
If it's not, maybe you should rephrase your question.
> Is there any possibility to block the particular field i...Possible to detect changes to an XmlDocument object?
If I instantiate an XmlDocument object, the load a file through the Load
method, is there a way, later on in execution, to easily determine if the
XmlDocument object has changed from the original version loaded?
I'd like to be able to check a condition to see if the document in memory
has been editted (i.e., nodes added, attributes changed, etc.) so that my
user can decide whether or not to commit changes to the disk file before
moving to another file.
Will I have to resort to re-loading the file, and comparing OuterXml
Gabe Covert wrote:
> I'd like t...Money in laptop and office computer
I tried money 2006 and later I bought the standard version downloaded via
Now I want to open my I downloaded the trial version, but cannot open the
file, neither want to buy another money 2006. Do I have to?.
In microsoft.public.money, email@example.com
>I tried money 2006 and later I bought the standard version downloaded via
>Now I want to open my I downloaded the trial version, but cannot open the
>file, neither want to buy another money 2006. Do I have to?.
You can download and install the Mo...Using project indicators and the current date
Is there a way to set up project indicators based on the current date verses
the finish date? I want it more for a visual for resources to basically alert
them visually if a task is due to finish within 2 weeks, or has passed.
Here's what I want to show:
Green - Finish date is < 2 weeks away
Yellow - Finish date is >= 2 weeks
Red - The Finish date has passed
This would be using the current date, not baseline.
Is this in MSProject, or Project Web Access?
"...Using rundll32.exe to install using a non interactive session
I'm trying to write a script that will remotely install a file system filter
driver remotely across a number of systems using psexec.exe (from
sysinernals). This works fine if the user is logged on to the remote system,
but does not seem to work if no user is logged in. If I try to run other
applications using psexec when the user is not logged in, they wrk fine.
Are there any reasons why rundll32.exe cannot be used in this way?
"Rich Jones" <Rich Jones@discussions.microsoft.com> wrote in message
news:D9910D08-E00E-49E5-842E-93E9F...working out which colour text is used to populate a cell
Fingers crossed someone out there will be able to help me.
I have been tasked to provide a spreadsheet at work to monitor a number of
applications and written applications that we receive and the number of days
we respond by.
I have the following cells ‘application received’(Cell B), ‘enquiry
received’(Cell C), ‘date completed’(Cell E) I then have the following formula
in Cell H =NETWORKDAYS(IF(B4<>"",B4,C4),E4,$A$119:$A$158) which determines
which cell has the date in (B or C) and then works out the number of days it
has taken looking at cell E (the...Downloading Statements Directly Not Possible
I have Money 2002 installed on an Win XP Pro SP1 machine. Something
happened and I probably did it, that causes the statement downloads not to
go directly to the account. Rather they want to be saved in a file and then
opened into Money. I then have to delete the download.
I have tried several things in order to fix this:
1. I verified the file associations of OFC, OFX were correct. They were.
2. Lowered all my security settings in IE. Even put banks into Trusted site
zone. No go.
3. Made new accounts. Didn't help.
4. My IE cache is large (500MB) and regularly cleaned out.
5. I made s...is this possible? reload a form that is based on a query with new query that is defined in the form.
I have a basic form.
The form is based on a query, so when I open the form, a pop comes up
where I enter in what I want to query.
So instead of 30,0000 records, I get 1-10 records.
on the form, I have a text box. I want to be able to enter in what I
want to query next and afterupdate have the recordset/form reload with
that query instead of my original qeury.
I figure this has to be done with VB. I am just starting to learn some
VB but I am lost.
Any info would be great, thank you.
You need to apply the new query or table name, or the sql string to
the forms recordsource, then...Recommendations, Please: Inexpensive PDA/handheld for Syncing Outlook 2000/2003
I need to purchase a PDA to sync with Outlook 2000 on one system and Outlook
2003 on the other system. As well as using it to sync the two Outlooks, I'd
also like it to be a useful PDA. There is an application I may use that
requires Palm OS 4.1 or higher. However, this isn't crucial. Any suggestions
are really appreciated.
Peter D <please@.sk> wrote:
> I need to purchase a PDA to sync with Outlook 2000 on one system and
> Outlook 2003 on the other system. As well as using it to sync the two
> Outlooks, I'd also like it to be a useful PDA. There is an
> applic...Is it possible to compare a string and a field name
I have the following tables: Membership, Subscriptions, OfficeUseOnly. The
Office Table contains a Year, Year To and From [financial year] and the other
fields are the 5 membership types (regular, student etc) and these 5 fields
contain the different amount each type of member has to pay.
I want to create a form whereby on entering the financial year and the
membership type the correct amount is automatically inserted into the
FinancialYear - in current form = OfficeUseOnly SubsFinYear
and then if MemberType = 'Student' find Student field ...pictures in various shapes
Is it possible to insert a picture and make it into a circle or an oval or
various other shapes than just squares and rectangles? Thank you ahead of
with a graphics editor
Microsoft MVP - FrontPage
"Stephanie" <Stephanie@discussions.microsoft.com> wrote in message
| Is it possible to insert a picture and make it into a circle or an oval or
| various other shapes than just squares and rectangles? Thank you ahead of
> Is it possible to insert a pict...VS 2005 Using Crystal Reports from MFC application
I'm trying to find documentation on how to integrate Crystal Reports
(the one included with Visual Studio 2005) into a C++/MFC dialog based
Has anybody had any success with this? If so, do you know if I have
to use managed C++ in order to accomplish this?
I tried to add the CrystalReports ActiveX ReportViewer (10.2) into my
dialog but it doesn't appear in the list of available ActiveX
objects. I looked into the Registry to see if the component was
actually registered and the entry is blank (HKEY_CLASSES_ROOT
\CrystalReports102.ActiveXReportViewer.1 is empty).
Does any...Using Outlook with Hotmail
I've just started using Outlook 2003, after having owned the disc for a
while (I only used office for Word prior to this).
I use two hotmail accounts, both of which are installed fine.
1) How can I get an audio alert when new hotmail arrives? Surely if Outlook
Express provides one, then the more advanced program should too??? This is a
mjor thing for me, as I don't want to have to keep checking constantly to see
if I have mail.
2) How do I configure my sent items to stay in the right place - e.g. the
hotmail sent items with their relevant accounts, rather than in the un...Is this possible
I want to make a list of the files in several different
folders. Is it possible to somehow "Copy and paste" just
the filenames into a list, in either Word or Excel or
Wordperfect. I am just trying to sort the files in
several different folders to weed out duplicates. There
has got to be an easier way then typing them all or screen
printing the lists and manually weeding them out. Any
Here is some code that will start in a directory and list all files in that
and any sub directories. It uses recursion to go through all the subs.
Just ch...Graphing a Line Using the Equation
Is there a way to graph a line using the equation of the line?
try this url
see chapter 15 and refer to "charting a function"
tortoise25 <firstname.lastname@example.org> wrote in message
> Is there a way to graph a line using the equation of the line?
See PLOT manager
and Stephen Bullen's ChtFrmla.zip at
http://www...POST using SSL in MFC
I have the need to "use an object such as Microsoft's WinHTTP or XMLHTTP to
emulate an HTML Form POST using SSL."
I have examples for doing this in C# and .NET. Can anyone point me in the
right direction for accomplishing this on the desktop using VC++ with or
"Jonathan Wood" <email@example.com> wrote in message
>I have the need to "use an object such as Microsoft's WinHTTP or XMLHTTP to
>emulate an...Crash when using listview.
we have a multi-threaded application that includes a list control
(CListControl). At one point the application crashes with the following
stack traces for the different threads. The threads 2, and 3 are sending
a message to the GUI thread (#4), but for some reason the GUI thread is
crashing when calling ntdll!RtlAllocateHeap. The difficulty is that it's
not happening all the time, but always at the same place, so it's hard
to pinpoint the problem.
Is there a known issue about window messaging problems around this piece
THREAD #1 (Worker Thread)
WARNING: Stack ...using the cells property for use with Application.WorksheetFunction.Sum
Has anyone had any success with using the Cells Propery when using the
Application.WorksheetFunction.Sum function? My code is below:
Sub AddDataMorningMil(mon As String, Day As String, yr As String,
intDOW As Integer) 'DOW = Day of Week
Dim x As Integer, row As Integer, colStart As Integer, colEnd As
Integer, varSum As Variant
' -- Friday column & starting row
colEnd = 6
row = 15
' -- Get the start column & row
Select Case intDOW
Case 2 'Monday
colStart = 2
Case 3 'TuesDay
colStart = 3
...Is this Possible ?
Have a newsletter document with text boxes that have no outlines but
internal gradient colour fills.
Is it possible that a macro could remove all colour fills in one hit just
leaving the text in place ?
Dim oShape As Shape
For Each oShape In ActiveDocument.Shapes
If oShape.Type = msoTextBox Then
If oShape.Line.Visible = msoFalse Then
oShape.Fill.Visible = msoFalse
should clear the fill from text boxes that are filled and have no border.
<>>< ><<> ><&l...Using a variable to refer to a control in VBA
I was wondering if any one can tell me how to fix the 3rd line to work like
the 2nd one does. The 2nd one works fine but one the 3rd one they system
throws an error.
Dim intloop as integer
Forms![frmDate]![frmsubMonth].Form![subForm8].visible = False
Forms![frmDate]![frmsubMonth].Form!("subFrom" & intloop & "").visible = False
Dale K wrote:
>I was wondering if any one can tell me how to fix the 3rd line to work like
>the 2nd one does. The 2nd one works fine but one ...using macros to autofilter using CURRENT date
What is the macro I need for autofiltering using the current date?
I want the macro to update every day and know the date.
Message posted from http://www.ExcelForum.com/
|| What is the macro I need for autofiltering using the current date?
|| I want the macro to update every day and know the date.
|| Message posted from http://www.ExcelForum.com/
typing =now() will enter the current date into a cell.
so you could have a cell containing this function and a autofilter
referencing this cell, assuming the dates are stored in col A
Worksheets("sheet1").Range("...Using XmlDocument.Save removes previous formatting of the file
I have a nicely formatted .xml file that loses that nice formatting when
I edit it and use XmlDocument.Save to save the file. Does anyone know of
any way to keep the formatting I had when I opened the file?
The XmlDocument.PreserveWhitespace property is what you need. Set it to
True before Loading the XML document, and all whitespace is preserved.
Set it to True before Saving, and your whitespace will be preserved.
BTW, "XmlDocument.Save" auto-indents the output which you save.
Thanks so much, Cerebrus...