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...Font Sizing
I am visually impaired.
I would like to increase font size in the IN-box window
where the From: Subject: and Received: columns are
I have been able to increase font size to read the body of
the e-mail and can compose e-mail with larger font - just
would like to increase font size for the incoming message
Please write to me at: firstname.lastname@example.org if you can
thank you in advance.
Depending on your version of Outlook, View->Current View->Customize Current
View->Other Settings. You can customize the Fonts from there.
Milly Staples [MVP...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...Word2007. Checkbox. No Form
We have a document (not a form) that we would like to use checkboxes in.
This document has a couple of sections where it would be useful if the user
could check if something is applicable. We can't protect the whole document.
Thank you for your help!
I actually used this feature in a form this morning. Although you don't say
what version of Word you are using, you can access the Control Toolbox
toolbar in Word 2003, or in Word 2007, it is on Developer tab.
To show the developer tab, click the Microsoft Office Button and then click
Word Options. S...Changing font in Money 2004 register?
Is there any way to change the font(s) used in MS Money
2004's registers? The default font is too small and
difficult for me to read. Also, is there any way to
change the color scheme to something more pleasing to my
eye (like you can do in Quicken...)
Nope and Nope. See http://umpmfaq.info/faqdb.php?q=136.
"Debbie R." <email@example.com> wrote in message
> Is there any way to change the font(s) used in MS Money
> 2004's registers? The default font is too small and
> difficult for me to read....Global Column Row Preview Font Size
I know I can change the column, row and preview font size for the current
email folder's view, but how do I do it for all of the email folders? I have
loads of email addresses each with lots of folders. I don't want to have to
do each one at a time. Surely there must be a default font setting (even if
it's only in the registry)?
Thanks in advance,
I too would love an answer to this.
"Timie Milie" <firstname.lastname@example.org> wrote in message
>I know I can change the column, row and preview font ...Outlook 2007 Search always returns no matches
Any search I do in Outlook 2007's new search box returns no matches.
I watched the Indexing Status as it progressed, and now it says "Outlook has
finished indexing all of your items"
But, searching on anything, even the word "The" or "a" returns no results.
I'm searching all Outlook items. I'm on an Exchange Server via VPN.
Anyone have any suggestions?
I uninstalled Office and re-installed and the problem went away...
"Tom" <email@example.com> wrote in message
> Any search I do i...Publisher 2007 frequently crashes
I'm having some difficulty with Publisher 2007. Whenever I try to open a
particular file, the program crashes. I get no error message, except that
Publisher needs to close. I've run Office Diagnostics (twice), with no
results. I can open other Publisher files. The file that I am trying to open
is an internal website for the company I work for. This file began acting
strangely a couple of weeks ago - it wouldn't insert a duplicate page for a
while, but I found a workaround, so I didn't worry about it. However, now I
think that it may be a part of a larger probl...Add PowerPoint 2007 to Office Basic
I have Office Basic installed on my laptop and need to add PowerPoint. What
is the most recommended, easiest and least expensive way to do this?
...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...I would like to know how to set up a 'fill in the blanks' form?
I would like to set up a templet of sorts to fill in the blanks for
...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....Creating Text Box in Publisher 2007 Crashes the Application
Hello, we have a clean install of Publisher 2007 under Windows XP SP2, and
when we try to create a text box in a document, (both an existing document
and a blank document), publisher crashes. Office is fully patched.
I ran Office Diagnostics from the help menu and no problems were found and
the issue persists. Any thoughts on how to resolve the issue?
See if selecting a different printer as default helps.
How to view error signatures if an Office program experiences a serious error
Mary Sauer MSFT MVP
http://of...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...Macro to change default setting on startup
I am in need of a macro that can change a default setting in excel and for it
to run on startup
The task is:
uncheck Update links on save
Below is the recording of the macro:
..RelyOnCSS = True
..OrganizeInFolder = True
..UseLongFileNames = True
..DownloadComponents = False
..RelyOnVML = False
..AllowPNG = False
..ScreenSize = msoScreenSize800x600
..PixelsPerInch = 96
..Encoding = msoEncodingWestern
..SaveHiddenData = True
..LoadPictures = True
....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,...Fonts in Outlook
I have a friend who is having problems with Microsoft Office
Outlook 11 emails. I do not have Outlook and have never used it. This
is what he says about fonts:
My msgs go out as Arial 10 pt which I have always used. Trouble is
when I type msgs, that's what it says on the font bar, but the sent
ones look more like 8. used to be that ones I typed looked like ones
I sent and not bigger as they do now. Is there any way to get back to
Do not know why but my Agent changes font when I paste his message.
The actual font looks like 8 or lower.
I think his problem is...Picture control on a form
What is the best way to fill a form with a picture control so that when the
client window is resized the picture control will fill the form?
Take a look at this and see if this is what you want:
"Al" <Al@discussions.microsoft.com> wrote in message
> What is the best way to fill a form with a picture control so that when
> client window is resized the picture control will fill the form?
> Just Al
&...Null value in form not trapped by beforeupdate event
I have a form in Access 2003 linked to a SQL Server 2005 table. When
I clear the value in a textbox (bound field is varchar and is
required), I want the before update event to run to tell the user the
value cannot be null.
When I press the tab button to move to the next field after clearing
the texbox, the before update event is not triggering and instead I'm
getting the following error:
You tried to assign the Null value to a variable that is not a Variant
data type. (Error 3162)
How can I prevent nulls before and this error from triggering?
...MS Project 2007 question
I am developing a simple schedule with no resources but 2 tasks out of 100
are hazardous and I would like to make the schedule so that when these tasks
occur, no other tasks can occur. In other words, even though all tasks are
moving around as the schedule is being developed, I would like to make sure
no other tasks can be scheduled wherever these 2 hazardous tasks fall. These
2 tasks are serial to every other task in the schedule. Is there a way to do
Thanks for your help.
Create two milestones. Use milestone 1 as the successor task to all tasks