Trouble Importing Vendors into Items in a New Database
We are using a Microsoft SQL database import utility and have successfully
imported all items into their respective departsment with the correct tax IDs
ect. We cannot import the supplier choices into each item. What would be the
quickest way to set each item up with their appropriate supplier choice? This
customer has almost 1500 items and he doesn't look forward to enter each item
by hand with its supplier setting.
Hi Big Dave - where you able to import the suppliers into the supplier table
? - items are then linked to suppliers in the supplierlist table on item.id =
supplierlist...I do not have Excel on my computer. How do I open an attachment w.
How do I open an attachment in my e- mail with an XLS file, if I do not have
Excel installed on my computer? My model is Windows XP Home.
You can use the free viewer available from microsoft web site that only
allows viewing. Or, you can find a copy of open office/star office that
allows you to import excel files.
"Kathy" <Kathy@discussions.microsoft.com> wrote in message
> How do I open an attachment in my e- mail with an XLS file, if I do not
> Excel ins...open/save dialog title broken
The title bar of any Office 2003 program's open/save dialog has just a
single letter. Any ideas what's broken?
...Domain Controller Security Policy
I was trying to open both "Domain Controller Security
Policy" and "Domain Security Policy", I have the error:
"Failed to open the group policy object, you may not have
appropriate rights" and in detail section "the parameter
I log on as administrator so don't think if it has
anything to do with permission and right
...Publisher file made in Publisher 2007 won't open in 2007
I produced an 8.5 x 11 brochure two days ago in Publisher 2007. I was able
to save, resave and reopen the file many times during the day. When I tried
to open the file today, I get the "Publisher cannot open the file" error
message. I've tried to open the file on two different machines with
Publisher 2007 and get the error message both time. One has XP Pro, the
other has Visa Home Basic. It's a 1.6 meg file. I have a smaller publisher
file of a bumper sticker (40 kb) which was made a couple of weeks ago which
opens with no problem.
This is the second time I ha...preview text disappears when email is opened
When someone responds to an my email, I can see what they have typed - until
I open the message - then only my original message is viewable. The preview
pane shows new message text when email arrives, hoever when the email is
opened the preview text disappears - and I just see the earlier part of the
message which I had sent.
If I mark it as unread it does not return to the previous state.
This seems to happen on email responses that people have received and
answered from a webmail service not that they downloaded and opened in
outlook on their PC
OL'03 XP pro sp2
Respectfully,...Repair SQL Corrupt database
I have a corrupt MS SQL Server 2005 database which I
am trying to repair using:
DBCC CHECKDB ('MYDB', REPAIR_ALLOW_DATA_LOSS)
Unfortunately this does not seem to fix anything.
After running the repair multiple times, I ran
DBCC CHECKDB ('MYDB') WITH NO_INFOMSGS
to see if it fixed the corruption, I noticed that is was returning a
random amount of errors on each run.
Does any know if It is the case that this database is beyond repair?
If so will the best approach be to revert back to a non corrupt
database backup and then roll forward using Transaction Lo...Exchange database folder
I have just installed Exchange 2003 on windows 2003 server and all files
(database, mailboxes....) are installed on drive "c:".
How could move all on drive "e:" ?
Open ESM, navigate to the server -> Mailbox Store -> Properties ->
-> Database TAB
Click "Brows" for Exchange Database file and brows to the new location
Do the same fore the Exchange streaming file
Click Apply, after move process finished you notify for it
It is highly recommended that you move the Transaction Log to another
The operatio...can't open files
I have Microsoft Office 2003 ~ all of a sudden when I go to my documents
and try to open a file, I get this message "problem sending command to the
program". Error 0646 and dt000
See the article "How to re-register Word when problems crop up opening
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Lost in Vegas" <Lo...XML as a database that can be written to
Has anyone had any luck using XML as a database that not only can be read,
but also written to?
What features are available in .NET to do this?
I need to do all of this from a Web based application.
Am I thinking File System Object?
> Has anyone had any luck using XML as a database that not only can be read,
> but also written to?
That's doable, but you better use real database instead. XML wasn't
meant to be used as a database, it's just a data format.
Oleg Tkachenko [XML MVP]
Yes, it can be done and I think its an id...Practice downloaded opened but instruction viewer encountered prob
HELP! I downloaded the free trial of 20007 Professional. After viewing
Windows Word 2007 Training 1st session, pressed practice session. 2007 word
downloaded practice screen but the instruction screen attempted to open but
received error message box "MS Office Help Viewer encountered problem and
needs to close." Could not get instructions to complete practice!! Trying to
get a job and need to review & practice 2007 software asap! Any suggestions?
...toggling between open work books
Re EXCEL97 under WinXP-Pro w/SR-2
Microsoft Windows allows you to easily toggle between applications using
Alt-Tab. Is there a similar key board to toggle between two open
workbooks in Excel? One can use Alt-W to display list of open
workbooks, but you can�t just blinding hit the up or down arrow, because
the most recently accessed workbook is not always at the top or bottom.
I realize that I could get around the problem of opening two copies of
Excel and then toggling using the Alt-Tab keys, but typically I�ve got
two workbooks open in one copy of Excel before I realize I need the
f...08 Mac Office activation problems
Operating System: Mac OS X 10.5 (Leopard)
Just found an article posted by michellec and I am faced with exactly the same problem - on 'activation' of the product, none of the 3 product keys seem to be correct, hence activation is unsuccessful!! Have received some help emails (and thanks Diana yours had the microsoft help number that has been good, despite the fact they can't help me and tell me I must get in touch with Digital River) but seems that what I need is another product key, and now that I'm asking for that since about 10 days, I don't get any reply ...Opening for Great Plains Developer in SF Bay Area
We have a current position open for a Great Plains developer to perform
dB maintenance for Great Plains installation. Open to Contract or
Contract to Perm.
Full job description on request.
Please email if you are interested.
...Opening and formating a CSV file?
Could someone remind me how to handle CSV files please? I had assumed
the Text Import Wizard would pop-up when I use File|Open, but the data
goes straight into the worksheet. (Presumably because it is not
'delimited'?) Without the Wizard at my side, how do I get each
comma-separated field in its own column?
Terry, West Sussex, UK
Try renaming your .csv file to .txt
Terry Pinnell wrote:
> Could someone remind me how to handle CSV files please? I had assumed
> the Text Import Wizard would pop-up when I use File|Open, but the data
> goes straight into the worksheet...Open Workbook
I have a query that pulls 2 fields from a table. One field (ReportName) is
selected from a form combo box. The second field (ReportLocation) in the
query is the full path of the ReportName selected. I want to open the
workbook using the ReportLocation, when the ReportName in the form changes.
So I need to the code to enter in "On Change" for my form, so whatever report
is selected, it opens up.
Please help. Thank you in advance.
Message posted via AccessMonster.com
here is my current code that doesn'...Opening to a default tab?
Is there a way to get a workbook to default to a certain tab when opening
the file? I noticed that it opens to whatever page was open when last saved
but I want it to always open to the first sheet regardless. Any ideas?
Thank you in advance,
Use the Workbook_open event in ThisWorkbook module or an auto_open macro in
a regular module
"Joe" <Joe@home.com> wrote in message
> Is there a wa...CRM 3.0 Setup err databases already exist on the specified SQL Ser
Question : How to clear this problem?
The On-Line Help did not applied as SQL 2005 has been installed on SBS2003
Microsoft SQL Server Reporting Services
There are two causes for this error:
Microsoft SQL Server Reporting Services is already installed on the
Setup has found a version of Microsoft SQL Server that is not supported by
Microsoft SQL Server Reporting Services.
One of the following versions of Microsoft SQL Server are required for
Microsoft SQL Server Repor...Read file info using SMO locks database!
I'm using SMO from C# to restore a database from a backup file. Since I want
to re-use the same datafiles I try to read the datafiles in my destination
database and call RelocateFile to use these filenames during the restore.
Everyting works fine except when I try to read the current datafilenames
(see code below). If I skip this code and just hardcode the paths in
relocatefile everything works fine.
Database db = svr.Databases[destinationDBName];
foreach (FileGroup group in db.FileGroups)
foreach (DataFile file in group.Files)
Console.WriteLine...Open Continuous form with a few lines showing
I have successfully implemented a continuous form to open at a new
in the Load Event
However, you have to manually scroll a little to see a few of the
It would be nice to see up to 5 of these previous lines on Opening the
Is there a way to modify this code to do that?
Change the form's underlying record source to a Top 5 query.
In a query's design view, right click in a blank area, and choose
properties. Set the Top Values to 5, then adjust your criteria and order by
clause to ret...Excel2002 suddenly taking 2 minutes just to open! Any thought?!
Norton AV 2003 } (latest everthing)
System c. 1.5 year old - Intel P4 1.7GHz, 512MB
My Excel(2002) is suddenly taking over 2 minutes (!!)
to open (without asking it to open a particular
I am on Windows2000 and Norton AntiVirus 2003.
I have tried re-booting.
I have defragged and scanned the disk with the utilities
that come with Windows2000.
Both my hard disks have plenty space.
Everything else is normal speed.
What is weird is that it gets stuc...Emails are automatically opening
When I select an email in outlook xp the emails are automatically opening the first highlighted email. Yes, ;) I have checked my settings in folder views - double click is selected, even if I reset it to single then back to double still no go. Also once I close a message, the next one automatically opens - just close not move or deletes.
...can't open attachments in OE 6
I just installed OE 6 in Win 98, and it won't let me open attachments. What
do I do to change this?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.502 / Virus Database: 300 - Release Date: 7/18/03
hit forward, then save the attachment :)
It's a new security feature to prevent accidental opening of viruses, either
by yourself or scripting. you can disable it in tools | options | security,
but I think the extra effort to hit forward is safer and well worth the
...Run a macro when opening a spreadsheet
How or where do I invoke a macro when I open a spreadsheet.
name it autoexec
In the workbook's ThisWorkbook Module, insert a
macro. To access this module, right-click the Excel icon to the left of
"File" on th menu bar, select "View Code".
Alternatively, in a general module, insert a
If you are unfamiliar with macros, see David McRitchie's Getting Started
with Macros and User Defined Fu...Accessing Outlook data from database or programatically from ASP.NET
I'm not sure whether I post this in the correct group but nevertheless, here
is my problem:
I would like to manipulate Outlook data (tasks, contacts, calendar, etc.)
programatically from an ASP.NET apllication, more precisely I would like to
be able to add and change contacts and enter events to calendar in the
Outlook from a web application. Now, the logical way seemed to be to link
from an MS Access database to objects within Outlook and then to access
those tables from within my ASP.NET code. However, I've noticed something
strange: for example, the linked table &qu...