Pass Through to SQL Server Optimization Questions
On an autoexec function several recordsets are opened. Some are
queries to local tables, some are to sql server tables.
I have been trying to optimize performance but I haven't seen much
difference in speed between queries run directly against linked SQL
Server tables vs pass through queries. Here is my code for creating
the pass throughs (I have another function OpenRecordSetLocal that
handles queries to tables within the frontend. The ODBC connection
string resides in the query Q_PassThrough.
Am I missing something key? Is there a better way to do this?
Function OpenRecord...Use Form to prompt for report criteria
I have a form that I am using to prompt for report criteria. When I run the
query outside of the form, it works fine - prompting me for both criteria.
However when I run from the form, I get #Error#. Can you see what I am doing
wrong? Thanks in advance.
I have two combo boxes that I have put in my underlying query. In the
fields of the query are:
[Forms]![frmSelection Criteria Form]![OfficeNumber]
[Forms]![frmSelection Criteria Form]![Manager]
On the OnClick event is the following:
Private Sub Command6_Click()
On Error GoTo Err_command6_Click
Dim stDocName As String
st...MS Office 2008 home version with Pro for entourage
Hello and thanks for any help you can provide.
I have MS Office 2008 Home & Student edition. I want to install only
word, excel and powerpoint and then separately install Entourage 2008
Pro (as provided by my hosted exchange co.) in order to connect to my
exchange server. I have done this before and remember some convoluted
errors but it eventually worked. My latest attempt did not. Has there
been a change to prevent this from working?
I don't know if you guys have ever try to show the total tax sale on the z
report, but when i make the modified on the z report it came out that the
total tax is 0. It didn't show me anything, i don't know if the script is
wrong or the script is not working for RMS V1.3?? Has anyone ever tried
<ROW> "Taxable Sales|" Report.SalesPlusTax </ROW>
...Microsoft CRM server is not responding
Workflow Manager write:
The specified Microsoft CRM server is not responding. This might happen if
it is currently unavailable, it is not a Microsoft CRM server, or you are
not a valid user. Fro more information, contact your system administrator.
How fix it? In IE i can logon to CRM.
I've resolved this problem by restoring the metabase with the original
version in IIS
> Workflow Manager write:
> The specified Microsoft CRM server is not responding. This might happen if
> it is currently un...Purchase history and projected usage
Is anyone aware of an add-on or a way to figure projected usage for
purchasing? I find the minimum quantity function usueful but many times I
have to purchase for a few months and it would be helpful if the system could
help estimate required quantity for a specific period. To be really useful
and accurate RMS should be able to estimate product requirements for a
period, is anyone else running into this?
Funny you should write about this. I was just talking to my RMS partner about
this the other day. He was going to see what he could come up with for this.
I will let you know if i he...Report CRM 3.0
I would need to find out the detailed procedure (step by step) to customize
Could anybody inform about any links or documents concerning this issue?
I'm not sure if it's detailed enough, but the technical training manual has
a section on creating and customizing reports. You can find it here:
Jeffry van de Vuurst
"Marco Rocca" <Marco Rocca@discussions.microsoft.com> wrote in message
news:CEF80683-EC26-456C-82C...MSCRM 3.0 (How does the user access Microsoft CRM from server)
I have installed Microsoft CRM 3.0 on Windows Small Biz Server. I am able
see Sales, Marketing, Services running on the server.
I want to let the respective user to see the UI, how do let them access from
They would enter the URL for the server (http://servername). They may also
need the port (by default http://servername:5555).
MVP - Microsoft CRM
"pat" <firstname.lastname@example.org> wrote in message
I have installed Microsoft CRM 3.0 on Windows Small...Problems Converting Data from Quicken 2001 Deluxe to MS Money
I have a relatively new Compaq Desktop (2.5 GHz Celeron with 512 MB RAM).
I have a Viewsonic Pocket PC and I wanted to use it to track my financial
data so I purchased Money 2003 Standard.
I tried several times to convert my Qucken Data (it's a big file--I've
been using Quicken since 1995). My Quicken program is Quicken 2001
Anyway, the MS Money program started to convert and after a few minutes
"Your Quicken file could not be converted. Money could not convert your
Quicken file. You might have run out of disk space or system memory. Try
closing othe...Dropped connection to POP3 servers
Just installed Office 2003 under XP Home. Outlook is
dropping connection to POP3 servers, I check 2 different
servers with a S/R. Both fail at the same time, never
separately. Sometimes I can exit Outlook gracefully but
a reboot is required to get Outlook to work again.
Sometimes locks entire system and have to powerdown
Pattern not fully determined but it appears to happen
when there is other activity to the internet that is
going to specific servers using an ID and password. I
use Medved Quotetracker with E*Trade quotes (requires
ID). If I bring up Quotetracker, Ou...how to config Server for one user which has 2 mail address.
we have one NT4.0 + Exchange 5.5 Server "A" Email email@example.com ��and
windows2003 + exchange 2003 Server "B" firstname.lastname@example.org user name is same in A
B��Mx record was be set ,question is how to config Exchange 2003 to receive
down the mail to Server A , because of we need to replace A with B.
thanks a lot.
E2K3 setup guides you through common scenarios (like yours) pretty much holding
your hand - on welcome screen tell it that you have existing E55 org and want to
join it, then follow on-screen instructions. Having usable backup of Exchange
databases and AD i...Insert,Update Data in sage (MS Access Linked tables) using Vb.net form
I am developing application using vb.net which requires integration with SAGE
LINE 50 (Accounting software ) V11... The data which SAGE is using is MC
ACCESS 2003 database... with linked tables in it... Now I Have developed the
Sage connection using ODBC which works fine when reading the record but
cannot Add or Update record into the Linked tables.... When i debug the
program the error is at the line where it has...
Can anybody Help ?????
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/acce...How Can I Control When Messages are Downloaded from Server
I have the box "Check for messages every ___ minutes" unchecked
Yet seemingly randomly, messages get downloaded a couple of times a day
without my clicking "Sync." This is problematic due to the way I share the
Is there another setting I need to keep this spontaneous downloading from
"Gripper" <Gripper@discussions.microsoft.com> wrote in message
> I have the box "Check for messages every ___ minutes" unchecked
> (too...Exchange Server 2000 Secuirty Setup problems
I have apply wrong setting to our exchange server 2000 . The wrong setting
as from exchange manager . mail store , I have apply everyone send as and
receive as access right, the group included remote access via offline sync.
This setting once apply , all user access other mailbox without apply access
right. I have try disable this setting, after all local office user no
problems, but a remote offline sync laptop user does not work . The error as
below: Unable to display the folder. Microsoft Outlook could not access the
specified folder location. The file C:\exchange\shawnb.ost cannot b...CRM 4.0 Custom Report Filter Problem
I am using the Report Wizard to create a simple report.
Report is using Quotes and Quote Products
I have a custom field in Quote Products which is a bit field Yes-No
When I use that field as a filter for report output, I get all records. The
filter criteria appears to be ignored
Is this an inherent problem with Report Wizard or Am I doing something
depends on your business logic and what you want to see.
If you have three quotes:
Quote-1 has three products, all with the custom field set to Yes
Q2 has three products, two set to Yes, 1 to No
Q3 has three products, all set...stock variance report
Is there any way to edit that stock variance report at HQ? There are no $$
values and this is quite important at HQ.
How do others work with this?
Create a custom report using the Quantity Discrepancy List as a template,
add the SnapShotCost, SnapShotLastCost and/or SnapShotReplacementCost column
from the ItemDynamic table times the qty difference.
"Ivan Brebner" <email@example.com> wrote in message
Is there any way to edit that stock variance report at HQ? There are no ...How to set dependencies on project
I have created a separate build on an existing project and copied settings
from the existing project (Build->Configurations->Add). When I build the new
project, it does not pickup any of the dependencies from sub-projects (ie I
get link errors for all of them). Can someone tell me where to set these for
the new project? The Project->Dependencies dialog list all dependencies for
the project and are checked.
> Hello all,
> I have created a separate build on an existing project and copied settings
> from the existing project (Build->Con...MS Excel Print setup
When i save a document by using landscape setting,& by
opening again that document it does'nt show saved setting.
It shows portrait option,not landscpe option.
...DPM and VMM on same server using side-by-side SQL installation
Windows 2008 Std R2 Server, 64bit
VMM 2007 is currently installed (with the built-in default database) SQL
2005 Express Edition, SP3, 32bit.
I was advised by Microsoft that both VMM and DPM could be installed on the
same server (small DR environment)
The VMs are hosted on a Windows 2008 Enterprise Server w/ VS2005R2 - because
the hardware didn't support HyperV.
VMM works great to manage the Windows 2008 VS2005R2 Host running Win2K3
server instances ... after lots of trial and error.
Now, I need to install DPM 2007 onto the same server... DPM wants to install
the 64bit vers...Report Filter focus
I am experiencing an issue with the report filters in RMS. It is not a
show stopper, but annoying.
When I launch a report in SO Manager on a win XP machine, RMS version
1.3, the report filter is there, but the correct field is not selected
and the filter under Filters is not selected. When this happens and I
want to change the filter, I first need to click on the Filter itself
in the bottom box and then select the correct field out of the Fields
list, then change the Value. Is there anything I can do to fix this?
To use a real report as an example, When I run the Detailed Sales
How can I change the time that it takes for message to
shift from BOLD (unread) to PLAIN TEXT (as read) in my
inbox. If I open MS OUTLOOK it will change within 30
seconds to PLAIN TEXT from BOLD appearing as read, even
if I don't want to read them at that time. Therefore,
later, I don't know if I read that one or not. I have
seen the time limit change on the setup somewhere, but
can't find it now!
Outlook does not have this option to mark an email as read when viewing in
the Preview pane.
Only Outlook Express does.
"Joe Dobbins" <joe...MS Access 2007, Forms
When using the "Forms Wizard", I need to use the "Style: Ricepaper", but it
isn't available in the 2007 version and I have not been successful trying to
find it in Office Online or on the web.
Does anyone know where I can get it?
Access 2007 has 25 AutoFormats, but as you noticed, they are virtually all new ones. It's actually
nice to see that these were updated.
To get the older Ricepaper style you could probably create a form in an earlier version of Access
and then import it into your current database. If you're using the ACCDB file format, you would...Outlook 2000 client Connection TimeOut w/ Ex5.5 server???
Hi, we have a really intriguing issue that started recently.
Outlook users, when clicking on an item in the Mailbox, will get the message
"Can't open this item. The operation could not be completed because of an
error on the network. Try to log on to the network again, and then repeat
The user will click OK, and usually will be able to open the same item in
one or two attempts.
The Envrionment: Ex5.5 SP4, Outlook 2000.
It is ONLY the Windows98 users that is seeing this message, on NT and W2k
stations, there's this occassional hour-glass when we click on an ...Exchange Server C Drive No free space
Need some advise.
The Exchange Server during certain times C Drive will not have free space. I
have check that during that period there is a temp file which will increase
in size and takes up all the disk space in C. The file will not have any
extension (the file name ex. T232C or R408).
When this happened, the Exchange MTA service will stop, users will not able
to send email.
I have rum Spyware scan, Virus Scan, Online Virus scan, all seems to be
Anyone experience this before?
Thanks in Advance for the help.
On Wed, 26 Jul 2006...Outlook reports OLE registration error
I have Office 2000 running in Windows Me on a Dell
Dimension XPS D266 with 64 meg ram. Outlook stopped
working so I ran Repair from Office 2000 CD and then Re-
install Office from same source. Both times Outlook says"
An OLE registration error occured. Program is not
correctly installed. Run Setup again."
Doesn't seem to be much sense in running it again. What
Reinstall Outlook Express.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal