how to use temporary tables in dex
Somebody has one example of how to use temporary tables in dex
Hi Cesar. Define temp tables just as you would define a SQL table in Dex -
but with physical name as "temp" without the quotation. I recommend using
database type ctree for performance as it would just create a temp file in
your directory. From there on, just use the temp table as you would with
normal dex table but remember that once you are done with your routine, your
temp table will be deleted automatically. Use temp table as a temporary
repository for your calculations, reports, etc.
---Darryl Baj...Embedded word doc changed to image-need to change back to word.
I have an embedded word document that misteriously changed into an image.
This image is not a word doc converted into a picture (i.e. like I convert an
embedded word doc by right clicking and selecting 'image object', 'covert',
and then select to activate as a word doc.) but an actual image as if I
inserted a picture. Need to turn the image back into a word doc so I can
recover my work. It would also be nice to figure out how I am changing to an
image, amost seems like a bug since it has randomly happened twice.
...How do I add a secondary axis to a pivot table chart?
Using XL2007 - the secondary axis radio buttons are greyed out. Is there a
way to add the 2nd axis?
This is chart type dependent. Suppose you have a line chart, right click
the series and choose Format Series, the Axis radio button should be
What type of chart are you using?
"dangelor" <email@example.com> wrote in message
> Using XL2007 - the secondary axis radio buttons are greyed out. Is there a
> way to add the 2nd axis?
...Pivot Table #5
I create a pivot table of growing data each month. Now when I create the
pivot table after I set up the layout. I see the message "calculating Pivot
Table" but nothing happens. Is there some setting I need to change on my
computer. All I get now is a empty new worksheet.
...Setting random number range based on query, not table
I have a "quiz" form that randomly pulls up questions from my table. It
works fine, and I don't mind that it repeats questions. This allows me to
sit and review for as long as I want.
The problem is, that I want to use criteria in a query to limit the
available questions. If I base this form on a query and limit the number of
questions, the code I am using is still setting the maximum number as the
number of records in my table.
In the past, I had a similar database (which I have lost) that would open
the form, set the selector to the last record available to the form,...Table requires Custom Linking to Excel
I have a table in Word 2000 with various columns. Each row represents one
order for a meal package. One of the columns indicates one of three baked
pies to order (apple, cherry or pumpkin). Another column indicates whether
or not the order has been paid or unpaid.
Is there a way to put a total number for each of the pie types ordered into
an Excel worksheet? Similarly, would there be a way to analyze all of the
rows, and for all rows with an unpaid status, multiply this number by the
cost for each meal package, and display this result in an Excel worksheet as
Thanks...AutoFormat not working in Word 2007 in Windows 7
I have just installed the Office 2007 suite on Windows 7 Professional, 64-bit
edition. Almost everything works well, but I noticed that when I type
quotes, Word 2007 is not automatically converting them from straight quotes
to curly quotes.
I have went into the Word Options and tried the setting both ways, but it
makes no difference.
I have made absolutely no changes to this installation, and this problem
does not occur on my Windows Vista and Windows XP machines. The computer is
virus-free (I have an antivirus solution running, I don't go to shady sites
to begin with...pivot tables #9
i posted this on the general forum but i thought maybe someone here can
I have a table that has four regions and total sales amount for each
reason by week.
my pivot table lists all those and totals it per region per month.
i want to add in the pivot table a percentage of the regions sales for
that one week over the total sales for all four regions.
is there a way i can add that to the table?
i.e. the table is currently like this:
Week 1 East 500
i want to add the percentages like this:
Week 1 East ...display the value of an unbound textbox in a field within a table
I created 3 textboxs to calculate the number of business days between 2
dates. The 3rd textbox contains the value. I now want to have this value
displayed in a table field. I'm sure this is easy but I'm a complete novice
and have spent far too much time on this already. Can anyone help!
The general concept of tables is that they are for storage of data in
the background. They are not for display of data. That is what forms
and reports are for. Therefore, the appearance of the data in the
tables is not normally relevant, and the display of calculated values is
im...get/change first operation on table 'uprEmployeeCount' failed
I created a 'test' company on V10, restored the backup from our real company
into this test company.
I have inactivated all the employees in the test company.
Unless I enter Dynamics as sa, I get the following message:
A get/change first operation on table 'uprEmployeeCount' failed accessing
Under the more info button:
[Microsoft][ODBC SQL Server Drive][SQL Server] The EXECUTE permission was
denied on the object 'zDP_UPR41600F_1',database 'DYNAMICS', schemo 'dbo'.
I have deleted the UPR41600 table and recreated it but I still get the...Pivot Table Refresh error "Problems Obtaining Data"
I can't seem to get data or change the data source. When I refresh, I get
the error message "Problems Obtaining Data" When I start the Pivot Table
Wizard, the back button is grayed out so that I can't go back and change
Any help is appreciated.
...How the heck do I find tables, views, forms etc... in Access 2007
Can Access 2007 navigation be any more convoluted? I've been spending close
to an hour trying to find a single table, query form, etc... now that the
navigation has been changed. Is there a way to get the old style back?
It does take some time - more than an hour :-) - to become familiar with the
new interface in A2007 (NavPane, ribbon, ...)
- The title bar at the top of the Nav Pane includes a tick box for:
All Access Objects
- Set Category to:
- The categories (Tables, Queries, ...) collapse.
- Show and use the Search Bar. It filters objects as...MAPI Failure message using 2007 word
JOHN HASKINS I keep getting this error message when I try to send a
document from Word 2007 to my Outlook Email Client, which is my default email
setup. I followed the recommended steps that help feature suggested, but that
did not work by saving the document then closing and also closing Outlook,
which was when word would restart it would start a new MAPI Session. No Go!
What much I do. All other applications and software allow me to send to my
email client except Office.
...Pivot table returns `
I have data from an SQL WBC-A. When I pivot this data it returns ` (The
character below the tilde) Any other data returns the correct pivot. E.g.
WBC-X returns WBC-X
...Read XML into Dataset and load SQL server table from Dataset
I am working on a project with the following characteristics:
1. Load data from a SQL server table to an xml file
2. Read the xml file into a dataset.
3. Load data from the dataset into another SQL server table.
I was able to accomplish the first objective.
I used the following code to read the generated xml file into a dataset.
Dim strXml As String = "C:\Customers.xml"
Dim sr As StreamReader = New StreamReader(strXml)
Dim ds As DataSet = New DataSet
How can I traverse in the dataset and post each row to my desired table on ...Tables and banding color in background
I am creating a template where many tables will need to be used. Our standard
is to have banding of rows in the table, and when users want to expand the
table, I would like them to be able to have the banding automatically occur.
This option appears in Word 2007, but does not function well. Has anyone had
success with this functionality?
Thanks in advance for your help.
Color banding can be applied as part of a table style.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"sharon27lily" <sharon27lily@di...DailySales Table
Does anyone know what Type & TypeID columns referring to in DailySales
table in HQ ?
I have customization guide but there is no details about that columns.
Hi Arthur - my understanding of the Daily Sales table is that it gets
populated by some internal function that groups based on supplier, cashier,
etc. Here are some old notes I found on what the Daily Sales Type refer to:
6: Sales Rep
-- the TypeID may refer to the batch that's feeding the info (ie
batch.batchnumber ...Hide Quck Parts in Word 2007
Is it possible to hide empty quick parts in word 2007?
I am populating quick parts from a sharepoint list (wss 3.0) and some of the
fields in this list are not rquired and the field names are showing when the
metadata is empty.
I am running Windows 7 and Word 2007.
I want my attachments to open in Print preview not full screen reading view.
I have unchecked the box in Word Options, rebooted and resent emails with
attachments to myself.
However, they will not open in any other mode but full screen reading view.
Any suggestions welcome.
You can disable Full Screen Reading view, but you cannot force documents to
open in Print Preview. If you mean Print Layout view, then you need to save
them in this view; see http://word.mvps.org/FAQs/General/SaveViewAndZoom.htm
Suzanne S. Barnhill
Microsoft MVP (...View equations created in Word 2007
Operating System: Mac OS X 10.5 (Leopard)
Greetings! I've successfully installed Office 2008 update 12.0.1 on my MacBook Pro running 10.5.2. One of the fixes that was listed in the Microsoft Knowledgebase article associated with the update was the ability to edit equations created in Word 2007 for Windows. After applying the update, I still get a warning message when opening a file created in Word 2007: "This file contains Word 2007 for Windows equations"; the document opens with placeholders (blank squares) instead of the equations. Does anyone el...Inserting word 'merge field' into Excel
I have data in Word merge fields that I need to put in an Excel table. Each Word file is exactly the same and there are a few hundred files. If I can't do this direct to a spreadsheet, can I do it through Access?
...opening an old 1992 Word document, registry error
I tried to open a document created in 1992 but instead of opening I get a
message that tells me I cannot because my registry doesn't allow it
See “Information about certain file types that are blocked after you install
Office 2003 Service Pack 3” at http://support.microsoft.com/?kbid=938810
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Seabee74" <Seabee74@discussions.microsoft.com> wrote in message
>I tried to open a document...Can't open office documents from my emails until word is openned f
When I try to open a word document or excel spreadsheet that is saved as an
attachement to an email, I get the message:
Windows cannot find ‘c:/users/mona/appdata/local\microsoft\windows\temporary
internet files\low\content.IE5\SB2EHHFL\xxx.xls\’ Make sure you typed the
name correctly, and then try again.
If I open Word or Excel before clicking on the attachement to open it, then
it works. This problem only happens when using my laptop which is running
Windows Vista and office 2007. I do not have any problems with this on our
desktop which is running XP and office 2003.
Wo...Table design question
I just wanted to see if the design of some fields in the table are standard
The database admin set up a Code_Desc table with fields Code_Type_ID,
Code_Value and Code_Desc
Code_Type_ID, Code_Value, Code_Desc
1 1 Emp Status - Active
1 2 Emp Status - Inactive
2 1 Emp Type - Associate
2 2 Emp Type - Manager
2 3 Emp Type - Auditor
3 1 ...Mutiple Table Entry into One form Wthout using subforms
I have created a form by adding information from several differnt forms and
table as they areall getting input by several differnt people on the network.
the problem i am having is that i can not make this new form add records and
save them for later query or report from it? could someone please help
Message posted via http://www.accessmonster.com
Why do you not want to use subforms? Unless you can join the tables in such
a way that the resultant query is updatable (usually a challenge), subforms
are the easiest approach.
Doug Steele, Microsoft Access MVP