Registering messages at run time?
I'm new to Windows/MFC. I see that you normally declare a message map to
map messages to routines in your program. What I need to do is to map
these at run time. Is this possible?
Chris Griffin wrote:
> I'm new to Windows/MFC. I see that you normally declare a message map to
> map messages to routines in your program. What I need to do is to map
> these at run time. Is this possible?
No, its not possible to modify the map at runtime. But you probably
don't need to: Even if you are creating controls dynamically you can
still put the IDs into the message map at bui...creating spreadsheet with colunms for names adresses & zipcodes
How do I create a spreadsheet with seperate colunms for names, addresses &
zipcodes? I want to use this with streets & trips so I can map several
adresses at one time.
I don't understand the question, if you want to create a spreadsheet you
need to type in headers
for each needed column, then put the names and addresses in their respective
"neilabu" <email@example.com> wrote in message
> How do I create a spreadsheet with seperate colunms for names,...Maximum spreadsheet sort limit
Can someone tell me if Excel 2000 has a maximum sort limit in terms of
number of rows? The reason I ask is that the spreadsheet we are currently
using is 17000 or so rows and when it is sorted there is still a large number
of rows that appear to be unsorted.
Thanks in advance for any assistance
I just did a simple test and loaded 60,000+ rows and sorted them.Looks
perfect to me.
There must be some other factor affecting it.
(remove nothere from the email address if mailing direct)
"Paul Townsend" <PaulTownsend@discussions.microsoft.c...Auto numbering of spreadsheets
I have created an elec application form for use on a telephony section. Each
time a user enters the form when a customer rings, I want the form to be
numbered automatically, so that each form has a reference number. There is
the possibilty that more than one user will open the form at any one time -
will they still have seperate IDs?
Can this be done? Any help appreciated...
"abfabrob" <firstname.lastname@example.org.NO_SPAM> wrote in message
>I have created an elec application form for...power spreadsheet users wanted for beta tests
The makers of Personal Audio Link, a cellphone_to_VoIP application,
are offering six months free Vonage telephone service to beta clients
for a new "remote cellphone to PC" sofware.
They are looking for power spreadsheet users to sample the software, in
exchange for the free Vonage service and comments to the website's
user forum re: likes and dislikes, suggestins, etc.
It allows users to send and receive e-mail by voice, via cell phone,
interact w/ & parse records in their Excel spreadsheets by cellphone,
from a cellphone, g...Too long time to open My Computer folder
It takes some 3 minutes to open My Computer folder. The searching torchlight
animation is shown all this time. The OS is Windows XP x64 Pro, laptop with
Turion TL-56 processor. I cannot figure out the reason for this. The other
tasks and applications run quite fast.
...Pull Members' Race Times from a Database?
Sheet 1 is a spreadsheet with 1/2 marathon race results. Column A has
all the names (Last and first in the same cell, sorted alphabetically
by last name). Column K has the finishing times.
Sheet 2 is a list of our club members names. Again, last and first
names in the same cell, sorted alphabetically.
I am trying to use VLOOKUP to pull any members' finishing times from
sheet 1. However it is not working correctly. Times appear for those
who did not run the race (I want NA to show) and some members who did
run the race have the wrong time next to them. Trying FALSE or ...How do I get year to date earnings on a payroll spreadsheet(what'.
I am trying to create a payroll spreadsheet. I want to get the formula for
year to date.
I would rather not use a 52 column sheet with totals. How can I add the
change each week without using a large sheet?
If I can offer an opinion: regarding payroll, keep as much information
as you can. Payroll is sacred- people literally live by it, and they
are VERY concerned that proper records are kept. A Fortune 500 company
is judged by its stock price; small and even medium sized companies are
judged by whether or not they met payroll.
My suggestion is to allow the spreadsheet to be as large as i...Add new record to master and subform at the same time.
Using Access 2003 SP2.
I have a master form and linked subform. For procedural reasons related to
another form, I need to ensure that a new record is added to the subform when
a new record is created in the master form. Obviously, I'm having an issue.
Setup: The forms are locked down. The user must click an custom Add button
to add a new record in the master form. I'm trying to fit the additional code
into this routine. The user can also click another Add button to manually add
a record into the subform, but I also need to do this automatically.
What is the best way to accomplish...Spreadsheet Formatting
I am having trouble with shared workbooks and their formatting. Th
many users who access these workbook and enter data all work i
different offices in differenct cities. The files are stored on
shared drive so that everyone can access and work on their assigne
The problem we are having is that after spending a long time formattin
the worksheets to look and print the way we would like them, each time
new user opens a workbook, the formatting has all changed. (Headers an
Footers disappear, isn't set to landscape anymore, etc.)
Why is this happening? Is there a way to keep the...How do you protect a spreadsheet from being deleted?
I want to protect spreadsheets from being deleted by other users, does anyone
know how to do this?
do you mean single tabs?. If yes try 'tools - Protection - Workbook'
> I want to protect spreadsheets from being deleted by other users,
> does anyone know how to do this?
...Weekly Time Sheet Consolidate
I am having a problem with time sheet reporting. We have a weekly timesheet
which hourly employees complete every week. Most have been saving EACH
timesheet. That is 52 timesheet tabs.
What I am trying to accomplish is this:
Use the time sheet, and have the TOTALS of each column transfer to a single
worksheet. Example of columns in weekly timesheet:
DAte Day of Week Reg OT Sick Vac Total Hours Lunch
The date column is filled with date beginning on a Sunday, ending Saturday.
There are formulas to calculate the total hours.
...cancel charts & graphs on my spreadsheet
How can I cancel my charts & graphs I have on a spread sheet? I have windows
XP. Cannot find how to remove them from my spread sheet. Thank you.
Click chart; press Delete key
Have you tried this?
Bernard V Liengme
remove caps from email
"bluebare@92507" <bluebare@email@example.com> wrote in message
> How can I cancel my charts & graphs I have on a spread sheet? I have
> XP. Cannot find how to remove them from my spread...Formatting excel spreadsheet
Operating System: Mac OS X 10.5 (Leopard)
How do I delete or change the row numbering? I want the numbering to start on the second row, not the first row which has the headings.
The rows can't be arbitrarily renumbered � the top row of any given sheet is
Row 1 regardless of what [if any] content occupies it.
On 1/4/10 4:23 PM, in article 59bb00ff.-1@webcrossing.JaKIaxP2ac0,
"firstname.lastname@example.org" <email@example.com> wrote:
> Version: 2004 Operating System: Mac OS X 10.5 (Leopard) How do I ...My spreadsheet only appears in the top left of the page.
My spreadsheet only appears in the top left of the page and I am unable to
resize it. You can only view rows 1-17. You can scrool down and across. This
is only happening to 1 spreadsheet I created and no others.
I'm not quite I understand, but maybe you've frozen the window so that only a
portion of the screen is visible.
In xl2003 menus, I'd try:
Terry Evans wrote:
> My spreadsheet only appears in the top left of the page and I am unable to
> resize it. You can only view rows 1-17. You can scrool down and across. This
I'm making a spreadsheet and would like to keep the lines when I print it.
How do I do this. Thank you
If you go to File | Page Setup | Sheet (tab) you will be able to check
Hope this helps.
> I'm making a spreadsheet and would like to keep the lines when I print it.
> How do I do this. Thank you
Thank you very much. that worked fine. Thanks again.
> Hi Mary,
> If you go to File | Page Setup | Sheet (tab) you will be able to check
> Print Gridlines.
> Hope this helps.
>...run-time error 3075
I have the following message when clicking on a command button designed to
print a report based on the current record in a tabbed form.
Syntax error (missing operator) in query expression '(MachNumber=2G-CH01)'.
The following code is on the "click" event of the button:
Private Sub MachTag_Click()
DoCmd.OpenReport "M-Equipment Tag", acPreview, , "MachNumber = " &
The 1st tab of the form is pulling the MachNumber data directly from the
table. The 2nd tab form (is a subform) and is pulling the data from a second
Hy, some users ask me how to create a model of e-mail, they would to
have a reutilizable draft that everytime they need to send a standard
message to someone they just have an esisting model to compile and send
without rewrite all the message every time...
how i can do it with outlook 2003?
thanks to all
Kentucky <firstname.lastname@example.org> wrote:
> Hy, some users ask me how to create a model of e-mail, they would to
> have a reutilizable draft that everytime they need to send a standard
> message to someone they just have an esisting model to compile and
> send without r...Open an Excel Spreadsheet to a Specfic Worksheet
I have tried the following with no luck...
Any other ideas?
This worksheet formula worked ok for me:
=HYPERLINK("file:////c:/my documents/excel/book2.xls#sheet1!a1","click me")
Jody Baldwin wrote:
> Good Morning,
> I have tried the following with no luck...
> Any other ideas?
Cannot be done via Command as you are attempting.
Sheets cannot be selected to open...Outlook msg starting for first time. deleted existing email accoun
"Outlook is starting for the first time" Outlook opened with all the old
emails, but the email account was deleted. I cannot set up the old email
account. It says the password is incorrect.
Now, Outlook has opened and does not show the old emails. This new copy of
Outlook is not seeing the .pst file.
I had not made any changes to Outlook.
You can reconnect another pst-file via;
File-> Open-> Outlook Data File...
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins a...Tracking loan last year; importing time tracking items
1. I am not able to set up a loan account to track my loan which started last
year. Money allows me to track only from the beginning of the current year.
2. I have a bunch of 'time tracking' items in a spreadsheet which I would
like to import into Money SB for association with invoices, but understand
that it is not possible.
Are there solutions to these problems?
1) Set the date back on your computer just long enough to create the loan
account. Why Money enforces this piece of mindlessness is a question for the
2) I have no clue. I don't use SB. Next to nobody ...calculate time on time record
I'm creating a time record using Excel 2003 and need to know how to calculate
to get the correct total worked for the day:
IN A.M. OUT LUNCH IN LUNCH OUT P.M. TOTAL
9:00 1:00 2:00 5:00 7:00
Also, if the time is recorded as:
IN A.M. OUT LUNCH IN LUNCH OUT P.M. TOTAL
9:10 1:00 1:50 5:00
See Chip Pearson's site for timesheet assistance.
Gord Dibben MS Excel MVP
On Mon, 9 Apr 2007 13:00:01 -0700, DTucker <DTucker@discussions.microsoft.com>
>I'...Time stamp is 1 hour behind
Anybody know the correction to this:
When I send an email, it time stamps it exactly 1 hour
behind actual. When I receive a meeting request via an
email and accept, it posts to my calendar 1 hour
behind. ??? - Before anyone asks the obvious - Yes, my
computer time is set correctly.
Check that your time zone is set properly, its' often
overlooked in troubleshooting time stamps.
>Anybody know the correction to this:
>When I send an email, it time stamps it exactly 1 hour
>behind actual. When I receive a meeting request via an ...Error Importing Excel Spreadsheet into Access
I'm trying to import a general excel spreadsheet into access. However,
everytime I try to import it, it says there is an error importing the data
and that it can not be imported. Also, it doesn't give me any indication to
what type of error it is. I've tried pasting the data into a fresh
spreadsheet and that still didn't reslove the issue. Does any one have an
idea onto why I would be getting this error message?
It could be some of the values in the title of a column such as # and @.
What kind of data are you importing? Time- Dates- just words?
Are there ...Adding up times
I have used the formula below to work out the amount of hours from a start
time to a finish time for each day.
Start - Finish - Total Hours
It works fine and give me the result but if I try to add the weeks hours I
get is 00:00:00.
Each sell has a formula which shows the correct times but the value shown
can not be used.
I hope this makes sense as it has got me beaten.
Any help would be appreciated.
You can't add text.
and format Custom as "h:mm:ss"
Format the to...