Calling Dex Procedures from SQL
Is there any way to call dex procs from SQL or VB code?
There is an undocumented and unsupported method of calling Dex code from
VBA. However, I know of no method of calling Dexterity from SQL.
Please email me if you want an example, just remove the online. from the
David Musgrave [MSFT]
Senior Development Consultant
MBS Services - Asia Pacific
Microsoft Business Solutions
Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This p...is SQL 2000 architecture different SQL Server 2005 / 2008 architecture?
Hi I have a book "inside SQL Server 2000" by Kalen Delaney, which I
have been told is a good book. I am going backwards... reading about
the sql server architecture in chapter 3 of the book.
As I'm reading... I was wondering is it different SQL Server 2000 vs
SQL Server 2005/2008? Also
where can I find a book/or link that can give me more details about
the internals on architecture?
norm (firstname.lastname@example.org) writes:
> Hi I have a book "inside SQL Server 2000" by Kalen Delaney, which I
> have been told is a good book. I am g...How do you tab multiple lines to the right
I try to tab name and address to the right 2 or 3 tabs over but my document
only tabs the first line. I have to tab one line at a time. Help!
If you are expecting the tab key to indent the paragraph, then you have to
have the relevant option enabled. This option is located in different places
in Word 97-2000, 2002-2003, and 2007-2010, so we need to know what version
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"fionabeau" <email@example.com> wrote in message
news:E5CD...Help with database
I need to create a database that lists companies, with dates items done by,
money paid, notes etc. Thats okay, but I need to retain the previous years
records and start a new year off fresh. How would I do that?
It sounds like you have never created a database so I'm going to suggest you
Jeff Conrad's resources page...
The Access Web resources page...
A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu...Moving customizations from SQL 2k to SQL 2k5 CRM
This may be a non-issue but I wanted to check to see if anyone has done this
and ran into issues.
I have the XML customization files from our previous install of CRM 3.0 with
SQL 2k database. I now want to import and publish these same customizations
to CRM 3.0 on SQL 2k5.
Has anyone done this or can point me to documentation that tells about the
success or issues for doing this?
On 7 Feb., 06:35, Chris Treanor
> This may be a non-issue but I wanted to check to see if anyone has done this
> and ran into issues.
&...Connection problems on SSAS for some projects
I am running on VS 2005 and Sql Server 2005 and trying to deploy my project
to Analysis Server and I get the following message:
A connection cannot be made. Ensure that the server is running.
No connection could be made because the target machine actively refused
I created 2 project virtually identical. The only difference was that I
created a new connection for the first project and then pointed at the
existing connection for the 2nd project.
The connection showing for both projects when I right-click the Adventure
WorksDW...Uppercase notation in access 2007
I have a table tblPupils in access 2007.
In this table there is a column called "town". All the towns are in
Now, how can I change all town names to uppercase at once? The property
I don't know.
Can anybody help me out?
Thanks in advance.
Use an Update query:
SET town = UCase([town])
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"SDS2" <nomailtoSDS@collegewaregemdeletethis.com> wrote in message
news:%239f2MLH8KHA.1760@...how to repeat print single tile of multiple tile poster?
in publisher one tile of multiple tile poster failed to print (ran out of
ink). how do I print only the tile that missing? Other than complete (20
sheet) print run.
There is no easy way of doing this. Take a look at print preview to determine
what tile you need to print. Create rectangles around the areas you don't want
to print, fill with white, no line. Keep checking print preview to be sure you
are covering the correct tiles. You will end up printing 20 pages, but only one
will use ink.
"billyb." <billyb.@discus...XML as general-purpose database?
Hi! I'm coming from building desktop applications using Borland Delphi
(Win32) with embedded databases (compiled into the executable). While I find
this a very powerfull combo, I'm looking into how I would want to make those
kind of applications using C#. As I can't offer potential customers any
direct support (it's just a sidekick), I don't want to have them dealing
with real database-servers like MSDE.
Now, let's say that the number of tables will be between 5 - 25, and the
largest tables will hold no more than 10 000 records. The data should be
held in a dataSet, so...Send message from any client
Hi, I'm looking for a MAPI VB/VBA code example that can send a message with
an attachment to many recipients.
I have VBA code that works with Outlook but fails with Outlook Express.
...CRM 3.0 Install Error with SQL Reporting Services and SQL 2005
Doing a CRM 3.0 Server installation. During the last page of the install
wizard (or what I assume is the last page) when I goes through and does
verification I get a red X next to SQL Reporting Services. The message I
receive when I look at the details is:
The specified path is not a metabase path.
Parameter name: path
Now SRS is installed and working. I put in the URL:
http://<servername>/reportserver and every other variation on that I can
also assuming you did not use ssl...
=======================...SQL 'for xml' and C# example??
I'm missing some piece of the puzzle. I'm using 'for xml' type queries from
SQL2K - and now trying to change the front-end from ADO to C#, I can't quite
figure it out..
It seems that I could use an XmlReader.. and somehow use that instead of a
DataReader.. but that didn't work.. I tried using a DataReader and get the
byte array - but that wasn't right.
SQL returns formatted XML, I need to load that XML into an XmlDocument
somehow without ANY molestation of that dom. Any ideas? Examples? Missing
THANKS!! I've been looking for the answer to ...Eror connecting Reports MAnager
Hi all, i have been trying to install CRM 3.0 on a SBS installation with
SQL 2000 installed and Sharepoint Services , and have the following problem:
when I verify the report server the message is :
servername/ReportServer - /
Microsoft SQL Server Reporting Services Versión 8.00.1038.00
but when attempt to go to the reports administrator can't connect :
ERROR The connection has been finished: It is not possible to connect with
the remote server.
...sql summarizing help
id, cdate, weeksago, amount, typeid, timeclose
496, 2010-02-11, 0, 450, 3, 1
490, 2010-02-01, 1, 200, 4, 1
491, 2010-02-01, 1, 350, 2, 2
493, 2010-02-01, 1, 500, 5, 1
489, 2010-01-21, 3, 150, 2, 1
136, 2010-01-12, 4, 500, 3, 2
137, 2010-01-12, 4, 100, 3, 1
138, 2010-01-12, 4, 500, 2, 1
1. i'm trying to create a sql that will give me a summary resultset grouped
2. i want to sum the columns and get counts based on typeid.
3. avg of timeclose
here's the sql i have:
, (sum(timeClose)/(count(timeclo...Password protecting multiple profiles in Outlook 2003
We are using Outlook 2003 with some machines supporting multiple users.
To accomodate them, we have set up two Outlook profiles under a single
Windows XP account. As we have an Exchange environment, I have set the
checkbox in the profile options to 'Always prompt for user name and
password' and also for Outlook to prompt for profile selection each
The problem is that Outlook 2003 doesn't actually prompt for the
username and password EVERY time it opens. If the user who opens
Outlook first is the user whose account the machine is logged into
Windows with, Outlook seems to ...Restore database from backup
I made a backup of my database and had to open it to recover changes that had
been lost. How do I restore my backup to my original database? The Save &
Save As commands only seem to save database objects to my open database.
only SQL Server supports true backup / restore functionality
with Access, you've got to HOPE that someone didn't have the db open
when you back it up
On Apr 7, 11:26=A0am, Roland @ Zuca <Roland @
> I made a backup of my database and had to open it to recover changes that=
> been lo...Print selected worksheets in multiple workbooks?
We would like to print two specific worksheets that exist in multiple
workbooks at the same time. In other words, we would like to be able to
select all workbook files in a directory and send to the printer to have the
same two pages from each workbook print, not the entire workbook. We would
like to avoid having to select each file individually to send two sheets to
the printer, and then close and go on to the next file. Is this possible, and
if so, how do we accomplish this? Thanks for any direction you can provide.
I wasn't sure what all you needed, so the code below will ...Update multivalue field in table from form with SQL
Access 2007 on Vista
I am using a form to establish the variables for a report before it is
created. One field on the underlying table is a multivalue field, and the
form includes a multi-select combo box control. After selections are made and
the OK button on the multi-select combo drop down is clicked, focus moves to
the next control. I have discovered though, that the underlying table does
not update immediately, but does so correctly when I close the form. This
sequence does not deliver the proper report data, so I need a way to
immediately update the underlying table (m...Jet database engine cannot find the input table or query
I can't create form from table or query. Also I can't import .xls file into
I downloaded Jet 4.0 SP8 or later and tried to install it But there is msg
already installed it
What's problem there Please help me
On Mon, 31 Dec 2007 05:57:02 -0800, Mubat <Mubat@discussions.microsoft.com>
>I can't create form from table or query. Also I can't import .xls file into
>I downloaded Jet 4.0 SP8 or later and tried to install it But there is msg
>already installed it
>What's problem there Please help me
Are you using full Access?...limit on new database query?
I am trying to create an olap cube to export to another product, however
when I use the new database query to bring the data into excel (from another
excel table) I only get 1440 rows. Is there any reason or way to change
...Refer to SQL statements globally
I have two large SQL statements that I need to use across several
forms, reports, etc.
Rather than repeat them in each form, I'm trying to store and
reference them globally.
For example, I'd like to store strSQL1 and strSQL2 in a global module,
so I can use either like this in a form:
Me!lstResults.RowSource = strSQL1
Me.Report.RecordSource = strSQL2
Would I just store the SQL statements in a global module like:
Public Function SQLSource() As String
Dim strSQL1 As String
Dim strSQL2 As String
strSQL1 = "SELECT blah blah...Event Management Database Template
I'm changing a few things on this template to make it suit the event
management we need. I have removed references to "SalesTaxRate" from the
following tables: Attendees, Registration and Company Information; I have
also removed references to same from the respective forms as well. I have
attempted to find all calculations that refer to this item and adjust them.
However, when you open the "Attendees" form, it first brings up a Request
Parameter Value box for "Registration.SalesTaxRate". Any idea where I might
have missed something?
Thanks fo...some suggestions regarding the outlook client
I would like to see some improvements to the Outlook client.
1) When using the outlook client and navigating to a contact I would like
the ‘email’ button to launch an Outlook email rather than a web client email.
If you are using the outlook client it is natural to assume you would not
want to use the browser email tool to send an email
2) When viewing email in Outlook I would like the CRM toolbar to contain the
view regarding button as well as the track in CRM button – currently you have
to open the email to find this button which means to get to the related items
you have to open thr...To SQL or not to SQL?
I have a very vertical product developed 100% in M/S Access. I developed it
myself in 1993 in the initial release of Access and been with it ever since.
It is currently very stable and running in Access 2003. My big question is
how or even *if* we should move it to SQL. My customers are getting bigger
all the time with more users. Typically our customers run one or two
workstations generally never more than 5. Performance, however, is starting
to slow with database sizes passing 500 meg. We also have a LOT of code
behind forms so are bound tightly to the Access development environ...PostgreSQL or other SQL servers in RMS
Has anyone successfully implemented RMS with one of the free SQL servers?
Theoretically, is there any reason why we have to use MS SQL Server 2000 for
"dh" <firstname.lastname@example.org> ha scritto nel messaggio
> Has anyone successfully implemented RMS with one of the free SQL servers?
> Theoretically, is there any reason why we have to use MS SQL Server 2000
> large databases?
RMS has implemented only for MS SQL Server (2000/MSDE) and isn't possible to
work with ano...