Unit of Measure Detail table
I am trying to modify the GP sales invoice to add line item weight but for
some reason I cannot pull the IV UOM Detail table on the report. This report
is linked to the IV UOM HDR table which I was able to pull on the SOP Sales
report but if I try to open this, I cannot see the IV UOM Detail table. Any
...matching data from different tables with similar columns
HI, I am having some trouble with matching some data and I was wonderin
if anybody could help me? I have two tables with the columns "Name" an
"Amount", the first table has the column "Names" field but the colum
"Amount" empty. I wanted to fill the "Amount" column in the firs
table based on the second table, the problem is that the second tabl
has many more records than the first. Is there a way to create
formula to look up the name on second table and "amount" data on th
first table. Thanks for the help.
Mes...Pivot Table Problem
I am working in an excel spreadsheet which another person created a pivot
table in. I have to do a lot of cutting and pasting into another report. When
I scroll my mouse over any cell in the sheet with data in it a bluebox
appears with the information in that in cell. How do I turn that off? It is
very annoying as it causes a delay in my trying to copy that cell.
While in the pivot table choose PivotTable Tools, Options, Options, Display
and turn off Show contextual tooltips.
If this helps, please click the Yes button.
...Excel 2002 only pivot table feature?
I have a pivot table that was created in Excel 2002. My
co-workers who view the same pivot table in Excel 2000
don't get a "Show All" selection to "select
all"/"deselect all" row field data when they click on the
row field item down-arrow. I hope someone can help me
with this question...Is the "Show All" selection an Excel
2002 only feature or is there a setting/feature in Excel
2000 that can produce the same result as the Excel
2002 "Show All" selection?
Excel 2000 doesn't have this feature, but you can show ...Cross table
Hi everybody !!
i come again here with a problem i can seem to solve :s
i hope someone will be able to give me a hand on this...
here it is :
i have a sheet with 2 rows: location and activity.
several activities can be found in one location, even several of the
I would like to create something that give me as a result a sheet where
we can see the spatial relations between the activities.
so i would have all...Excel Table Question
I have a table of data, 3 columns
Date Type Business Unit
01Jul 06 FAC NP
05 Jul 06 FAC BU5
11 Jul 06 MTC BU3
14 Aug 06 FAC BU3
16 Aug 06 MTC BU1
22 Aug 06 NWR NP
23 Aug 06 NWR NP
25 Aug 06 FAC BU1
The output I want is a table for each Business Unit, as below
BU1 FAC MTC NWR RWC LTC Total
Jul 06 2 1 0 0 0 3
Aug 06 2 1 2 ...pivot tables #28
Hi, I need you help, please, because I don´t find any solution to this:
I have 5 columns. Column A has company names. Column B has months. C and
D have items.
A B C D
Company Month Item1 Item2
I would like to get in cells C2 the sum of item1 along the year.
And in C3 the sum of the item in the first month of the year.
I don´t know how to do it.
How do I find something saved in temporary documents by accident?
If you mean the Temp folder on your system, you can press Windows key + R to
display the Run dialog box. Type
and press Enter. Locate the file and move it to a proper location.
On the other hand, if you have edited an e-mail attachment without saving it
to the hard drive first, see http://www.gmayor.com/outlook_attachments.htm.
Microsoft Word MVP
"Lisa M" <Lisa M@discussions.microsoft.com> wrote in message
news:009F3D91-414E-4213-AA89-B4CA5939BE8B@microsoft.com.....Franchise Opportunity, Join A Winning Team
Automotive Franchise Opportunity
Join A Winning Team
Bear Transmission Center, a Leading Transmission & Complete Car Care
Franchise Company is expanding in the following areas:
Throughout the state of Florida 273 cities.
No Automotive or Mechanical Experience is Required. .
Why Bear Transmission?
Over 15 years solid automotive transmission business and trade
The best and most lucrative of transmission repair specialists in the
Most of our franchisees do not have automotive experience
We offer a Proven System with the Best Training & Support in ...Temporary files
I was trying to burn a movie when a message came up to say that there was no
room in C:\documents~\Bonnie~|local~\tmp~ Files like DF19C2.tmp,
DF9E43.tmp, DF5OF6.tmp what are these files?
=?Utf-8?B?cGVha3MgYXo=?= <peaks firstname.lastname@example.org>
> I was trying to burn a movie when a message came up to say
> that there was no room in C:\documents~\Bonnie~|local~\tmp~
> Files like DF19C2.tmp, DF9E43.tmp, DF5OF6.tmp what are
> these files?
Generally, most *.tmp files (along with *.~, ~8.*...excel table
how can i set the "name" and "range" in the "Excel table"??
lsy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23917
View this thread: http://www.excelforum.com/showthread.php?threadid=375910
If you are talking about creating a new table or range, highlight the area
you wish to make a range, then do Insert > Name > Define, and type the name
you wish to give the range in the small window at the top of the
pop-up.........the "Refers to:&quo...Export Tables to SQL Server
I have a database already in Access 2003, and want to export the structure
(just the tables, not the data) into SQL Server Express 2005 (there are no
stored queries, macros, etc... to worry about).
What's the easiest way to do this?
I've tried using the Upsizing Wizard, but it doesn't seem to want to talk to
SQL Server Express.
you shoudl get a copy of SLQ Server Developers Edition and learn how to use
or if you go file, new, project (existing data) you should be able to import
SOME tables into SQL Server just using MS Access
"Phil" <N/...Disable a table in CTabCtrl.
How to disable a table in CTabCtrl.
I cannot do this, anyone could give a solution?
...Update table with date and number
I'm trying to update a table with the current date and the current user ID
but I keep getting a syntax error. Could somebody check my code and tell me
what I'm doing wrong?
Dim strUserID As Integer
strUserID = DLookup("UserID", "q_GetUser")
CurrentDb.Execute "UPDATE (pt_PurchaseOrders) SET
pt_PurchaseOrders.CancelledDate = Date(), pt_PurchaseOrders.CancelledBy =
strUserID WHERE pt_PurchaseOrders.PONumber = " & Me.PONumber
Two things - you want the RunSQL statement (not the Execute), and also the
strUserID needs to have ...SAving temporary files
So I opened a document file from my email and worked on it for awhile. I
pressed the save button and the bar in the lower right hand corner saig word
is saving wo.doc. But now I cannot find said word document. I have looked in
my temporary internet files and cannot find it there.
Locations shown here;
"emily" <email@example.com> wrote in message
> So I opened a document file from my email and worked on it for awhile. I
> pre...to show only last date from a table
I have a table for employee vacation dates. How can i get a text box in a
form to show only the last vacation date?
On Wed, 21 Nov 2007 14:37:01 -0800, Mr. G. <MrG@discussions.microsoft.com>
>I have a table for employee vacation dates. How can i get a text box in a
>form to show only the last vacation date?
Set its control source to
=DMax("[vacationdate]", "[tablename]", "[employeeID] = " & [EmployeeID])
using your own field and table names of course.
John W. Vinson [MVP]
"John W. V...Best approach? Native Excel pivot for a SQL table
We've researched how to have an Excel pivot table use as its source a table
generated by a SQL-based program. There are a number of ways mentioned in
the Excel documentation. At least one seem complicated to even test--like
having to create a data definition. We're happy to do the work but are
unclear which method is best, and whether one or more methods is risky. We
first probably will have to create the pivot table using a sample table with
the right field names, and then ideally will point it somehow at the real
table, which will be on a different system and at a different path....Word cannot read temporary file
Operating System: Mac OS X 10.6 (Snow Leopard)
Over the last two months I have experienced a major problem with Word (12.2.4) when dealing with Word attachments opened from Lotus Notes (8.5.1). After opening Word attachments at some indeterminate time afterwards I will receive the message 'Word encountered an error reading xxxxx.doc. The file may be corrupt'. Clicking OK results in 'Word failed reading from this file'. The retry button here just loops back to the same message, pressing Cancel results on 'Word encountered an error readi...Pivot Table - Group by Month
My data is in financial year, July to June. The date field is in the format
DD/MM/YYYY which is in the column area of the pivot table. I have this
grouped by month and year, so it displays Jul-Dec 2003, followed by Jan-Jun
Some items in the "Row" area of the table do not have entries for all 12
months, but I still want to display the month for that item (with no data).
In the "field settings" of month I have selected "show items with no data".
Unfortunately this then displays Jan-Jun for 2003 and Jul-Dec for 2004, all
blank because those d...Pivot Table configuration
I have got a query looking at Sales History against Forecast and want to see
the accuracy to forecast as a percentage in a pivot table.
The fields I have are
Var: IIf([ForecastQty] Is Null,[ActualSales],([ActualSales]-[ForecastQty]))
This all works fine if I run the query but when I try and put it into a
pivot Table it doesn't like it and crashes.
Is there a different way to handle this in Pivot tables.
Thank you in Advance
...working with temporary working files.. #2
I keep getting the message that I cannot save a temp. working file. This work
has been save on a cd and transfered back on to my desk top. Help
Right-click the file, properties, see if "read only" is checked. This happens when a
file is saved to a CD. Save the file on your hard drive and then copy it to the CD.
Publisher does not like saving to removable media.
Delete all the temporary (.tmp) files that are located in the Windows\Temp folder.
For information about how to delete files, click Start, click Help, click the Index
tab, type deleting files, and then click Display.
i want to develop a timetable for teachers and their periods.
i want there should not be timeclash
b166er's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3491
View this thread: http://www.excelforum.com/showthread.php?threadid=57376
What have you done so far?
Where are you getting stuck?
If you provide some details, someone may be able to help.
> hi members
> i want to develop a timetable for teachers and their periods.
> i want there sh...Decimal places in a temporary table
I am using a temporary table to perform calculations before appending
the resultant invoice transaction records to my main table. The
temporary table is created in code like this:
strSQL = "CREATE TABLE tblInvoiceTransactionsTemp
(fldInvoiceTransactionID Double,fldProductID Double, fldIFAID
Double,fldQuantity Integer, fldFreeOfCharge YesNo,"
strSQL = strSQL & "fldEnqID Double, fldInvoiceHeaderID Double,
fldAgreedPrice Currency, fldVATRate Double)"
This all works fine but the problem is the VAT (tax) rate - the
current rate is 17.5% but wh...Mass Data Entry for a Junction Table
On my Junction table we track the employee and what education
offerings they have attended. We have found that we have multiple
employees attending the same offerings on the same day. (makes sense,
if a class is offered one day you will about 20-30 people in that
class) Is there any way to simplify the data entry process.
Right now on the form the person doing data entry selects the
employee, the education offering and the date. This has to be done for
What would be great would be to create a form that allows you to
select a course and a date, and then select mult...Outlook attachment temporary folder
In outlook 2000, the attachment will be saved to a fixed location, defined
under the key
reTempFolder (from KB KB249793)
The temporary file will be removed from those temporary location usually,
but not always. It may leave some files behind in this folder. How to make
sure that Outlook will clear up the temporary file inside that folder?
The only way to insure that outlook deletes the temps is to close the
attachment before moving to a new message.
"Samuel" <firstname.lastname@example.org> wrote in message