SEarching for records with unwanted unicode "blob" in text
We have an unknown number of records which contain a Unicode (65533)
character in a text address field.
Ie a "=EF=BF=BD"
We need to removed these blobs.
For a specific row I have done this SQL Select...
where ContactId in ( 'A9DCDB9D-06C6-DE11-ADDF-00237DEC9650')
This returned 65533 and 63 for ASCII(...)
So now, how do I find any other records which may contain this
I have tried the following with no joy...
patindex(char(63), COLUMN) > 0
a...Grouping History Records by a "department"
Is it possible in Microsoft CRM to group history records based on a
department? As it stands now, we can have 200 history records in a 30 day
period by 5 different people in 3 different departments. Could you creat a
tab of some sort?
...Account Record Changing?
We have a Customer Maintenance question that we cannot figure out, hoping for
insight from more experienced users.
Sometimes the Bill To and Ship To defaults in the Customer Record change to
the last one used on an order, and we can't figure out how. The only party
that really uses that record is Accounting, and they claim ignorance.
Does anyone know how those might change from another entry or posting
...Comparing Record In Two Recordset
I am writing macro who will extract table name from ORACLE and chek is
this in DB2 or not.
I am using windows2003 server and ORACLE 8.2.1 and DB2 8.2. and office
my code is folowing
********************** CODE *******************
Private ORACLECON As Connection
Private DB2CON As Connection
Private RSORACLE As Recordset
Private RSDB2 As Recordset
Set ORACLECON = New Connection
Set DB2CON = New Connection
ORACLECON.ConnectionString = "Provider=MSDAORA.1;Data Source=" &
LCase(Trim(server_name.Text)) & ";User ID=" & LCase(Trim(user_id.Text))
& ";Passw...Spin-off recording
using small business 2004 and trying to record a spin-off. I get an error
message that the operation can't be completed. "Help" tells me to run the
file repair tool which I have done. -both the Quick repair tool and the
Standard to no avail. "help" also tells me that there is a download
available for the latest version of the "Standard file tool". I can't seem
to find this download on microsoft's site after an eshaustive search. Any
...want header stay stay when scrolling
I am battling to get the heading of the page to stay when previewing site
design, how do I freeze the header or top pics
You'd need to use frames, Pub doesn't "do" frames...except for iframes.
ps... frames are bad news, you shouldn't use them unless you are prepared to
deal with problems they can cause.
"Mark" <Mark@discussions.microsoft.com> wrote in message
|I am battling to get the heading of the page to stay when previewing site
| design, how do I freeze the header or top pics
...email stays in outbox on win2k
i send my emails, but they stay in outbox until I click some folder or other
email. Same happens when I want to receive.
Any ideas ??
I have the same problem with Outlook 2000 on an XP laptop. Usually if I
hit Send/Receive it will go. Make sure in tools, options, Mail Delivery,
you have the box checked that says Send messages immediately when connected.
Other than that, I don't think it's much you can do.
".:J:." <MONKEYselskab@bigfoot.com> wrote in message
> i send my...send mail stays in outbox
i have a paid yahoo pop3 account and having problems getting mail in outlook
2003 as well as trouble sending. I get the error message 0x82004210B. Any
idea how to fix this?
tere via OfficeKB.com <u14560@uwe> wrote:
> i have a paid yahoo pop3 account and having problems getting mail in
> outlook 2003 as well as trouble sending. I get the error message
> 0x82004210B. Any idea how to fix this?
What version of Outlook? Is that the entire message? What do Yahoo's
support people say?
...OWA: Change the time the "New mail notification" window stays open?
I would like the OWA new mail notification to stay visible for a longer time
or even better until you click on it. Is there a way to do this? I can't
find any server side registry keys for this.
In Outlook, click on the Tools menu, then go to Options. On the Options
page, click the Email Options button on the Preferences tab. On the
E-mail Options page, click the Advanced E-mail Options button. On the
Advanced E-mail Options page, click the Desktop Alert Settings button.
You can't set it to leave the alert up until you click on it, but you
can set it to stay up for ...Query that can number records on the fly???
How can I make a query number each line in sequence of records found?
Example if a query return 6 lines of records, I would like the query to
return 1 for record 1, 2 for record 2 and so on.
1 Red House
2 Blue House
3 Orange House
4 Green House
5 Yellow House
You'd need to include a "ranking" field to give you that number. What is the
SQL statement of the current query? How is the "number sequence" to be
<MS ACCESS MVP>
"Michael Kintner" <email@example.com> wrote in message
How do I get the timestamp =now() from an unbound text box on a form to
update and save in a table...So I know when the record was last updated.
e.g., I have a Master Table in DB1 linked to DB2. In db2 I have a form with
unbound text box with =now() function. Is there a simple way to get the
timestamp on update to save to the Master table. I am not a programmer.
In the form's Before Update event:
Me.Timestamp = Now()
where Timestamp is the name of the field.
If you want the actual value from the unbound text box (which may be the time
you first went to the record ...List records not in a set
As you may know from other posts I've made here, I'm playing with
Access to build a small chess management system.
As part of a draw for a match, one of the options to consider is to
match players that have not played one another previously.
To do this, I would like to have a form with a Combo box that is
populated with all the players that the current player have not yet
played (and, as a bonus, not their own record as well).
I can construct a query to list all the players that a particular
player has played before. How can I now construct a query and how do I
put this in the combo..."Show an envelope icon in the notification area" check mark stay?
How to make "Show an envelope icon in the notification area" check mark stay
in "Advanced E-mail Options" on "Preferences" tab? The check mark disappears
after my Outlook 2003 sp2 restart.
...Autofit does not stay on.
When I type text into cells and it wraps to the next line, then I move to
another cell, all the text on the extra lines disappears. I found in the
help section to set the rows to "autofit", which I did. But it doesn't stay
on. The lines still disappear, and when I go back to the "autofit", it is
back to being set at "Height". Help, please.
...Assign all records
A user leaves the firm an I want to assign accounts, contacts, open
oppertunitys en leads to a new user. Can I use "reassign all records" in
usermanagement after changing the relationship behaviour properly? Or should
I assign manualy to accomplish this.
You should use the reassign records in the users record. Once done you can
disable the user and release the license
Microsoft CRM MVP
"JN" <JN@discussions.microsoft.com> wrote in message
news:B14EEA3E-...mx records #2
I have two email domains in my environment e.g. @test1 and
@test2. My mail is hosted at a webhosts in pop accounts.
Is it possible to use a mx record to poll the mail to my
internal domain and then have Exchange perform the
necessary routing to the intended users.
Hi - what version of Exchange?
For Exchange 2000, see http://www.msexchange.org/tutorials/MF002.html for
instructions on how to get Exchange to receive Internet mail sent via SMTP,
the way it's meant to do (will apply pretty well to E2003 too) - for
Exchange 5.5, see
http://www.exchangeadmin.com/Articles/Index...Find name in subform using cbox and go to that record # in main fo
I have a customer entry form with linked sub form, one main customer name
with multiple pets names (many) in the sub form. I realize you cant use the
find button to search in the sub form. I have tried to use Allen's code to
use the sub form table in a combo box but couldn't get it to work.
I want be be able to choose the pet name using the combo box and then in the
after update event, have the main form go to that record #.
The [customer #] is the same in the main table and the sub table and that is
what links them...[Cust #] in main, [Customer #] in sub table.
How d...stay connected
Can anyone tell me how to set the option to stay connected after
send/receive in Outlook XP
> Can anyone tell me how to set the option to stay connected after
> send/receive in Outlook XP
Are you using dial-up modem or broadband connection?
This posting represents my own opinion, and in no way claims
to represent the views of Microsoft Corporation. This posting
is provided "as is" with no warranties, and confers no rights.
Please do not send e-mail directly to this alias. This alias
is for newsgroup purposes o...Dumping out a single record of data for external processing
I'm interested in extracting out some field data in single record for
further processing by an outside application. My idea was to creat just a
generic report that would query the fields that I would need, and that
particular record. Then perhaps I could export it out so that the items
would show up in a text file as:
Does anyone have any ideas as to a better way to do this? I've been playing
with T-SQL for basic reporting needs we have, and thought going this route
would make it simple in that once the rep...Outlook 2003 stays resident?
When I close programs I kind of like them to close. However, with Outlook
2003, even after I close it there's an icon in the system tray, there's a
copy of outlook in the task manager, and it goes on downloading my emails
from the POP server. I do not want any of these things to happen after I
close Outlook, so how do I stop it? I can't find anything in the help menus.
That is caused by an addin which you have installed.
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.h...Stop Marco Recording Toolbar
I have lost my "stop macro recording toolbar" and can not figure how to get
it to reappear. I know this is simple, thanks in advance for your help.
While "recording", Click Tools, Customize, and put a tick in "Stop
Jim McGivney wrote:
> I have lost my "stop macro recording toolbar" and can not figure how to get
> it to reappear. I know this is simple, thanks in advance for your help.
Just to add to Bob's post, when you are finished recording a Macro click on
the Stop recording button (Black sq...Need to populate a Report with several records
In short, I have one report containing 5 records from the same table. The
individual records are layed out to support proper printing. I need to
populate each record with from the same table. I can not give them all the
same pointer to the table or I get 5 copies of the same record. How can I
populate those 5 records with 5 records from my table?
I think you need to have a group by in your report. Thus you will get 1
group of data for each of the 5 that you are refering to as 5 records.
> In short, I have one report containing 5 records from the same t...Why don't modified styles stay the same after saving?
I have tried to modify a heading's style to be green, but when I save the
document and then reopen it, the heading's style goes back to the original
color before I modified it. Is this just a dumb glitch or has anyone else
experience this problem?
What version Publisher? Are you using a pre-designed color scheme or are you
customizing one of your own? What specific design are you using so I can test this on
my computer? I can use the Quick Publication Wizard without any problem.
Mary Sauer MSFT MVP
news://msnews.microsoft...Stay Far Away
Stay far away from Money 2004 Delux. I purchased the
online version for my computer and then a month later my
hard drive began going bad. I tried to access online
help before I lost my drive completely, but Microsoft
online help would not recognize my product ID (I checked
it three times). After reinstalling a new hard drive,
Microsoft will not help me get my product back. They
want my ID number (which I lost with the hard drive), my
product key (which doesn't exist since I bought the
software online), or $35 dollars for technical support
(which should come free with my warra...Edit/Add New Record
I have a form that I want to use as both a data entry and a data
update form. I want the form to open up as a new record. When the user
enters the Order ID number in the OrderID box and hits enter or exits
that box and goes to another box, I want a query to run that goes out
to the Orders table and queries whether that Order ID number exists in
the table. (OrderID is the primary key). If it does, I want the rest
of the forms to populate with the information in the form. If not, I
want the user to be able to enter the new data into the new record.
Some info that may be of help.
Table name = O...