SBS 2003 > 2008 migration
I have a migration in progress that is not very far in the process. The old
2003 server has been prepped, the answer file created and the new server
installed (and named, and joined to the network of course as part of the
however for some reason the partitions on the destination server got all
boogered up. I have a 300 GB C drive, a 2 GB D drive and a 100 GB E drive.
Windows is installed to the C of course.
However that is not idea for a lot of reasons and we want to redo the server
with properly sized partitions. Can I re-run the install on the destinatio...Vlookup Help #6
Hi, please help me out:
i have two excel files:
First File contains few numbers in A column:
Now, i have another file which conatins some codes for these numbers
but please note that the this file may conatain thie same number mor
than 1 time as well, and all the times the code may be same or may not
NOW, I AM APPLYING THE FORMULA IN FIRST FILe (VLOOKUP), AND I M GETTIN
THE RESULT AS:
5123866 ...concatenate help
Hello, I am having issues with the CONCATENATE function. I am entering
it correctly, and it is equaling the correct values. However, when I
try to drag the cell down, it is just copying the same cell over and
over as opposed to putting the correct value in the cell. Am I being
clear? Please help. I have a list due tomorrow that will take a whole
lot more time to finish if I can't get this function to work.
Message posted from the Excel Tip Forum at http://www.ExcelTip.com/forum/
-- View and post usenet messages directly from htt...SMS 2003 report help
I have no idea how to do this, but hopefully someone out there can help.
Running SMS 2003 and I have the two reports below that I would like to
combine with a change.
I would like to be able to see the username and time of day usage for each
user hit, not just the last usage along with everything in that first
I would also like to just pull all the data for all games and all dates
instead of having to specify. We aren't that big that I need to cut this
Any ideas? Thanks a bunch for any help!
"Users that have run a specific metered s...Help
I have produced an Excel workbook for gathering exam results and giving a
score to them, counting the number of passes over a certain level etc. Each
sheet is one student and I have used a little macro to name the sheet
according to the name entered at the top of the sheet.
My summary sheet requires certain formulae to analyse results from each
The problem is, I can easily enter the row of formulae for one student - but
there could be up to 50 in a workbook! The fill action does not increment
through the sheet names either when they are re-named or when they have
original na...Can't send email. Error msg: can't connect to outgoing SMTP serve
Setting up existing email account on Outlook. I can receive but not send
messages. I use IMAP but error msg says Outlook is unable to connect to
outgoing SMTP server.
"Scott" <Scott@discussions.microsoft.com> wrote in message
> Setting up existing email account on Outlook. I can receive but not send
> messages. I use IMAP but error msg says Outlook is unable to connect to
> outgoing SMTP server.
Well, IMAP is only how you access your mailbox, not how you send email.
that uses SMTP.
Have you ever bee...Need Help with Report
I have a main from and subform. Main form looks up a doctor and the subform
lists the doctor's patients. On the main form there are command buttons to
print specific report for these patients. However, when I click on report
the report comes up with only 4 out of the 5 paitients. It does not pick up
the first patient. Everything else works fine except that one. This is my
code for the report. I do have requery in my main form. Even after I
requery, it will no show all 5 patients. I would appreciate any help anyone
can give me with this. Thank you.
Private Sub ADOLVC_Click...Need Help w/ Weighted Averaging
I now want to utilize Weighted Averaging. Please find some example data
The result of A6 = Sum of A1:A5 (or 15)
The results of B1 to B5 are: B1 = A1/A6 (or 0.067); B2 = A2/A6 (or 0.133);
B3 = A3/A6 (or 0.200), etc.
The result of B6 = Sum of B1:B6 (or 1.000)
Now, here's what I'm trying to achieve:
- Alt...What is the maximum no of bytes that can be stored in a excel file
what is the maximun of bytes that can be stored in a excel file
I am trying to save records from another Quest TOOL called (TOAD) into
Please let me know.
Eagerly waiting for your reply
prekida's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2660
View this thread: http://www.excelforum.com/showthread.php?threadid=39879
The limit on bytes depends on your computer's RAM. The max number of
rows Excel can have is 65536 and the max number of columns is 256....How can MAPI VB set the "From" Email addr in Outlook/Outlook
I have a VB5 Program that sends Emails to customers from various salespeople.
If I change either Outlook or Outlook Express to have a different email
address for each salesperson, how can I automatically insert the
salesperson's Email address in the "From" Address in the Email automatically
generated by my VB program.
Currently the "From" email address is determined by whoever logged onto
either Outlook/Outlook Express last.
Also, I want Outlook to immediately send the Email without waiting for
someone to log onto Outlook and click the Send/Receive bu...How can I embed a file as an unopened object in a worksheet or wo.
I want ot place Word, pdf, and other documents into a spreadsheet as objects
that can be opened by clicking the icon.
Have you tried
Goat Boy wrote:
> I want ot place Word, pdf, and other documents into a spreadsheet as objects
> that can be opened by clicking the icon.
...What is error 623? How can I correct it?
When I close Outlook I get the message,"error 623:the system could not find
the phone book entry for this address."
What can I do to correcct this?
...Newbie needs help with table
I have created a database with two tables:
The product table contains the following fields:
the orders table contains:
When I created the Orders table I wanted to use the ProdID on the
Product table as a lookup field. When I created the lookup type I
selected from the Product Table the ProdID and Descr.
When I try to do data entry the system does not properly input the
data into the orders ProdID table.
What I want is to display the ID AND the Description but I only want
the ID placed in the or...Can't send images to multiple users
I am using Outlook 2003 and when I try to send an image to
multiple people the message will not send it just sits in
my outbox. If I send the image to one person at a time
everything works correctly.
How big is the image, and how many recipients? Multiply the file size by the
number of recipients and add on a bit more to figure out how big the
outbound message is...you may be hitting a limit set by your ISP for message
Michael Stephens wrote:
> I am using Outlook 2003 and when I try to send an image to
> multiple people the message will not send it just sits in
> my outbox....can't copy text to new pub document
I am trying to copy entire pages from one Publisher 2007 doc to another. It
will copy the text in some text boxes but not in others. I don't understand
why this is happening. How do I get it to copy the entire page as is? I am
using Ctrl A or Select All.
Oh, another thing to add: Even if I select only a single text box, it will
not copy any text.
> I am trying to copy entire pages from one Publisher 2007 doc to another. It
> will copy the text in some text boxes but not in others. I don't understand
> why this is happening. How d...OE6
how do i Modify the Unsafe File List? is that the best way to reset this
This newsgroup is for support of Outlook 97-2003 from the Office
family for Windows PCs. For Outlook Express (OE) support try posting in one
microsoft.public.inetexplorer.ie4.outlookexpress for OE 4.x
microsoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.x
http://support.microsoft.com/newsgroups/default.aspx?ICP=GSS3&NewsGroup=microsoft.public.windows.inetexplorer.ie5.outlookexpress&SLCID=US&sd=GN&id=fh;en-us;newsgroupsmicrosoft.public.windows.inetexplore...Help me with formula
I have a basic graph 1,2,3,4,5.....going down in and a,b,c,d,e,f,c going
A B C D E F G
1 500 25 75 800 (200)
My question is how can I make an equation that Goes like this :
I showed an example above for on row but i wouuld wnat this to work for
any row no matter what data I answer.
I want this ewuation to work for any data entered for the whole sheet.
I hope you understand and can help anyone.
------...Can't send attachments #8
Although I can send email, if I try to send an attachment
the mail doesn't go through and I receive the following
msg: "An unknown error has occurred. Subject 'Request
for e-mail help, etc EXERCISES.xls [07/20]', Account: '--
my edress-- Mail Account',
Server: 'smtpauth.earthlink.net', Protocol: SMTP, Server
Response: '554 Too many nonmail commands', Port: 25,
Secure(SSL): No, Server Error: 554, Error Number:
Can anyone give me any hints about how to rectify this
problem? I'm barely literate in computers and need to use...can't open .jpg from outlook 2000 without saving first
We have a laptop running Windows XP SP1 with Office 2000
Premium SR1 installed, all patches up to date. When this
laptop receives an email message with a .jpg file
attached, we cannot double-click the attachment to open
it. We get the error message, "No file format
information can be found in the registry." When we
clicks OK, we get the message, "Unknown file format."
Microsoft Photo Editor opens, but nothing appears.
If we save the file to the desktop, it opens without any
problem, but uses the program Windows Picture and Fax
Viewer. When we go in to the Fol...Help identifying virus
I get an email. Almost instantly another email "arrives" with the same
subject but containing the following text:
--- begin quote
How are you doing recently?
I would like to introduce you a very good company which i knew. Their
website is www.ebakm.com They can offer
you all kinds of electronical products which you need,like Laptops ,GPS ,TV
LCD,Cell Phones,PS3,MP3/4,Watch etc........
Please take some time to have a check ,there must be something you 'd like
to purchase .
Hope you have a good mood in shopping from their company !
Best Regar...Help Pleeeeeeeeeeeeeeeeease :-(
hello im new, my names Gary an im from coventry in england :-)
im doing A(s)-Level ICT and currently working on a spreadsheet desig
for a business including order forms customer database etc. the classi
a-level ict project basically.
I have a catalogue page with the products and the cutomer chooses th
size of the product and how many they want etc. i want to create
button that the uer clicks that then inserrts this data they hav
chosen into the next available space on the order form worksheet, ho
would i do this? i probably sound really stupid :confused: but i
would really help me if you c...I need help to customize a specific PowerPoint template
For PowerPoint template called "Beam", how do I change the first bullet on
the master slide to be yellow instead of red and still keep the shade effect,
and bring the bullet that is blue with the shade effect up to be the second
...Getting duplicate records, can't figure out why!
I'm creating a database to track inventory movements for reserve calculation
purposes. I start out with two tables, Inv Mov and Inv Bal.
From Inv Mov, I create a Query "Initial Movements" as a filter. When I run
this query, all looks good.
I create a new query, "Transaction Summary" that joins fields "P/N" from
table "Inv Bal" and Query "Initial Movements".
When I run this second query, every record is duplicated. I can't figure
out why, and I'm trying to eliminate this. Here's the SQL:
SELECT [Inv Bal Eco].[P/N], ...auto-updating the auto-updater so 12.0.1 can be installed forces a complete delete and reinstall of office 2008
Operating System: Mac OS X 10.5 (Leopard)
Okay - I must confess I never thought that the mac geeks that work for microsoft had any affinity for writing bad code, but i definately found some in the auo-updating system - which after a reinstall didnt recognise that 12.0.1 OR its own update were ready for download - i had to download 12.0.1 as a .dmg and have NO idea how to force the upgrader program to upgrade itself like its supposed to -- because it DID SO ONCE, and as of this moment none of the applications that are updated by that package refect that they have...Command Button
I would appreciate any help with this. I have a command button on my main
form that when you click on it it will take you to the main switchboard and
the reports page. This is the what I have now. My Switchboard has two
pages. Page one has forms and button to go to the second page which lists
reports. This only takes me to the main switchboard. If I type
[SwitchboardID] is says there is no such field. I want the command button to
take me to the second page of the switchboard and open reports.
This is the info in the switchboard table for Reports.
SwitchboardID = 2; ItemNumber =...