Qry showing AutoNumber as A. B or C.
Using a Select Qry to display the ID Autonumber of an open Form.
Note: txtCustomerID is an Alias for CustomerID.
When the Qry is run it shows the ID number as A, B or C.
Although it shows as a number on the Frm.
And it will continue to add Alpha letters if the User adds new records.
Even tried adding a control with its source as Name: FedFromID Record
Source=txtCustomerID and changing IDNumber:
Would someone be so kind to point me in the correct direction to correct
Thank You for taking the ...Table of Contens not working in Panther
I am running Microsoft Office 10.1.5 on a PowerBOOK G3, 500 MHz using Apple OS X Panther 10.3.2 Inside of WORD X, I cannot get the TABLE OF CONTENTS function using the “index and tables…” option on the “Insert” menu to work. I keep getting the following message; Error! No table of contents entries found.
On 2/23/04 6:11 PM, in article
> I am running Microsoft Office 10.1.5 on a PowerBOOK G3, 500 MHz using Apple OS
> X Panther 10.3.2 Inside of WORD X, I cannot get th...getting a sumif statement to work across multiple files
I was wondering if there was a way to get a sumif statement to wor
across different files.
Currently I have three files, one for currency conversions, one fo
items purchased for specific accounts, and third the cover shee
listing balances for all the accounts.
The cover sheet has a sumif statement linking once to the currenc
conversion file and once to the items purchased file, for differen
items. When I do this however, it gives me a '#VALUE' response. As soo
as I open the file, it links properly, but once I close it the erro
pops up. Also, if I combine the three spreadsheets ...Simple question: Can I a lookup across multiple columns? (ie, if c and d = j and k)
Say I want to match a value from column a and column b with a value tha
is somewhere in column j and column k, and if it does make the value o
the selected cell the value in column l.
A B C J K L
1 2 2 3 x
4 5 6 7 y
8 9 1 2 z
In that example the lookup would give back the value of z for the firs
c column entry and nothing for the others since 4 and 5, and, 8 and
do not match up with any two columns in j and k
Message posted from http://www.ExcelForum.com
Something like this might work for you:
I put the table in A1:L3.
I put 1 i...CTRL+1 and CTRL+ALT+T problems
When I use the CTRL+1 shortcut in Outlook 2007, it opens the mail view which
is good. Problem is, it selects the default Inbox folder that I don't use.
I have to scroll down the list of folders to get to my actual Inboxes. Is
there a way to specify which Inbox Outlook selects when using the CTRL+1
command? What if I was to just delete the empty default Inbox that it always
My second question is, why doesn't Outlook 2007 bring up a new task window
when typing the CTRL+ALT+T command? I was told this should work even if
you're in a different program or ...My right click menu is not working.
I used to be able to right click with my mouse and get a menu that would
allow me to copy, paste etc... I have lost that ability... How do I get it
back... I know it is something simple...
Try typing this in the VBE immediate window
(remove nothere from the email address if mailing direct)
"Right click mouse in excel to copy" <Right click mouse in excel to
firstname.lastname@example.org> wrote in message
> I used to be able to right click wit...Cannot get working password change functionality in OWA
I've got Password change button and set up SSL with SelfSSL tool from IIS 6.0 resource kit, tested SSL with SSL Diagnostic tool. SSL seems working: when I assigned it to complete Exchange web site it works fine https://testsrv/exchange
But when I click on Change Password buttonI am getting:
The page cannot be foun
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.
Please try the following
Make sure that the Web site address displayed in the address bar o...need funct to match data in 3 seperate spreadsheets column 1 to v.
I need to write a function in Excel to find matching data in 3 seperate
spreadsheets, column 1 so that I can view and compare the corresponding data
in column 5 of those 3 spreadsheets. I am hav9ing problems writing the
function: first phase
You're having problems with the Vlookup function because you are assigning
the first argument (the lookup value) to a multi-cell range (ie: multiple
values). How is XL suspose to lookup multiple value at once?
If however, you assign a single cell range to the 1st argument (ie:
Sheet1!A1), the...Is it worthwhile to start learning and using C# and forms instead of C++ and MFC?
Now that I've learned to make C++ GUIs using MFC-dialogs and -Doc/View
apps, is it worth my time to start using C# and formviews? The only
argument I've heard from people (who btw do not know how to use MFC) is
"but forms in c# are so much easier". Well, I don't think MFC is hard
and can't imagine anything easier, especially when I can do things in
MFC I have no idea about how to even get started with in c# forms.
It's always a good idea to learn as much as possible. Microsoft is obviously
pushing .NET and specifically C# (check out the options for C# in VS...Anybody knows native group to discuss C++ fundas ?
Hi, anybody please know microsoft newsgroup to discuss C++ fundamentals and
concepts ?? does ms have such kind of group to discuss c or c++ problems..
+91 98258 69961
"Jigar Mehta" <email@example.com> wrote in message news:enuTCpmVFHA.3076@TK2MSFTNGP12.phx.gbl...
> Hi, anybody please know microsoft newsgroup to discuss C++ fundamentals and
> concepts ?? does ms have such kind of group to discuss c or c++ problems..
> --Jigar Mehta
> Software Developer
> ...Works 9
When I was using XP I could past names into a data base, save them and then
bring up Custom Labels and print the names I needed for my job. Now in
windows 7 I can only print one label or name at a time. Each name I print I
have to do a mail merge, new data base then print. Something is obviously
wrong, but what? Please help.
...Search Doesn't work in WMP12
Search has never works well in all Chinese windows media player series. For
example if you search "party" in the player, the search results will include
"Let's have a party". But if you search "party" in Chinese, it will only give
you the results that starts with "party". So we are missing so so so many
The same thing happens on the layout of the library. It groups all the items
with the same initials. For example all singer with initial "E" will include
Eminem, Elvis. But in Chinese singers, it groups with th...From Borland C++ 502 to Visual C++ 6
HI,I need help!!! I've the source code of a software written with
Borland C++ 5.02 IDE. I want to port this code from Borland C++ 502 to
Visual C++ 6. Is this possible?? Do you have any advice for me??
Thank's for All
I've done this by hand a long time ago, porting from Borland 5.x to MSVC++.
And by hand is how I think you'll have to do it as well.
A good way to start is to create an empty app, of the same type as the BC
one (SDI, MDI or whatever), and add resources. Create dialog box classes,
and go through each dialog box class in the original, map the sa...fatal error c1189: MFC need c++ compiler.
fatal error c1189: when I compile a vc project, it show the error message:
MFC need c++ compiler, please tell me the steps to solve this problem.
I appreciate your help.
I have never seen it. Sounds like something is not installed correctly. Does
it work if you create a new simple wizard generated project? If not, you
probably need a good install. If it does, then you have issue with your
project. See this and do some googling on C1189:
Ajay Kalra [MVP - VC++]
"Jakein2006" <firstname.lastname@example.org> wrote in message
news:6B4AECD1-C6FA-4CD6-8D76-5D7...Ctrl+C and Ctrl+V not working?
I have a coworker whose Ctrl+C and Ctrl+V shortcut keys do
not work in Excel XP. No one else in our work group has
this problem. We checked with our IT support person and
he is stumped as well. He can right-click and copy/paste
that way...but cannot copy/paste using the shortcut keys.
Try opening excel in safe mode:
Windows Start button
Do you still have the problem? If no, then maybe there's a "helpful" macro
that's stealing your ctrl-c/ctrl-V's.
Do any of the ctrl- shortcuts work? (maybe it's a malfunctioning keyboard).
Ryan Sp...wait cursor not working
Does anyone know of any issues with CWaitCursor and AfxBeginThread?
If I begin a thread from a dialog's initinstance, and call CWaitCursor from
within the MainFunc of the thread, the cursor does not change to an
hourglass but remains an arrow.
Has anyone has similar experiences?
>Does anyone know of any issues with CWaitCursor and AfxBeginThread?
>If I begin a thread from a dialog's initinstance, and call CWaitCursor from
>within the MainFunc of the thread, the cursor does not change to an
>hourglass but remains an arrow.
The cursor will only ch...Working with hours
I have two columns of hours in [h]:mm format. Column A1 is reading
148:00 and column B1 is reading 175:00.
I have a formula that says B1-A1 giving me the correct answer 27:00.
In the next row, I have the same formula but with the hours 148:00 in
A2 and 140:00 in B2. I would like the answer to read -8:00. Is this
possible? When I try it, I get a load of hashes. I've tried changing
the formatting but nothing seems to work.
Hope you can help,
You can't use negative time values in Excel unless you use the Mac's
datesystem under tools>options>calculation and ...Junk Mail Filter seems not work
I have Outlook 2003 installed, and turned on junk mail filter (Tools ->
Options -> Preferences -> Jun Email -> High). It seems that this function
never works on my machine. If I logon to another machine with my NT account
inside same domain, Outlook 2003 on that machine works, and it moves some
junk mails to "Junk-Email" folder, but it never happens on my local machine.
What else do I need to configurate? I am lost.
Are you using Cached Exchange Mode on the machine where t...Not receiving any inbound email, outbound works fine.
I have new Comcast hi speed service and new computer with Vista Home Premium,
Office Pro 2007 and MS Outlook. Everything works but my inbound email.
Comcast has tried to help and their messages get through and so do MS Outlook
test messages, but nothing else. Have turned off anti-virus email scanning on
both in and outbound emails. Firewall still running. Ports re-set to
Comcast's specs. Still can't receive ANY inbound email from anyone else.
JournalistJane <JournalistJane@discussions.microsoft.com> wrote:
> I have new Comcast hi speed service and new computer with Vist...PreTranslateMessage and Ctrl + A
how can I check in PreTranslateMessage, if the user has pressed Ctrl and A?
pMsg->wParam; //?? Ctrl+A ?
pMsg->lParam; //?? Ctrl+A ?
Thanks for help,
On Wed, 25 Jul 2007 18:42:17 +0200, "Guido Franzke" <email@example.com>
>how can I check in PreTranslateMessage, if the user has pressed Ctrl and A?
> pMsg->wParam; //?? Ctrl+A ?
> pMsg->lParam; //?? Ctrl+A ?
>Thanks ...purge logs SMTPSVC1 C:\WINDOWS\system32\LogFiles\SMTPSVC1
I have 2 exchange with about 500 user , the folder
C:\WINDOWS\system32\LogFiles\SMTPSVC1 has a size of 7 gb, how i clean the old
log, just deleting them or there a procedure for do that
On Thu, 8 Jun 2006 15:55:01 -0700, Corvety
>I have 2 exchange with about 500 user , the folder
>C:\WINDOWS\system32\LogFiles\SMTPSVC1 has a size of 7 gb, how i clean the old
>log, just deleting them or there a procedure for do that
Delete them and since you never use them you can go into the
proper...Code from 2003 no longer works on 2007
I barely know enough about Microsoft Access to get by and I created a program
for work that keeps track of inventory and uses a visual basic code to pull
up pictures in forms. This has always worked great on Access 2003 but since
we upgraded to 2007 this no longer works. If anyone could please tell me what
I need to do to this code to get it to work in 2007 I would greatly
Option Compare Database
Private Sub Form_Current()
On Error GoTo err_Form_Current
If Not Me!txtPicture = "" Or Not IsNull(Me!txtPicture) Then
Me!Picture.Picture = GetPathPart & Me!txtPict...MFC code integrated with normal C,C++ code.
Are there any real issues involved when I integrate my C code with MFC code. I am integrating my C,C++ file
in the MFC generated project workspace.
I have my normal C,C++ files as
In Implementer.cpp I hav
static myclass *getOb()
Assuming Project name gui I have my MFC files as gui.cpp, guiDlg.cpp , stdafx.cpp.
When I use myclass::getOb() in my guiDlg.cpp I get an error
error LNK2001: unresolved external symbol public: static class myclass* __cdecl myclass::getObA(void)"...
Can anybody plz tell me why am I getting this error ?
B...C field to show the expected amount of time to be spent on a task
What is the formula for a custom field to show the expected amount of time to
be spent on a task on a particular day?
Can anyone help me for this?
You need to examine the assignment Work field in either the Task Usage view
or Resource Usage view. If you apply the Task Usage view and zoom the
timescale to Weeks Over Days, you will see the assignment Work field in the
right half of the view (the timephased grid). You can examine the Work
assigned to a resource on any day. Hope this helps.
Dale A. Howard [MVP]
VP of Educational Services
...Business working days & Cash FLow
I have been asked to build a custom spreadsheet that will help an
entity determine expected cash flow from customers.
If I have 4 customers and each pay their bills in a different amount
of business days, I want excel to tell me the day that payment should
be expected and put that amount in a column with that date.
If I bill customers A, B C & D $5000 each on Jan 2, and they pay in
30, 45, 50 & 60 days, respectively, excluding Saturday, Sundays, and
Holidays, on what day can I expect payment?
I am thinking of laying the spreadsheet out in this manner:
A B C ...