size of database after backup
after a full backup with HP Data Protector i have the problem that the size
of my priv database grows from 6 GB to 14,5 GB. The online defrag says that
there is 6 GB free space. After an offline defrag the size of database ist 6
Has anyone help?
...convert "Text" into "Number" for null or empty value
Need your help , please
I have a field which from database is "text", and have to convert it "number"
using CDbl function, able to solve it. But problem for data which have "null
or "", the result is #Error
I'm try to use below queries, but same result. Any other's function?
Message posted via AccessMonster.com
Now is works.
Using Val([A] & "")
>H...Drag and Drop: Implementing a Drop Target
I have a CSplitter with multiple windows. I am trying to implement a Drop
Target in one of them.
In the View Class .h file I declare a variable of type COleDropTarget
In the OnCreate() member function I try to register.
BOOL b = m_dropTarget.Register(this);
While stepping through, It fails in oledrop2.cpp at the following function.
BOOL COleDropTarget::Register(CWnd* pWnd)
//the object must be locked externally to keep LRPC connections alive
if (CoLockObjectExternal(lpUnknown, TRUE, FALSE) != S_OK)
I don'...Publisher 2011
Windows 7 / Publisher 2011
Is there a simple way to change the background color in a P2011 document? The 'Page Design', 'Backround' tab colors are limited and I see no way to add to them?
In general, I'm finding it quite difficult to find answers to simple questions? Is there a good tutorial out there? - Thanks for your help, IM
...Custom drop down menus
Hi. I once saw a spreadsheet that had its own drop-dpwn menus (like File,
Edit, ect, but it had Invoice and things like that). Is that a special add-in
or can it be done straight in Excel somehow? Any ideas? Thx
View - Toolbars - Customize - Commands tab - scroll down categories to New
Menu - drag the "New Menu" from the commands to your menu bar. Drag addition
sub-menu items under this new menu item. Right click on the new menu items
and change the name / assign macro.
Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hote...Multiple Combo Boxes Highlighted
I have a problem with something in VB6.
I have 4 combo boxes with individual names (not an array) located on an
When I select another tab and then return to the tab these boxes are located
on, each of them appears to be highlighted in blue.
I add values to them only when loading the form so I'm at a loss as to why
this happens ?
Any ideas are greatly appreciated.
"Jennifer Ward" <firstname.lastname@example.org> wrote in message
> I have a problem with someth...Privelevel change in status.html
i know i can display customers Pricelevel by
QSRules.Transaction.Customer.PriceLevel in status.html
but does anybody know how can i change this pricelevel for customers current
transaction. Please anyhelp will be much appreciated.
You can change the PriceLevel at the time of the transaction using the
Shift-F3 and setting the PriceLevel manually after adding the customer to
the transaction. Or create 3 macros to do this for you.
"Shoby" <Shoby@discussions.microsoft.com> wrote in message
news:6714525B-9B61-4D69-8355-F152F97A931A@microsoft.c...How do I move data without changing an associated formula?
I have created an Excel worksheet which I update with new values each day
(golf scores). I keep the last 10 scores but want an average of the last 5
scores. How can I move the data one column to the left and not change the
averaging formula so that when I post the new score it still uses the
original formula (sum of G5 to K5 devided by 5).
If you put a "$" before any cell reference, it will "freeze" the formula
value. So, if your formula references cell G5, you can use $G5 to freeze
the column or G$5 to freeze the row or $G$5 to freeze the entire cell
...How do I remove a check box once I have inserted it?
How do I remove a check box once I have inserted it?
r-click and select cut works for me
"billmeier" <email@example.com> wrote in message
> How do I remove a check box once I have inserted it?
I tried that, all it does it let me move it to another location, but I'm
still stuck with the check box.
"Adam Kroger @hotmail.com>" wrote:
> r-click and select cut works for me
> "billmeier" <firstname.lastname@example.org> wrote in message
&...My text does not show in a connecting text box?
...Changing Office from one PC to another
Just bought a new desktop PC. I'm planning to keep the old one, but will
use the new one for Office applications. Is there any problem with
installing Office 2003 on the new one and deleting it from the old?
"Williams" <cwillyATE@OOHAY.com> wrote in message
> Just bought a new desktop PC. I'm planning to keep the old one, but will
> use the new one for Office applications. Is there any problem with
> installing Office 2003 on the new one and deleting it from the old?
&g...How do I format a MSGBOX to show text and variables in a macro?
I have a macro that receives a variable that is input by a user (&rsp1)
I want a MsgBox to display “Do you want to print off the data for “and the
The MsgBox lookes like:-
MsgBox "Do you want to print off the data for &rsp1 - 1?", vbYesNo, "Do you
want to Print off”
Additionally, if I know the location of a particular file, how do I
incorporate an open to it?
Any assistance offered will be appreciated.
I'm not sure i ub=nderstand the second part of your question but try this for
the first bit.
rsp1 = InputBox(&quo...RUS did not process all changes
I did run a scan using Best Practices Analyzer Tool and get .."RUS did not
process all changes"..as a message.I clicked the link and it require me to
edit AD using ADSI which i have never used before. Do you suggest i go ahead
and edit the nessary as per
or do i leave it as is because it wouldn't really affect my exchange box?
Can anyone please help me.
I've noticed the same warning against our Production Organization. I have
one RUS co...Are MFC FTP classes limited to 32bit file sizes?
I have found that when using the GetLength member of the CFtpFileFind class
that the filezizes are limited to 4GB (0xFFFFFFFF).
Now I know that in old versions of MFC, GetLength only returned a DWORD and
one needed to use the Getlength64 function. However I am using VS2008 and
GetLength returns a ULONGLONG.
I then heared about a possible bug in MFC so I derived a class from
CFtpFileFind so that I would be able to see the actual WIN32_FIND_DATA used.
And indeed the low order DWORD is set to 0xFFFFFFFF and the high order DWORD
is set to 0x00000000.
I know that this is not a server issue...How do I write my Ms outlook in box mail to a CD
My Out look mail box is full.I want to get the all my mails in inbox to a cd
and deleete them(like a backup).I already archive the mail box.but it is not
enough for me.I want to deleete the all mails and get them to a Cd to future
"Hansi" <Hansi@discussions.microsoft.com> wrote in message
> My Out look mail box is full.I want to get the all my mails in inbox to a
> and deleete them(like a backup).I already archive the mail box.but it is
> enough for me.I want to del...How do you change a system (unexposed) entity/string label?
I would like to change the label of the “Service” system entity, so
that the name in the left-hand navigation pane changes.
I’ve read in various places that this is impossible (because it is a system
entity), however I have also found someone who has an example of how it is
However this does not appear to work. (I get an error regarding a unique key)
I am using CRM 3.0
Could someone please enlighten me?
On Jul 15, 1:57 am, Steve <St...@discussions.microsoft.com> wrote:
> ...Excel Changes Links Improperly
We are having a problem where Excel changes links to
other workbooks and breaks them. This comes up in the
Different users have access rights to different
directories and have their drives mapped differently
(i.e. to the directories they have access to). Sometimes
a user modifies data in a file that has links to
directories that don't exist for them. Of course the
links don't work for them, but that's ok. What isn't ok
is that when they save the file, Excel changes the links
(apparently trying to make the links relative to drive
where this use...Outlook 2000 software with huge font size
Running Win98 and Outlook 2000.
When I open outlook, the font on EVERYTHING from within
the program is abnormally large. I did a View dropdown
to "text size" and "medium" is selected.
Anybody know what the fix is for this.
Thank u all :)
Are you using Word as the editor? If yes, then open a new message and check
the zoom settings.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer
rossj <email@example.com> asked:
| Running Win9...Vista automatically changes the volume mixer
Some programs in Windows Vista automatically changes the volume in the
mixer. Is there a way to lock the volume so it never can be changed
(untill you unlock it again). It's really annoying that you have to
manually change the volume, because i play games where i need the
In advance - Thanks.
If you can mention which programs you're referring to then that may help.
Both Vista programs and games usually have volume settings within themselves
that you can adjust.
"Thomas Andersen" <firstname.lastname@example.org> wrote in message
news:af01...Changing Chart Location Problems
I am using excel 2007. When i move a chart from a worksheet to a "New Sheet"
i.e. "Chart1", the chart does not show up in the new location / sheet. When I
click on the new sheet "Chart1" all I see is a blank page. Please Help
The beta did stuff like this, but the RTM version (i.e., the commercially
released version) seemed to be fixed.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"*Dave*" <Dave@discussions.microsoft.com> wrote in message
news:7F18352C-9137-407E-923F-009E7628576...Common Dilaog Box
Well I just want to call a common dialog box e.g.
CFontDialog and then want to change the color of any od
the edit control inside that dialog box.
If possible reply me back to email@example.com
N.B : If u can give the source code its better.
Have you looked at CWnd::CtlColor()? It is used for just such purposes!
"rupak" <firstname.lastname@example.org> wrote in message
> Well I just want to call a common dialog box e.g.
> CFontDialog and then want to change the color of any od
> the edit control inside ...Drop Down Menu
How do I create a drop down menu in a particular cell. I want the menu
to contain alternate date the user can click on and it will
automatically enter the cell once clicked.
Look on Debra's site for examples
Regards Ron de Bruin
"nicole" <email@example.com> wrote in message news:firstname.lastname@example.org...
> How do I create a drop down menu in a particular cell. I want the menu
> to contain alternate date the user can click on and it will
> au...Allotment Details area and the Total Cases/Minutes box
Scenario: Service Contract Template with allotment type set to time. Contract
created with that template and contract line set accordingly with 121 total
hours, units in hours and in the Case/Minutes box i entered 7260
(multiplicity of 121 and 60). When i create a case and had it resolved for a
period of 3 days. The allotments remaining only decrement by one. Whats
going on. Thanks
I am using Access 2000 and Windows XP.
I have a form that I need to generate a pop up box to say "Do you want to
save changes" with options "Yes" or "No" for users to click on. If they
choose "No" then changes are undone. This only needs to happen when closing
the form, moving to a new/another record or saving updating and not for every
I have this code at the moment which I have put in the Form properties:
Select Case MsgBox( _
"Changes have been made - Do you want to save?" _
, vbYe...How to change the default font and size of "comments"?
Can anybody tell me how to change the default font and size of a "Comment"?
I can change the font and size of every comment separately but I can't find
a function to set a standard (default).
Changing Font etc in cell comments (#font)
Excel uses the Tahoma font for new comment boxes, and you cannot change
that default. You can set the default interior color, the font color, and the fontsize
in the Control Panel (Display, Appearance, Tool Tip)"
You can run macros (also found in ...