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...visual basic
I trying to retrieve values from a table to calculate the 14days average
value of a stock closing price. However, i encounter some problem as stated
beside the code as follows:
'Calculate the average value of a given value.
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim varBookmark As Variant
Dim numAve, numDaysAvg As Double
Dim intA, intB, lngCount As Integer
Set db = CurrentDb
Set rst = db.OpenRecordset("SGX Individual Historical", dbOpenTable)
Do While Not rst.EOF
intA = 1
intB = 0
varBookmark = rst.Bookmark
n...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...Web query timeout setting.
I fill an Excel table using data that I take from an Internet
Unfortunately, this site is very slow and so I often get a "query did not
provide any data" error message.
How can I increment the default web query timeout limit?
Thanks in advance,
...Windows Server 2008 R2 04-09-10
Windows Server 2008 R2 and Windows 7 share the same code? how is that
possible when Windows 7 has both 32 bit and 64 bit versions and windows
server 2008 r2 is only 64 bit
As Microsoft is going to use only 64bit versions for servers they don't built
the 32bit version. Sharing the same code doesn't mean that the server OS
use exaclty the same files, there are a lot more and different ones. But
the basic code is the same.
Disclaimer: This posting is provided "AS IS" with no warranties, and confers
...Invoice Numbers 10-27-07
We produce reports that are invoices.. The reports are really a group of
compined reports if this matters... When we print the reports I would like to
have printed consecutive invoice numbers. If possible I would like to have
the number apprear as AS-00001, AS-00002 ect.. I am not really interested in
storing the invoice numbers I just need them on the printed invoice as it is
made of of groups of various data that is stored...
Thank In Advance for you help.
If you just want a consequetive numbering on the report, all with an AS-
Numbering Entries in a Report o...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...GP 10 AP Reconciliation Statement
I have one query about the reconcile feature that is available in GP
10 to reconcile the AP and AR to GL.
It has come to my notice when i take a recon statement for AP it does
not match with the AP historical aged trail balance after taking into
consideration the unmatched and potentially matched transactions.
I have taken the AP smartlist for the given period and compared it
with the transaction being displayed in the recon statement. What has
come to my notice is the recon statement is not taking few transaction
like invoice or payment for some reason. I faced this issue with
almo...VBA to put a copy of worksheet on the desktop 05-13-10
In my workbook XYZ I have a sheet ABC. With a button on sheet DEF I can
refresh sheet ABC. When the code finishes it job I want to add the actual
date (short European notation dmyy) and time (f.i. 241110 16.31) to the name
of the sheet (which becomes ABC 241110 16.31) and after that make a copy of
that sheet in a separate workbook and put that workbook as an icon on the
desktop of my computer. Is this possible? If so, please help me with the
necessary code. Thanks in advance for your assistance.
...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...Date Calculation
I have a DB which tracks training of employees. The grace periods allowed
with the training is that new training can be completed within 90 days of the
expiry date without changing the anniversary date (e.g. the training is due
on 1 April 2010, the employee conducts the training on 2 January 2010 but
gets to keep the 1 April anniversary date).
The table I am working with is mainly based on the date of training and the
training type (which determines whether the training expires on the 1st of
the 13th, 25th or 37th months or if it keeps the same date); what I w...Calculating totals
I have two columns on a worksheet: "Project Codes" and "Totals." I would
like to have columns on another worksheet that will automatically total up
the different project numbers "A,B,C,etc." How do I do that?
Thanks in advance for your help,
Enter a *unique* list of your "Project Codes", starting in A2 of Sheet2.
In B2, enter this formula:
And copy down as needed.
Please keep all correspondence within the G...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,...total group & max function
I am using Access 2003
I created a Db for Machine Mtce. The table consists of 3 tables, (1) Basic
Mach Infor (ie Mach#, Mach Name, Mfg etc) - (2) Operations Table - consists
of different prev mtce (PM) that need to be completed at various time frames.
Ex: "Mach 100" could have 3 different operations; Oper # 100A to change the
oil due every 90 days, Oper # 100B to check the belts due every 180 days,
Oper # 100C to grease the machine due every 365 days.
The 3rd table is the "PM History" table which includes the history of all of
the PM's completed with Work Order...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...SQL query / Formula for Reorder Point?
Is it possible to issue an SQL command(s) that would:
1. Set the Restock Level for all items to be equal to the current on-hand
quantity for each item.
2. Set the Reorder point for all items to be equal to 1/3 of that items
I'm currently doing this manually, or using a formula in excel when items
are initially imported into the DB, but there are still several thousand that
need to be retro-fitted like this...
Thanx in advance!
UPDATE Item SET RestockLevel=(Quantity - QuantityCommitted)
UPDATE Item SET ReorderPoint=ROUND(RestockLevel/3,0)
Ne...Calculating Subsets of Data
I have data for records that can span between 1 to 16 months.. I want to be
able to calculate the average activity for the most recent six months in a
query and be able to display that in a report.
I can create the calculation in the query for the entire duration of months
for each record but am stuck on how to have it choose only the most recent
six months of data to do the calculation and understand that the six months
may really only be between 1 to 6 months of data..
Any suggestions would be greatly appreciated..My skill level is somewhere
between meatball surgeon and ki...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...#error in the calculated field
I locked the data entered for some users, because their role is just to
input the date of invoice for approval by Prj.Manager.
My qeustion is, is it the reason we see the "# error" in the VAT checking
field??. I tried to ck formula in the qrid query, nothing wrong
Thanks for your explanation
H. Frank Situmorang
On Tue, 15 Jan 2008 23:33:01 -0800, Frank Situmorang <email@example.com>
>I locked the data entered for some users, because their role is just to
>input the date of invoice for approval by Prj.Manager.
I was trying to troubleshoot a problem and checking to see if services in
SharePoint Central Admin were running. I must have accidently clicked when
rolling over the start and stop as I got kicked out of Central Admin and
can't get back in. How does one restart if stopped or regain access???
Services generally allow you to stop and restart.
Where do I go to restore access. Everything seems to be running ok, but it
wont let me access Central Admin in the server. Anybody know how to restore
Hi Rick. Fear not, thankfully, there is a stsadm command to help start the
I created a datbase for an archery tournament. Is there a way to easily
delete last years scores so I can start clean again this year without
deleting each score individually.
If you designed it properly to begin with you wouldn't need to delete
anything and could just move forward. But, barring that, you can just open
the tables and click the top left square where the columns and rows meet,
which should select all of the records and then hit your delete key
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com