Access 97 can't resize database window
My database window with the listings of forms tables etc was adjusted to a
smaller width, but resizing it is completely disabled and renders Access
2007 utterly useless for me. Is there anyway to 'reset' the window?
...How to link with an Access DB
Hi, I have an Acces DB with many tables.
I need to choose the name of a customer in a cell of Excel.
For example, in acces I have this tables:
I need to choose the last name from a drop down menu in a spreadsheet and
then in other cell I need to put all the data regarding the last name that
I hope to be exaustive, and sorry for my english. :-)
...exporting outlook 2000 pst files to a database
I need to export outlook 2000 to a database- attachments
and all. Is there a simple way to do this so you can search
and retreive messages and attachments in a database form?
You can export individual folders to access or excel to have them available
for searching. I have never tried to export my entire .pst file to access
or excel however.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer
Jeff <email@example.com> asked:
| I need to export outlook 2000 to a database- ...[Access 2007] How to edit custom menubar created in Access2003?
This is my first post to this server, Hello everyone.
We're working on a database created by my collegue in MS Access 2003. Since
some time we've moved to MS Access 2007. Now we find problems editing the
menubar. Each time we want to remove/add/alter a menu item my collegue goes
to his MS Access 2003 and changes a menu.
In 2007 the full menubar is visible under Add-Ins ribbon menu.
Normally there should be a system table USysRibbon, but it is not there.
There are only MSys* objects. How can we change the menubar directly in MS
Access 2007? Is that possible at al...Access 2003 resets form variables during debugging while the form is open
I am using MS Access 2003. (FWIW, this is about an ADP project, not
A form has a variable that is initialized (by some function call) in
Form_Load() and then stays unchanged for the form's entire lifetime.
(In a language more advanced than VBA, it would be a constant, not a
variable; unfortunately, in VBA I cannot initialize a constant by non-
constant expression). Specifically, in my case it looks like this:
Private sTempFileName as String
Private Sub Form_Load()
sTempFileName = GenerateTempFileName(...)
Priv...office 2000 [excel] cannot open previously OK file. Help
When trying to open a Microsoft Excel Work Sheet that I had accessed modified
and saved to only yesterday [Office 2000] a window pops up with:
"name.xls cannot be accessed. The file may be resd-only, or you may be
trying toaccess a read only location. Or, the server the document is stored
on may not be responding."
Older files stored on the same mediums ;HD, Flash memory or 3.5in. diskette
are accessed with no problem.
This is on a network drive?
...Can't move things to deleted items: The item could not be deleted. It was either moved or already deleted, or access was denied
This is weird. It looks like I have one user with a damaged 'deleted
items' bin. Everyone else is fine. This user had opened up an accout of
someone who left the company a while back and apparently tried to
delete a few thousand spam messages that they had. Their system eitehr
locked up, or they got sick of waiting and did something to stop it,
when they did we could no longer mount the information store. I ran
several things including an eseutil /p on the database, and then
removed the log files and ran the ISINTEG -s server01 -test alltests
-fix, which found 2 or three problems and f...Getting control IS in Active X controls
The common recipee is to use
both return 0
So what can be done
...Outlook 2000 not opening.
I am having a major problem with outlook. Can anyone tell
why Outlook will not open when selecting it. When I check
in the processes there is an instance of Outlook.exe there
but it is not doing anything. When a different user logs
onto the machine Outlook will open fine with no problems.
I have deleted the users profile and recreated it but to
no use. I have tried comparing the local registry keys of
the two users and they seem to be the same.
Can anyone please help me as I have ran out of things to
Thanks in advance.
Does Outlook start in /safe mode? (I'm assumi...users with restricted access
We have some users that we have directed to only get their information
from a report that has been set up. Because of that, I set up a
parameter query to make the information more easy to see.
The parameter query prompts for last name or broker #, is there a
way, when the last name is entered to include Jr's & Sr's? Or should
this be another field in the table to make the last name field more
...CRM Outlook Client Configuration Wizard Problem
CRM 4.0 - Microsoft Outlook Client
We've Microsoft CRM 4.0 Server roll up 8 as well as CRM Outlook Client on
the same roll up version. Our Internal Web Access works without problems
users get to it and they're automatically authenticated. IFD Development is
the same way except they're prompt through a login page for their username
and password when they're coming from an external network.
Ever since we moved to a new facility users are experiencing problems
connecting to CRM using their outlook client, I have a test machine where I
have the CRM Outlook Client ins...Access 97/2000/2003 comparisons
I have a rather large application that uses an access 97 database (DAO). We
also have a version that works with access 2000, Oracle, msde, and SQLServer
(ADO). We would like to retire the DAO version of the product, but there are
places where the ADO version is much slower compared to where we run DAO
seeks (very noticeable when looping). So, I have a few questions.
1. Are there any tips/tricks to speed up ADO queries to compare with DAO
2. Would there be any benifit in using access 2003 over previous versions of
the software besides the added features (xml support, etc).
3...Using later version of microsoft access
I've got access 2000 on my computer. When I go to open a database someone
sent me I get an error message :
this database is in an unrecognized format. The database may have been
created with a later version of microsoft access.
Is there any way I can open and use this file (short of upgrading to later
version of access)?
If you do not have Access 2002 or 2003, ask the person to save it in Access
2000 format for you.
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at m...Controling a MailMerge...
I am about to redo a procedure that will control a mail merge.
My current process requires that the AccessDB is closed. This is the
1) Data exists an access table that represents children in a household.
2) The assumption is made that the youngest child stores the most current
mailing address and parent's names. A form/sub-form process allows viewing
all children in a selected household as well as updating the address
3) A button on the main menu starts the mail-merge. It runs a Make Table
query that generates the data necessary for the household. Then l...Audio does not work on other end of video call
I have 3 or 4 people that I have tried to setup video calls thru messenger
and only one of them can hear me clearly. One can hear me but I have to
yell. Another cannot hardly hear me at all and is choppy.
The video portion works fantastic on both ends, as well I can hear everyone
crystal clear. I also know that the other party's systems seem to be working
well because I can actually hear their pc's making noise when I type a
message or when they play something. So I don't think they have speaker
Does anyone know what the problem could be?
Everyone i...backup file won't work!!
OK, now I've really had it! This is my last resort!
Several years ago, while using Money 97, our computer
crashed. We had backed up every time we used money, so I
thought we were OK. However, we could never get the
backup file to pull up after fixing the computer and
everything was lost. I vowed that this would not happen
again, so I tried backing up on a ZIP disk instead, and
then on CDs. I also got on this newsgroup and got the
advice that I needed to first copy the backup file onto
the desktop and open it from there. I tried doing that
with the old program, and it seeme...How to make Run Integration work in GP 10
Can anyone tell me how to make the Run Integration tool work in GP 10. We
just did our first client upgrade to GP 10 and the client has only 1
integration that they used to be able to run via the RUN INTEGRATION Tool.
Any help would be greatly appreciated.
I have the same probelm...did you get any answers to this?
I have to go into Integration Manager to run it b/c Tools>Run Integration
does nothing. I even checked the ini files to make sure the path is correct.
"Tammy Chavez" wrote:
> Can anyone tell me how to make the Run Integration tool work in...no access to send internet email
Exchange 2003. Can a mail enabled user be restricted to send internal email
only and not internet email?
> Exchange 2003. Can a mail enabled user be restricted to send internal
> only and not internet email?
yes, that is possible.
There are multiple ways to archive this goal. Depents on your
If you have mailing to external over an SMTP Connector, try this:
First look into your SMTP Connector, you will find Delivery Restrictions
It is self explaining.
If you have trouble with that or you won't find it,
then i will need additi...Data migration - Adventure Works
I have a company where the adventure works db has been used and had a
lot of data populated into the system. We have now purchased MSCRM and
have obtained the company reg keys.
What is the easiest way to get the data from the 1 system to the next?
We will be establishing a new AD domain and users for the new
Data Migration Framework?
Microsoft CRM MVP
"funboy...Special Pasting a work book with many sheets and formulas
I have a workbook with many sheets that all have formulas and links to other
data. I want to save the workbook as another name with all the worksheets
keeping the values only (no links or formulas). Is there a quick way to do
this for everysheet without having to special paste every sheet in the
workbook. So can I save everysheets data values at workbook level.
See this page for a code example
Regards Ron de Bruin
"lex63" <firstname.lastname@example.org> wrote in message news:ED708...Is Outlook 2000 compatiple with Windows XP Home?
It seems to be having problems if it is... something like
Outlook has experience a problem and must close. I rand
the compatibility wizard, but it didn't help. Can you?
I have Outlook 2000 installed on my XP Home machine and
it works fine.
>It seems to be having problems if it is... something
>Outlook has experience a problem and must close. I rand
>the compatibility wizard, but it didn't help. Can you?
Rod <email@example.com> wrote:
> It seems to be having problems if it is... something...OL 2000 should not autom send/receive on start
I found it in OL 2002 but not in OL 2000.
How can I define, or better disable, that OL is trying to
send/receive mails on starting and closing OL?
And it should never automatically try every x minutes to
do so. I found this option on OL2000 but my impression
is, that OL is still polling the pop3 account for new
Any help on this would be appreciated.
Thanks a lot
Tools->email accounts->send/receive settings.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail se...Setting Defaults in New Item Wizard
How can I set a default value in the New Item Wizard? I want to always use a
barcode type that is about 10 down from the top and I want Taxable Item to
always be checked. Help...
Good question, I need an answer too.
"A StanTech Associate" wrote:
> How can I set a default value in the New Item Wizard? I want to always use a
> barcode type that is about 10 down from the top and I want Taxable Item to
> always be checked. Help...
You can set the default sales tax under Manager, File, Configuration, Sales
Tax, Default item tax group.
To set a default barcode type yo...Outlook 2000 #187
When I launch Outlook 2000, it hangs up. I've installed
the upgrade from Office 97 to Office 2000. Can anyone
tell me why outlook hangs up. I've check the properties
and verified my internet e-mail information.
J. Tolbert Fuller, jr.
Houston TX 77093-8411
Fuller John T. <firstname.lastname@example.org> wrote:
> When I launch Outlook 2000, it hangs up. I've installed
> the upgrade from Office 97 to Office 2000. Can anyone
> tell me why outlook hangs up. I've check the properties
> and verified my inte...Rule Wizard: "Rules In Error"
I have a blackberry, and I have my outlook forwarding
emails to it, but about once a day, I get a message that
says "Rules in Error: Error in Rule Execution" and it
won't forward any emails after that. I only have one
single rule, so it's not a rule conflict. Does anyone
know the deal? This is extremely frustrating as sometimes
I'll be out of the office during the weekend or at night
and won't receive any message for hours on my blackberry,
only to find out later that this "Rules in Error" dialog
box popped up and it won't forward emails. It see...