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 ...auto fill a form
please help I have tried but cant seem to get this to work. What I need is
information from form 1 to be auto field in on form 2 I already have a combo
box on form 2 that pulls data from a field (unit number) on form 1. Now I
need the information for 4 more fields (vin mumber,make,model,year) on form 2
that is also on form 1. Thank you.....
I may be reading too much into your description...
It sounds like you want to replicate data. That is, you want data in one
table (visible via form1) to be added to a second table (via form2). If
this is what you are trying to accomplish, consider ...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?
...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?
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...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 ...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...Reporting table fields vertically
I've come across a client with a non-normalized table with sales of items
for eight different regions. So, the fields in the table are:
Typically the client is printing these sales in columns, with a report that
has the eight regions spaced horizontally across the page. Something like
ItemCode Region1SalesQty Region2SalesQty ... Region8SalesQty
However, they now need a report with the sales reported vertically, like
...Combo Boxes on Form
I have 4 unbound combo boxes on a form. Two have the Row Source Type as
Table/Query. Two use a value list. If the user leaves all fields blank, I
would like to retrieve all the records in the table.
Right now, there is an underlying query to this form which accepts the
entries of the combo boxes.
How can I do this?
Also, once the records are retrieved, I need to open an additional form to
display the records. There is a button on the form which runs the query.
Would I code it to open the form first and have the form use the query as the
Thanks for your help.
O...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...How to stop a form being 'non maximised'
I have a form that is set to being maximised. I have disabled the min/max
buttons and set the formborderstyle to be fixedtoolwindow.
Once the application has started it maximise just fine, but the user can
then dbl click the window title bar and it is no longer maximised.
My application is a touch screen application and therefore the number of
accidental double clicks occuring that result in the form no longer
remaining maximised is a problem
Is there away to have the for start up maximised, and then disable all form
resizes or moves, with exception to the close form ...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)
...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.
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...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 ...#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...Quick Create form for custom entities? (CRM 3.0)
Are Quick Create forms available for custom entities?
Actually, in my case, I want to make sure they are not (or if they are, how
to turn it off for a particular custom entity), since customizations for the
regular custom form might break if used on the Quick Create form.
...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 <firstname.lastname@example.org> 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 email@example.com,
which goes to a spam folder-- please send...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?
...Data entry form opens up as blank page Access 2007
Hi - I am so eager to get feedback on this.
I have a simple little data entry form (Detail) that appears as a button on
a switchboard form (Manager). The only other choices on the switchboard are
Exit and Review Records Entered (runs a macro that runs a query that displays
only the records entered so far by that staff person). I set the database so
that it opens default to the switchboard. I split it then and copied the
front end individually for each user.
All records are going into a "back end" with 4 tables, one containing the
records they are entering and the other 3 prov...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...Take text out of table
Using Word 2008, we have a table of data that we would like to take out of
the table and have it just show on the page as text.
Is there a way to do that?
Or can you select a table and just get rid of the table formatting and just
leave the text so we can work with it as text separated by tabs?
In article <ejsZAqg1KHA.3652@TK2MSFTNGP04.phx.gbl>,
tshad <firstname.lastname@example.org> wrote:
>Using Word 2008, we have a table of data that we would like to take out of
>the table and have it just show on the page as text.
>Is there a way to ...can not open linked table
When trying to open a linked table I get an error message that the file is
opened exclusivelyby another user. I have used this link before many times
and have knowingly done nothing to change it. I am using acces 2007 on a
vista lap top to an access 2000 database on a different computer (xp) which
uses access 2000 .
If you are certain that you are the only user, close Access and delete the
LDB file on the remote computer. If there is more than 1 user, 1 or more
have the database opened exclusively. Go to Options on each computer using
the database, and change that.