I keep getting and error on start of Office x.v
I just purchased Office X.v and installed it onto my Mac. I also
removed Office Test Drive before installing the full Office X.v, but i
didn't empty my trash. So after I installed the full version i keep
getting the error "An unexpected error occurred while trying to load
Microsoft Framework X library" on all office programs. I read on
mactopia that this could be caused by "lock" identities in the
microsoft identity file, but all of mine are unlocked. When i tried
to empty my trash, it would not empty a few microsoft file because it
says they are in use. Framework ...Off topic: VB6 question
sorry this is way off topic.
using _vb6_: i'm trying to add/replace nodes to an xml document via
xml = "<item>floogle</item>"
set newNode = oDom.createTextNode(xml)
call dDom.replaceChild( newNode, bloogleNode)
It works ok. But I can no longer find the new node in the document via an
xpath query. When I save the doc to disk I can see the new node but its been
escaped, presumably because it was a text node:
I guess my question is: H...How do I get an item's rank?
Let's say I have 10 merchants selling the same product at different prices.
How do I get a vendor's ranking?
I'd be passing the stored procedure ProductID and VendorID. And the data
comes from a table with three columns ProductID, VendorID, Price where the
Price field is smallmoney.
With RankedVendors As
(Select ProductID, VendorID, Price,
Row_Number() Over (Order By Price) As Rank
Where ProductID = <product you are looking for>)
Select ProductID, VendorID, Price, Rank
...Button/Macro Not Working, Help!
I have a macro that pulls up Report Manager and prints out pre-define
views. The macro works fine only after I use Report Manager the firs
time. If I exit my workbook and Excel, then return to it, th
button/macro does not function. Nothing happens until I manully us
Report Manager again. Is there a bug with this or am I missin
Message posted from http://www.ExcelForum.com
Post your code.
Gord Dibben Excel MVP
On Thu, 20 May 2004 08:38:55 -0500, baston
>I have a macro that pulls up Report Manager and prints out pre...mailboxes are getting larger on Exchange Server
I ve a problem in my exchange server 2003.
* The mailboxes are getting larger and although i m delvering the mails to
*Many mailboxes shows that they r above the limit "mailbox disabled" .... i
using a quata for the mailboxes. and by browsing the mailbox i dont c any
thing in the mail box from the user's side ... the only solution is to
expand the its quota then
it returns to normale stauts
Note: I m taking backup every day "the normal backup size was 17 GB after
that its 65 GB"
*It only took one day to get to the 65...Access ODBC problem: Excel cannot get float columns
I need some help
I'm trying to get Access external data from an Excel workbook, using
the MS Query feature.
Everything is ok except when I try to fetch some tables that ODBC
refuses to get data from. The error message tells that the MS Access
ODBC driver doesn't allow some columns to be transmited because of its
number of characters.
The most strange thing is that I can see the data from MS Query
correctly, but I caannot get it back from Excel.
After some tries, I thing it occurs only with real typed columns.
Can anybody help me?
I use Windows XP Home + Office 2000 spanish versio...Create form similar to MS Access 2000 Help
Is it possible to create a form that works similar to the Help - Index form
in Access 2000?
My StreetTable consists of the following fields: Street_ID(autonumber),
I want to be able to type the beginning letters of the street and the List
continually reduces until I see the street I need in the StreetNames window.
I would then
click on that street and the Directions would appear in the third window
Since I'm dealing with approx. 5000 streets, scrolling really isn't an
option that I want to consider.
I found that a combo ...Change opening postion /Form
From my Main Form I have a control that open a smaller form overtop of main
Form, It always opens in the middle of my Main Form, can I reposition it to
open higher on my Main Form,
Thanks for any Help.....Bob
On Mon, 6 Aug 2007 11:13:29 +1200, Bob V wrote:
> From my Main Form I have a control that open a smaller form overtop of main
> Form, It always opens in the middle of my Main Form, can I reposition it to
> open higher on my Main Form,
> Thanks for any Help.....Bob
Look up the MoveSize method in VBA help.
DoCmd.MoveSize 2 *1440, 3 * 1440
will position a form 2 inch...How do I get special symbols for correct sign?
...how to get a fixed window with caption?
which is the best way to get a window (dialog box) with captionbar but no
posibility for the user to move the window?
Try overriding the WM_WINDOWPOSCHANGING message to prevent
the move before it happens.
>which is the best way to get a window (dialog box) with
captionbar but no
>posibility for the user to move the window?
...Newbie: can't get a calculated value on the form?
I have a table with numbers and a form that shows the numbers. I have
a query that takes one of the numbers and mulitplies it. I put a text
box on the form from the query result field, but I get a "#Name" error
instead of the result. When I run the query, I get the correct
"Ed from AZ" <email@example.com> wrote in message
>I have a table with numbers and a form that shows the numbers. I have
> a query that takes one of the numbers and mulitplies it. I p...can't get scrollbar to come up -- CScrollView
I am new to MFC and I am trying to get a simple app working with a
scrollable view. I have put in the call to SetScrollSizes in the
OnInitialUpdate method. I'm still not quite sure what sizeTotal is supposed
to do. I just gave it a value of 5 for the y for now, which I think I want
to set to the number of lines of text I have to display. And then I set y
int numLines = 5;
sizeTotal.cy = numLines;
sizeTotal.cx = 50;
In the OnDraw method, I put in code to draw my text on the view using the
device context. The text get...Is there a wizard to export and match fields?
I would like to export products from my table into a csv that has different
field names. Is there a wizard that would allow me to select which fields to
export and what fields they match up to in the new file?
Instead of exporting a table, create a query and alias the field names to
the ones you want in the CSV, then export the query.
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
"ZenMasta" <me...Updateing data when closing forms
I am using MS Access 2000
I have a table that has several required fields.
I developed a form to add records to the table.
In addition to the table fields, the form has a form-close button
constructed with the button wizard.
When I enter a record that does not have the required information and close
the form with the “Close Window” (X) button on the tool bar, the appropriate
error message appears telling me that there is missing data. (Just what I
When I use the close button on the form, the form closes with no message and
without adding the record.
How do I give the button on the f...My input form isn't empty?
I have a form with two subforms. All three forms have the Data Entry property
set to Yes. The main form only has one control called txtmonth and the two
subforms are linked to the main form on this control. However when I input a
value to the control on the main form the subforms are populated with data
from their related tables. Why aren't my subforms empty for me to add new
Why don't my grey cells communicate with each as fast as they used to? I hate
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-for...Grayed out Close button on Title bar
The Close button is unavailable. Is there a fix for this
problem or do I need to uninstall and then reinstall.
Repairing Excel did not fix this problem.
Do you use Groupwise?
"Elena" <firstname.lastname@example.org> wrote in message
: The Close button is unavailable. Is there a fix for this
: problem or do I need to uninstall and then reinstall.
: Repairing Excel did not fix this problem.
just to add to lady layla's response:
xl: close button is dimmed after groupwise ...VBA code to hide all the tables on form open
I don't want people to use a blank mdb to import my tables. I manually hide
them all. However, after running the macro to delete all records and import
from .txt, the table become unhide. I do the importation on daily basis.
I posted to macro newsgroup and asked way to hide table after importation
action macro but got no answer. Maybe it cannot be done in macro?
If so, I need VBA code to hide all the tables on form open. Thanks.
Hiding your tables won't prevent people from being able to import them into
a blank mdb. All they have to do is ensure that they've set the datab...Passing Values from One Form to Another Including a Combo Box
Hi, hope someone can help with passing two values from one form to
another by way of a command button. I have spent a week on various
code taken from this site, but still no luck. Please ... someone help!!
The form I am passing values from is called PATIENT HISTORY-Form. On
this form, I need to pass a date from a field called DateSFESigned and
I also need to pass information collected from a Combo box, Combo91.
The command button is called Command119.
The form that the values are being passed to is called Personal Habits-
Thank you in advance for any help on this matter.
Maurita ...Lookup Wizard changing Data Type
I am trying to make Lookups from Table Field to Table Field and generally it
However the LookupWizard is changing the Data Type from Text to Number (I
guess it's looking at the ID?)
Data picked from Combo Box 'looks' OK in Table view
A Query view is asking for a number but displays the Text field value when a
valid ID number is added.
Viewing Results in FrontPage Database Wizard, and using hand coded .asp
querie, it's showing the ID field value.
I can see why...
Yes, the wizard isn't the problem it's the use of Lookup Fields in ...Adding a formula to the same cell (H5) on every tab
I have an inventory spreadsheet with 125 tabs. The tabs are numbered
1 through 125. The are identical except for the data below the column
headings. If I wanted to put a formula in H5 on every tab, can it be
done other than manually opening every tab and typing it?
One additional question: If I add a Summary Tab, how could I show the
value of a specific cell on each tab without manually entering it? I
show the formula I'm using bring B3 to the summary for every tab:
1 Unit Value
2 1 ='1'!B3
3 2 ='2'!B3
4 3 ='3'!B3
5 4 ='4'!B3
6 5 ='5'!B3
7...Importing to a contact subfolder with that has a custom form
I am using a custom form for a subfolder under contacts.
When I use the import wizard to import a comma deliniated
DOS file the resulting records are in the default contact
form rather than the custom form.
When I manually add a contact it correctly chooses the
Any help will be welcomed!
You can re-apply the form to the items that don't have it - methods depend
on your version of Outlook.
Bob White wrote:
> I am using a custom form for a subfolder under contacts.
> When I use the import wizard to import a comma deliniated
> DOS file the resulting records are i...How 2 sort an autosum total list after adding items 2 autosum item
Am using detail dollar amount list to insert new transactions in the middle
of a the detail list, and they in turn get included in the 'autosum' total
calc which is located in another item total summary list in the same workbook.
If we try to sort the autosum total summary list, the autosum totals seem to
loose their connection with the detail autosum calc list.
Is there anyway to keep this connection, ie be able to add items into the
detail autosum calc lists, and then sort the autosum summary totals ?
Thanks again for your help.
akm (XPpro,SP-2,IE-7,Office2003...Can't get past welcome screen
I recently used a startup manager utility to reduce the amount of programmes
that launched automatically on startup. I am now unable to get XP to start
past the welcome screen. If I click on a user it loads settings and then logs
off immediately. I can't get into safe mode as it does the same thing. I've
tried copy userinit.exe wsaupdater.exe as suggested in
http://support.microsoft.com/kb/892893 but this does not help. Any other
On Sat, 5 Dec 2009 12:00:01 -0800, Sam Wardill
>I recently used a startup mana...Rules Wizard on server
I have some groupmailboxes that I need to add "rules" on. My problem is that
it's about 20 of them and I don't want to log in to each and every account
and change it that way. Is there any way on the server to add rules to an
Windows 2000 Server
no, you cannot add rules to individual mailboxes! The only mean should be
with OWA on the server, but you must do that one by one!
Another possibility, you can create "Event sinks" (scripts) to test some
conditions (users...) and do some actions directly on the s...ENTER button
Isn't there a way to make it so that if you're entering data and tabbing over several columns as you go, that after you hit ENTER the box moves down one row and to the first column that you began entering data into
Here is one I use that goes back to the original column and one row down. I
use the right arrow key.
right click sheet tab>view code>insert this>modify to suit.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Row > 5 And Target.Column = 8 Then ActiveCell.Offset(1, -6).Select