link custom field to resource names
i have created a custom field "Primary contact"
is there a way to link it to the list of Resource names?
maybe turn it into a drop down list?
"greg" <email@example.com> wrote in message
> i have created a custom field "Primary contact"
> is there a way to link it to the list of Resource names?
> maybe turn it into a drop down list?
...Bizarre Sales Tax Table Issue
I have four taxes set up in my system, and confirmed in the TAX table in the
ID Description Rate
1 Sales Tax 0%
2 VAT 15%
3 VAT-EX 0%
4 VAT-ZR 0%
If I create a new item, and select VAT, then check the ITEM table, the TaxID
= 3 for that item. You would think that the system would apply the VAT-EX
taxation on the item. However, when i do a transaction, it puts the 15% rate
on the item and everything seems work out okay, including the reports, which
show that VAT was collected. The TransactionEntry table has the proper sales
...count a pair of numbers in row in a table
my question is:
we have the following table:
34 29 13 15 7
15 8 40 11 24
13 6 8 21 38
9 17 23 1 4
22 38 42 37 16
1 18 11 37 41
5 42 18 33 45
9 1 21 41 15
41 1 27 23 42
23 29 7 38 18
42 12 26 34 36
and this one in another sheet
1 2 3
I want to fill the second table with the sum of how many times the numbers
if each row and column appear in the same row in the first table. for
example: how many time the numbers 2 and 3 appear together in the same row
on the first table
Assume t...saving format
i have a spreadsheet that i backup & copy to a new folder but the cell
formulas are replaced with the cell values. how do i keep the formula
Save two copies???
One with the formulas and one after the formulas have been converted to values.
> i have a spreadsheet that i backup & copy to a new folder but the cell
> formulas are replaced with the cell values. how do i keep the formula
Or are you saying that when you make the backup copy the formulas are somehow
changed to values...Add the same field twice to a pivot table but filter one of them?
In my datasheet, I have a "cost" column and a "date" column so each
cost has an associated date. In my pivot table, I've added the "cost"
as a field, which shows the total and this is fine. However, I'd like
to add the "cost" as a field again and this time selecting which dates
to include in the cost number so that I have two cost fields side by
side. Is something like this possible?
That is not possible in the same PT.
You will need to set up a second PT based upon the same data set as the
first but do NOT use the same Pivot Cache to save ...Swipe cards for Cashiers / Customer Loyalty
Is anyone useing swipe cards for cashier sign on?
Or customer loyalty functions?
If so do you know of a good add-on for these or can you give me any other
We have a biometrics Add-in that can be very simply modified to accept a
card swipe instead of a finger print. If you are interested please give us
a call at 1-888-267-RITE or drop us an email at firstname.lastname@example.org.
Retail Information Technology Enterprises (RITE)
320-230-2282 ext. 4002 (Office)
"Gaz" <Gaz@discussi...Problems with Access 2000 reports in Access 2003
we have a sent out a 2000 format access database to a
client running Access 2003. When trying to open any of the
reports they get an error - "the openreport action was
cancelled" - Not sure if they get this by running the
report from the database window or if it's only when done
through a form (buttons that run docmd.openreport when
Is anyone aware of any issues that may be causing this? I
couldn't find anything elsewhere on the MS site.
P.S. the reports work fine in 2000 and XP.
...Erratic custom properties
Two apparently related problems when I use custom properties in custom
stencils with custom templates and property sets (taking into account the
settings related to master and document stencils):
1) Using custom properties result in unpredictable behavior - the custom
properties of the instance does not correspond to that of the stencel (both
with master or document stencils)
2) From time to time when I save a file and re-open it, the custom
properties seem to have gone to MS heaven - properties and values gone.
Appreciate any assistance
Using Excel 2003. I usually use excel to make forms (glorified word
processing) I have recently started to paste data from an Access database
tables, and queries into excel. I would like to know how I should set up my
spreadsheet to show my data by month, quarter and then yearly. I want my
report to show an average percent for the month of April, May, etc then
other cells that show the percent per quarter.
I don't necessarily need you to tell me how to do it step by step because I
think it is going to be alot of steps. For right now, I have 2 sheets and
...Designing a report based on a crosstabe
Hope someone can help cause this is getting into my nerves...
I have a crosstabe that I run with a parameter for "date of sales".
Date of Sale is my column and the results are showed per month. So I run the
query and set the dates from 01/jan/07 to 31/july/07 and the query returns
the 7 months I want (mm/yy). How could I design a report that that would run
with various parameters? From what I understood so far, the field in the
report must necessarily have the name of the result achieved (ex. 01/07,
Hope I made myself understandable...
Cheers everyon...saving file from asp.net
I dynamically generate Word Documents from my web application using
XmlDocument object and need to save them on a mapped network drive. I use
the Save method of XmlDocument object to save documents. Ican save them
successfully on local drive on web server. But when I try to save them on a
mapped network drive, I get permission denied errors. I made sure that
ASPNET had full access right in the folder where I need to save documents. I
also tried using UNC path, but that also does not work. Can someone please
point to what I may be doing wrong and explain the whole setup proces...CUSTOMIZING YOUR OUTLOOK TODAY
When you change the style of Outlook Today by customizing
it (to summer or winter styles for example), then go to
another screen such as Messages or Calendar, and then
switch back to Outlook Today the style that appears is not
the style that you customized it to be.
How can I get it to stay that Style?
Your Caps Lock is Broken
"BRENT (Please Help)" <email@example.com> wrote in message
> When you change the style of Outlook Today by customizing
> it (to summer or winter styles for example), then go to
> another scr...mySQL datetime field reports as Long Integer with ODBC
I'm using Access 2003 as a reporting tool against a mySQL database,
connecting with the mySQL ODBC driver 3.51.17.
The ODBC driver reports every datetime field as a Long Integer in Access.
This makes date operations problematic.
I notice an interesting post in this forum from 2005 that would work fine
("Convert UNIX time to windows general date"), but using a function with
every row seems like an unnecessary performance hit. Also, it seems
counter-intuitive that the driver doesn't recognize the correct field type.
The problem looks suspiciously like the mySQL bug rep...Report Manager #4
I have created a cusomised toolbar but when I customise the toolbar I cannot
find "Report Manager" anywhere to add to it.
The odd thing is that it is on the main menu but does not appear in the
customisable dialogue box.
Does anyone know where to find it, so I can put it on my toolbar.
All help much appreciated.
I'm guessing you created this customized toolbar manually (not by code).
If that's the case and you have "report manager" under the existing tools menu
already (or is it under Data???).
Tools|Customize (just to see that dialog ...Readonly a linked table
I have a table that gets generated every month, and we use as a source
of data for other databases. We link this, but I was wondering if
there is a way to make that linked table read only.
Thanks so much,
> I have a table that gets generated every month, and we use as a source
> of data for other databases. We link this, but I was wondering if
> there is a way to make that linked table read only.
Either make the back-end read-only or use a pass-through query instead
of a linked table.
--> stefan <--
...Connecting Crystal Reports
I've created my ODBC connections and I can see in Crystal Reports my "Great
Plains" connection. I know exactly which tables I want to pull my reports
from but all I see are these ZDP_Tables. I believe these are stored procedure
tables. For example I would like to use the CPY10100 (EE card table) but I
see a few ZDP_CPY10100N_1;1, ZDP_CPY10100N_2;1, ZDP_CPY10100N_3;1 and so
on. These tables have some of the columes I need but not all. Why would I
know be able to see the table doesn't anyone have any idea?
If you look at the screen in which you configure your data sour...Best tool for adding a pivot chart like chart to a report?
Is it the PivotChart form or should I used the MSChart OCX?
Which is easier to set up/configure to display the data properly? (A
multi-column, multi-entity bar chart)
Which is the most flexible?
And where can I find tutorials on using both?
...Print all records on a report ONLY IF Invoice NO is same
How do I get all the detail records for the same invoice no. to appear on the
Presumably you have 2 tables, such as:
- tblInvoice (the header record), with fields:
o InvoiceID primary key
o ClientID relates to tblClient.Client
o InvoiceDate Date/Time
- tblInvoiceDetail (the line items), with fields:
o InvoiceID relates to tblIvoice.InvoiceID
o ProductID relates to tblProduct.ProductID
o Quantity Number
o PriceEach Currency
To create a report that looks like an invoice:
1. Create a query that uses both tables, along with...Text fields in report writer
I have a modified report dictionary, when I go into a report layout and enter
a text field, when I tab off the field what I wrote is converted to something
totally different. Has anyone seen this before? Reports that I have been
using for months suddenly the text fields print something totally different.
????? Any suggestions would be helpful. Thank you!
We use a shared dictionary located on our server, and I find text fields do
not "travel" well - ie. I often lose info if I export a report out of the
dictionary to work on it.
What I do is make a copy of the enti...Using tables created in 2003 IN 2007
My office has recently upgraded to 2007. I enjoy new features such as the
ability to highlight a few words within the table without the ENTIRE table's
font changing; unfortunately, this only works in tables I have created since
the upgrade. My old tables that were brought over from 2003 do not have this
capability. Is there an add-on out there? I do not have to resort to
re-typing and creating all new tables. PS. Copy and pasting into a new table
does not work. Convertting the file using the office button does not work.
I think you talking about what is called...Saving data #2
I need to save data (results) from a base spread sheet program that i use on
a weekly basis. i am in the middle of building this program, and have just
discovered macros, but this, along with links is about my current knowledge
how can i automate to accumulate data from the base spread sheet (program)
when i clear all data from the program to produce fresh results the following
week, and to keep past data up to date and available for further use.
Any help would be appreciated.
With a combination of formulas and dynamic named ranges, it is possible to
just add the ...Totals For a Pivot Table??
I have a pivot table with data linked to an access database.
I went to pivot table options and checked the box under the format options
area "Grand Totals for columns" so that my colums would have totals at the
When it is on the Title all the way to the far right appears but none of my
columns have totals at the bottom?? CAN anybody tell me why?? How can i
resolve this, i'm i checking the wrong format box?
...Sent Messages not being saved in sent folder
Hi. When I send a message, Outlook is no longer saving it
in the sent folder. It was doing this until about a month
ago. It does not matter if this is a new message or a
reply to an old message.
Anyone have any suggestions on how to correct this?
...Placing the results within a table
I have a form where I would add how many openings there are for each
position. Once I get the total I can see it on my form but I am not able to
transfer that total into my table.
My code for this text box is
it adds up the number from each of those fields. What I wanna do it to get
that sum placed into my table. I have tried
Please help me. I am at a lost.
Please and Thank you,
It is not correct to put the total i...save attachment dialog box
Does anyone know how to change the dialog box that opens
up when you click on an attachment to open, instead of
save? The boss thinks he wastes too much time changing
the checkbox. My guess would be somewhere in the
registry, but don't know where or how.
What exactly do you mean? You mean the dialog that comes up and promps you
to Save, Open or Cancel?
The "Confirm Open after Download" can only be modified with local
admnistrator permissions as it changes the registry of the local computer.
Control Panel-> Folder Options-> tab File Types
Robert Sparnaaij [MVP-O...