Business Portal Error-SQL server does not exist or access denied
We are running business portal 4.0 for one of our customer. It was running
correctly, however, they have changed the SQL server port (previously it was
set as default 1433). After that the business portal becomes very slow and
while creating a new request (purchase requisition) if we open the item pop
up; it is showing exception
"SQL Server does not exist or access denied...."
Can any body tell me how can I provide the new port number to business
portal connection to the database.
Thanks and Regards,
Thanks for using the newsgroups. I have a...What's happened to the findfirst function in Access 2010?
I have a working Access 2007 Application which is now failing miserably in
2010. It hinges on location the first available working document in a table
runing the following VBA code:
.FindFirst "([fld1] + [fld2]) = 0"
If .NoMatch Then
.FindLast "([fdl1] + [fld2]) <> 0"
.... FURTHER PROCESSING ...
What must I do to correct this? Go through a record by record search?
In 2007, this works correctly, stopping at the appropriate record (approc.
rec 1385 in the recordset...Removing multiple users from Outlook
We did some computer switching, which involved uninstalling a copy of Office
XP and replacing it with a copy of Office 2003. Now when I open Outlook, it
makes me choose a user. This wasn't in the .pst file which was transferred
for the other computer, but apparenly it was on this computer someplace.
How can I get Outlook to simply open for the one account without that dialog
box popping up?
Control Panel | Mail | Show Profiles...remove any profiles you don't want.
Select the one you do want and set it as the default. (if there are more
than one left)
-Ben-...open two different Access reports
I was wondering if i can get some help here. I have two different reports
that i want to open when a user clicks a button to view the reports for
printing. Is there any way of popping them up at the same time in VBA?
Thank you in advance
>I was wondering if i can get some help here. I have two different reports
>that i want to open when a user clicks a button to view the reports for
>printing. Is there any way of popping them up at the same time in VBA?
>Thank you in advance
Yes. Call the DoCmd.OpenReport command twic...Access 2007 and Vista code problem
I am developing a database on a XP SP2 machine. On a form I have created
some buttons with event procedures that run 2 queries and open a form. I
sent the db to someone running Access 2007 on a Vista machine and nothing
happens when she clicks the buttons and there are no messages.
I know nothing about Vista so thanks in advance for any help.
Might be a reference problem, have them open the open a code window and
click tools references. See what says missing and tell them what should be
there, Add it and it should work. Duff
"Tim Reid" <TimReid@discussions.micr...Macro for Sharepoint List and another Table?? Same # records?
I am creating a database which we have a form made up of prepopulated data
(from a sharepoint list) and also data input needed by a user (for example,
I have two tables: one sharepoint list that is linked to sharepoint website
and another table that houses the additional user inputs [table 2]. I have
linked the files based on the primary key. So, every record in my table 2
has a plus sign and it will expand and you will see the linked data from the
Is there a way that I can automatically create a record for every
corresponding record ...2011 Calendar templates
what's up with the calendar templates?
why can't i find a 2011 calendar in Word 2007 templates or online.
i would like both a 12 month calendar 1 month per page and the 6 months per
Can anyone help me?
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
&quo...changing values of one field based on another
How can I best change the values of one field in a table based on
values of another field of the same table. We have an existing table
of thousands of entries and I would like to use the following logic to
populate a new boolean field.
If field1 = "Done" Then BooleanFieldCompleted = True
I have some Excel VBA experience but limited Access. I dont want to
do this manually! Any assistance appreciated.
In general, you'd use an Update query. However, in this case I don't see why
you'd need such a field.
Why not just create a query with a computed field that returns True...OWA Calendar Views
I am hosting an Exchange 2003 SP1 server with many users connecting via
OWA. Many of the users (including my boss) are not fond of the 7 day
view and much prefer the 5 day "Work Week" view within Outlook. Are
there any modules that I can load to implement this "Work Week" view
within OWA? I am aware of the control click method in the OWA calendar
but my boss does not like that solution.
Thanks in advance,
...Page setup for 8.5x11 calendar w/picture on tabloid paper?
How can I set up a calendar with 8.5x11 (landscape) pages with pictures for
each month to print on tabloid (11x17) paper so it can be saddle stiched? I
would like the picture on the top half and calendar on the bottom half. I
keep ending up with two of the same pictures on one page and two calendars
on the next page. Thanks, Bob
I assume you are taking this to a professional printer so why not just set
each page up as a landscape 8� x 11 and let your printer do the rest?
MVP Microsoft [Publisher]
"Bob at 4799" <Bob at firstname.lastname@example.org>...Using Access 2003 on client to see Sharepoint 2007
Testing a Sharepoint environment and I can easily manipulate and run the
database from Access 2007, but when I try to use Access 2003 it wants me to
save the database to a location. The Access 2003 has the compatiblity pack,
but it seems to not work when I download it.
So the question is using Sharepoint 2007 and posting the Access 2007 format
to it, can a user go to the sharepoint site and use a 2003 Access database
that has the compatibility pack and open without having to download it?
Message posted via http://www.accessmonster.com
Send check for $500.00 to: David A Jenn...Copying Data in a cell in one sheet to a cell in another sheet
I've run into a problem trying to copy data from a cell
in one sheet to another. I have a spreadsheet
called "rating" which contains a number of formula that
calculates a final number. I also have a spreadsheet
called "Final" that copies over the information
from "Rating". In "Final", I'm trying to copy a number
from "Rating" into a particular cell. I put in =Rating!
G89, but it won't work. When I press enter, a window
pops up "Update value:Rating". I press enter again and
in the cell where I want the number ...Outlook 2007 Calendar -> Outlook 2003
In the past I could forward appointments and birthdays from one PC to
another, if both PC's had Office 2003. I just tried forwarding a birthday
from Outlook 2007 to Outlook 2003 and it doesn't work. I get the email in
2003. Open it, open the calendar item, then click on Save & Close. No
error message. But it's not there. Neither in the current month or for
next year. I forwarded it as a reoccurring item, that's the only way it
will let you do that.
Has anyone else been able to do this?
Or, is this a backward compatibility issue?
It's odd.... this works fine for...compact database in VBA access 2007
I have recently upgrade to office 2007 from office 2003. To compact a
database from within the database itself, I used the follwing code.
Unfortunately it no longer works in access 2007. Is there some similar code
that will work?
Public Function FncCompactTheCurrentDB()
CommandBars("Menu Bar"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
On Thu, 28 Jan 2010 17:34:01 -0800, SL <SL@discussions.microsoft....LDAP Write access?
My ldap server allows Write access to entries - and a few clients now
Any plugins available for Outlook to allow this too?
None that I'm aware of.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
Subscribe to Exchange Messaging Outlook newsletter:
Outlook Tips: http://www.outlook...MS Access 2007 code not running
I have created a brand new database in Access 2007 and linked some VB
code to run on Form_Load. This code worked perfect with no problems
the day I created it. Now today I opened the same form and it is not
running the Form_Load code anymore (and yes it is still there, I did
not delete it). I got frustrated so I copied and pasted the code to
Form_Current and several On_Change events and set breakpoints at the
beginning of all the events just to see if it was the Form_Load that
was not triggering, but NO events are triggering my VB code. Any
See this page:
http://accessjunkie.com/fa...unable to grant existing user access to TEST company
Set up test company using live company data; ran the script referenced in
CustomerSource article ID#871973; can grant and remove user access in all
other companies; ran grantsql 9.2; the dexsql log shows the user already
has access probably because of using the other company data for the test; I
can set up a new user and grant them access, existing users who already have
access can view the company...but, I cannot figure out how to grant access
to the TEST company to an existing user. The error popup reads "The user
could not be added to one or more databases."
Dynamics 9.0,...Accessing another user's calendar OL2000/OL2003/Ex2000
Here's the situation:
Running Exchange2000, v 6.0, sp4. Users are on XP/OL2003 or NT/OL2000.
(we're in the process of upgrading all of the workstations to XP.)
VIP user is on XP/OL2003. He can access his calendar just fine on his
His secretary and other office admin type people are still on NT/OL2000.
They have reviewer or editor rights to his calendar. They try to access his
calendar by chosing File/Open/Other User's Folder... and put in his name and
calendar. When they do this, the process hangs. In Task Manager, Outlook
is "Running." End the Outloo...OWA Calendar
Is it possible to publish a public folder calendar (that users currently
make changes to in Outlook) to a web page? Does Exchange have some sort of
tools to do this? Users could still make changes through Outlook and we
would like to be able to display the calendar on our website. Thoughts?
"Jason King" <email@example.com> wrote in message
> Is it possible to publish a public folder calendar (that users currently
> make changes to in Outlook) to a web page? Does Exchange have so...WLM transfer to another computer
I finally moved from Windows 7 RTM to Win7 Pro 64. I did it by installing
the new OS on a brand new hard drive, then installed my old hard drive in a
2.5" external enclosure. I've been successful in moving most of my files and
settings over, but WLM is the exception. Can someone help answer these
questions for me:
1. Where are the actual mail files stored?
2. Where is the account login info stored?
3. In Outlook and OE installing on a new computer, even after moving files,
prompted for a full redownload off of the POP server. Anyway to avoid this?
Is ther...Re-enabled user account cannot log in
In trying to troubleshoot and issue in CRM where I had multiple user accounts
for a single ADUC user, I tried disabling and re-enabling a user's account.
But even after re-enabling the account the user cannot log in now. The error
message says that it is disallowed when he tries to browse to the CRM server.
Please help, I need to get this user account working again asap.
...How export all mailbox-enabled users from the GAL using Outlook?
We have a user which, for administrative reasons, needs to export all
mailbox-enabled users in the GAL now and then. They just need all the
names. Is there a straightforward way for them to do that?
We don't want to give them any special permissions and want to avoid
server scripting. Ideally, they should be able to export it to a CSV
file or any text file.
> We have a user which, for administrative reasons, needs to export all
> mailbox-enabled users in the GAL now and then. They just need all the
> names. Is there a straightforward way fo...Perhaps another Money alternative?
After years of their saying "what's Windows?" I not that the following
Announcement: GnuCash 2.1.1 Release - 2007-04-28 17:47
GnuCash 2.1.1 released
The GnuCash development team proudly announces GnuCash 2.1.1 aka
"Bug-begone", the second of several unstable 2.1.x releases of the GnuCash
Open Source Accounting Software which will eventually lead to the stable
version 2.2.0. With this new release series, GnuCash is available on
Microsoft Windows for the first time...
I haven't checked into this further just yet, but that will certainly be...Can't use openURL or access internet on some locations
I have previously raised a question where openUrl threw an exception in
a specific office location. However the problem I have now is that the
application just freeze when I call openURL. It seems as it is waiting
This only happens at one company so far the company does have a proxy
but so do I at work and I have no problems.
I have also tried the Microsoft TEAR sample and it behaves the exact
same way, it says "Opening internet...Connection made" and then it just
stops. If I run it on my computer it gets the webpage and everything
I have tried to set t...How to detect my tray icon covered by another app.?
Could someone tell me how to detect my system tray icon covered by another
application? If the tray icon is covered, I don't want to update the icon.
Thank you very much in advance.
"L. Zhou" <firstname.lastname@example.org> wrote in message
> Could someone tell me how to detect my system tray icon covered by another
> application? If the tray icon is covered, I don't want to update the icon.
> Thank you very much in advance.
Hmm, I doubt that is possible... The only thing I think you can do is to duplicat...