FIELDS NOT EDITABLE!
I have a problem. I know how to add a field but i dont know how I can make
an existing field editable. If you look at a field like 'Price per Unit' in
Opportunityproduct. You see that the price in the field can not be changed.
There must be a way to change that. I already looked at the properties and i
cant find nothing. Can somebody help me with this.
...Adding and Linking Dates to Another Field
I have two (2) field in my form. Field 1 is called "Date" and field 2 is
called "Due Date". I would like the "Due Date" field to automatically add 90
days from the "Date" field and have that updated in the "Due Date" field. I
tried using the DateAdd function in the control box and also the default
portion of the field.
Any help would be appreciated.
For staters, change the name of the field you call Date. Date is an Access
reserved word. Even when enclosing the name in brackets [Date], you can have
Wher...Boot problem 03-04-10
I have a boot up problem with my xp pro. I shut my computer down at night
and in the morning I get a grey screen at boot up, before anything shows. I
can hear the computer going thru the startup process with nothing showing on
the screen. After turning it on and off many times, including using a dos
boot disc (which doesn't make a difference) it will finally boot. (a
twenty-five minute process). Once it is running I am able to restart without
any problem. It only happens after several hours of being shut down. I have
run diagnostics on the hardware, monitor, graphics card and...Pivot Table?
I need to be able to report on data within a spreadsheet and allow for this to
be customisable by Month / Year.
I thought that I could do this with a pivot table but i'm struggling.
If I've basically got several rows containing the following data fields:
Problem Ref:, Problem Description:, Date Raised:
What I want to be able to do is @ the top level of the report - specify month /
year raised, this will then filter all of the appropriate records underneath
Appreciate your help on this one - many thanks, Al Mackay ( firstname.lastname@example.org
So create your table, g...Problem with msflxgrd.ocx in vista
I have an access 2007 database ive made in Windows XP that uses msflxgrd.ocx
for some activex elements. The customer has Vista and Access 2007 but
whenever I try to open the form that has the FlexGrid it gives me object
Ive copied the msflxgrd.ocx from the Windows XP install to the Vista install
but it doesnt seem to work. If i try and create a new control I get a
How did you register it? I'm just starting to tackle Vista problems, but I
believe you need to register it as admin.
It's also not in the list of Vista's supported vb6.0 run...Duplicates
One worksheet has 600 + lines with a lot of expenses, including SOME of the
local expenses. This is a check register..
Another worksheet has 300 + lines with ONLY local expenses.
Trying to get ALL expenses together, but eliminating the duplicates from new
list. Thinking B2=date. C2=name, E2=amount - - SO B2&C2&E2 on first long
worksheet and then the same on short worksheet... Bring BOTH over to new
tab and then stuck. Any ideas greatly appreciated, or another better way to
You could use excel filter:
Data - Filter - Advanced Filter - Unique records on...Which Office X 10.1.5 duplicate fonts can be removed from which folders?
Which of these duplicate fonts can be removed from the
Applications/Microsoft/Office X/Office/Fonts folder AND/OR the
All of the following are duplicated in the two folders. Two of them, Times
New Roman and Verdana, also are in OS 10.3.3/Library/Fonts.
Comic Sans MS
Copperplate Gothic Bold
Copperplate Gothic Light
Edwardian Script ITC
Times New Roman
On Tue, 6 Apr 2004 04:42:59 -0400, Norman R. Nager, Ph.D. wrote
(in article <...Single continuous field in a report
Wonder if someone can advise.
I'd like to take a single field from a query and have all the results
printed continuously, each field separated by ; and nothing else (i.e. no
What I'm trying to achieve in a rather "quick and dirty" manner is a listing
of e-mail addresses that I can copy and paste into OE to send a large(ish)
e-mail to an organisation's members without *too* much manual intervention.
>I'd like to take a single field from a query and have all the results
>printed continuously, each field separated by ; a...Publisher and tables #2
I am making a booklet. I am putting info in as a table and I need to know if
there is a way to get my table to automatically continue on to the next page.
No, Publisher hasn't this function. Word does...
Mary Sauer MSFT MVP
"Kimmy" <Kimmy@discussions.microsoft.com> wrote in message
>I am making a booklet. I am putting info in as a table and I need to know if
> there is a way to get my table to automatically continue on ...Duplicate data from field into another field in same form?
Can I duplicate data from one field on a form into another field in the same
On our exhibitor entry form, the Program Contact info (fields for name,
address, phone, fax, email) is entered first. Mail Contact info is often the
same, but not always.
Is it possible to autopopulate the Mail Contact with the data from the
Program Contact, but allow me to enter new data if necessary?
If so, can you tell me exactly how?
On Fri, 23 Mar 2007 09:46:24 -0700, Andi <Andi@discussions.microsoft.com>
>Can I duplicate data from one field on a ...nested Serialization problems
I have a class derived from CObject
class CStuff:public CObject
unsigned int *nIntData; // this is an array of unsigned int;
unsigned int m_nValue1, m_nValue2;
// and some member functions;
virtual void Serialize(CArchive &ar);
The object m_SomeElements of the CObArray is populated if objects classes
that are derived from CObject where the
DECLARE_SERIAL and IMPLEMENT_SERIAL macros are specified as well.
CStuff::Serialize(C...Name Resolve in To Field
Outlook 2000 with SP3 on it. Am not able to have any of
the email names that I sent resolve the next time I sent
an email out. Example If I send and email to email@example.com,
the next time I email and start typing jo, I should have
all the names that start with j or jo resolve that were
sent out. Not happing for this customer. Check the KB
with no luck.
CJR <firstname.lastname@example.org> wrote:
> Outlook 2000 with SP3 on it. Am not able to have any of
> the email names that I sent resolve the next time I sent
> an email out. Example If I send and emai...Updateable Query problem in Windows 7
I'm using Office 2003 in a new windows 7 computer. I copied a database to the
new computer from the server. When I try to run the following query, I get a
"must use updateable query" error.
UPDATE LowStockListQuery1B INNER JOIN NewList3 ON LowStockListQuery1B.number
= NewList3.item SET NewList3.LowStk = Yes;
SELECT stock.distrib, supplier.name, stock.number, stock.desc, stock.low,
FROM stock LEFT JOIN supplier ON stock.distrib = supplier.code
WHERE (((stock.distrib)=[Forms]![LLPage]![Combo8]) AND ((stock.low)<2) AND
(...Script execution problem
I'm trying to install patches in PowerShell script. I'm using
`"c:\Hot_Fix_W2K8\Windows6.1-KB974431-x64.msu /quiet /norestart`" ") to
install a patch.
It works well for 1 patch but when I want to installe more patches, it
failed becaus PowerShell lunch all CMD at the same time.
Is there a way to force PowerShell to wait a command finish befor execute
the next one ?
It's more of a problem with msiexec in that it returns immediately.
Perha...Recurring Transfer Payment
I have seen a lot of posts that are similar to my problem but none of
them match exactly.
I'm using MS Money 2003. I have been using Money for over 5 years now
but I'm just now starting to use the budget feature. Here is the
problem that I'm having.
I deleted a $2500 recurring payment from my checking account to my
credit card. When I run the budget reports, it shows a budgeted income
of $2500 under "Transfers Into Budget Accounts". Is there any way to
remove this from my budget reports? It is not income so it is very
The report seemingly cannot be cus...Problem recieving mail on Exchange Server 2003
A client is trying to send us an e-mail, but Exchange keeps dropping the
connection. i have attached the SMTP logs - ip's & addresses removed.
2005-06-09 10:28:46 ---.---.---.--- ###.##.co.uk SMTPSVC1 ===-==
---.---.---.--- 0 EHLO - +###.##.co.uk 250 0 328 22 0 SMTP - - - -
2005-06-09 10:28:46 ---.---.---.--- ###.##.co.uk SMTPSVC1 ===-==
---.---.---.--- 0 MAIL - +FROM:<name@address> 250 0 45 32 0 SMTP - - - -
2005-06-09 10:28:46 ---.---.---.--- ###.##.co.uk SMTPSVC1 ===-==
---.---.---.--- 0 RCPT - +TO:<name@anotheraddress> 250 0 45 42 0 SMTP - - - -
2005-06-09 10:28:4...Time field continues to show date
I have a time field which I have formatted to medium time eg 07:00 AM. This
is OK until you click on it to edit the time, when the date continues to
In the time control's "on enter", "on click" and "before update" events I
have set Me.time = Format(Me.time, "hh:nn"). This prevents the time from
showing the date/time.
However, the date/time continues to flick up every time you click on the
field to change the time. It is driving me mad!
Is there any way to fix this?
> I have a time field which I have formatte...MS Excel VBA Pivot table link cell fetch records
I have a table 'tbl_Final' in MS Access 2007 where the data is used
and cached in a pivot
table found in the 'Data' worksheet in MS Excel 2007.
In this MS Excel 2007 workbook, I have various worksheets reports
which links to the pivot table values
found 'Data' worksheet.
I linked formulae in one of the cells found the worksheet reports,
looks like this:
Lets say the cell value total is: 1000
So, In pivot: 1000
...Changing the names of fields in tables after creating other object
I just leaned about the naming conventions after I have created my tables,
reports and several queries. Can I change the name of fields in my tables
(to remove the spaces and give them unique names ie not just last name but
childlastname) without destroying the work I have done in queries, reports,
Positive Direction for Youth & Families, Inc. (www.pdfyinc.com)
Possibly. If you are using a newer version of Access, say 2003 or 2007 AND
you have Name Autocorrect, and all it's options, enabled, it MIGHT work. I
found it somewhat buggy.
Before you...Receiving duplicate emails
I have just recently created my email account in
Microsoft Outlook and now when I receive email I get the
same one 15 times (and that is no stretch!) Is there
something I have done wrong? How do I fix this?!
What version of Outlook do you have? What sort of mail account(s)? Do you
only get a single message many times, or all the messages many times?
This posting is provided "AS IS" with no warranties, and confers no rights
"Carrie" <email@example.com> wrote in message
news:firstname.lastname@example.org...Adding a formula to a pivot table
I have constructed a pivot table that summarises data from
11,000 rows. It works well enough but I have been asked
to produce totals of certain data. There are 28 Companies
in my 'Data' table, which contain applications for
projects. Applications occur more than once but always
belong to the same company.
I can produce a pivot table to show applications by
Company but how do I produce a pivot to count how many
times a unique application occurs by Company. The best
that I could achieve was to add a formula in the top
row '=COUNTIF(B2:B10000,"*")', f...Stumped with Exchange 2003 mailbox problem
I recently added a second Exchange 2003 server to our system and migrated 1/2
of our users to the new Exchange server. Some of the migrated mailboxes are
ones that I have added to my Outlook 2007 in order to monitor.
While these mailboxes were on the old server I had zero problems opening
them. However, once they were moved to the new server, I can no longer open
them. When I try I get an error message stating that the folder can not be
I can find no reason for this issue. Suggestions? What am I missing?
On Fri, 2 Apr 2010 11:05:01 -0700, Dave Kennedy
Although this is a horseracing problem, it could possibly be adapted from a
financial (stocks/shares) problem.
I have a spreadsheet that extracts data from the internet and displays the
current horse odds on a worksheet in column E.
I would like to copy this data and display/paste it in another
workbork/worksheet. (I thought another workbook might be better in case
the new coding interfered with the current code). I would also like to
gather this data every 30/60 seconds (gathering of data timing is
adjustable on the main workbook), and display each capture of data in a new
column. Calcula...Update and insert a Date into a field in sql
I have the following sql statement.
'now set follow up
strsql1 = "UPDATE tblCustomerContacts " & _
" SET [Follow_Up] = " & Me![Follow_Up] & _
" WHERE [LineID] = " & Me!Customer_Contact_LineID 'Quotes this
way as feild is numeric
Where Me![Follow_Up] is a date - short date
The field that is being updated is also a date feild
In the current format 25/06/2010 (25 June 2010) results in 30/12/1899
What is the cor...Default field setting for cross tabs
I am trying to figure something out for a friend. He is coding in VB and
creating cross tabs. I'm not sure of the specifics, but when he pulls in a
new field into the cross tab the default field setting is always "Count".
However, it seems as if the field name begins with "TOTAL" it defaults to
"Sum". Is that true?
Is there a way to always set the default so that it is "Sum" instead of
If there's any non-numeric cells in that column (including text and empty
cells), then you'll get Count. If...