Out of Office message #4
I am using outlook 2000 and trying to put an out of office message on my e-mail so that I can notify people when I am not in the office
I just click on Tools and then on Out of Office
Assistant, but I run Outlook 2002. Yours may be
>I am using outlook 2000 and trying to put an out of
office message on my e-mail so that I can notify people
when I am not in the office
This is a multi-part message in MIME format.
Content-Transfer-En...Footnote in a form
I need to add footnotes in a locked form. The sections where I need footnotes
are unprotected when I tyr to include a footnote the footnote is greyed out.
I am using Office 2002 and 2003
Footnotes are just another feature that is unavailable in protected
documents (even in unprotected sections). In order to insert a footnote, you
will have to unprotect the form.
Microsoft Word MVP
"FMini" <FMini@discussions.microsoft.com> wrote in message
>I need to add footnotes in ...How to send form data to tables programatically
Is there a way to programatically have a form update to the underlying tables?
What I mean is... As a user types into a form, Access doesn't seem to
actually send that data to the table (and thereby create autonumbers) until
user moves on to another record.
Is there a way to force that data to the tables (ie make the new records)
while the user is still on the form?
On Sun, 30 Dec 2007 11:33:02 -0800, markmarko
>Is there a way to programatically have a form update to the underlying tables?
>What I mean is... As a user ...Completing field on subform from command button on main form
This is a simplistic version of what I need to do. I have a form named
frmCLIENT with a subform named sfFAMILY. On the form frmCLIENT I have a
command butten and when I press it I want it to automatically complete a
field named CHILDREN on the subform sfFAMILY with the word "NONE".
Can anyone help me.
The code for the button is
Me.YourSubformName.Form.Children = "None"
'so that you can see the results
This assumes that the subform has only 1 record or that the record you want
editing, is the first ...Populating FIELDS from another form(s)
I have one form were I create meetings, than another one were the individual
is inputted (all works great - this is not the problem). I am trying to open
a form(Travel) from that form by clicking on a button (This I already have
and that part works). I want the newly opened form (Travel) to automatically
populate a few fields (that you can not see on the form) that are the primary
fields. example: [field1] = Me.[field1] and [field2] = Me.[field2].
Now if the record already exist then I want it to populate the form.
So far I have this:
Private Sub btnTravel_Click()
On Error GoTo Err_btnT...How do I create a poster consisting of 4 x A4 pages which get glue
I know this can be done as I have done it some yaers before. It may have been
in Power Point however.
As I remember I created the poster content on the word document page and
then using some option/s one is able to segment the page into 4 quarters,
print these and then glue them together.
I am using Microsoft Office Student and Teacher 2003
Word cannot create posters - try Publisher.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP...Filling bound controls in a form with calculated results
I have a form that a user may partially fill with text and numbers that
could then be used to calculate numerical results that could fill in other
blank fields in the same form. My idea would be to have a un-bound button in
the upper title bar of the form that the user could click after filling in
some of the initial fields, and this action would calculate numerical
results via VBA functions or procedures, the results then being used to fill
in multiple field values I know how to write the VB functions/procedures to
calculate the results, but I'm not sure where to use the
functions...Online form ~ I have word 2003 and 2007
I am trying to create an online form that will allow for a limited amount of
characters per field.
Name: 20 Characters at length and so on
Date: 15 Characters
Title of the reading: 40 characters
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader an...Contact Form Changed with Regional Setting Change
I recently had to change my Windows XP "Settings/Control
Panel/Regional and Language Options/Advanced/Language for
non-Unicode programs" to "Chinese (PRC)" in order to view
Chinese characters in a translation software package.
Just to be clear - my Windows system is still in English -
this setting just allows my Chinese software characters
to also show up.
Strangely, after the above change, the form layout in
Outlook 2003 changed. Most significantly, the "Full
Name" button is no longer available on the main page,
which makes editing of names difficult ...Main Form
I've been searching through the forums, but haven't found anything yet.
Does anyone know of a way to copy data from multiple worksheets (i.e. 30) to
one master form? I do NOT want to summarize the data, I want to replicate it
exactly, and have a live link so that if the individual sheets are changed,
the master will update. All column headings are identical, but there are
variable numbers of rows.
My only thoughts so far are simply typing =Sheet1!A2 and dragging, repeating
for each sheet (or I guess writing a macro to do this). However, if I insert
a new r...SMTP connection failure - 501 5.5.4 Invalid Address
I have a number of SMTP document scanning devices that currently communicate
with our 5.5 smtp connectors, I need to transfer them to Exchange 03 smtp
comms as part of a migration.
I have turned the logging up on the 03 smtp transport and have been
receiving a 7010 when the smtp document scanner try's to send an email via
the smtp virtual server on the 03 cluster.
I have searched technet and I have found no info on "501 5.5.4 Invalid Address
Please find the event below
Thanks in anticipation
Event Type: Error
Event Source: MSExchangeTransport
Event Category: SMTP Protocol
Eve...Link between forms when the child field is part of the primary key causing crashes when creating new records in main form
This is access 2003.
I'm making a form to create new records in a main table and
simultaneously allow the user to create records linking them to data
from a second. The link table data is shown as an embedded form
within the main form. The link table has two columns to store foreign
keys from the main table and a lookup table. I want it to have a
compound primary key composed of the two foreign keys.
The problem is that if I have the compoundPK set and then create a new
record in the main form/table or have the secondary form set to link
MainTablePK between the child and master forms ...Badmail #4
are there any utilities for actually reading badmail
IIRC, rename the .bad files to .eml and open them with Outlook Express.
However, they are just NDRs that could not be delivered, so they are
probably not much use.
For Exchange news, links, and tips, check:
"Rich Eustace" <email@example.com> wrote in message
> are there any utilities for actually reading badmail
Thanks, I have misunderstood badmail then. What I actually want...Blank Field in Form
I have a query that gets some criteria (City and State) from a form.
I have the State field set up as a ComboBox connected to a local table
I created. If a user was to type in a City (i.e. "Springfield") and
then leave the State field empty, then the query would have no
How do I make the query so that if one of the fields on the form is
left empty it will run for all possibilities (i.e. look for all
Springfields in any state)?
Assuming the name of your form is FrmCityState and there are two textboxes
named City and State on the form, put the following expressio...Refresh the original form
I have a main form with a command button that loads a second form to
determine the parameters for an insert operation. The operation goes well but
when the second form closes, I would like the main form to be refreshed.
How can I do that?
I tried different things like:
but I get the message saying that this form does not exist or is closed.
Any help would be appreciated.
Hi Jac Tremblay,
"Jac Tremblay" wrote:
> I have a main form with a com...2003 Form fields losing formatting in 2007
I have some forms, created in Word 2003, which when opened as a .docx, all
form fields revert to Times New Roman font but if they are opened as a .doc,
they are in the correct font of Arial.
Anyone got any ideas why and how I can fix this?
Thanks very much.
This doesn't make any sense. Documents always open in the format in which
they are saved. What *exactly* are you doing?
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
...Update Form with Command Button
I have a report which is created using criteria entered into a form. There is
already a button on the form which opens the report. If someone does not tab
out of a particular box then sometimes the the control isn't updated and the
report doesn't get the proper criteria. I can use the button to update all of
the individual controls before creating the form, but can I use the button to
update the entire form instead?
Just do a...
Microsoft Access MVP 2006-2009
http://ho...CustomLookup not working in MS CRM 4.0
I have a code which is working on v3 and after upgrade stopped working.
This is a code:
crmForm.all.<fieldname>_d.innerHTML = "<TABLE class=lu style='TABLE-LAYOUT:
fixed' cellSpacing=0 cellPadding=0 width='100%'><TBODY><TR><TD><DIV
class=lu> </DIV></TD><TD style='TEXT-ALIGN: right' width=25><IMG class=lu
id=<fieldname> title='Click to select a value for Company.' tabIndex=1270
src='/_imgs/btn_off_lookup.gif' req='0' defaulttype='0' lookupstyle='single'
look...Publishing forms to Organizational Forms
When publishing a form to organizational forms I get the
following error message. There are no articles in the KB.
"an error occurred while going to this folder"
All permissions have been checked and are okay.
If there are any REAL ideas about what is going on in
Exchange, please post a reply.
Thanks to all!
...Tennessee Frist Sales Tax Holiday 8/4/06 to 8/6/06?
Today I got a memo from the Tennessee Department of Revenue for a
Back-to-School Supplies, Clothing, and Computers Tax-Exempt During
Tennessee's First Sales Tax Holiday.
In August of this year, Tennessee will hold its first annual sales tax
holiday, giving shoppers the opportunity to purchase certian school
suppliers, computers and clothing tax-free for a specific period of time
beginning at 12:01am on Friday, Aug 4 and ending at 11:59pl on Sunday, Aug 6.
We have stores on all different parts of Tennessee with different items
sales tax base on their location. I saw two opt...conditional formatting form using OR
I have a form with the following fields: Address1, Address2, and
I would like to use conditional formatting that will convert the font for
CurrentAddress if it does not equal Address1 OR Address2.
For some reason, the conditional formatting doesn't seem to work properly.
It's almost like Access is using AND instead of OR, so I'm not sure how to
Thanks in advance for your help!!
I'm using the following conditional formatting for CurrentAddress--
Condition 1: Field value is not equal to [Address1]
Condition 2: Field value is not equal to [Add...Is there a way to do Sorting and Grouping on a continuous form, similar to a report?
Let's say I was looking at tools - rather than having a line after each
item, I'd like a line after each header; e.g. screwwdriver, or hammer
Screwdriver - flat-tip
Screwdriver - phillips
Hammer - ball peen
Hammer - claw
Hammer - sledge
Is it possible to do this in a continuous sub-form?
There's no way that I'm aware of in a form.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"M Skabialka" <mskabialka@NOSPAMdrc.com> wrote in message
news:%23...Data Entry Form.
I had created a form for entering the employees Contract Form with the
employees table as the database.i had created the exact fields in the table &
the form for entering data into the employees table through the form.
I had created the base table named values with the same fields Like
Department,Employee Name, DOJ (Date of Joining) & CED(Contract Expiry date)
On my form i had created 2 comboboxes & 2 textboxes.
The first combo box is to select a department the list.Upon selecting a
department only the employees in that particular dept should appear.
The 1st Text ...Multiple Domains #4
I'm sure I'm the millionth person asking about htis but I searched the
threads and soem onfo but ot exactly what I wa slooking for. Any my issue:
I have two email domains domain1 and domain2. Domain1 has a MS w2k ad domain
and an exchange server 2000 servicing it. I'm trying to bring domain2 on
board to the excahge server and ditch their old mail server. There is no
win2k domain for domain2 and consequently no ad users and logins. We are just
interested in email sending and recieveing. I have setup domain2 users in
domain1 added their domain2 emails and they can reciev...Total from a Query to a Form
I have several queries that have count totals from certain fields in a
table. I would like to be able to insert those totals (just the
numbers) on certain places in another form for a manager's summary
view. How can I make this possible.
Thanks in advance.
On Sep 25, 8:34 am, Chris <chris.ho...@gmail.com> wrote:
> I have several queries that have count totals from certain fields in a
> table. I would like to be able to insert those totals (just the
> numbers) on certain places in another form for a manager's summary
> view. How can I ma...