Change check box value in table
i have i form linked to a table with these fields
Name Line1 Line2 ... LineN
Line1 .. LineN are check box with value = false at the beginning.
In the table there are obviously many records that means
Name1 False False .... False
Name 2 False False ... False
Name 3 False False .... False
NameN False False .... False
What i want to do is to modify/fixed the value of check box at true value
(for example clik on a button) until the last record.
For example starting from the first records, for 5 records, change the value
of line1 to a true value, then, starting from r...How: Setting UTF8 as an application wide text encoding format
XmlTextReader myXmlReader = new XmlTextReader(args);
string en = myXmlReader.Encoding.EncodingName;
Unhandled Exception: System.NullReferenceException: Object
reference not set to
an instance of an object.
HOW CAN I GET THE ENCODING NAME ? Basically determine the
Also How can I "set" an application wide Encoding ? I want
all modules and everything to stick to and conform to UTF-
But somehow some methods automatically go to UTF-16
1) What's args in your example? Does it contain any Xml? In that case you
first...A lot of Text Boxes!
I got a problem on my excel files. Hope you may help.
I don't know why, many of my excel files have a huge number of Text
Boxes. It's over 50,000 and they're all empty. As a result, it slows down
my computer. Whenever I edit the files, it takes more than 10 seconds to
move one cell to another. So, I can't do anything on them anymore.
I've checked my computer and it's no virus. I'm still using Excel 97.
Any one of you have the same experience? Why this happened? You will help
me a lot if you could solve my problem. Many thanks!
R...fill color toolbar buttons for specific colors
Is there a way to have multiple toolbar buttons that fill different
colors? For example, one toolbar button for fill blue, another to fill
red, another to fill yellow.
Currently, to work with several colors, I need to click to get to the
fill palette, then select the color. Quite tedious and slow.
One way would be to have a macro for each assigned to a custom button on a
Microsoft MVP Excel
"bucky3" <firstname.lastname@example.org> wrote in message
news:email@example.com.....need help with hq p.o. planner
i'm trying to figure out how to enter a po number in
headquarters as opposed to having headquarters
automatically generate one. in the help topics for this
is states that prior to approval you may click details
and modify any information, including the p.o. number.
when i do a po planner right now it will not allow me to
edit p.o. number, status, p.o. date, total, sales tax,
currency, exchange rate, tax rate. do i have something
set incorrectly or something i'm doing wrong?
Thanks for any help,
...Text Box Truncation -- detect it?
If I put a text box on a report and fill it with text which may be a short
line or a long line, and I set the property to CanGrow=No, The short line
will fit in the box and the long line will truncate. I expect that. Is there
a way to determine, within the report detail, whether the line was truncated
or not, and where? I tried comparing the source data with the value in the
control, but apparently the value in the control is the untruncated long
line, even it it won't all display. It always compares equal, even with
See Stephen Lebans' information here:
http...Need help in removing large email from Outbox
How do I remove a large email from my outbox without it
freezing up my computer and blocking me from sending new
mail? I was trying to send a compassed file and it has
frozen my computer each time I've tried to delete it. It
there a way to stop this?
...Key Words Search against Entire Store
What is the best way to search the entire mail store on
Example, I want to find all emails containing the
words "apple" and "orange"
...FIX: Outlook 2007 Instant Search Broken / Indexer Not Indexing Mail Items
Well, it cost me a support incident at MSFT so hopefully what I learned
will help others.
I am running Outlook 2007 as part of Office 2007 Ultimate on Windows XP
There have been numerours threads around with people complaining that
searching in instant search in Outlook 2007 or through Windows Desktop
Search 3.0 doesn't return any results. Some have said that PST files
work fine but results from Exchange mailboxes were missing.
The solution on my machine turned out to be related to the fact that
the Exchange 2003 system management tools were installed on my
machine.There was a prob...Dividing text
I know about the text-to-columns function, but if I have a sentence of
text with each word separated by a space, it'll split across as many
columns as there are words in the source cell.
If I want to split on a specific 3 character sequence (namely " - "), is
there any way I can do so by using the various text functions to
determine where in the sentence that exact sequence occurs, and
splitting only at that point?
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)
As you may have discovered, the 'TextToC...CDialog caption text size
I'm sure this must be easy, but for some reason I can't figure it...
I want to change the titlebar (caption) of a dialog depending on the
current system font size used. E.g., in XP you can use standard old
style Windows fonts, or chunky XP fonts. The text clearly takes up a
different amount of room depending on which is used. How do you tell?
CString titleStr = _T("Whatever 123");
CDC* pDC = GetWindowDC();
CFont* pOldFont = pDC->SelectObject(GetFont());
CSize size = pDC->GetOutputTex...Referencing a text file for data instead of importing
Hi, not sure if this is the right place to post this, but hopefully
someone can help me out.
My problem is, I am trying to figure out a way to reference data in a
text file that has data with columns seperated by semicolons (;), and
end of rows denoted by a space I think. Anyway, I have over a hundred
of these text files, and in the past have just imported the data into a
new spreadsheet in excel, but this is getting too big, and I am getting
too many sheets, and I'm not sure, but I dont want to reach the limit.
Is there a way to reference this data in the original text files from
exce...Emails in TEXT format wrap at around 53 characters.
I have noticed that when I send emails in plain text format they end
up being wrapped at around the 53rd character on the receiving end.
I mailed tests to yahoo, gmail, and msn accounts, and they all get
reformatted as above when sent via Outlook. The only version that is
not wrapping is the copy in my Outlook Sent folder.
I noticed that my Outlook inbox is full of plain text email that
others have sent me and they DO NOT wrap at a fixed line width (but
are still denoted as being in plain text format). Instead they 'free
wrap' to the size of the window. So it does not seem to be ...Need Access 2.0 Converter to Access 2002
Any idea how to get an Access 2.0 .mdb file converted to
Access 2002? I just bought Office Pro with Access 2000
and it does not have a converter for this old file. The
Office website says that no converter is currenty
> Any idea how to get an Access 2.0 .mdb file converted to
> Access 2002? I just bought Office Pro with Access 2000
> and it does not have a converter for this old file. The
> Office website says that no converter is currenty
> available. Thanks!
Create a new MDB in your new version of Access, then import all objects from the
Access 2...News Button Deleted
While setting up my news reader I initially draged the news icon from the
button setup to the toolbar. After setting up news I relized that I should
have put it in the go field. I deleted it from the toolbar area and now it is
nowhere to be found. I can still run outlook express from a shortcut but it
would be nice to start it from outlook at th go field. Have I lost this
feature and it is nowhere to be found anywhere in the button setup. Thanks
for any help ---
Shall we assume your version to be Outlook 2003?
To get the News command back, go back to the Programs tab in Control Panel |
...outlook needs to close window
I keep getting a window after I open my outlook that
reads, Microsoft Outlook has encountered a problem and
needs to close. error message reads C:\DOCUME~1
\JOHN\LOCALS`1\TEMP\WER4.tmp.dir00\appcompat.txt. I also
keep sending an error report.
I am running XP Home & Outlook 2000
>What version of Outlook and Windows are you using?
>Milly Staples [MVP - Outlook]
>Post all replies to the group to keep the discussion=20
>After searching google.groups.com and finding no answer
>John M <jguitarfly55@h...Validating required fields on click of close button
What is the easiest way to validate that all required fields have been
populated when clicking a close form button?
Use the form's Before Update event and then you can do things like:
Dim blnFlag As Boolean
If IsNull(Me.MyTextBox) Or Me.MyTextBox = "" Then
blnFlag = True
If IsNull(Me.MyComboBox) Then
blnFlag = True
If blnFlag Then
If MsgBox( "You have not filled out the form completely. Do you want to
continue filling it out?, vbQuestion + vbYesNo, "Incomplete Form") = vbNo Then
Cancel = True
And that...Refresh an Excel link with button
In my tables I have a link to an Excel workbook. What VBA code can I
put in the OnClick event of a button to automatically refresh that
<firstname.lastname@example.org> wrote in message
> In my tables I have a link to an Excel workbook. What VBA code can I
> put in the OnClick event of a button to automatically refresh that
...Command Button in Datasheet View
Hi Folks - I'd like to display a list of records in datasheet view. One of
the fields is a checkbox. I'd like users to select the records to print,
then click a command button that runs a report. I thought a form in
datasheet view with a command button in the form header would easily
accomplish this task. However, it looks like a form in datasheet view cannot
display a command button. Do you have any workarounds? Thanks.
Change Datasheet to Continuous Forms. Put the field labels in the form header
above the field's textbox, put all textboxes at the top of the deta...Aligning Text Boxes & Graphics
I've recently updated to Publisher 2003 on Windows XP. In previous versions
of Publisher I could align horizontally & vertically in one step by holding
down the shift key. In 2003 it appears to be a two step process, requiring
to open the align window twice. Is there a way around this?
No, it is what is called an abortion of an idea.
My neighbour using my computer to fix his Windows.
Grrrrrr he should have changed it back. I suppose at 87 I may also be a
"Connor O'Grady" <email@example.com> wrote in message
news:Oc%23im8DiFHA.57...I need help with SQL please
I have a form with a group box on it. The code for it is:
20 Select Case grpPlan.Value
30 strMon = "WorkRec"
40 Case 2
50 strMon = "IntRec"
60 Case 3
70 strMon = "FinalRec"
80 End Select
After I select the one I want then the SQL is build based on the selection
and a report is generated.
strWhere = "EmpSuper.WorkRec=""" & strMon & _
""" or EmpSuper.IntRec=""" & strMon & _
&quo...Chart data file lost
I have a chart created by an intern last year, the data to create the chart
was in a file stored in their temp files and is now lost. When I open that
chart file the chart still has data in it so I know the file has the data
stored somewhere in it. Has anyone ever had this issue, and were you able to
get the data back out of the chart?
If the chart series now contains actual values rather than links to
ranges/cells you could try the following in order to recoup the data.
Select a series, it's formula should be displayed in the formula bar.
Something like this,
=SERIES("se...Split text into columns
Has anyone got any code that would split a name in one cell into three
columns. I have seen somewhere how to look for the space and so split it
up! An example of my data is:
Rev Christopher Dent
I assume your names are in Col. A and you want the First Name in Col.B,
Middle Name in Col.C, and Last Name in Col.D. This will do it for you.
Dim rng As Range
For Each rng In Range("A1:A" & Cells(Rows.Count, "A").End(xlUp).Row)
Range(Cells(rng.Row, rng.Column + 1), Cells(rng.Row, rng.Column +
3)) = Split(rng, " &quo...Voting buttons not showing
I'm sorry for the cross-posting:
Using Outlook 2003, I've created and published a customer satisfaction form
with voting buttons to the Organizational Forms Library.
I have one problem: the voting buttons don't appear, when the form is opened
Interestingly, if users open the form and send it to themselves, then the
voting buttons do appear?
Can anyone think of a VBA work-around please?
I'd like to be able to see the voting buttons on the form as soon as it is
opened from the Organizational Forms Library?
That's normal and by design.
-...Email Templates Button/Toolbar
I have created an few outlook 2003 email template (*.oft) files that I would
like all our users to be able to use.
I have them accessible thought an toolbar within my version of outlook,
which I can just click and choose the desired template.
I would like to roll this out to every version of Outlook in our company.
I have checked the registry for changes since I created the toolbar, but
cant find any.
Does anybody know an simple way to do this (ie Login script, Group Policy,
Thanks in Advance