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...How to Debug MFC dll
I have a VS 2003 soln with 2 projects - 1 MFC Dialog based app and the other
I am loading the MFC dll from my MFC app. If I set breakpoints in the MFC
dll code, it doesn't stop there. How do I debug the dll ?
Is the DLL linked in with the App or do you dynamically load it?
"Cagespear" <Cagespear@discussions.microsoft.com> wrote in message
>I have a VS 2003 soln with 2 projects - 1 MFC Dialog based app and the
> MFC dll.
> I am loading the MFC dll from my...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...Adding support for mfc / atl types in a Win32 project
MSDN says this about adding support for classes shared between atl &
mfc (I'm just after points and rects btw)... just add the header (
I'm getting linker errors for these classes though. Is there a lib I
need to add? Any screwy build options need changing? It's in VC 2003.
In the project wizard I note that atl and mfc support aren't available
when creating an empty Win32 application.
On 26 May 2006 07:42:09 -0700, Simon L wrote:
> MSDN says this about adding support for classes shared between atl &
> mfc (I'm just after points and rect...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...Preventing dissambly/decompiliation of MFC Apps and DLLs
I was wondering if there are any software products out there that will take
a compiled MFC app or MFC DLL and prevent the files from being disassemble or
James Simpson wrote:
> I was wondering if there are any software products out there that will take
> a compiled MFC app or MFC DLL and prevent the files from being disassemble or
> being decompiled?
> James Simpson
Whether or not MFC is used is irrelevant. There is no way to prevent or
even resist disassembly. If it is execut...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...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?
--...Textbox fomatting value based on another textbox
I have two text boxes on a form. One is a value that can be changed by the
user. The second is the value 1 - textbox1. I need everthing to be in %.
For example, in textbox1 the user could type 75 and it would automatically
be recognized as 75% and textbox2's value would calculate to be 25%.
Everytime I try textbox1's value is = to say 7500%. Any help is
Maybe something like:
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim TB1Val As Double
If IsNumeric(.Value) Then
TB1Va...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 ...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...MFC classes DISAPPEAR!!!!help
could someone please help me:
many MFC classes almost always disappear from class browser window!!!
while their files continue to be properly listed in the file browser window
Try deleting the clw file and let the class wizard recreate it for you. If
that doesnt help also try deleting the opt and ncb files. Or else try
upgrading to Everett :-)
Nish [VC++ MVP]
"BIANCA" <firstname.lastname@example.org> wrote in message
> could someone please help me:
> many MFC classes almost always disappear from...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...Summing based on a unique ID
I have a worksheet consisting of 5,000 lines with 4 columns of data:
(1) (2) (3) (4)
Portfolio Deal # Reference ID Raw Amount
I have written a macro to create a separate worksheet tab, within the
same workbook, for each of the 40 unique portfolios in column 1. This
However within each of these separate worksheets I would like to do a
sum on each Deal#
as there could be as many as 10 line entries for a particular deal.
Is this some thing that could be accomplished in one step, or do I have
to write another macro to do the...