Editing Default Filters
I'm trying to edit a default filter on a report I've created and I need to
bring back records that fall between two dates chosen by the user.
The dates are from the same field e.g. Return all records with start dates
between dd/mm/yyyy and dd/mm/yyyy
Is this possible?
Yes, you can.
For example, if you want to let users to to report on account created on
between dates, you can specify default filters as
"created on" "on or after" "Enter Value"
"created on" "on or before "Enter Value".
When users run this report...Editable .doc bound report object in Access 2003
I have a report which containers a bound word file, which allows me to edit
the wording in Word.
However, when I convert the database to the .mde format, I loose that
Is there a setting or a way I can keep that functionality for this report in
the .mde version?
...asp.net webpart access to data bound to control using ITemplate cl
I have a c# 2008 asp web part with a Datalist for which I have defined my own
template. I have done this by creating a class that implements ITemplate.
After I get some data I use the ITemplate class to create the control so I
can add it back in the web part.
This is the problem, for a label (lblHH) in the Datalist I need to compare
the label’s text to a string held in ViewState["SearchHighlight"]. I use a
procedure declared in the web part to compare and highlight matching words.
I use the ITemplate class to create the Datalist
class DatalistColumns : ITemplate
...Partial editing of cell contents.
I am developing a spreadsheet to be distributed to numerous individuals for
updating and returned to me to be compiled. I have a column for account
number which consists of a 6-segment number, each segment separated by
hyphens. I need recipients to edit the middle two segments and return to me.
I want to create another column that duplicates the account number string
except for the middle two segments, and either highlight the segments to be
edited or mask the two segments to ensure correct number of digits are
entered for the segments. How can I accomplish this?
...How Do I Tab From An OptionButton To A TextBox
I have a UserForm with an OptionButton between several TextBoxes. The
TAB order is set and working. The problem is the OptionButton will
not advance with the ENTER key, only the TAB key. The TextBoxes will
advance with either the ENTER or TAB keys.
Is there any way to get the OptionButton to advance with the ENTER
Any help would be appreciated.
...Help Editing an XML File
This is my first post and I am hoping (praying) someone could help me. I am
not a programmer, I just know enough to be dangerous.
I have a custom application someone developed for me that generates an XML
file to display web pages. Following is a very small portion of an example
<QLabel>Position</QLabel><QText>Which one of the following best describes
your primary job function?</QText><RotationValue>0</RotationValue>
I want to modify the XML file so that the web pages are displayed in
In the resource editor under edit properties for a multiline
editcontrol there is a checkbox for a vertical scroll.
If i look in msdn for edit-styles this vertical scroll is not
There is an ES_AUTOVSCROLL style but that's not what i want...
I have to create the multiline CEdit control dynamically to override
some methodes like OnChar to intercept the enter-key. (Which works
How do i get this vertical scroll style using Create() ?
WS_VSCROLL is the style added by the Vertical Scroll property setting.
Microsoft MVP - Visual C++
"RAN&qu...CFM_BACKCOLOR for Highligthing selection in Rich Edit Control does not work
For some reason I can't get Highlighting feature in Rich Edit Control to
work at all.
Here is how I am trying to do it
if( IDOK == dlg.DoModal() )
SendMessage(EM_GETCHARFORMAT, SCF_SELECTION | SCF_WORD, (LPARAM)&cf);
cf.cbSize = sizeof CHARFORMAT2;
cf.dwMask = CFM_BACKCOLOR;
cf.crBackColor = dlg.GetColor();
SendMessage(EM_SETCHARFORMAT, SCF_SELECTION | SCF_WORD, (LPARAM)&cf);
...Office 2010 Home and Business Edition
I am thinking of pre ordering Office 2010 Home and Business Edition to
replace my Office 2003. Will I be able to install it on my desktop and
laptop with the license that comes with 2010 or will I have to buy two
licenses? That would probably be a deal killer.
Jack Gillis wrote:
> I am thinking of pre ordering Office 2010 Home and Business Edition to
> replace my Office 2003. Will I be able to install it on my desktop and
> laptop with the license that comes with 2010 or will I have to buy two
> licenses? That would probably be a deal killer.
When editing formulas, either directly in cell or in the formula bar,
sometimes cell and range references appear in different colours whilst at
other times matching pairs of brackets are coloured. Both of these are
really useful features, but which is most useful depends on what I am trying
to do. I cannot work out how to control which type of feature is coloured.
Can anyone explain, please?
In Excel 97 (and 2000) when you press F2 to edit a formula the range
references are colored and the parens are not (also when entering the
formula initially). As soon as you m...Standard Edition versus Edition 2004
I have Microsoft My Money Standard Edition installed on my PC (WinXP).
It came as a part of Ms Works suite 2006. Now I would like to restore
the backup file to My Money 2004 editions. But there seems to be a
problem, My Money 2004 does not accept the backup files of the Standard
Edition. Is the anything I can do in order to make the transfer of the
backup file possible?
Grateful for your help
The version of Money in Works 2006 was likely newer than Money 2004. You
will need to use a version of Money at least as recent as that which was
used to make the backup.
"QV" <q...Showing contents of specific cell in form's textbox
This is a multi-part message in MIME format.
I am trying to set up a form with TextBox_Change() Private Sub in it and =
would like the form to show what is in a specific cell prior to changing =
it. This way when the form is open, only the things that need to be =
changed need changed. How can this be accomplished? I know I can add =
something in the Text Property, but I would like it to read the excel =
file and show what is in the cell as the ...Conditions on form calculated textbox
In a form called Schedule (based on the table Schedule) I have the following
textboxes that are bound to the table Schedule:
Time In, Time Out, Time Off, Anomaly and Overtime
I also have an unbound textbox called HRS that gives me the result of the
=[Time Out] - [Time In] - [Time Off] - [Anomaly] + [Overtime]
The above result gives me the daily hours that someone worked.
The formating is decimal, as an example.
16.5 (4:30) - 7.5 (7:30) - 1.0 - 1.0+ 3.0 = 10.0
I also added another figure for lunch the hour
[16.5 (4:30) - 7.5 (7:30) - 1.0 - 1.0...mysterious edits
I'm trying to understand a form of mistake in documents
that have been edited by other people.
The column will be mostly text, such as:
Sent to Smith for approval in September.
And somehow an error can get in there, going undetected
for awhile, which includes a cell reference, just as
Sent to Smith for approval in September+G123.
Can you think of a sequence of actions which could lead to
this? Some kind of automation? Or some kind of personal
options someone could have set?
Thanks in advance.
Most likely an errant user edited the cell.
"Al...return key in text edit
I would like to enter a text in my text box on the form.
When I press "enter" key the form goes to next record.
I want to enter a text to go to next line, but I am unble to do so.
I need type in the note pad which has multi lines and copy paster to the form.
Are there any property to turn retrun key to go to next line in the text
edit instead go to next record.
Your information is great appreicated,
On Dec 13, 6:06 am, Souris <Sou...@discussions.microsoft.com> wrote:
> I would like to enter a text in my text box on the form.
> When I press "enter" ke...Mass SQL Edit?
Kind of a long question,
When POS2009 1st came out, you could not create Inv. items with the same
Description & I had lots of those types of items (Books). I created a work
around by concatenating the Item description & the item # (e.g.
ITEM-123456789). Now with the service pack, you can create items with the
same description. So, I was wondering if there is a way to remove the item #,
everything after"-" “-123456789”.
I have about 49,000 items, so doing this manually would be a huge
undertaking. I was wondering if there was a way to do this, possibly in
upon hitting edit--links, there appears a link to: "E:/testprogram.xls" i
want to get rid of this link. additional info:
i have no idea of what this "linked" file is, probably one i used in the
past, but he "E" drive is curious.
i have tried all the usuall stuff like edit, links, change source, but to no
avail. there are no spreadsheet formulas in the entire workbook.
there are, however, graphs throughout that may have been brought in from
another file, but all of the source data feeding the graphs are from this
workbook and the graphs work fine. any thought...[Access 2007] How to edit custom menubar created in Access2003?
This is my first post to this server, Hello everyone.
We're working on a database created by my collegue in MS Access 2003. Since
some time we've moved to MS Access 2007. Now we find problems editing the
menubar. Each time we want to remove/add/alter a menu item my collegue goes
to his MS Access 2003 and changes a menu.
In 2007 the full menubar is visible under Add-Ins ribbon menu.
Normally there should be a system table USysRibbon, but it is not there.
There are only MSys* objects. How can we change the menubar directly in MS
Access 2007? Is that possible at al...Editing a GIF file in Visio
How do I edit an existing gif file in Visio. I have only just started using
the program and have a series of images from an existing website that need to
be altered slightly. Most of them are flow charts, but because they have
been posted on the web they have been saved as gif files. When I open in
Visio it has saved the file as one large shape, I can't seem to edit the
smaller individual shapes, can anyone help. Do I have to try and convert to
some other file format?
visio does not support editing gif files.
"Darren" <Darren@discussions.microsoft.com> wrote i...CString an edit box
Another quickie. Really simple one.
I want to pass a CString to a multiline edit box. The edit box doesn't like
return carriages "\n". How can I get the edit box to show return carriages?
I have "want return" checked for the edit box and the edit box allows it
from the user, but not internally.
PS (I'm all quite new to this, so if you can explain like you're explaining
to an idiot would be appreciated.....)
Use "\r\n" instead of just "\n".
Check Abdoul [VC++ MVP]
"Henry&...Cannot Edit Attachments received in Email
I am running Outlook 2000. When I receive an attachment
in an email, say Excel, after I change the data and
attempt to resend the email with the changes- the changes
do not stick.
Does anyone have any advice or tips?
"Beth" said in news:email@example.com:
> I am running Outlook 2000. When I receive an attachment
> in an email, say Excel, after I change the data and
> attempt to resend the email with the changes- the changes
> do not stick.
> Does anyone have any advice or tips?
Attach the file you edit...edit web query
This was working a few days ago and now doesn't. When you try and Edit a Web
query the web query box pops up with the correct web address, but you get a
message ... "Navigation to the webpage was cancelled". The Web Query does
work as it is on automatic refresh in the background and pulls back the
correct data, I just can't edit it. I can run IE7 with the same address and
it works fine. I also cannot add a new web query as I only ever get the
default IE web page displayed.
the address is http://uk.finance.yahoo.com/d/quotes.csv?s=DGO.L&f=c1
Any ideas? I suspec...Rich Edit crashes with Windows 98
I'm getting problems with CRichEditCtrl (VC++ 6) in Windows 98. My
program simple crashes when I load even less than 32k of text (with
20k p.e.)... With very small amount of text it's ok. I'm calling
AfxInitRichEdit(), and I'm using SF_TEXT (no RTF). In Windows 2000
it's everything fine. Anybody knows what it could be? Is there any
replacement for RichEditCtrl?
Diogo Moreno Pereira Gomes.
ps: sorry by my poor english, isn't my native language...
> I'm getting problems with CRichEditCtrl (VC++ 6) in Windows 98.
Which version of the rich edit co...2003 CDN Edition
I am trying to set up a retirement account that my employer contributes to; a
5 year guaranteed interest account. Even tho I have the CDN edition, all
banking info and retirement account info is for US users, no CDN info
available. Is this the same for '04 and '05 versions?
What type of retirement account should I be choosing for the GIC (the 401K
perhaps)? The account is just over 5 years old, so there are bi-weekly
contributions from my employer, plus on a monthly basis, there are transfers
out to RRSP's because of the maturing 5 year old deposits (the employer
recen...datagrid bound to dataset is only getting 50 chars
I have a memo field in an ACCES database (up to 650000 characters).
I have set up an adapter and a dataset for the database. I have a datagrid
bound to the dataset. There are 4 fields in the datatable. The "Codetext"
field which should be the memo only gets the first 50 characters from the
Is it the schema generated by Visual Basic ? Here is the schema:
<?xml version="1.0" standalone="yes" ?>
- <xs:schema id="DsCodeKeeper"