Form fields vs. document properties
I'm creating common templates for multiple dealers of the same product. For
example, one dealer may open my "Client Guide" document and all he needs to
do is update approximately 20 fields and he is done. I'm using the standard
document properties fields for my company information, but there are 10+ more
unique fields I need to do this for.
I've been trying all night to use quick parts, building blocks, etc. to
accomplish this but I am really struggling. I can use a fill-in field, but
it prompts for the field every place I use it. I've enabled th...Calculation / Format Error
I'm using this formula in cell AE69
When the logic is true I want the cell value to be zero, but show as blank.
When this cell is summed up with others, a #VALUE! is returned. I am
assuming excel is seeing this cell as text and thus returning an error.
I have tried adjusting the formula to:
I have selected the accounting formating for AE69 with the "£" symbol.
However, instead of getting the £ symbol to the left and a dash representing
z...Pivot table and it's macro
I am creating a table and from the table a pivot table using a macro. When I
run the macro the table gets created without a problem but when it goes to
create the pivot table I get an error and the debugger highlights this
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
:="Perf Tables!R2C8", TableName:="PivotTable1", DefaultVersion:= _
Can anyone see where the problem is happening?
My ...Sub Form
I have a main form and a subform each has a table. The problem I'm running
into is when I get to the subform, and try to enter info into it nothing
happens. Also if I click in the subform it'll work but it starts at the last
field in the subform. I need it to go to the first field on the subform. How
would I get it to do this? I was told something about the label from the
subform that something has to be entered into this.
> when I get to the subform, and try to enter info into it nothing
What do you mean? Are you saying that you cannot even enter data in y...require cell completion in a form?
I have a very simple form in Excel. I'm not sure if it matters, but
the machine I'm on uses Excel 2002, and most of the users are on Excel
2000. The first 2 questions on my form require that the user select
from a list of names, and then select their relationship to that
person. Then the users answer a series of questions about this
person's job performance.
I'm using data validation to manage the two drop-down lists - the
names and the relationships. However, about a third of my users end
up leaving one or both of these cells blank. I have a comment box set
up as a remin...Pivot Table % of
I have a pivot table like the followng:
Joe Trans Ct
Total Joe 10
Total Kelly 11
I added another Count of Trans shown as a "% of column", but it gives me the
percent of the entire column when what I really want is the % of Total Joe, %
of Total Kelly, etc. In this instance I simply made the names go across
instead of down which solved the problem, but there are instances where I
don't want to do that. Any suggestions for getting the percent per item
rather than pe...Pivot Table Updates Issue
My Data had a coloum containing stuff like
I built a bunch of pivot tables on this data. Then I changed the data
and performed a Refresh Data.
Now, on the filter pulldowns on any of the Pivot tables, I see
The first three option no longer exist in any of the data, and I do not
want them in the list. How to fix this problem without recreating and
reformatting 38 seperate Pivot table...Pivot table row header
In a pivot table, I have 2 fields in the row section.
How can I have the value on the first fields to repeat in every row instead
of just showing once?
Try Debra Dalgleish's page at:
Fill Blank Cells
Fill Blank Cells Programmatically*
'by Dave Peterson 2004-01-06]
GMT+8, 1� 22' N 103� 45' E
"Jason" <Jason@discussions.microsoft.com> wrote in message
news:08549CBC-68A7-442E-BABF-D48B11E29479@microsoft.co...how to create escalation form
How do I create escalation form.
> How do I create escalation form.
Since you're the only one here who knows what you're escalating, to whom, in
what way and for what reason, you are the only one who can tell what the
form should look like.
In general, you should create a Word template:
If the form needs to have text that doesn't change, and places to enter text
that does change, then you should create it as a form template:
http://www.word.mvps.org/FAQs/TblsFldsFms/LinesInForms.h...Database Engine Tuning Advisor and autocomplete
Hello there, in the never ending quest for better GP performance, I am onto
indexes. I am convinced that there are additional indexes that can improve
GP in real life situations, but have been unable to find anyone listing
indexes they have used. So my question is, has anyone used the tuning
advisor in sql server 05 and implemented its reccomendations? Were there
noticable effects on GP performance? While I can run a trace against
production and the advisor against a dev environment, I am still wary of
implementing the changes in production...
On a side question, where are the actu...Best Practise
In the process of creating a new Exchange 2003 SP2 Cluster, and had some
questions about breaking up the stores. I am a bit confused between Storage
Groups, and Mailbox Stores.
To break things down, here is the current setup on the existing Exchange
Server (the non cluster one)
Store is at 110GB
Backup Time - Long
When I start moving staff over to the new Exchange box, we want to implement
quotas, and break up some of the accounts. Thought process was this:
1)Directors\Management\Tech - No Quotas
2)Supervisors and other Critical Staff - 700MB
3)Other staff - ...time calculation
I need to do a check on the time.. if it is after midnight but before 5am
then I need to minus 1 day off of the date. How could I do this?
If the Date and Time is in cell A1, use
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
...shortened versions would be
=A1+AND(MOD(A1,1)>VALUE("12:00 AM"),MOD(A1,1)<VALUE("05:00 AM"))
** Posted via: http://www.ozgrid...create pivot table formula without the GETPIVOTDATA function
Previous to Excel 2003 I could use a pivot table result in a formula and copy
that formula as a relative reference. In Excel 2003 a GETPIVOTDATA fromula
is created and uses an absolute reference. Is there a way in Excel 2003 to
either make it arelative reference (without editing the formula) or revert to
the method used in all prior releases?
There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off:
> Previous to Excel 2003 I could use a pivot table resu...Creating Forms
I want to create a form on my website but do not know which program to
use. Should using html be adequate for the purpose?
On 26 Mar 2007 10:16:47 -0700, stromo wrote:
> I want to create a form on my website but do not know which program to
> use. Should using html be adequate for the purpose?
You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
Please repost to the correct newsgroup for whatever Office program you
are using. I would suggest you include your Windows and Office version
number in the message...Pass a command text in pivot table
I've got a pivot table with data give back by odbc (in excel 2003).
When i pass a new sql command, it answer me the database, also if i pass the
connection string. My code is this:
.CommandText = sSelect
.Connection = "ODBC;DSN=DS;DB=" & NomeDB & ";SRVR=;UID=SYSADM;PWD="
sNamePivot --> string variable contain the correct name of the pivot table.
NomeDB --> string variable contain the database.
sSelect --> variable contain the sql command.
Why does it called me ...Pivot Table: showing data as % of subtotal
I have pivot table data in this format:
Name Type Amount
ABC 1 $100
ABC Total $1,000
DEF 1 $150
DEF Total $1,140
and so on
I want to see the data as follows:
Name Type Amount %
ABC...Opening a blank form
I created a form to consult data, the record source is a query that gather
information from different tables, the problem is when I open the form it
shows data already, I want a blank form when it opens, I already tried
including DoCmd.GoToRecord , , acNewRecord in the open from event, but I get
“You can go to the specified record”, if I go to the query I can’t modify the
data or add a new record that is why the acNewRecord is not working.
I’ll really appreciate any help
>I created a form to consult data, the record source is a query ...ACCOUNTS RECEIVABLE / STORE ACCOUNT
For the past three weeks or so we have been implementing RMS and allowing
charges to be made to Tendered "Store Account". Now when we go to print
accounts receivable or statements, no data/balance is available. Purchase
history shows that a charge was made to the "Store Account". Help... a
statement is no good if it does not show a balance. (The company who sold us
RMS was fired months ago do to gross incompetence.)
What is the Tender Type setting of the "Store Account" Tender? SO
Tiber Creek Consulting
http://...Program accessing address stored in outlook
Every time I try to open an email in Outlook 2002 I get a
message saying that a program is trying to access e-mail
addresses stored in Outlook...
How do I make it stop?
I have scanned for viruses and such, I'm clean. Please
(PS - this seems to have started right after updating to
the latest office service pack).
Do you have third party programs installed for spam detection or antivirus
filtering? Have you visited the vendors of these programs for the latest
updates? Are you using Word for the message editor? Try turning off Word
for the meantime until you visit your thi...how to create referential integrity between two tables in diff dat
How can we create referential integrity relationship between tables in
I have databasea db1 and db2.
How to create integrity relationship between Empid of two tables in diff
You cannot create DRI between databases, I mean create PK/FK...
However , you can simple join the tables between databases like
SELECT <columns> FROM db1.tb1 T1 JOIN db2.tb1 T2 ON T1.col=T2.col
"Ajay" <Ajay@discussions.microsoft.com> w...Chart- View Labels- Shared Database...
I am working out of a database used by two other individuals. When I attempt
to print a report, my chart does not display the labels. If I open the chart
in design view, I am unable to view the labels, but if I go further and
actually open the chart all information is displayed.
The other individuals working in the database are able to readily review the
reports and print the data without any problem. We are all using the Access
version, and I have already installed the Office Service Pack 3 fix. Nothing
seems to working.
Any assistance is greatly appreciated.
...Adding row to table in Publisher 2003?
I created a table in Publisher 2003 with two rows and four columns. I added
four pictures to the 1st row ( one in each column), and added the text in
the 2nd row (each text item to correspond with the picture above). Now I
wanted to add a row above the first 1st because I wanted to add a title,
then put a border around the table. But when I select Table, the first row,
and select Insert Row ABOVE, the row always ends up BELOW the row I
selected. What do I need to do?
Thanks for help!
I cannot duplicate this. Are you highlighting the complete row? You need to only
place your curs...Form/ subform link problems
My parent form holds information about a part and my subform holds ordering
information for that part.
Up to now I have linked the child to the parent via PartID : RecordID and
Component Name : Component name. This is great as it shows the component name
on the subform after it has been found on the parent form.
The only problem with this is if the user changes the component name it does
not keep the order information for the same item with the old name.
I want to link purely on the partID : RecordID so that whatever else is
changed the order information history still shows.
When I do t...Percentages in Pivot table
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.
Is this not possible could somebody let me know please.
> ...Maintaining rows in a Pivot Table
I have an Income Statement that has account numbers and subtotals. I want to
keep the hierarchy/order if possible but it seems when I put the data into a
pivot table that it puts everything in numerical order followed by
So is there a way for it not to sort my account data?
You could create a custom list of your account numbers, and base the
sort order on that.
In a cell on a blank worksheet, type your list, then select it
Select the Custom Lists tab
Click the Import button, click OK
When you create a new pivot table, items should b...