String search on two tables
I have two tables where I want find the best match according to the
description on both tables. The result will be the corresponding code in the
102 single family
103 mobile home
104 vacant land
1002 Single Family Residence
When both tables are matched, the macro should look for the best fit in
table 2 and returns the code. ...How do I print without borders when creating a brochure
When I creat a brochure in Publisher there is a border around it. How do I
eliminate it so that the pictures print to the edge?
> When I creat a brochure in Publisher there is a border around it. How
> do I eliminate it so that the pictures print to the edge?
Do you have a printer that can print to the edge?
The following article may be worth a look:
"How to find the maximum print area of your printer"
John Inzer MS-MVP
Digital Media Experience
...Chinese characters in English subject
I have a user who sends internet e-mail in English and sometimes her subject
line changes to Chinese characters. When I check the Options I get the
I had her foward me the message from her Sent Mail and again checked the
options and get the following:
Subj...Howto create textbox like in powerpoint
Could someone tell me how to create powerpoint type textboxes? Are
they windowless rich edit controls?
They are rich edit control, but they have a window, they are owned by the
window that they are being displayed on.
"sachinkundu" <email@example.com> wrote in message
> Could someone tell me how to create powerpoint type textboxes? Are
> they windowless rich edit controls?
> They are rich edit control, but they have a wind...parsing query strings in XSL?
I'm using XSLT to transoform XML into navigation.
My XML has a field for the URL, and a field for a variable that sets the
'active node' in the menu when it displays. The catch is that I now repeat
data on some nodes:
So, if we change one, we need to remember to change the other.
I'd like to streamline this and append the linkID to the URL when I write it
out/transform it in XSL:
This will work just fine provided I DON...MessageBox without buttons
How do I put up a "MessageBox" like message to inform the user that I am
looking for data and than close it when I return without any actions on the
part of the user?
Thanks in advance, this is a great group!
x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 90,000 other groups
x-- Access to over 1 Terabyte per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD
You will need to have a separate worker thread in order to achieve
this. UI thread will show the dialog and worker thread will do the
There are alternate approaches. Ta...What's wrong with this code? Serialization
Dim strSQL As String = "SELECT lastname, firstname, title, hiredate " & _
"FROM Employees "
If Len(lastname) > 0 Then
strSQL += "WHERE lastname = '" & lastname & "' "
strSQL += "FOR XML AUTO"
Dim objConn As SqlConnection = New SqlConnection("Data
Dim objCmd As SqlCommand = New SqlCommand(strSQL, objConn)
Dim serializer As XmlSerializer
Dim reader As XmlTextReader
reader = objCmd.ExecuteXmlReader
Dim emp As New ...Smtp Authentication
I'm an IBM Domino administrator.But i have to fix an exchange 2003
server in these days.The problem is; the exchange server was full of
spam yesterday because of open relay, i deleted all the spam.Now i want
to make an smtp authentication setting on the exchange server.
the schema is as that:
1 MS 2003 server (domain controller) with exchange 2003 installed (all
fixpacks are included) (192.168.0.1).15 clients (winXP+Outlook
network adress is 192.168.0.0/24
all the computers access to internet by a dsl router (192.168.0.254),
using 192.168.0.1 as DNS server...Setting up e-mail without Exchange Server
Need some help here....
I want everytime a lead or an oppurtunity is created, an e-mail to be sent
to a user...
The problem is that i am not using an exchange e-mail server but an the
e-mail server of my isp...
I have created a rule in the Process Manager but where should i state the
e-mail's server address?
My best Regards
You will be using SMTP to send mails out from the CRM server. You can
configure the SMTP settings during the installation of the server. If you
have already installed the server and want to specify the SMTP settings now,
refer to http://sup...Serializing object to XmlDocument (or string)
I am on .NET 2.0 and am trying to serialize an object to an XmlDocument
(or a string which I can then create an XmlDocument from).
What I have so far is (User is my class);
XmlSerializer x = new XmlSerializer(typeof(User));
MemoryStream memStream = new MemoryStream();
How can I get this to a string or an XmlDocument?
The serialization works fine as if I serialize to a text file (using
StreamWriter), everything looks fine.
I've try converting to bytes, reading on XmlWriter, but nothing seems
...SEND A STRING TO THE PRINTER
I have a string variable that is presently being sent to a MessageBox.
I want to add a command button to the Form so I can send the string variable
directly to the printer.
Is there a simple way to do this.
The only simple way is to create a report and run it.
Dave Hargis, Microsoft Access MVP
"RICHARD BROMBERG" wrote:
> I have a string variable that is presently being sent to a MessageBox.
> I want to add a command button to the Form so I can send the string variable
> directly to the printer.
> Is there a simple way to do this.
&g...Replacing "OR" with a character separator
When I am using a form to view data and use the Filter by Selection option I
would like to use a character separator between the multiple values rather
than typing the word OR between:
Rather than type "Bob OR Alice OR Susan"
I would rather type "Bob, Alice, Susan" or some similar character
Anyone know how to do this?
IN("Bob", "Alice", "Susan")
Dave Hargis, Microsoft Access MVP
> When I am using a form to view data and use the Filter by Selection option I
> would like to use a character separator...? Tutorial on HOOKS without DLL
Can anyone point me towards a tutorial on using hooks within a program
(without using a dll)? I need a good clear example.
alec <@> synetech <.> cjb <.> net
Note that global hooks *must* reside in a DLL. This is because these events
can occur in other processes and the "hooking" DLL must be mapped into the
address space of each process that can cause the event.
Available for consulting: http://www.softcircuits.com/jwood/resume.htm
"Alec S." <firstname.lastname@example.org&...special characters
I have a memo field in table A that contains " (special character). I need
to update table B with the memo field from table A. However, Access
compalins that the string used to update table B is not formatted properly
because the memo field in table A contains " characters. How do I enclose
the memo field in an update statment to accommodate that?
sqlstring = "UPDATE [table_A] " _
& " SET [comments] = " & Chr(34) & table_B!Comments & Chr(34)
thanks in advance for your help!
If the comm...Serial emails
is there a possibility to send serial emails out of MS CRM with attachment
or are there any suitable add-ons for it?
...A string problem
I have a form on which is a subform and 5 commands buttons.
On the click of a button, I want to change the records shown on the subform.
I am having a problem with one of those buttons.
One is suppose to show records of costumers that came between 2 dates. To do
so I made a table with 3 fields :ID, date_1, date_2.
date_1 and date_2 are date/time variables.
I also made a small form that changes those dates and with an OK button.
The command button opens the small date subform.
On the click of the OK button on the small subform I go into this procedure :
' A déf...HOWTO Force landscape printing with CPrintDialog.
HOWTO Force landscape printing with CPrintDialog.
Please help, I have the following code I want to FORCE to print in landscape
after the CPrintDialog finishes. This solution must not touch the CWinApp's
"m_hDevMode" data member. This solution must only do something to the DC
returned from the CPrintDialog, and it must override any possible orientation
settings the user may have change while they were inside CPrintDialog. :
if (CPrintDialog_Temp.DoModal() == IDOK)
// Do something here to FORCE the print out to be landscape
...std:string problem (string subscript out of range)
Hi. This code gives me an "string subscript out of range" error.
+];............................................HERE!!!!!, THIS LINE
where afterRLE is a std:string.
Is memory data in the string continuous? Does it matter? Where could
be the problem?
In addition I say that my application is compressing/decompressing/
rendering v...First 6 characters in column
I have a data that I'm importing into excel that looks similar to:
123456 012. What I want to do is on this whole column trim everything
away and leave only the first 6 characters. Is this something fairly
Message posted from http://www.ExcelForum.com/
You could use the Text to Columns feature:
Select the cells that contain the numbers.
Choose Data>Text to Columns
Select Fixed Width, click Next
In the Data Preview window, click after the sixth character,
to add a break line.
With the first column selected, choose
'Do not import column ...Send characters to combobox
I have a non-updateable datasheet subform. I am wanting to catch the subform
keypress and direct these to a combobox on the parent as if the keypress was
to the combobox directly.
I don't want to use sendkeys as all comments caution its use, and the
combobox may not have the focus anyway (I could ensure it does).
Using the following in the subform:
Private Sub Form_KeyPress(KeyAscii As Integer)
If (KeyAscii > 64 And KeyAscii < 91) Or (KeyAscii > 96 And KeyAscii < 123)
'Alpha key so send to parent combo
Me.Parent.cboFiller = Nz(Me.Parent.cboFil...CString
I have been working on very large cstrings - maximum length goes upto
around 750000. I am working on a 1 GB RAM machine and i have the
following problem in a portion of the code.
abc += xyz;
At some point (though it is different everytime i run, around length
of 500000 + ), the concatination statement crashes (consistently as
unhandled exception) and the call stack leads me to the allocbuffer
statement in cstring (where in turn it seems to fail on the new
1) Viewing the task manager, I can say that the full RAM is not
ut...How do I compare item text of combobox to one string
Hello all experts
I have used combobox I ms Access like that
Limit to List=yes
all above it working but
I can not get item text of this combobox,so How can I do
can you healp me.
> Hello all experts
> I have used combobox I ms Access like that
> combobox.bound Column=2
> Limit to List=yes
> all above it working but
> I can not get item text of this combobox,so How can I do
> can you healp me.
...Why does Autoexpand in combo box not work with accented characters?
To quote the Access online help:
You can use the AutoExpand property to specify whether Microsoft Access
automatically fills the text box portion of a combo box with a value from
the combo box list that matches the characters you enter as you type in the
combo box. This lets you quickly enter an existing value in a combo box
without displaying the list box portion of the combo box.
This works fine when I use the normal English alphabet, but fails if I type
an accented character as the first character of a name in a foreign language
such as Hungarian. Is there any way to make AutoExpand ...DLL Howto
I would like to fill in people who have not made MFC dlls
my experiences making them, and how to make DLL creation
First you want to create a MFC extension dll, which is
important because this specific type of DLL will allow
you to export functions and classes without any confusing
After that, implement any classes to the dll and when the
class is being declared include the AFX_EXT_CLASS macro.
class CModifyTransaction : public CDialog
class AFX_EXT_CLASS CModifyTransaction : public CDialog
after that is added any dll ...HOWTO: Protecting a Document???
I'm still using Office XP (Word 2002). I'm just about finished making a
FORM document which I plan to turn into a template (.DOT).
I've turned on the "Forms Protect"... which moves the user around the
"protected text" but I also want to disable anyone from changing the
original .DOT itself (this will be a standard form and don't need some
smart-ass altering something that I'm, ultimately, responsible for).
I'm still GOOGLE'g but... how can I allow a user to OPEN this file to enter
data/check boxes into the FORM FIELDS......