Any reason CurrentDb.TableDefs(0).Connect returns empty sting in Access 2007?
I use the function below to return the server or database name for various
However, now that we've switched to 2007 the line
which used to return the connection string is returning an empty string.
Function GetConnectionProperty(ServerOrDatabase As String) As String
' Returns name of connected server if "Server" passed in.
' Retuns name of connected Database if "Database" passed in.
Dim sConnectionString As String
Dim aConnectionPieces() As String
Dim sConnectionPiece As String
Dim i As ...How to access macros via tool buttons?
When using v2003, I had many macros In my Personal.xls, which I
accessed via custom tool buttons on many custom toolbars that I built.
I now have version 2007, which includes my old Personal.xls with all
my macros, but I want the easy access to those macros I used to have.
Being the tool ribbon is a different system, what is now the strategy
for fast button-clickable launching of macros? Are buttons built,
[I already know about the Quick Access Toolbar, but I have over a
hundred macros I previously had divided onto several toolbars that I'd
hide and s...Menu wont delete!
My application uses a CMDIFrameWnd to display documents. The documents are
generated in a CMDIChildWnd object. The problem is the the MDI child (i
think) is creating an extra menu on top which I dont need. I tried deleting
the menu inside the OnCreate method, but it does not get rid of the menu.
Here is how my application looks right now with two menus at the top.
Here is a snippet of code that I used to delete the top menu:
int CChildFrame::OnCreate(LPCREATESTRUCT lpCreateStruct)
this->SetMenu(NUL...menu event functions
I am a new bee here.
I wanted to know in which class should I keep my menu OnCommand
Should those be in App class or frame class or view class or doc
As you know for SDI we keep it in App class.
Also I wanted to add that I want this to know in case of MDI
> I am a new bee here.
> I wanted to know in which class should I keep my menu OnCommand
> Should those be in App class or frame class or view class or doc
> As you know for SDI...replicas de access
como puedo quitar las replicas de access
"Por mi raza hablara el espiritu"
If you mean 'removing' the replications features... you can start with
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=7#7 (note that the
site is multilingual).
Vanderghast, Access MVP
"victor kingobol" <firstname.lastname@example.org> wrote in message
> como puedo quitar las replicas de access
> "Por mi raza hablara el espiritu"
...allow folders in access
It's pretty common to have logical groupings of queries, reports and so on.
It would be great if Access provided a grouping mechanism - via named folders
or something similar - within the object management panes.
For example, if I'm creating a report - MyReport - that has several
subreports - MySubreport1, MySubreport2 and MySharedSubreportA - I could set
things up in the Reports pane like this:
- MyReportFolder [folder]
MyReport [rpt obj]
MySubreport1 [rpt obj]
MySubreport2 [rpt obj]
- MySharedSubreports [folder]
MySharedSubreportA [rpt obj]
Two things to note:
...Microsoft Outlook Web access #3
I use this to pull office emails at home. Up until
Tuesday, this worked fine. Wednesday I was unable to get
any new mail(said nothing to view) even though Wednesday
is the one day I know there will be early morning mail as
it it the day I get a newsletter. I had downloaded
something on my office computer on Tuesday, so I
uninstalled. When I got home, same thing . This time
the response was a error symbol in lower left. Since I
have Windows XP, I did a restore to Monday. Still
nothing. I am still getting nothing to view or the error
symbol with no additional information. Any ...Message of: a program is trying to access email addresses
you have stored in outlook. Do you want to allow this.
Why does this show up when a MAPI account tries to use
this. It there something in a security setting I can
See if the information on the following page helps:
MVP - Outlook
*** Replies sent to my e-mail address will probably not be answered --
please reply only to the newsgroup to preserve the message thread. ***
"Kim Newberry" <email@example.com> wrote in message
> you...Access 2007 and windows 7 12-25-09
Under windows xp and vista. I was using a batch file to compact a database,
now under windows 7 it does not work I get an error.
"c:\Consulting Tracking Program\Consulting Tracking.accdb" /compact
Now I get a message box saying that was a problem sending the command to the
Thanks for the help
> Under windows xp and vista. I was using a batch file to compact a database,
> now under windows 7 it does not work I get an error.
> "c:\Consulting Tracking Program\Consulting Tra...how do I create an adp in access 2010
My commercial app developed over ten years uses an Access adp 'structure
file' connected to SQL Server.
I want to try developing in the Access 2010 IDE but can't figure out how to
Yes, I could create an adp in 2007 or 2003 and open it in 2010 but that's
it looks like there is no way to create adp in 2010 (but keep in mind - 2010
is beta yet). Microsoft recommends making MDB with linked tables, and
perhaps reduces support for ADP
Alex Dybenko (MVP)
http://accessblog....Opening Access Database file
I am trying to open my access database file on my home computer but i get a
message that i will not be able to make changes to it. Is there a way to work
around it. By the way i had been using this file with GeoMedia.
If any wizard can guide me in the right direction i will be thankful to him
I'm not sure what GeoMedia is, but if you copied the file to your PC from
elsewhere, the read-only attribute may be set. Try this ...
Using either 'My Computer' or 'Windows Explorer', navigate to the folder
that contains your MDB.
Right-click the MDB and...Access 1.10 MDV file conversions to
I have an old Access data base that has never been
updated over the last decade. I have been told by a
consultant that the new version of Access will not
convert this earlier .mdv files to the current format.
Does anyone know if this is the case?
I assume you mean MDB files, and yes, it's true that the latest version of
Access (Access 2003) cannot open Access 1.x files. To be honest, I forget
the last version that was capable of converting those files.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"firstname.lastname@example.org" <anony...Chrome and Menu Control
I have an asp.net 3.5 framework website that uses asp.net Menu controls both
horizontal and vertical. When I use the website on IE or Firefox the
controls work and look fine. However, when using Google Chrome, they look
strange and background, alignment and hover properties do not work correctly.
Is there any way to assure the Menu control works the same in all major
...Use list options to hide columns
I was wondering if the following is possible in excel:
<big deep breath>
I have 4 separate worksheets for data entry and results calculation for
radiation detection, each is a separate type of test.
These worksheets/tests share a lot of common Fields for data input and
calculations, what I want to do is combine the worksheets and show/hide
only the columns relevant to each test.
In column A, I have added a drop down list of 4 different types of
Depending on the type of test I select; call them A, B, C & D
Can I use a List to control which columns are sho...Remote options to CRM 3.0
What are my options to let end users access CRM 3.0 off our regular network?
Web Page - Webpage must be SSL, in order to encrypted the data
Offline Outlook client
Mobile Device Option
May also consider Terminal Service/Critix Client.
Frank Lee, Microsoft CRM MVP
"Sabo, Eric" wrote:
> What are my options to let end users access CRM 3.0 off our regular network?
> Web Page - Webpage must be SSL, in order to encrypted the data
> Offline Outlook client
> M...Web Services access to MS-CRM by Java and http: post
I am trying to integrate MS-CRM with a number of non .NET based
While it's true that MS-CRM is based on a web services architecture, the
only way I've been able to successfully integrate is by uilding .NET code
using the Microsoft Proxy dll.
Is there any third party integrator that simply takes all the Microsoft CRM
objects and exposes them through standard SOAP calls or better yet, http
posts? I want to be able to call alll of the MS-CRM objects from non .NET
platforms without having to custom code every object.
This is a multi-part message in MIME forma...IMF: Shouldn't this option be in the product?
IMF is setup and working wonderfully. I'm using IMF and Connection Filter.
The problem is, we have obscure mailboxes (AD accounts w/ Exchange mail)
that sometimes receive email. The email generally comes from users who send
via HTML forms. So the email looks like UCE, but it's not.
How do I configure IMF to say "any time an email is addressed to
'email@example.com' always let it thru?"
Many thanks and kudos in advance to who knows the answer
IMF: How to exclude recipients from IMF filtering
http://www.exchangepedia.com/blog/2006/04/imf-how-to-exclude-recipie...SQL options and new upgrade GP9.0 (from GP7.5)
Here is my problem after I upgraded to GP9.0. I need to add a user with GP,
unless I refresh its password (in SQL Enterprise Manager) and re-define its
properties, I cannot use it to access GP moreover, use SQL resources.
I also discoverred that DYNGRP dont have permissions on some of the GP
Also when I change the password in GP. It does not update the one used in
SQL. Why is that?
How can I correct this issue?
If you create a user in GP the password is encrytped by GP so that the
password that is sent to SQL is not the same. This is why a GP user can not
do anything in SQL...Accessing Document in SDI
How do I access the document from the main frame in an SDI application?
...Time Onbehalf of Option Active only
Business Portal 3.0 HRM Self Services:
Site Settings > HRM Self Service > Timecard Entry Setup
Currently in the timecard entry setup screen the default display is for all
employee cards in the employee master table. It would be nice if there was
an option to display this window with only the active employee's. Reason for
is because as company's have turn over the inactive employee name will
continue to display in the window. This file could become large depending on
the number of employee's. Sorting through the list would be much easier if
only active employee da...support case options
I am looking to be able to assign a single support case to multiple
Accounts. Is there any way that this can be done in MSCRM. Is there a way
to do this thru System Customization? If so, is it a matter of adding
fields to the form, and does it change the way that reporting is handled.
Any help is greatly appreciated.
...I cannot access any hyperlinks in e-mail messages I receive.
Somebody or something has changed access settings in my Outlook e-mail. If I
click on a hyperlink I receive a message telling me that it can't perform
this action and that this computer has restrictions and I should contact my
system administrator. Unfortunately, that's me!!
> Somebody or something has changed access settings in my Outlook e-mail. If I
> click on a hyperlink I receive a message telling me that it can't perform
> this action and that this computer has restrictions and I should contact my
> system administrato...Running Access Query Returns Incorrect Number of Records
I am running some code which loops through and runs the queries in an
Access Database. The count of the records is then stored in a
For most of the queries, the figure stored in the Worksheet matches
the number of records if you run the query in Access. But for certain
queries, the count of the records does not match the number of records
when the query is run in Access.
If I change the query to a make table query and then base another
query on that table, the results are correct.
Can anybody suggest running the query from Excel would results in a
different number of records bein...how to active the ribbon Tab automatically when the form opens[Access 2007]
I built a ribbon tab for a form. It works fine and when the form opening,
the ribbon will be loaded fine. But it would be focus (or active)
automatically. It still focus in the tab where I set now. Please
is the callbacks for the ribbon always in Modules? I remember in Access
2003, the callbacks function could be in the form class modules. If all the
callbacks should be in the Modules, does it mean we need distinguish which
form or report is active now?
Thank you very much.
Hi Ribbon is the new command bar system in office 2007...email access in outlook from a cruise ship
I'm going on a cruise to Alaska and I need to access my email to answer
quotes, ( working vacation ) thanks.
doug blair wrote:
> I'm going on a cruise to Alaska and I need to access my email to answer
> quotes, ( working vacation ) thanks.
i don't quote understand what you mean. if your cruise ship gives you
access to the Internet, you should be able to use Outlook.
Check with your mail provider to see if what kind of web access they =
offer. This isn't an Outlook issue per se.=20
Sue Mosher, Outlook MVP
Author of ...