use a results in a Query to compare with information in a table
This is what I am trying to accomplish: I do a Query on one table that
returns a result of the combined time and number of parts produced for that
time. Then I get an expression that results in number of parts produced per
hour. This is all good but now I need it to compare the “part number”
returned in the Query with the “part number” in the Parts table and compare
the “parts per hour produced” with the “parts per hour estimated” and return
as % efficient. How do I that information from the parts table? Thanks for
any help. Access 2007
We're not there, we can't see your...corrupt pst file problem
I use Outlook 2002 with Internet Mail Only (IMO). My pst
file is 540,944 bytes. When I use Outlook now, it is
likely that my computer will crash with a blue screen.\
"cannot copy file bobg: cyclic redundancy error":
I tried to copy my pst file before I tried to fix or
change anything but at the very end of the copy I get an
error "cannot copy file bobg: cyclic redundancy error".
I have used Norton disk doctor and PC-Doctor to check the
hard disk (NTFS). PC-Doctor reports no errors, Norton
reports a couple of indexes that should be deleted.
I was surprised that sea...Ms Oulook-Information store could not be opened
I hope someone can help me with an oultook problem I am
I have just moved to a new city and I am trying to access
my e-mail on my comouter. Our office is operating and
exchange server for e-mail. I have a windows XP and
outlook 2002 on my home machine. I am accessing through a
network provided by the university.
Whenever I try to access my e-mail. Outlook takes forever
trying to connect to the server and comes back with a
message saying the server is not available now and gives
the option of working off line or retry. When I retry I
get an error message saying that in...Internet Order variables in exchange table through the Yahoo stores module
I have a custom built shopping cart based on the yahoo stores module and I
use the exchange table to import the web orders. The only documentation I
have is the example provided in the Knowledge base. In the example, there is
no tag for discount, how can i specift a discount the the transaction? Also,
the currency is denoted by:
<Order currency="USD" id="smspos-588">
Some orders are in canadian, what should I write in this case?
Thank you very much
I would imagine the Canadian currency is just set to CND and the smspos-588
stays the same. T...Epson TM-H6000II Printer using Windows Driver with Store Operation
I have downloaded the printer driver from Epson. The receipt prints very
slow. It looks good, but takes for ever to print. Does anyone have a clue
why? I'm wondering if my dip switches are set correctly. Any ideas on dip
Try using an OPOS driver.
It may increase the speed.
"Steve A. Petty" <Steve A. Petty@discussions.microsoft.com> wrote in message
> I have downloaded the printer driver from Epson. The receipt prints very
> slow. It looks good, but ...Upgraded OE 6 fails to recognize previous Store directories emails/folders
For several months, I had been using IE/Outlook Express 6.0/SP1 with no
difficulties. During that time, because of many thousands of Yahoo type
group emails, I decided to use my OE 6's Tools--> Options -->
Maintenance --> Store Folder option to change my Store Folder from my small
C drive, to a folder on my large, external USB D drive.
This was working just fine, after exporting once, all of the emails to that
drive (except for whenever I forgot to turn on the external/USB drive, then,
I would have to go through the above process (except for the export) to
change the...Filter information from a combo box to a combo box
I have a equipment table(EqID,Descr,location,etc)and a equipment fixed
table(JobID, empoyee, Location, EqDesc,etc) what i need to do is select in a
form from a combo box the location(already have) and select from another
combo box the equipment linked to the location filed, can some one help me
Take a look at any or all of the following:
Doug Steele,...Collecting customer information at time of sale.
We would like to collect zip codes for each customer and display reminder
prompt the cashier to offer gift certificates? Any suggestions?
In a prior post someone had recommended setting up a walk in customer but
this would prove very cumbersome when the store is busy.
Thanks in advance.
For our clinet, we had set-up customers as surronding area zip code.
For e.g. zip-code 10020, customer account # = 10020
So at the time of the sale select the correct zip-code / account #.
This will make it easy to know which zip codes your customers are coming
from and do marketing accordingly.
I'm running a single instance of Exchange 2000 on a member W2K3 server.
Using NTbackup the account I've designated to run the tasks under can't
back up the information store.
Logs show the following message:
Error: <server>\Microsoft Information Store\First Storage Group is not a
valid drive, or you do not have access.
The account is a member of the local backup operators group and can
successfuly backup all drives and the system state.
My admin account can back up the IS with no problem.
Any suggestions would be welcome. I'd rather not continue running the IS
...Update a spreadsheet with new information.
My problem deals with data. I obtain data from my company database and copy
the information onto Excel spreadsheet. There are about 6 columns with the
last column being labeled the "Notes" column because that's where I track and
leave notes on how things are going with each item. The PROBLEM is that our
database is constantly being updated with new information. Thus I am forced
to either create an entirely new spreadsheet and sit there re-entering my
"Notes" information for each item OR to go through my original spreadsheet
and compare it to the new one to find ...Excel changing information to date
I am receiving a .csv file which has parcel information in
it(municipal use). The parcel information includes a lot
ID which comes in two forms map-lot or map-lot-sublot. A
parcel identified as Map 99 Lot 23 would com in as 99-23,
Map 99, lot 27-4 would be 99-27-4. When opening the CSV
file in Excel this works fine as long as this id does not
look like a date such as Map 2 lot 15 or map 2 lot 15-2,
which would be 2-15 or 2-15-1 which Excel converts these
upon opening to 15-Feb and 2/15/2001. Is there a way to
force Excel to stop making these conversions? There are
two many record...Store domain/username for Exchange on Outlook 2003 client
Anyone know how to store the domain and username on a
client machine using Outlook 2003 and an Exchange Server?
With all previous versions of Outlook, you simply had to
add a couple keys to the registry in :
String Value : LogonDomain = "value"
String Value : UserName = "value"
These values are not used by Outlook 2003 - if anyone
knows the correct registry location, I would appreciate
...Money Money 2002 invoice designer corrupted
after installing Money 2002 on a new computer, fresh
installation, I went to print an invoice and brought up
the invoice designer to add a logo. The program actually
locked and seems to have corrupted the invoice printing
routine. So now I can no longer print any invoices, no
templates even appear to select from, just blanks. I
reinstalled Money thinking that might fix the problem but
it doesn't. None of my older invoices (historical ones
that printer fine on my old computer) print either on the
new install. Is there some file that can be copied over
to fix this. Seems like...Office 2004 Font corruptions.
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Has anyone else experienced major issues with Fonts Corruption with Office
2004. But with all other programs my fonts work 100%. I had this problem
before with Office, it mainly does it when either upgrading the OS 10.4.x or
updating the Office 2004 package. Are there any fix programs that will fix
the fonts for me.
--B_...Outlook 'Corrupted' (crashes system)
Is there a utility/procedure for testing/fixing Outlook? I was working
with Outlook and for some reason it freezes the whole system (WinXP)
when I launch. Even if I click a link in the browser that launches a
mail doc (e.g. Craigslist reply) once it loads the system freezes.
Any help appreciated!
Version of Outlook?
Email environment: POP3, Exchange, etc.?
Anything in the application event viewer?
Using a PST?
Any error messages/numbers?
Outlook Tips: http://www.outlook-tips.net/
> Is th...Printing email without header information
We need to print a large number of emails, but we need to be able to do it
without the annoying header information ie: the name of the user who sent it
to the printer.
How can this be done?
Perhaps some other mail client can do this?
You can't do it in outlook- have no idea if other clients support it.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solu...Excel Chart Vertical Lines Corrupting?
Does anyone know why vertical lines plotted with a XY series on a line
chart would become corrupted? If so, is there a fix or way to prevent
I update 6 workbooks monthly and each has about 40 line charts. We
added vertical lines to all of the charts 6 months ago using the
technique in John Walkenbach's "Excel Charts" book. We adjust the
vertical lines by changing the values in the A column of a single
table each month:
A | B
| XY Series | |
| | ...Information about the OS
are there functions to retrive information
on wich operating system (Win95, 98, ME, XP) the programm
"Kai Sandner" <email@example.com> wrote in message
> are there functions to retrive information
> on wich operating system (Win95, 98, ME, XP) the programm
Jeff Partch [VC++ MVP]
...How can I retrieve information from CRM without software?
My organization used to have CRM 4 from Microsoft. We no longer have the
software but still have all of the files. Is any one aware of how I can read
the data that may be in these files with ease. I have client information in
there that would be great to have.
If you still have your organizationname_MSCRM database, you can retore that
to a SQL server and access the information in the tables. You will most
likely be interested in the AccountBase and ContactBase tables.
"CherylM" <CherylM@discussions.microsoft.com> wrote in message
news:5F2A9E1...Project Server OLAP Database
Today I started getting a strange error whenever I access anything within the
Project Server OLAP database.
1. The actual Project Server databases (non OLAP) are working fine. Can I
generate or recover the OLAP database from the non-OLAP databases (Note: I
don't have a backup for the OLAP database but only for the non-OLAP
2. Is there any fix for this issue?
The error is as follows:
File system error: The following file is corrupted: Physical file:
\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\ProjectServer.0.db\Task Is Milesto...Help with combining information
I am trying to find an easy solution to combine data.
Old Acc New Acc Description Amount
123.120 123 whatever 50.00
155.120 155 whatever 125.00
155.120 155 whatever 220.00
155.120 155 whatever 243.00
199.120 199 whatever 157.00
What I would like to do is be able to roll up the data eg:
Old Acc New Acc Description Amount
123.120 123 whatever 50.00
155.120 155 whatever 588.00
199.120 199 ...Web Service returning class in XML with namespace information
I am trying to return a class from a Webservice without having to deal
with xmlns:xsd and xmlns:xsi. I have to get rid of those because this
is sent over an expensive network and I'd like to minimize the cost.
I've seen posts that show how to do this, but it didn't work for me.
Here is what I've done so far:
public class clsQueTrans
public string label;
public byte data;
public clsQueTrans GetNextMessage(string queueName)
clsQueTrans qt = new clsQueTrans();
qt.label = "fing";
qt.data = new byte;
for(int i = 0; i <...Check Information
Good evening. I am new to Money for the most part. I used Money 2004
Standard and downloaded my bank transactions daily. I have upgraded to MS
Money 2006 Deluxd and am trying to use the Online services and automatic
updates. Money connects to Key Bank fine, but none of the check information
is brought over (check number, memo, etc). So, I end up having to go to
KeyBank anyway, so it doesn't seem to make a lot of sense to use the online
That's where I've always gotten to.
"langley111" <firstname.lastname@example.org> wrote in message
n...Stored procedure smGetNextNoteIndex
I have a co-worker who was posting a batch in Dynamics, when they received
the following message:
The stored procedure smGetNextNoteIndex returned the following results:
DBMS: 1205, Great Plains: 0.
I've never seen this sort of message before. We're using Great Plains 7.5
with MS SQL. Does anyone know what this means? My knowledge of Dynamics is
limited, and our company's resident Dynamics expert is unavailable.
Thanks in advance,
With these types of messages, a number after DBMS means it's a SQL error and
a number after Great Plains me...store some of the information from one cell into another
I would like to store some of the information from one cell into another. For
instance, information in one cell has StampPDF V 2.3. I would like to cut 2.3
into a different cell. I was wondering if anyone new of the quickest way to
do this. I have about 2000+ cells to work with.
If the information you want from the cell is always at the end, and is always
the last 3 characters you could use
=RIGHT(A1,3) assuming that the original information is in cell reference A1
If you actually want to remove the 2.3 from the original cell then
> I would like to st...