How can i Secure my projectHi all, i have created a small project in access.
3 database tables. 8 forms, 6 queries.
in start up i put the main form to open.
and now i unchecked the display database window option, so in execution the
, forms, queries and tables will not appear.
even i have customized my menu bar , to only 2 fields,,1. FILE, 2. Help all
other i have removed....
but still any body can go inside my project, like
if we right click on form, it can lead to form design view,
if F11 is pressed we can see the Database window..
I have also made to NO, the allow form view, design view.
...
How can I have more than 64000 rows in one sheet?I want to import an access database in one excel sheet, it requires 200.000
rows. Any suggestions?
"blafblaf" <blafblaf@discussions.microsoft.com> wrote in message
news:C3D0F75D-7F4E-4F76-95F3-72D7F3AE8D7A@microsoft.com...
>I want to import an access database in one excel sheet, it requires 200.000
> rows. Any suggestions?
Hi BlafBlaf,
The current worksheet row limit of 65536 is not expected to be increased in
the immediately foreseeable future.
To import your database to Excel, it would therefore be necessary to pass
64k tranches to each of four worksheets.
This...
can't use video/audio setupI uninstalled WLM9.0 and re-installed WLM 8.5 (version 8.5.1302.1018). Now I
can't use the video/audio setup. It returned "we are unable to run
video/audio setup for the time being".
My machine runs on Windows XP SP2
Please help
The WLM could not run the audio chat after reinstallation. Anyone can help?
"Walter_C" wrote:
> I uninstalled WLM9.0 and re-installed WLM 8.5 (version 8.5.1302.1018). Now I
> can't use the video/audio setup. It returned "we are unable to run
> video/audio setup for the time being".
>
> ...
Can I delete everything on MSN Money?Hello,
I seem to have lots of problems syncronizing my MSN Money
information with the web. It seems to work fine for a few
months, then, for no reason, I start to get syncronization
errors. I have signed up for multiple passports, because
when these problems start, it seems that I get tons of
multiple accounts. For example, on my one MSN Money
account I have 15+ old accounts that I can't delete.
1. How do I delete ALL of the information out on MSN
Money for my passport account?
2. How do I keep the syncronization from breaking in the
future? Any tips or advice would be g...
I can no longer convert my files to pdfI have Publisher 2003 and yesterday, my pdf menu on the top left disappeared
and I can no longer convert my Publisher files to pdf. I've even
uninstalled/reinstalled the Adobe Acrobat 7 and have also updated to 7.8 but
still no luck.
The next step was to uninstall and reinstall Publisher and still no luck.
Any one know what may be the problem? Thanks.
How are you trying to convert your files? When happens when you try?
--
JoAnn Paules
MVP Microsoft [Publisher]
"darrellm" <darrellm@discussions.microsoft.com> wrote in message
news:A78B7B52-981D-4FB7-8625-EAD9...
How can I parse or Loop a list based on single field to GooglemapsThis is some code that will parse each sequential field [Point_#) into a list
for googlemaps.
[Form_Runs].WebRouteMap.navigate
"http://maps.google.co.uk/maps?f=q&hl=en&q=" & "from: " & Me.Point_1 & (" to:
" + Me.Point_2) & (" to: " + Me.Point_3)
The table/form is laid outlike this:
[Route_No] [Point_1] [Point_2] [Point_2]
5 North St, N1 East St, N3 High Road, W6
And the code will give this style of parsed list:
from: North St, N1 to: East St, N3 to: High Road, W6
That works just ...
can not move files and folders on vista
hi, I am having problem moving any type of files or folders to different
place. I cannot even move a file in my document to a folder in my
document. can any one help please. I tried setting the admin but that
did not resolve it. I am using vista. However, I can delete and rename
files and floders but just can't move them
--
lovelacews
Not a Windows Live Mail issue. Please post here.
Windows Vista General Newsgroup.
In your newsreader:
news://msnews.microsoft.com/microsoft.public.windows.vista.general
On the Web:
http://www.microsoft.com/communities/newsgroups/en-u...
can not mount information storei am receiving event id 454, Information Store (2704) Database
recovery/restore failed with unexpected error -540. . in exchange admin i get
the error An internal processing error has occurred. Try restarting the
Exchange System Manager or the Microsoft Exchange Information Store service,
or both
we have plently of disk space available which is stated as the cause by a
number of tech notes.
Can anyone help?
Hi
Did it happen after restore?
Try to move the exchange log files (cut-paste) and mount the store.
If still can’t mount run eseutil.exe /p
--
"nick reed" wrote...
Can't get rules to run.I can't get Outlook 2003 rules to run. I am getting my mail from a pop3 account and would like to have new mail sorted to specific folders when it arrives. I set up the rules as I did in previous versions of outlook, but they do not run automatically. I can run the rules manually and they will move the mail.
I have this rule (for example
Apply this rule after the message arrive
from some@email.address
and on this machine only
move it to the somefolder folde
I have tried deselecting on this machine only
Thanks.
Do you have an Exchange service in this profile? Are you using Cache...
Bug: MM05 online bankingMM05 uses a single login for each bank - unfortunately my brokerage (Bank of
America Investment Services) uses a unique login for each account. So, I'm
unable to use online banking in MS Money to sync with my brokerage and IRA
accounts.
If there was some way for me to duplicate the "Bank of America Investment
Services" so I have two instances of the bank, I could make it work - any
suggestions?
In microsoft.public.money, Crimbo wrote:
>MM05 uses a single login for each bank - unfortunately my brokerage (Bank of
>America Investment Services) uses a unique login f...
How can I reset the default pie chart label "Other" to "Equity"?I show Cash, Equities, and Fixed Income in the large pie to the left. The
equity slice is further split into large, medium, and small. The problem is
that the Equity slice gets relabeled as "Other". When I manuallly change it
back to Equity, I lose the ability to link to any new data...so I can't use
the pie chart as a template that would allow me to put new data in the table
and have the pie chart adjust automaticially. How can I reset the default
pie chart label to "Equity"? or is there another solution.
Instead of making pie charts (which are notor...
Can't Send Messages Until I Press F9 KeyThis is a multi-part message in MIME format.
--------------030800050502050601040701
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
After I compose a message and click Send, the message does go its way
until I press F9 or choose Tools|Send/Receive. I'm using Outlook 2003 on
Windows XP. In case it matters, there's a toolbar for ZoneAlrm Outlook
Addin with Junk filters (I use the Zone lite firewall freebie). Is there
a setting in Outlook I need to set to automatically send messages?
Should I disable the Zone addin? If so, how?
Thanks.
---...
can servers be moved between administrative groups?Below is an extract from the 70-284 MS training kit. I am totaly confused i
have been told in this newsgroup by an MVP that you can not move a server
once installed to a different administrative group and have also read
elsewhere that you cannot but Microsoft below say you can in both modes.
Subsequent Exchange servers are added to routing groups during the
installation process,and if necessary, you can move servers between routing
groups using Exchange System Manager. The only caveat is that in mixed mode,
you cannot move servers between routing groups that belong to different
administrative...
Has Anyone ever seen a chart like this?
Looking for some help. I need to know what this column chart is called?
Or how to make it?
'CLick Here to View Chart'
(http://www.f150online.com/galleries/pictureview.cfm?pnum=163585&anum=11244)
I can't find any option in Excel to make this chart. Maybe it was not
made in Excel? Or I need a specific plugin?
--
TsunamiBob
------------------------------------------------------------------------
TsunamiBob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36202
View this thread: http://www.excelforum.com/showthread.php?threadid=559874
Hi,
It...
REQ: Can Someone Help Me With This Outlook XP Question?Hello All:
I use Word to edit my e-mail msgs in Outlook XP. I had to reinstall Office
the other day and now whenever I want to start a new e-mail or reply to an
e-mail I get a warning that comes up:
"A program is trying to access e-mail addresses you have stored in Outlook.
Do you want to allow this?
If this is unexpected it may be a virus and you should choose 'No'"
There is a box that asks for the amount of time to allow the access: 1 to 10
minutes.
Do I have to have specific settings for my Outlook address book? I use the
Contact area in Outlook for addresses.
I have ...
in excel how can we put formula to convert numericalfigureto wordfor example :
in excel i have mention 25000.00 in numerical amount , i want to know how
can i convert in next colum , about word ?/;
How can i put formula to make the numerical in to words like 25000 in
numerical to twenty five thousands in word.
There is no direct functions to convert this. For a VBA solution check out
the below links
http://support.microsoft.com/kb/213360
http://www.ozgrid.com/VBA/ValueToWords.htm
http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
Jacob (MVP - Excel)
"excel" wrote:
> for example :
>
> in excel i hav...
How can I wrap text across merged cells?I'm using Excel 2000. I have a set of merged cells A5-
E5. I have several lines
of text in the cells and I want them to wrap across the
merged cells and it is not working. All I get is the
first line of text showing and the rest is cut off. It
works if the cells are not merged, but I really need to do
it in my merged cells. Is there a way to this other than
manually resizing the height of the row?
Instead of merging cells, have you tried the "Center Across Selection"
option ?
The appearence is just about identical to what you would get using merged
cells, although I d...
Can the column index in a cell address be made variable?Hi,
To refer to a cell with a variable row number, we can just code it as,
for example,
Dim i As Interger
i=234
Range("A" & i).Select
To refer to a cell with a variable column index, it seems not that easy
because the column
index must be explicitly specified in a cell address. So, if I want to
go to the j th column on the 2nd row or j columns to the right of cell
AA3, is there a quick and easy way to do it? Thank you in advance.
David
You may be able to use R1C1 terminology, but you'll need to get someone else
to help from here.
"cyberdude" <honc...
How many Server-side rules can you put on one mailbox?I am using Exchange Server 2003 and want to setup 52 rules on one of the
mailboxes, is this possible?
the hardcoded limit on space for rules is 32K...i doubt you'll be able to
get 52 rules on one mailbox...
--
Susan Conkey [MVP]
"jmareel" <jmareel@discussions.microsoft.com> wrote in message
news:6ADDDCD7-948C-415F-B194-1944C9936BC2@microsoft.com...
> I am using Exchange Server 2003 and want to setup 52 rules on one of the
> mailboxes, is this possible?
http://support.microsoft.com/default.aspx?scid=kb;en-us;147298
--
Bharat Suneja
MVP - Exchange
www.zenpris...
Baseball Stats question: How can I get the RBI's?
I have a data table that looks like this:
Code
-------------------
STR-S SNK-S STR-K STR-F SNK-S STR-3 STR-2 STR-F SNK-S SNK-4 SNK-S STR-3 SNK-F STR-4 STR-O
-------------------
"STR", etc at the beginning are pitch types, SNK is Sinker for example
The end character is the result of the pitch, a 4 would be a home run,
3 a triple, and so forth. O is out, F is foul, S is strike --- you ge
it.
How can I figure the amount of RBI's? I know that it's 5, but I can'
think of any automated way to calculate this, anyone got any ideas?
THANK YOU!! :confused
--
AVER...
How can I convert a timeline to be vertically oriented?How can I convert a timeline to be vertically oriented? Microsoft says it's
possible on a few web pages but I can't find instructions.
Which version of Visio are you using?
Randall Arnold
"Sherry" <nowhere@microsoft.com> wrote in message
news:ut%23cPHX1DHA.3656@TK2MSFTNGP11.phx.gbl...
> How can I convert a timeline to be vertically oriented? Microsoft says
it's
> possible on a few web pages but I can't find instructions.
>
>
Visio 2000
"Randall Arnold" <rgarnold@cathartis.com_> wrote in message
news:#pEeMyY1DHA.1272@TK2MSFTNG...
can't open files I have Microsoft Office 2003 ~ all of a sudden when I go to my documents
and try to open a file, I get this message "problem sending command to the
program". Error 0646 and dt000
See the article "How to re-register Word when problems crop up opening
files” at:
http://www.word.mvps.org/FAQs/AppErrors/ReRegisterWord.htm
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Lost in Vegas" <Lo...
XML as a database that can be written toHas anyone had any luck using XML as a database that not only can be read,
but also written to?
What features are available in .NET to do this?
I need to do all of this from a Web based application.
Am I thinking File System Object?
Thanks.
mjc wrote:
> Has anyone had any luck using XML as a database that not only can be read,
> but also written to?
That's doable, but you better use real database instead. XML wasn't
meant to be used as a database, it's just a data format.
--
Oleg Tkachenko [XML MVP]
http://blog.tkachenko.com
Yes, it can be done and I think its an id...
Can I create sub-functions in a cross-functional flowchart?Trying to create a template for my organization to map processes to. Goal is
to map the organization to the 'function bars' in Visio's cross-function
flowcharts. However, I would like to create some 'sub-functions' for lower
organizational elements (i.e. divisions under a department). Is this
possible??
...
Can't edit print styles in Outlook 2007Weekly calendar view to print - Define print Styles - Edit "CANNOT DISPLAY
THE DIALOG BOX"
I'm using trial version - shouldn't be the case????
thks
I'm having the same problem where I cant edit the print syles ... please let me know what ou find out.
I think being able adjust the format and print the calendar is important, as I usually print my calendar.
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
Nate
This is an Excel newsgroup. I would suggest posting this to an Outlook one
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton...