I have a form with 2 combo boxes and I want to filter the second one
based on the selection in the first. I coded it as follows:
Table 1: Department
= DepartmentID & Departments Name
Combo Box1 = Department
Combo Box2 = Specifications
Answered in your second post:
Arvin Meyer, MCP, MVP
"tinaemail" <email@example.com> wrote in message
>I have a form with 2 combo boxes and I want to f...How do I set default start time, File-New-Meeting "start time"
when we point on a date in the furture - and then click on "File", "New",
"Booking" - then thus form starts at 23:59 the day BEFORE ....
I would like to have to start on the same date - and mayby at 08:00 ...
Will it possible to change the start time?
What happens if you double click on the date or time period?
If you use month view, you'll get all day appointments, if you use a day
view with time periods, you'll get an appointment for the time period.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook ...Opening Spreadsheets in New Windows
This one has been killing me, because I'm sure there's an
easy way to do this...
When you open a second (or third, fourth, etc..) instance
of Excel, how do you force it to open in a new window so
you can Alt-Tab between them?! I can't stand having
multiple spreadsheets open within the same instance of
Generally by going to Tools>Options>View and checking "windows in taskbar"
If you are using Excel 2000 there is a problem with this at times.
See KB Article
OFF2000: Only One Ico...Starting in Inbox
How do I configure Outlook to open in Inbox.Thanks in advance.
Outlook Express>Tools>Options> General tab - select open with.inbox.
"Scott" <firstname.lastname@example.org> wrote in message
> How do I configure Outlook to open in Inbox.Thanks in advance.
You should be able to set that here: Tools menu > Options > Other > Advanced
"Scott" <email@example.com> wrote in message
> How do I configure Outlook to open in Inbox.Thanks in advance.
Try this:...font suddenly went microscopic when I reply/compose new message
While working yesterday suddenly the font in new messages or reply became
Even my signature has become the size of ants
How can I restore the original setting of normal size fonts
I don't know... we have some pretty big ants here in the southwest US...
What does it show for "When replying and forwarding" under:
Tools-->Options-->Mail Format | Fonts button.
"Prerana" <Prerana@discussions.microsoft.com> wrote in message
> While working yesterday suddenly the font in new ...Moving Storage Group to New Server
I had Exchange 2003 running on an Enterprise server but I want to move it over to a SBS 2003 server instead. We only have a few mailboxes on the server and i want to know what the easiest way to move them over to the new server would be. I have made an attempt to do so using Windows backup and then restoring it on the new server but it would not mount the database on the new server because the Organizational name is different on the SBS server. However I was not given an opportunity to set that name during Exchange installation on the SBS server and I can't figure out how to set it afte...Save after adding or updating a field.
In Code Builder what do I write so that I can have the field save after a
adding new data or updating the info in it?
...How to Change start of week to Monday
I have a access report that is using "Sorting and grouping" to group
data by week. The default week days are Sunday to Saturday. How can I
change the start of the week to Monday to Sunday?
...Getting started tabs
I installed the getting started tab in MS Office 2007 and it does not show up
when I open word . The same for Powerpoint and Excel. Any ideas?
See the "Important before you download:" information at
Hope this helps,
Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.
"Larry" <Larry@discussions.microsoft.com> wrote in message
news:C73D97D3-F091-4F5F-AB24-B...Microsoft XP Outlook Start Menu Icon Incorrect
I have posted this message previously, but it did not look
like it got through.
When using the Microsoft XP start menu option, the Outlook
icon has been replaced by a generic icon. I want to point
it to the right icon, but when right clicking on the
generic icon there is no "properties" option
only "internet properties".
How do I set it up with the right icon?
Please post or e-mail me.
the easiest way is to remove the shortcut and create a new one. You can do
this in either the startmenu or in the startmenu option in the taskbar
Good Luck!...New post
Just wondering which locale does the time displayed (on the posts) use? Is
it from the news server's system or subscriber's?
I think its based on the viewer's system. If you change your time zone, I
think you will see a different post time.
Ajay Kalra (MVP - VC++)
"longtail" <firstname.lastname@example.org> wrote in message
> Just wondering which locale does the time displayed (on the posts) use? Is
> it from the news server's system or subscriber's?
> S...How to change the start of the week to Monday (instead of Sunday)
I want to change the filter of Summary Sales report (daily sales by
register) in a way that "Week to date" actually starts from Monday, instead
There is no way to change the built in Date ranges. The only way you can
accomplish what you want would be to do a Custom Date Range and manually set
the starting range to Monday and the end to todays date.
"Planted" <Planted@discussions.microsoft.com> wrote in message
> Hi all
> I want to change the filter of Summary Sa...Windows Installer always starts when Visio starts
Visio 2003 Pro on WinXP Pro.
Each time I start Visio, the Windows Installer
fires up, with the message "Please wait while
Windows configures Microsoft Office Visio
After the status bar reaches the end, the dialog
closes and Visio starts normally. Even if I
click Cancel, the Visio still starts normally.
Anyone knows why is this and how to get
rid of the nagging thing?
Something in the install is "damaged". Best bet is to uninstall and then
You can try a repair but my bet is you'll waste your time and end up
&q...Recovering exchange2k3 db on a new server, sbs2003
One of my clients had an interesting week last week. The office manager had
some personal issues with someone and decided to 1) trash the offsite
backups that she was in charge of 2) take a fire axe to the server,
including the external drive and the backup hardware (a box of hardware that
would allow us to build an identical server at any given time).
Everything was destroyed EXCEPT the hard drive! The hard drive was
completely unharmed amazingly enough! The new hardware and server is up and
running and is completely different then what we had before there. I can't
get it to boot up,...Is it bad to terminate Check Links on started???
Is it a bad idea to terminate Check Links once it has started by doing a
"hard-close" of Great Plains by Task Manager (Ctrl Alt Delete)??
From the Process Monitor in GP, I am able to "Suspend" or Pause the
Checklinks Process, but I am note able to "Remove" or delete it.
I'd already started the checklinks process but without doing a database
backup first, so I want to be on safe side and stop the Checklinks Process.
The only way I could think of is to "hard-close" out of GP. But is a bad idea
to terminate a checklinks this way? Can this lead to...Make a WinForms app act as if launched with start /w
When a WinForms application is launched from the command line, it
usually runs asynchronously, i.e., you are immediately prompted for
another command, even though the program hasn't finished.
Is there a way to make it wait? I know "start /w" will do that. But
can I make
c:\> something.exe (which is a WinForms app)
c:\> start /w something.exe
by putting something in the program itself?
...Problem with signature when creating new email
I am creating email via code from access using below;
objOutlookMsg.BodyFormat = olFormatHTML
objOutlookMsg.Body = "Dear abc..." & objOutlookMsg.Body
The email displays fine along with the signature set in outlook but as soon
as the text is added, the signature formatting is lost and the signature
image is replaced with a hyperlink. How can I preserve the signature
formatting while adding text before it?
Set the HTMLBody property instead of Body.
Keep in mind that HTML strings (unlike plain text) cannot be simply
...How to change value of field in one to many relation ship
I have 2 tables with 1 to many relation ship
table2 collection sub
both of them are linked through customer ID
I want to update one of the field 'lastAMCdate' which is equal to
'AMCtodate' in the latest enrty ie last row.
Please advise how I can update programatically above field in custoemr table
use an updatequery
> Dear Freinds
> I have 2 tables with 1 to many relation ship
> table1 customer
> table2 collection sub
> both of them are ...Line Chart #12
Plotting events "Y axis" not happening on even/equal "X axis" points and the
plottted points will not connect and form a line chart. All I get is plootted
Points. It would appears that I must have "Y points" evenly distributed along
the "X axis" or the points do not connect and form a line chart. What am I
Are your x-values real numbers rather than just categories? If so, make an
Both the Line and the XL chart allow you to have (1) just markers, (2) just
line segments and (3) markers joined by lines
If you need more, ple...Open in new windows
I have this:
<SubArea Id="Fld_service2" ResourceId="Contract Service"
Title="Contract Service" />
How do I get this to open in a full IE screen instead of inside the CRM
Thanks in advance
You can't with a SubArea in SiteMap. You can only do this from a button or
menu item in ISV.Config, and set WinMode = 0
David Jennaway - Microsoft Dynamics CRM MVP
Web: http:/...Search All worksheets for string & Create new Whorsheet with the Original Sheet Name and some cells.d some
I am running Excel 97 SR-1.
Here is what I want to do:
I have a workbook that has many worksheets- all the sheets are in the
I would like to be able to search through the entire workbook and copy
all rows that contain my "FIND DATA" to a new worksheet. The find data
is really a name.
Here are the specifics -
The new worksheet would have the original(found) worksheet name in
cell A, and all the data from the original cells ,in cells B through
J, put in cells b through J.
I am working on a macro to do this, but I am not having too much luck.
I have searched this group...Apple Iphone now on Verizon network starting February 10th.
The Verizon iPhone has finally arrived, offering users a CDMA
alternative to the AT&T version introduced in the summer of 2010.
...Computer Freezes 5 Minutes After Starting But Works O.K. After Reb
I bought a new PC in August.
Just recently is is freezing approx. 5 minutes after start up.
Ctrl Alt Del wont work & nor the cursor.
After rebooting using the mains switch or reset button, the PC then runs
normally for as long as it is being used.
Also, I have noticed that it is taking around 30 seconds to open relatively
small Word and Excel files.
I am running XP ser pack 2 plus Kaspersky Inetrnet Security 2009
Any help greatly appreciated.
> I bought a new PC in August.
> Just recently is is freezing approx. 5 minutes after start up.
> Ctrl Alt Del wont wor...two fields automatically need to come up!
Access 2003 - After creating a table, I can type in the first field and if I
have already used that student name, it automatically comes up and I can just
press enter. I would like the second field to come up automatically as soon
as the first field name is complete so I can press enter also - the first
field is the student name and the second field is the student ID #. In other
words, I would like the two fields to come up together automatically and I
just have to press enter. How do I do this?
What you are describing sounds suspiciously like what happens in Excel..
Access ...How to start fresh with Money 2004
I installed Money 2004 recently, but I accidentally deleted "My money.mny"
file, which is a user created file, stand alone in "my document" folder.
I thought I could just start fresh and build a new profile, but hey NO!
Every time I start Money, an error message jumps out saying the program has
encountered a problem and has to be shut down. But it can start from
"sample.many" just fine.
I have tried uninstall and re-install the program, the problem persists.
Money 2004 starts with no problem with "sample.many" but I can't create a