Use code to stop "...contains one or more links that cannot be updated"
I sequentially open then save & close about 30 files from a list in
master spreadsheet. I am receiving the link related messag
"...contains one or more links that cannot be updated" on open of eac
file. I need this message to be stopped from displaying by usin
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
> I sequentially open then save & close about 30 files from a list in a
> master spreadsheet. I am receiving the ...Retain Field Format From Excel
I have an excel file that I'm importing to Access. This field consists of
"time"...hours, minutes, seconds. The format in excel is set to "Custom" -
The data elements look like 150:27:50, 2:30:25, etc...
The time stays the same for some records but others change. For
example...150:27:50 becomes 6:27:50 AM when imported.
If someone can help me figure a way to retain the format for all records I
would greatly appreciate it.
150 divided by 24 = 6.25 or 6 and 1/4 days which is displayed a 6 AM.
You need to use a ...Pivot table pulling wrong value
I have pivot tables that seem to pull the wrong value from my data series.
The value in question is a string describing the name of a report "Motor
Drives - WW - 2005". My pivot table pulls this value and adds the value 2 to
it. E.g. "Motor Drives - WW - 20052". When I drill to detail, the correct
value is shown.
Is this an Excel bug? Has anyone else encountered it and know how to fix this?
If the data is internal to te workbook, could you send me a copy ? I'd
love to see it
...navigation bar links
My navigation bar does not link correctly to all of the pages of my website.
I have added pages and moved them around to get them in the right order.
They do not link correctly when I preview my website. Any suggestions?
Nevermind. I got it.
> My navigation bar does not link correctly to all of the pages of my website.
> I have added pages and moved them around to get them in the right order.
> They do not link correctly when I preview my website. Any suggestions?
...Link Subform to Subform
I was wondering if someone could help:
I have an unbound form with 2 subforms. On the unbound form, i have an
unbound combo box (cmbo_name) that displays a list of names. When a name is
selected, the person's details are shown on the first subform (works
perfectly) what im having trouble doing is linking the first subform to the
other subform so when a selection is made in subform1, it's details should
appear in subform 2. Does anyone know how this can be done??
Message posted via AccessMonster.com
Hi ...string table
Is there a way to paste a list of string IDs, Values and Captions into the
string table, or should I say into a string resource file?
"Steve Russell" <email@example.com> wrote in message
> Is there a way to paste a list of string IDs, Values and Captions into the
> string table, or should I say into a string resource file?
I'm not sure I understand your question, Steve, but you can open the *.rc
file as text and paste stuff in it.
Jeff wrote, I'm not sure I understand your question, Steve, but yo...Word table tinto excel with comments
I have a Word table that I wish to put into Excel, but it has several
comments in it. I wish the comments to stay with the cell they are linked
to, but when I paste the table into Excel, the comments are all listed at the
bottom of the data. Is there a way to keep the comments where they should be?
...Update field w/ string based on service due dates
I have a form that provides a listing of various instruments that are
serviced on a monthly to annual basis, with general info about the
instrument, last and next service dates, etc.. What I am trying to
is create an On Open event procedure that will identify all
instruments that are listed with a string of either "Past Due" or
"Schedule Vendor" based on whether each of their respective 'Due'
dates have already transpired or not from the current month.
The code I initially created for this was as follows:
Private Sub Form_Open()
Dim myDate, myDue
myD...Error when using XMLTextReader to read HTML
I have some simple HTML I'm trying to read with the XMLTextReader. As in the
MSDS examples, I set up a loop to read each XML node:
The reader moves along fine until it attempts...how do i link cells so that when typing in an item, the price app.
I'm trying to create a quotation template which enables me to enter in an
item in one cell and its corresponding price appear in the next cell? Is this
I have created a spreadsheet of Items and prices (of which there are going
to be over 1000) as a refernce point but am unsure how to link these for
automatic entry into the quotation.
Anyone know how to do this?
You need to build a table of the items and prices. For
example, on sheet2 in column A you list the items and in
column B you enter the corresponding price. Assume that
table...Error when add New User
Hi, dont know when it happened. When I add new user to production MSCRM 4,
there is an error message (An error Has occurred.....). However, when I try
to add this user to my test CRM, it can successfully add without any problem.
Both servers are running the same spec and version.
I tried to add different users to production but all failed. I have set the
deverror to ON but the error message still appear as An error has occurs.
Apart from that, I have used CRM diagostic Tool but cannot see anything
unusual from the log.
I have even run the repair but effort is all wasted.
Please He...Linking worksheets (ex. =sheet1!B2)
What I want to do seems so simple but Excel is doing some
weird stuff and I'm stumped. I'm starting with two
worksheets. The first is my raw data template. The
second is my summary page, made up of simple formulas,
many of which are referencing cells from the raw data
worksheet such as(=detail!B2). This initial setup works
fine. What I want to do now is re-use the detail
worksheet to produce multiple summary pages for individual
products. My method was this:
1. Make copy of summary worksheet
2. Rename new worksheet (new worksheet has the same
formulas as original)
3. &qu...Update 2 tables via Check Box in Form
I did not design this database, but it's in it's 4th generation update on
I have two tables:
-tblMain containing 3 check boxes
-tblHistory, updated yearly appending only those records where a check was
indicated in one of the 3 check boxes in tblMain, and filling in a year value
in column related to check box
I would like to automate this process so that when a check box is populated
via the form, it automatically:
1) creates a record in tblHistory
2) populates check box's associated column with year value stored in another
table (or sumsuch)
...rule out ODBC connection?
windows 2003 sp2/xp sp3
Is there a way to push out group plicy to users? I did the registry key
odbcini in the HKLM\Software\ODBC. But, we use the customized port. It
looks like that I can not specify the different port other than 1433?
Any way to do this?
If I understand you correctly, see:
Setup one machine correctly then export and import the settings to the other
machines that need them.
"ed" <firstname.lastname@example.org> wrote in message
Hi everyone, i have a sheet named: Employee Data, but i would like t
link this to Microsoft Access so that when the details of an employe
are entered in a form at Access, it is automatically inserted int
Excel too, i should be able to delete, edit and add details o
employees, and it should take into effect at Excel.
How do i go the right way with this? Thanx, regards
Message posted from http://www.ExcelForum.com
Adn4n, open your Access database and File > Get External Data > Link. Go
through the steps and, when you're done, you'll see the little Excel icon
with the arrow n...How can I cross reference information in a table?
I am writing a program in Excel and I want to be able to pull information
from a table, which is 15x11, in another worksheet. In the program,the user
enters a value which will corresponds to a specific column in the table (so
this is my x-value). Each column contain a series of increasing numbers. I
want the program to interpolate within that specific column entered by the
user, to another value that the program had calulated previously, then
reference that to a value in the first column (y-value).
3.0 3.5 4.0 4.5 5.0 5....Input form using 3 Tables
I have an Input Form based on a query using 3 Tables. 2 of the Tables are for
information only. The 3rd table is the table I want to input and update
information in. If I use 2 of the tables including the table I want to update
the Input form works. Once I introduce the 3rd table my fields become locked.
I have another database that is using the same concept and it works fine but
this database isn't, what am I missing.
...#Temp table error
my client gets an error at opening RMS HQ Manager and it's something like
"The name of the object '#Temp' is not valid.
SELECT * FROM #Temp
WHERE [Status] IN (0,1,2,3,5,6,7)"
I have seen this before, but I'm not sure (can't remember) if there was an
fix for this or workaround, or what's provoking it. ¿Any idea?
The client has an RMS v2.0 with SP2...
Thanks in advance,
This is a multi-part message in MIME format.
charset="ut...Excel's Pivot Tables
When I use VBA to create a pivot table from an external MS
Access database, it defaults to counting the data instead
of summing the data. When I use the field settings option
to change "Count of Amount" to "Sum of Amount" everything
goes to zero. I suspect this is because the data it
retrieved from the database is no longer available. How
can I ensure that the pivot table Sums?
I've had the same problem when exporting data from an
Access database into Excel. What I had do was multiply
all of the values by 1 in Excel, which then somehow
triggered that these ...Pub File linked with Excel File?
I wish to transmit (Via Email or to be Downloaded) a pair of files - one
Publisher linked with data in an excel file. How may i accomplish this w/o
breaking the link?
...Maintain formatting in linked chart title
I am linking an Excel chart title to a named range. Is there any way to
maintain the formatting used in the named range in the chart title?
On Tue, 15 May 2007, in microsoft.public.excel.charting,
chumley <email@example.com> said:
>I am linking an Excel chart title to a named range. Is there any way to
>maintain the formatting used in the named range in the chart title?
Not ordinarily. Someone may be able to do it using VBA.
NB Personal replies to this post will send email to firstname.lastname@example.org,
which goes to a spam folder-- please send...error value in the printout but not in the report
I was wondering if anyone might be able to help me out with the following
problem i have.
In the Access report, i have a textbox whose control source has the
following value in it.
="Student ID: " & Forms.EditStudForm.TB_studID & " Student Name: " &
Forms.EditStudForm.TB_FirstName & " " & Forms.EditStudForm.TB_LastName
When running the report, i can see all that in the report. However, when
printing it out from a printer, it read "#Name?"
I got confused as it appears all right in the report but not in the printout.
Thank...link with .mdb
I have created a access database and placed it on our
share drive. I have copied and pasted the URL or file
location into an email so that when someone receives it
and clicks on the URL it launches the database.
On some computers this works great - on others I get a
warning message saying I have to download the attachement
before viewing it - which defeats the purpose of the
We all have Office 2000. Is this an Outlook security
issue? I have tried changing the security setting but so
far no luck.
Nevermind - I found the answer.
http://support.micros...On Error Flakeyness
What causes the 'On Error GoTo xxx' to work sometimes and not to work other
I have a loop that contains an On Error statement. The first time through
the loop the code encounters a cell with data that causes an error, and the
On Error statement handles it - it sends the code to the designated label,
where I have an 'On Error GoTo 0' statement. The next time through the loop,
the 'On Error' Statement is again set, and the code encounters the next cell,
which has exactly the same data as the previous cell. This time an error
message pops up instead of th...Web Services Install Error GP 2010
As the install is running, I encounter the error "The Security ID structure
is invalid. (Exception from HRESULT:0x80070539)
It is a new install of Web Services on Windows 2008 Server\SQL 2008 Server.
The application account has DYNGROUP for Dynamics and company DB's. I since
made it a dbo trying to get past error. It is a local account that I also
granted local admin in an attempt to get to work. SQL and GP2010 are both on
the same box.
Nothing on customersource so any help would be appreciated.