input box #3
I have property value figures to input into a workbook every three months.
In the first accounting period 31/3/05 I would input total property value
figure into cell A21 then the domestic figure into cell A12. The next time
30/06/05 these figures would be input into the next column cell B21 and B12,
on 30/09/05 the figures would be input into the next column cell C21 and C12,
on 30/12/05 the figures would be input into the next column cell D21 and D12,
on 31/03/06 the figures would be input into the next column cell E21 and E12
and so on.
At present I have a message box appearing in orde...forms #2
I have invoices that get typed out every time Use them. Is there someway
to create the form in excel so I can use the computer? This would be so
muck easier than typing out three copies!
if you'ld like to email me (julied at hcts dot net dot au) direct i have a
sample invoicing workbook that might suit your needs.
"Bob Kerr" <email@example.com> wrote in message
>I have invoices that get typed out every time Use them. Is there someway to
>create the form in excel so I can use the compute...Is there a way to get an auto page break as data changes in Excel.
I list my students by grade and by teacher. Is there a way to force a page
break automatically as a specific piece of data changes (ie; teacher name,
only possib le using VBA.
"george_visalia" <firstname.lastname@example.org> schrieb im
>I list my students by grade and by teacher. Is there a way to force a page
> break automatically as a specific piece of data changes (ie; teacher name,
> grade, room)?
If your teacher n...Populate sub form
I have asubform that is linked to the main form via one field, multiples
entries are allowed in the sub form, but the linked field is the same for all
I can add new records manually in the sub form okay.
What I want to do , sactivate a query/programming etc that is done by
clicking a button that automatically adds several records to the subform from
a table that contains potential data items based on a field in the main form.
ie if the item in the main form is set to tru, then the sub form is to have
several specific records added to it.
how do i do populate the subform ...Auto reply #4
I was just wandering if there is a way to Auto reply to
emails you receive, if you are gonna be gone for like a
See if the information on the following page helps:
MVP - Outlook
*** Replies sent to my e-mail address will probably not be answered --
please reply only to the newsgroup to preserve the message thread. ***
"Jeff" <email@example.com> wrote in message
> I was just wandering if there is a way to Auto reply to
> emails you receive, if...Auto reply on sent once to each recipient.
We are using Exchange 5.5 sp4 on Win NT 4.0 server sp6a and varied client
setup of Win 2k SP3 / office 2k sr1 or NT 4.0 sp6a / office 2k sr1.
When Out of office reply is swicthed on, people who send the Out of office
mailbox an email will only receive the out of office autoreply the once.
Every time they send an email after that they do not receive the Out of
office autoreply even though the reply is switched on. If how ever the Out
of office is switched off and on again, the process will start again, only
one auto reply will be sent to each sender.
I have found MS KB article 1579...SELF group under e-mail box
What is the function of "SELF" for a exchange 2003 mailbox.
On Tue, 1 Aug 2006 09:32:02 -0700, Dipti
>What is the function of "SELF" for a exchange 2003 mailbox.
Daniel Petri always comes through with the Goods.
bookmark the site.
On Tue, 1 Aug 2006 09:32:02 -0700, Dipti
>What is the function of "SELF" for a exchange 2003 mailbox.
Mailboxes have an associated active account. If...Text Boxes #10
I've nearly finished a publication but have now been told that I need to put
a side panel on every page. This means that I need to move and resize all the
text boxes in the whole document!!
Is there a way of moving them all together as they need to be the same size
and in the same place on each page?
I don't know of a way to do all the pages in one operation.
What you can do to make all the existing text boxes the same size by
temporarily move the guide over to a location to match the intended location
of the side of the text box, go through the pages "snapping" ...How do I fill row colors based on cell value?
trying to figure out how to fill a row a color based on a certain value of a
Take a look at conditional formatting in help.
(remove nothere from the email address if mailing direct)
"Daskeeper" <Daskeeper@discussions.microsoft.com> wrote in message
> trying to figure out how to fill a row a color based on a certain value of
...Auto Number Concern
While looking at my tables, I noted that the AutoNumber has changed
radically. Expecting the table to continue building on the three digit
autonumber, I was surprised to see 10 digit autonumbers appearing and at
times preceded by a minus sign. What gives? I created a master with a
replica...is this the source for the change? Thanks Cheese
Yup: when you use Replication, the AutoNumber field is changed from
Sequential to Random. There's no way for you to change that behaviour.
Fortunately, it doesn't matter. The only intent of an AutoNumber field is to
provide a (practically ...AUTO CATEGORIZE
Does anyone know how to set up money so that it will
automatically categorize charges to a particular payee to
a cateogory? Currently only some of my credit card
transactions come with a category and it will be too much
work to categorize the rest of them. Also without
categorizing transactions then the reports do not make
Perhaps personal finance management is too much work as well.
"Jeffrey Sanders" <firstname.lastname@example.org> wrote in message
> Currently only some of my credit card
>...How do I "auto save" my file in MsOffice2003 Exel?
Dave Peterson's reply to a similar message may help you:
Excel FAQ, Tips & Book List
...Auto Forward Problem...
Is there a way to set auto forwarding to an address not in the global list.
I 've tried creating a rule to do this ... but it's not working.
I would just like to check for mail from a specifc user and send any
that come in to email@example.com
thanks in advance...
> Is there a way to set auto forwarding to an address not in the global
> list. I 've tried creating a rule to do this ... but it's not working.
Rules aren't the best way to do this anyway - see
http://www.msexchange.org/tutorials/MF015.ht...Auto protection of cells
I have the Dates in Column A , I want to protect the cells in Cloumn
B , based on todays date .This needs to be done automatically w/o
going to format cells , protection . How to do that ?
I mean noone can make any entry to the date other than Today's date
Try Data Validation.
Select Select cells then to get into data validation:-
xl2007 version: Data tab on ribbon->Data tools block->Data Validation
pre xl2007 versions: Menu item Data->Validation->
In allow field: Select Dates
Data field: Equal to
Uncheck Ignore blanks
In Formula field: =today()
Regards...Auto tab- Auto fill
I'm looking for a general formula for the entire worksheet. My secretary
spends extra time looking for the proper column each time she subsequently
enters a vendors name .
Is there some formula that would recognize the second (third, fourth, etc)
time a vendors name is entered and auto tab to the column that was last used
for that vendor? Also, the same for many different vendors on the same page.
Same question a different way: if the vendor's name were entered a second
time and a different amount were entered could that amount be auto filled in
the column that was used p...Auto Num
I want to set up a column that "auto numbers and
increments by one" as the user tabs into the cell. It
should be very simple, but I can't remember how to do it.
You could do something like:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Range("a:a")) Is Nothing Then Exit Sub
On Error GoTo errHandler:
Application.EnableEvents = False
If Target.Row = 1 Then
If IsEmpty(Target) Then
Target.Value = 1
...Newbie: Auto fowarding to external email address not working
We have recently switched from using Exchange 5.5 to Exchange 2003. (We have
a small office and responsibility for the IT falls on me, mostly I'm happy
with this but I feel a little out of my depth with Exchange.) Our MD has a
rule to forward a copy of all incoming email to his blackberry (basically
forwarding it to an external email address). This worked fine when we were
working with Exchange 5.5, but since migrating everyone to our new Exchange
2003 server this has stopped working. I know the rule fires, because if I
add an internal address then that recipient gets it. I also kno...A filter by subform field, or a Popup form?
I need to filter a main form based on fields in my subform. For example, my
main form has a field [Order Number] and the header contains standard
information about the origin of the parts and what is to be done with them,
like the PO Number, and Customer information. My subform contains
information like the Part Number, Qty, the ID Number for that particular line
item, etc. My boss needs to be able to tell how many orders contain Part
Number so and so... information that is specific to the underlying table in
the subform, but he also needs the associated information in the main form...trying to open two forms on maximized other usually max. but small
below is the code i have tied to the on click event of a command button
both forms normally open in Max. mode - when open individually
But for when I click on this command button would like the second form that
is listed(doesn't even seem to be opening with below) would like it to open
up in bottom of screen and the bottm part of the form to be displayed ON the
Maximized view of the 1st listed form
tried MoveSize and getting errors - tried looking it up on vb help and keeps
taking me to macros
Private Sub Command3_Click()
On Error GoTo Err_Command3_Click
Dim stDo...Outlook not auto populating email address
We are running Outlook 2000 and I recently had to redo my
profile. Previously, I was able to simply type a unique
portion of a name (ie. "Sus" for Susan) and Outlook would
automatically populate the rest of the email address based
on that unique portion of the name. It would pull this
from my address book. Since I redid my profile on my PC,
I can no longer get this function to work. Is there
something I must choose in a tools menu somewhere to
activate this "auto-population" of the address? I really
miss this functionality!!
Go to Tools -> Options -> Em...default font in text boxes
Where do I change the default font for text boxes? If I insert a text
box in a spreadsheet & start typing, it comes out as Calibri (body) 11
pt. If have two text boxes, both formatted as Ariel 12 and I'm
copying text from one box to the other, the copied text appears in
Calibri and then I have to re-highlight and change the font. I want
to make it Ariel 12, period.
I'm not 100% sure, but think the text boxes may adopt the default font
of the workbook, which can be changed via:
1) click the Office button
2) Select 'Popular'
3) Click the 'U...Auto send and receive
I am at a clients site and have run into a problem!
I have set up outlook to do a send and receive every 1
but it isn't working!
I have to do a manual send and receive in order to get
I went and installed outlook 2003 over outlook XP
thinking that this would correct the problem, but
NOOOOOOOOOOOOOO! what have I done or what have I missed?
do I now have to uninstall the outlook and reinstall????
Darryl the perplexed
Every 1 minute is just nuts.
It is difficult to determine why automatic polling is failing when you do
not post your mail account type, c...List Box Field Problem
I have added a list box to a form in Access 2003. The fields in the
list box are coming from a querry which has a percent format on it.
When I run the querry the fields show up in the % format. When I run
the form the field shows up in .99999 format. Is there some bug in
2003 that is preventing this from displaying correctly? I have the
same database running in 2000 and it displays correctly.
By chance, is the field to which the listbox is bound is a text field and
has a Format property setting for the field in the table? And by chance did
you recently update your Office 2003 software to SP3...Changing mail Form
I would like to change the new mail form permanently on my outlook 2003
client. I have created the form template I wish to use and saved it and can
use it if I choose it, but do not know how to set as the permanent default
for when opening the send new message button.
Thanks in advance.
Why do you want to do this? Using a custom form as your message form will
make it difficult to send attachments to non-Outlook recipients.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcod...Search Sub Form Help :)
I know this question has probably been asked a million times, but for a n00b
it's kinda hard to find the time at work to search similar threads, so
apologies in advance! :)
I take my issue is quite basic, so here's the jist:
I currently have:
1 Table (data), 1 Add Form (fields are bound to the table), 1 Search Form (4
unbound fields) where by populating the fields with similar data captured in
the existing table and clicking the "Search" cmd button, a query is activated
and a new table pops up with the search results.
I require: a SubForm in th...