CFileDialog -- auto completion issue
I'm using an extended CFileDialog (provides Win2k dialog support) and all is
working fine, but I had one minor tweak question.
If I have the files:
And I specify that the dialog is only looking for .xml files, when a user
types into the file name field "test", the auto-complete dropdown lists
suggests both possibilities. I'd like for it only to suggest the .xml file
since that's what the dialog's filter is set to.
This works in Office 2000, but with any other app that uses the dialog,
you'll get the multiple "incorrect&quo...Money will not print one check at a time
My money program will not print one check at a time. If
you do two or more checks, there is not problem, but if
yoiu print just one check IT WILL NOT PRINT.
No need to SHOUT, we hear you just fine. The answer is in the FAQ. See
<firstname.lastname@example.org> wrote in message
> My money program will not print one check at a time. If
> you do two or more checks, there is not problem, but if
> yoiu print just one check IT WILL NOT PRINT.
> ANY SUGGESTIONS?
...remove time card records
Does anyone know of a way to delete time card records either using a SQL
statement or other way?
This deletes them by cashier.
DELETE FROM Timeclock
INNER JOIN Cashier ON Timeclock.CashierID = Cashier.ID
WHERE Cashier.Number = '1004(t)'
"lax guy" <email@example.com> wrote in message
> Does anyone know of a way to delete time card records either using a SQL
> statement or other way?
> lax guy
Thanks fo...Auto Complete
I have a user that has the auto complete flag set but when he restarts his
machine he has to start all over. Nothing is retained from the day before.
I've looked everywhere I know to look. Any ideas?
You have? Search this group then. This problem has been posted countless
times. It usually means a corrupt Outlook profile.
"GSP@DCS" <firstname.lastname@example.org> wrote in message
>I have a user that has the auto complete flag set but when he restarts his
>machine he has to start all ove...Unhide more than one worksheet at a time
I have a worksheet that contains 50 hidden worksheets. Is there a method or
macro that somebody knows of where I can unhide more than one workseet at a
Try the following code:
Dim WS As Worksheet
For Each WS In ActiveWorkbook.Worksheets
WS.Visible = True
Microsoft MVP - Excel
Pearson Software Consulting, LLC
Some kind souls help is requested to make my worksheet more user
1) When data is filled in across cell range B14 � R14 and I then press
�enter�.... a new row is automatically inserted either above or
2) The new row would retain the formulas in the cells just copied, but
none of the calculations or text. I am using using the following code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
Dim lastrow As Long
lastrow = Cells(Cells.Rows.Count, "B").End(xlUp).Row
Rows(lastrow).AutoFill Rows(lastrow).Resize(2), xlFillDefault
Rows...Auto Complete list has been deleted somehow anyone know how to fix??
I have hundreds of emails in auto complete and today when I tried to use it they were all gone. This happened to me about 3 years ago and I never was able to find out why.
Can anyone help me please..
Submitted using http://www.outlookforums.com
mike long wrote:
> I have hundreds of emails in auto complete and today when I tried to ...
<gatewayed post was truncated to illustrate lack of proper line wrap>
The autocomplete cache is in the nickname file (.nk2). Do you still have a
..nk2 file? If it is gone or corrupted, restore it from your backups.
http://support.mi...RE: Understanding Project's Percent Complete vs. Percent Work Complete
Brian Kennemer wrote the subject-line article several years ago and was very
informative/enlightening on how % Complete is computed, etc. However, in
this article he showed a Microsoft Project view (Figure A) that had both
"Work" and "Actual Work" rows in the detail lines for each resources on a
specific task. Where can I find this view. I do need to enter actual hours
worked per resource per day on their respective task
Perhaps what you seek is on the resource view or task usage view. Bot...Auto Complete Category
Hi All. I'm having an issue with Money Plus. When I download my
statement, the information that come is: MEMO (i believe this should
be the payee and it is going to the wrong place) date and amount. As
the information is saved as MEMO and not PAyee, Money doesn't learn to
auto complete thye categories according to previous transactions. Does
anyone know how to solve this issue?
In microsoft.public.money, Mozinha wrote:
>Hi All. I'm having an issue with Money Plus. When I download my
>statement, the information that come is: MEMO (i believe this should
>be the payee and i...How do I average time (hh:mm:ss) excluding zeros?
I have an array of times all in the same column. I would like to average
this array without having to sort to exclude zero time fields. I've tried
=Average(A1:A50,<>0), but it doesn't work. Any ideas? Thanks.
This is an array formula that must be entered with CNTRL-SHFT-ENTER rather
than just the ENTER key.
Gary''s Student - gsnu200909
> I have an array of times all in the same column. I would like to average
> this array without having to sort to exclude zero tim...Access
My cursory looks at Access, courtesy of some work my wife is doing with it,
has me scratching my head about somethings.
A .mdb file seems to encompass both the database and all the 'code' (forms,
modules, and logic) used to CRUD the data in the tables.
1) Is there any way to separate the database from the code into separate
files, eg. the db is mydata.mdb and the 'code is in a separate file, eg.
2) Say you have v1.0 of an app and the tables and attributes are populated
with data. You then go and build v2.0 of the app, adding tables and columns
to what already existed i...Uninstall Mendeley completely
I have accidentally installed Mendeley, which turned out to be a big
mistake. I uninstalled it several times after closing all other
programs, but now it still appears as "Add-Ins" in office 2007
(including word, excel, etc). It also interferes with Endnote x2. This
is a huge problem for me now and please help.
restlessHK's Profile: http://forums.techarena.in/members/162019.htm
View this thread: http://forums.techarena.in/ms-office-support/1279777.htm
ht...Calculating time differences in Excel
How can I calculate the time difference in excel with the accuracy of
a hundredth of a second?
The times are in the following form:
thank you in advance,
"Ville" <email@example.com> wrote in message
> How can I calculate the time difference in excel with the accuracy of
> a hundredth of a second?
> The times are in the following form:
> 13:25:59.76 13:26:01.05
> thank you in advance,
Format the cells as hh:mm:ss.00 and then jus...Times to Decimal Hours
Am looking to calculate hours: mins into decimal hours and am struggling
big-time. Can anyone point me to an URL that details this (I have had a
good look around sites but unless I missed it cannot find how to crack it).
A B C D E F
1 08:15 19:30 00:30 10:45 9.0 1.75
where A = start time, B = end time, C = lunch time, D = hours worked (all on
E = normal hours worked (decimal), F = hours in excess of 9 (E) ion decimal
Any help would be gratefully appreciate
Ala...Excel won't completely open
When I click on an Excel document it will start to open but stops at a grey screen.
Only a few toolbar commands are selectable, all others are grey and not accesible. I need to go to file to open the correct document. This is frustating as I have several document in Excel and this is also confusing when I email it to someone else.
Please help if you think you can.
try the following:
goto 'Tools-Options-General " and uncheck "Ignore other
Exit Excel and try again
If this doesn't work try to re-register Excel
1. Close Excel first and
2. On the Windows...Outlook 2000 internet mode, timed mail delivery
I have MS Outlook 2000 internet mode. At one point I selected from a
which mail accounts to use when automatically receiving mail. I have
since deleted that account. I have other mail accounts but I have to
send/receive them manually. Does anybody know where to find the
dropdown box for selecting which accounts are used?
I already answered your question. Send/Receive groups did not appear until
Outlook 2002. In Outlook 2000, automatic polling includes all accounts. You
configure it here:
Tools menu > Options > Mail Delivery tab > Check mail every X minutes
Rus...2007 Structured Reference auto-completion not working completely?
In Excel 2007, when I:
1) Select a cell
2) Type "=" in the formula bar
3) Click a cell in a Table
I thought Excel would add a Structured Reference to the formula. Instead, it
just inserts an old-style, "A1" reference. The "Formula AutoComplete" and
"Use table names in formulas" options are both turned on. When I click the
cell in step 3, the TableTools tab appears so Excel agrees that the cell is
in a Table. Isn't Excel supposed to insert a Structured Reference when you
click a cell in a Table? Is there another setup/configuration switc...Forms completion
Here is a question for you, we have a pretty simple database to gather
comments and suggestions from users for improvement on things around our
office, It is a form entry, a suggestion that was given is when users want to
enter multiple suggestions they are having to re-enter the header section of
the form (Basics of name and contact information) repeatedly, is there a code
or work around where that will replicate for the user if they click the add
new record after they enter the first entry?
Are you storing this information in every row of the table?
The way it should work is, when the...How to organize Inbox by time
e Recently my Inbox has changed
I have only TODAY and after its go to LAST WEEK and after THREE WEEKS AGO
My file from YESTERDAY and TWO WEEKS AGO are gone
Please help to get them back
> e Recently my Inbox has changed
> I have only TODAY and after its go to LAST WEEK and after THREE WEEKS AGO
> My file from YESTERDAY and TWO WEEKS AGO are gone
> Please help to get them back
What version of Outlook are you using? Did you look in your Deleted
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.off...using hyperlinks or macro buttons to time stamp
I am currently using this code to time stamp one cell,
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If .Count > 1 Then Exit Sub
If Not Intersect(Range("A2:CL2"), .Cells) Is Nothing Then
Application.EnableEvents = False
If IsEmpty(.Value) Then
With .Offset(0, 1)
.NumberFormat = "dd mmm yyyy h:mm:ss"
.Value = Now
Application.EnableEvents = True
Can I do this to two cells, using a hyperlink, as in:
It is being used to track call center transact...TIME....again
I've reviewed the posts and tips relating to time, but haven't found an
EXACT answer to what I'm trying to do.
Like one of the other posters, I keep an hourly logbook.
I might enter a start time as 23:30 zulu, and an end time of 01:15
zulu. In this case, the time difference should equal 1:45, and then
converted to tenths should be 1.8. When I'm not starting and ending on
a different zulu day, I'm able to get the function to work perfectly.
BUT HERE'S THE RUB. For DATE, I only wish to enter the local start
date...regardless of what my zulu start or end date is....inbox repair tool fails to complete
I've been having problems with my newish laptop XP & Office 2003 ST edition.
Tried to run inbox repair tool on the .pst. I get the message that says
internal errors were found, and I selected the box for a backup file to be
created, but the process hangs on the repair. I tried twice, and can verify
the .bak file is there and the same size as the .pst, but the repair won't
complete. Using the Task Manager indicates the process is not responding.
Happened twice in a row.
Greta Grip <firstname.lastname@example.org> wrote:
>...Windows update is not completely successful Error Code: 0x64C
Cannot find a solution anywhere. No such error code in any of the help screens.
It is now showing Error Code: 0x8007064C. Still cannot find this discussed
"John with RadioWorks" wrote:
> Cannot find a solution anywhere. No such error code in any of the help screens.
"John with RadioWorks" <JohnwithRadioWorks@discussions.microsoft.com> wrote
in message news:016D3C6E-B2BE-49CC-8678-580B6E169903@microsoft.com...
> It is now showing Error Code: 0x8007064C. Still cannot find this discussed
> "John with RadioWo...Credit Card payment vs. Transfer, looking for more clarification
Money Premium 2006
I've read through the archives about CC payments v. transfers, but could
use some further clarification.
I understand the concept of transferring money from the "left pocket to
the right pocket", which makes sense.
My question is about setting up my recurring Bills/Transfers for credit
Over the past few days I've set up my checking and CC accounts w/ a
couple of years of historical data. When I recorded payments from my
checking account to my CC account, I used the category: Credit Card
Payment : <Card Name>. I then took the last ...program lock up/ time-out/ not responding
Each time when I run money, the program hangs for several (5-6) minutes
usually. Eventually it does open but it can simply time out and close itself.
When I try to use the task manager it will ALWAYS state that the 'program is
not responding'. I have used different video settings but it always does
this even when I just work offline. I do have a 1.5 mbps DSL/cable gateway
which I have used for years with money 2005 quite well. Any one with an
inkling of a clue as to what I am doing wrong PS: xpsp2w/all updates. This
problem is unique to this program-Doom 3 runs OK. Thanks