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...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...auto sort?
Is there any way to make a dated entry insert itself in the worksheet in the
correct order without doing a sort operation, or inserting a new row?
would be a big help for my reservations workbook
You could try the worksheet change event:
Private Sub Worksheet_Change(ByVal Target As Range)
This should re-sort your selection everytime the worksheet changes.
Hope this helps
"Dave" <firstname.lastname@example.org> wrote in message
> Is there any way to make a dated entry insert ...I cannot get the pictures to show on screen in Publisher web previ
I have tried embedding and linked but nothing seems to work. Do I have to
apply a master page? It is to be a one page web site. This is probably so
basic but I am trying to teach myself how to use it. What do I have to do to
have them show in preview and once uploaded?
Are you using FireFox to preview or IE?
"rendul" <email@example.com> wrote in message
>I have tried embedding and linked but nothing seems to work. Do I have to
> apply a master page? It is to be a one ...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...Auto-Forward of Meeting Responses
We are running Exchange 2000 / Outlook 2003. After staff realignment, we
have an assistant who no longer reports to a manager. The manager has
removed the assistant from her calendar shared list. Now when the manager
sends a meeting request to various attendees, the assistant is not notified
in any way. However when anyone invited to the meeting responds with an
acceptance or rejection to attend the meeting, the assistant receives a copy
of that response. I've looked in the manager's and assistant's rules and
alerts and calendar settings, however I cannot find any setting ...Excel Opens Without Displaying Workbook
I am having issues with opening an Excel file. The file opens, but the workbook is not displayed. I tried the resolution in the article XL97: Excel Opens Without Displaying Workbook (http://support.microsoft.com/default.aspx?scid=kb;en-us;158996&Product=xlw97), but neither of the resolutions fixed the problem. Any suggestions??
Are you using Excel 97?
Fort Collins, CO
>I am having issues with opening an Excel file. The file
opens, but the workbook is not displayed. I tried the
resolution in the article XL97: Excel Opens Without
Di...Display of UML State Transition Event
I am attempting to use the UML Statechart with a couple of
states and a transition between them. I select properties,
Events, Change Event type, say, and can see ChangeEvent1
in the property window but...
....when I Ok back to the drawing the ChangeEvent1 is not
displayed by the transition.
I can enter actions in a similar way and they are
How cna I get the event visible too in the drawing? Surely
this is the most important aspect of a transition i.e.
what caused it,
...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...Getting the BCC field by default.
I would like the BCC field to show by default but cannot find the setting
for this in 2007. Anyone know where this is located?
In a new message window, use the Options chunk to display the "Show BCC."
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, JC HARRIS asked:
| I would like the BCC field to show by default but cannot find the
| setting for this in 2007. Anyone know where this is located?
Thanks Milly. I had...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....Getting rid of selection
How can I get rid of the selection rectangle? It seems that it's always
there, with a heavy black rectangle, or there's a light black rectangle
marking where it was.
I'm trying to get rid of it altogether, so I can capture an image of the
sheet for use in a webpage.
I can achieve the effect that I want by selecting a cell which is
outside the area that I'm trying to capture, but now that I've found
that I cannot get rid of it entirely, it is driving me nuts trying to do so.
You could al...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...Workplace Queues
We just rolled out CRM a few weeks ago. I'm getting a lot of complaints from
the users about the thousands of items showing up in their My Work\Queues\In
Progress folder. When I look at my own items, I have about 1000 activities
showing in my In Progress folder but when I open them up most of them are
owned by someone else. According to the Help description of this folder,
only items that I have accepted should show up in my In Progress folder.
I've never accepted anything, so I'm not sure anything whatsoever would be
showing up in this folder. We used Scribe to import ...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,...CRM Email Displays Size=2>
One of my users is experiencing an issue when they save an email that is
tracked within CRM the email displays in CRM with "Size=2>" directly in front
of certain lines of the email. So for example "Size=2>" will appear in front
of someone's comments in the email or in front of their name. Does anyone
know why "Size=2>" is displaying in front of the lines of an email? Thanks.
"Mike H." wrote:
> One of my users is experiencing an issue when they save an email that is
> tracked within CRM the email displays in CRM wit...Problem displaying expected results with CString
I am writing a MFC program to import data from a single table database into
a normalized database with numerous tables. The first component opens a
recordset object to the database and performs some basic tests on the field
value, and the plan is to write the records out to a spreadsheet that fail
to meet any of the criteria defined for the field. Along with writing out
the record, I want to populate a comments field describing what failed. I
have tried to implement this with a CString variable; I initialize it to a
blank string each time a new record is examined, and then as each field is
che...Get info from Fidelity
I use money's portfolio manager to retrieve info from my
Fidelity accounts. However, it only retrieve stock and
bond informations. It did not retrieve the money market
fund information. How can I make it download money market
In microsoft.public.money, Peter Tso wrote:
>I use money's portfolio manager to retrieve info from my
>Fidelity accounts. However, it only retrieve stock and
>bond informations. It did not retrieve the money market
>fund information. How can I make it download money market
Fidelity does things a differently th...Auto calc YTD Numbers
Cells A1:L1 equal "Jan" thru "Dec". M1 equals "YTD". Cells A2:L2 equal numeric values.
If you haven't guessed it already, I would like M2 to sum all the values A2:L2 for those months previous and including the current month (but not future months). What is the best way for going about this
Here are 2 ways
hopefully your computer's clock is accurate
For everyone's benefit keep the discussion in the newsgroup.
Peo Sjo...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...Get Xml from web .
This is a link to an address where I would like to access xml.
The XXXX is the email address of a user. All I want to do is access the xml
and view it in a datagrid. I have read several tuturials and articles and
have not been able to find something that would explain how to do this. Does
anyone know of a sample code or something close I could use as a reference.
I am using visualstudio.net. and visual basic. THX
Take a look at using the following classes on your app:
DataSe...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...display in taskbar in excel 2000
Have a problem!
I work with Office 2000 and excel does not open more than onw screen
in the taskbar.
Windows in Taskbar, I checked in Excel.
Clustered display is turned off in the properties of the
Can anyone help me with this problem prog, get it only if I
2x open excel.
I can't figure out what exactly what is happening in your excel but
try this, Go to TOOLS (Menu Bar) then OPTIONS, in VIEW tab just CHECK
the Windows in Taskbar.
Hope this will help.