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. :-)
...[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...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
...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...Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam email@example.com> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...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...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...Exchange server crashed, please help....! Need to restore two priv.edb and pub.edb files into one....!
I was wondering if I could get some help with the following problem we are
having on our company.
Here is the scenario; Our Windows NT 4.0 SP4a server running Exchange 5.5
SP4 crashed (Server 1) due to the exchange database reaching its 16 Gig's
max limit. I went ahead and moved some mailboxes' e-mails to a few .pst
files in order to make some space. This worked ok. Then, I decided to build
another exchange server (Server 2) to moved some mailboxes and alleviate the
load. Once the server was ready and configured as part of the current
exchange site, I went ahead and move...restoring
attempting to use my money 2001 restore disk to load money
2003. 2003 says disk is corrupt or its not a money file
any fixes out there?
What you posted doesn't make sense to me.
What is a "money 2001 restore disk"? Is this a backup file produced by Money
2001 on a floppy or a CD or something?
You say you are trying to use it to "load money 2003"--does this mean you
are trying to restore a Money 2001 backup file using a functional
installation of Money 2003? If so, do you still have the original Money 2001
data file somewhere? Can you try moving that to the Money 20...Restoring Outlook Files
I need to move the actual inbox, etc. from one hard drive
to another. Which files do I look for? I had Outlook
configured as an IMAP client. I keep looking for a
master "inbox" or "mailbox" file, but am unable to find
thanks for the help!
Look here for all the information you need on backup and restoration of
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***
In news:02b50...upgrading from Access 97 to Access 2007
I designed a database (forms, reports, et al) several years ago in Access 97
and it continues to work well. I've just received a MS Office Professional
2007 and wonder if it is time to migrate my data into the new program.
I've attempted two or three times to do this in Access 2002 and I keep
getting error messages along the line of "...corrupted file..cannot be
opened by Access 2002 (or some such message)..." The help radio button
opens up a box which suggests I do some programming in Virtual Basic to
perform my transfer task.
The easy way out, of course, is to sti...Data validation list from another worksheet?
Is it possible that the value list for data validation be populated fro
puneetarora_12's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1840
View this thread: http://www.excelforum.com/showthread.php?threadid=38572
Sure is! Use a named range as described here:
"punee..."external data sources" and "external data ranges"
what is the difference between these?
i have run the vb macro code on http://support.microsoft.com/kb/330383 to
check if i have any external data sources or data ranges but there are none.
the reason i need to know is becuase i'm working with office sharepoint
server 2007 and i cannot access a file thru the web access web part because
"The workbook that you selected cannot be loaded because it contains the
following features that are not supported by Excel Services:
External data ranges (also called query tables)"
...Excel and Access
I admit I am a complete novice on this aspect of using
Excel. My requirement is as follows.
I have an Access Database called nt1.mdb on drive D: in
which there is one table (Table1) of data, indexed on
I wish to connect to this database and search the contents
of Table1 for a value in column1 that has been entered
into an Excel userform. The values of the other columns
in Table1 should be returned if the value is found.
How do I connect to the mdb, do the search and read the
resulting values from the table?
Any help gratefully received.
There's sample ...Receiving c1041724 error on restore
I ran the eseutil /cc command against the files in the c:\temp
I have pointed it to c:\temp where the restore.env file is located but I am
still not able to mount the database.
I also have restored from tape the transaction logs.
The transaction logs are in e:\exchsrvr\mdbdata.
The checkpoint file is in e:\exchsrvr\mdbdata.
Does anyone have any ideas?
Kami Groom MCSE 2000, A+, CNA
You have to specify the full path to the ENV file and if you are using the
defaults, you have to put quotes like:
eseutil /cc "C:\temp\First Storage Group"
"Kami Groom" <kgroom...Change default export to Excel location
Does anyone know how I might be able to change the default location for
exporting tables, queries, etc. from Access to Excel? It defaults to My
Documents, which I can't stand because it forces me to drill down to find
the spreadsheet. I'd rather that I could set it to go to my desktop. I've
looked in the Access settings and registry, but could not find where to make
Any help is appreciated.
Look at the TransferSpreadsheet method (in Help)... using that you can put
any path you wish.
2010 Microsoft MVP (Access)...Security/ Access Levels
Can someone please help me with this MS CRM security/ access level
question before I go completely mad trying to figure it out?
I want to be able to restrict who can access certain account records
(e.g. account records for our customers). For example, I don’t
want telesales people to be able to access our customers account
records. But I do want to give them access to other account records.
I’ve tried restricting access at a user level and at a business
unit level but cannot get either to work. If I set a particular users
role to only access account records that they...Source data, in Chart Menu, is grey and not accessible.
I set up a pivot table and designed a chart, saved and closed out of the
workbook. Upon returning to work on this project, when selecting the chart
menu to work with my source data, the source data is grey and not accessible.
What might be causing this and can I correct it?
It's a pivot chart. As soon as it's created, it's linked permanently to the
pivot table, and you cannot change the source data. you cannot add more data
that's not in the pivot table to the chart, nor can you remove data that is
in the pivot table from the chart.
Jon Peltier, Microsoft...Access file shares from Outlook
I=B4d like to add directories or file shares from servers to the mail
folder pane on the left side of Outlook. The folders should appear
like public folders. Is this possible?
No, but you can add them to the Shortcuts Navigation by simply dragging and
dropping the folder from Explorer into Outlook.
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
"maltic" <...integrating access with excel formulas
i'm building upload proccess from excel to access,
i need to take some amount from the access and enter it into a formula
inside of the excel
for example min(amount-5,60)
during the upload access programming will exchange the amount text in
real amount and will upload the result
is it posible to do the folowing:
1.exchange the amount text in the amount from access2
2.to calculate the formula in excel and the sum will be uploaded to
3.still to leave the formula as is in the excel without revising(all
changes will be made by the programming and values in access