adding a new item to existing matrix in rms 2.0
how come when you add an item to an existhing matrix non of the information
is being forward from the main matrix (ex. supplier, price, cost, reorder #,
barcode format, etc.) even the size, color, and 3rd dimention that you
entered to the new item is not being fowarded. what is going on with 2.0
I think the Matrix is still is a little buggy.. Get all hotfixed up and see
if the helps. There have been 3 for 2.0 hotfixes already.
"jack" <firstname.lastname@example.org> wrote in message
> how come...SQL Server
I'm currently using MS-Access to write reports using a SQL Server db as the
data source in a client/server arrangement.
The database is sufficiently large (2gb) that data retrieval speed is an
The current setup is linked tables to the SQL Server db via ODBC, and then
the usual queries.
1. Can views and/or stored procedures on the SQL Server side along with
paramaterized queries provide a significant performance boost?
2. I've read that views and stored procedures can be created w/i Access. Is
this the same as creating them in SQL Server?
3. Are there other things I sho...SBS2008 and SQL 2005
So here is my question, we have the SBS 2008 Premium, and all the
installation media are sent to us. And that includes the SQL 2005 and
2008 installation disks. But after I installed the SBS 2008 on my
first server which we also would like to turn it to SQL, I looked into
the Program And Features and found SQL 2005 already installed. But I
haven't really insert any SQL installation disk. So is that a valid
copy of SQL or just some thing like SQL Express? Do I need to
uninstall that and install from my SQL install disk or I can start to
T...item look up #3
a customer is having an issue. he scans an item in the pos screen and all
details show up. but when he tries to look for it later he cant find it. hes
tried it in manager too. he would usse name, or barcode, or anything and
still nothing. do we know what the problem is?
If the item is set as inactive (in the item properties) it will not show up
in the Find screen, but will scan in at the POS. You can turn off the find
option, but I think it is easier to use one of the SOM reports to find the
item, such as the price report. The item will show up in any report that
includes it as...Using Matrix Items
Someone...want to tell me how or if I can default which item is first
(selected) when a matrix item is scanned? Is there a way to set this up?
What are the dimensions you use?
"Vince" <Nagarra@yahoo.com.(donotspam)> wrote in message
> Someone...want to tell me how or if I can default which item is first
> (selected) when a matrix item is scanned? Is there a way to set this up?
> Thank You
> Vince :)
Using Lot Matrix, what I have is a six pack of coke or a sin...SBS 2008 Fax Sent Items Not showing all faxes sent
I need to allow sent faxes to be seen by all users. I have Windows XP and
Windows 7 64bit client machines. Currently they can only see their sent
faxes. In SBS 2003 they were able to see all sent faxes.
Could you create an Outlook rule based on the fax sent acknowledgement that
copied the fax to a public folder?
"RodSoh" <RodSoh@discussions.microsoft.com> wrote in message
> I need to allow sent faxes to be seen by all users. I have Windows XP...I don't have 'as items arrive' option
I have the 5 minute synch option, which works great.
But I do not have the 'as items arrive' option.
Yes, I am running a MSFP version, I checked the build.
Man I am so close to gettting this to work.
Please help. Thanks,
On Mon, 2 Apr 2007 12:42:00 -0700, MidMOman
>I have the 5 minute synch option, which works great.
>But I do not have the 'as items arrive' option.
>Yes, I am running a MSFP version, I checked the build.
>Man I am so close to gettting this to work.
>Please help. Thanks,
You are either mist...entering multiple costs for an item
I am very new to Retail Management, and am trying to enter inventory, and
create a purchase order. I can't figure out how to enter various costs for
the same item from the same supplier. For example, when we purchase in lots
of 50 pcs., the item cost is .50 per item (total cost of 25.00). However, if
we purchase in lots of 100 pcs, the item cost is .47 per item (total cost of
47.00). We can also purchase the item in boxes of 10 (5.50 per box for a
cost of .55 per item). How can I enter these costs so when I place a
purchase order, the cost will be correct according to the quant...Query emails coming to a specific domain
We have about 5 domains on our exchange server that we receive email
from. We are in the process of not renewing one of our domains but
would like to check to see if email from that domain is still coming
through. Is there any way to do that? I tried the Message Tracking
Center with the *.domain.com but it didn't like that. It wanted a
Check SMTP logs as well.
MVP - Exchange
NEW blog location:
<email@example.com> wrote in message
news:...Auditing Mailbox item access
Don't ask me why I am asking, you don't want to know....but
Is it possible to monitor and log access not only to a mailbox, but
actually to individual items within the mailbox and be able to trace it back
to the specific item and user who accessed it?
I am aware of the ability to log when a non-primary account logs into a
mailbox, but that is not granular enough for the scenario I need to look
into. The powers that be want to be able to see not only who accessed a
particular mailbox, but actually who accessed a particular message within
that mailbox. Just wanted to know if...A SQL error has occurred. Going off line with Outlook CRM 4.
I have seen this in multiple workstations.
Running the diagnostics, does not report any errors, however removing the
temprary data under advenced fixes the problem by deleting the content of the
off line database. The problem with this fix is that it may take up to 12
hours for some of our overseas employees to do their initial off line.
When is SP1 due?
...Add items to SupplierList
I just imported a new catalog of items to our database using EMS import, were
newly insterted and some were updated. The problem I'm having is getting the
supplier cost to update for the items that were in already and adding the
new items to the supplierlist table. I imported the SupplierID to the Item
table just can't figure out the query to go the other way updating and adding
new. Any help would be great.
You need to use T-SQL in the management studio. Use an InnerJoin of the
supplier id to the item id and set the cost to = supplier cost if it is the
"Do...getting consolidate list of "follow up" items
I would like to get a consolidated list of items (sent and received
mails)that have matured - i.e. whose follow up time is up.
I have the habit of tagging a sent mail (after actually sending) for
Similarly, mails received are also tagged for my further action (for
Would appreciate a consolidated follow up report generation way -
rather that opening each folder and looking for mature items (i.e.
Thanks in advance.
...401k Tracking Without Itemized Details
My 401k does not give me an itemized listing of investments. Instead it lists
them by investment type as follows.
Type Shares Price
Company Owned Stock 1000 65
Equity Units 150 300
Common Assets 250 1
I do know what the company owned stock is given it is who I work for. With
each quarterly statement it updates the inform...query to make a list of products based on delivery history
I have a table which lists all deliveries made of our product. From this
table, I'd like to make a list of all products. My problem is the products
will have many duplicates as they can be ordered multiple times and I just
want a list showing all the individual products that we offer.
Try something like:
SELECT DISTINCT [our product]
FROM [which list all deliveries made];
If you can't figure this out, come back with table and field names.
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Def...Update Query based on Current Recordset
I have a continuous form with filtered records. I want to run an update
query on a field in a table based on the current filtered records on the
form. What code would I use to accomplish this task? Any help appreciated
in getting me started.
Without a wee bit more information, like what are you trying to update,
field names, table names, do you want this attached to a button or an event,
etc... The best I can do is...
UPDATE SomeTable SET SomeTable.SomeField= WhateverValue
Of course, the above would be an ...Changing icon for list item
I would like to change the icon for the first column of the list
control in report view. Right now, the method I used is remove the
LVITEM at that location and reinsert at the exact same place with a
different icon. I know this is not efficient compared to directly
changing the icon. I had tried GetItem adn SetItem but even though i
specified a different icon using the index into the imagelist, it still
won't change. Could someone please enblighten me on this? thank you very
> I would like to change the icon for the first column of the list
&...Updating item properties.
We want to change the commission properties for items in our database, with
different commission rate for different as below:
Men’s Clothing – 2%
Women’s Clothing – 2%
Men’s Accessories – 1%
Men’s Accessories – 1%
And this will be a percent of sale.
Is this done with an update query?
It can be done with an SQL update query.
How do you know if an item is men's acc... ?
"Davidjc52" <Davidjc52@discussions.microsoft.com> wrote in message
> We want to change the commission properties for items in our database...IIF Query for Numeric Values in Text Field
I’m attempting to flag interest rate spread errors and omissions in a file
from a sales database using IIF statements I adapted from another database
(I’m a novice at this). The field I’m querying is text format and contains
both alpha and numeric values. When I test for a null value the IIF works
fine, but when I test for a numeric value I get an #ERROR.
Spread Error1: IIf(([Tbl 1 Eligible Closed Deposit Opps Appended]!Spread Is
Spread Error2: IIf(([CCC Fall 2007 Eligible Products]![IB/NIB]="NIB" And
[Tbl 1 Eligible Closed Deposit Opps Appended]!Spread<4),1,0...On Hand Quantity to be Adjusted by Picked (or Fulfilled)
In order for the On Hand quantity to match what is on the shelf at any given
time, the On Hand should be adusted by the picked/fulfilled but not posted
quantities. Those adjusting fields should be available quantities to view on
the Item Inquiry screen and SmartList "Item by Site", as well.
On Hand = Calculated On Hand after posting less unposted picked/fulfilled
The less frequent the invoicing/posting occurs, the more this is an issue.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To ...Insert query with two left outer joins gives "Record is Deleted" m
I have built an insert query to combine data from 3 tables into one table
based on a key value (RA_ID) on a form. Two of the from tables may or may
not have data associated with the main from table. So I have coded the
select from statement using left outer joins. When I run the query with a
row in the first child table but not in the second it works fine but when I
run the query with a key value that exists in the 2nd child table but not in
the first I get a message saying "record is deleted". Anybody have any ideas
what is causing this?
Here is the query.........
...getpivotdata multiple items
Is there any way to have getpivotdata retrieve more than one set o
data, other than doing it like below?
=GETPIVOTDATA('Roll-up Pivot'!$F$2,"hours enrg E
&I$163)+GETPIVOTDATA('Roll-up Pivot'!$F$2,"hours enrg M " &I$163)
For example, would it be possible to us a range of cells as a referenc
Message posted from http://www.ExcelForum.com
...SQL Server and MSDE ?
I have a server box running SQL Server 2000 and RMS HQ Server.
I have another server running MSDE, RMS SO and HQ Client. (at another
location, connected via ADSL VPN)
The problem i have is that HQ Client downloads all worksheets from HQ
Server. BUT it will not upload data back to HQ Server on a 401 it gives me a
SQL Server and MSDE use different collation. any ideas on how to change the
default collation so they are both the same?
You can do it using SQL - see SQL Books online or MSDN.
Also, HQ Administrator and SO administrator both have options on the
dat...SQL Server 2000 / GP 8 Performance problem
We have a default installation of SQL Server 2000 servicing about 5 GP
clients. As soon as more than one person tries using the payroll module
everyone starts slowing down.
A nework trace indicates multiple small queries going back and forth (ping
pong) creating stored procedures and executing them.
This looks like SQL server issue at first sight. Can someone give me ideas
on where I can start looking.
Have you applied SQL SP3a onto the SQL server?
"Dilan Arumainathan" <firstname.lastname@example.org> wrote in message
news:egPPRo%23BFHA.3820@TK...Postpone subform query in tabbed control
I have a form containing a tabbed control. One tab in the tab control
contains a subform loaded from a query. As I understand it, every time I page
from row to row on the main form, the query in the subform runs. I dont want
the query to run until the tab is accessed. If I happen to be on the tab, I
do want it to run. Hope this makes sensnse. Is this possible?