I am trying to design a custom contact sheet and am tearing my h.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have already designed a form that i would like to use - but unfortunately -
when i enter information in the fields - it duplicates itself throughout the
entire sheet ???? Can anyone help me please????
 
Thank you for your response Sue - I am on a deadline here and have been
battling for a week now !
I am trying to design a sheet where the first main sheet will be the general
sheet with all the contact info and notes and html info - then there are five
sheets tabbed behind it - each one a different department within the general
sheet - agian with each with their own contact details, www and e mail
addressses and notes area. My problem is that when i enter information on
the first page - anywhere - it dupicates throughout the whole form - urg -
so the 3rd sheet - totally new dep-artment - still keeps the information that
i have inserted into the main sheet!
 
You still haven't provide any specifics that would help with troubleshooting
this issue. Did you try what I suggested? You do realize that every piece of
information needs to be stored in its own Outlook property? Copying a
control from one page to another does not create any new property.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Hi Sue, Well I did make that mistake in the beginning - copying from the
first page onto the other pages and then changing the header names - and
realised my mistake! But perhaps because i did not start all over again is
why this is happening ..Then i went to the "new" in the control box - but i
dont think i am putting in the right information - because it is still doing
the same thing!I have to be honest and say that i am not sure what you mean
by saying :
You do realize that every piece of information needs to be stored in its
own Outlook property?
I am not very good at this - and the second time i have attempted this - the
first was no where near as complicated as what i am trying to do now !!! I
did e mail you - I would love to be able to forward the screen shots of the
form i designed - but realise this may not be convenient or appropriate!
Just a desperate person over here!!

Thank you !
 
I have to be honest and say that i am not sure what you mean
by saying :
You do realize that every piece of information needs to be stored in its
own Outlook property?

When you fill in a form at the bank or at an online store or anywhere else,
you are always asked to provide certain pieces of information, your name,
address, etc. The form gives you boxes or lines where you type in the
information. There is one box or line for each piece of information. Each
piece of informaiton has its place and there are no boxes left over.

What you don't see is that this information goes into a database. In the
database, each record has a place for the information typed into a
particular box. The information you typed into the box for your name goes
into the database field for your name. The information you typed into the
box for your address goes into the database field for your address. Names
don't get mixed up with addresses, because there's a clear connection --
even if you don't see it -- between the box where you put the information
and the field where the database stores it. The database has just as many
fields as it needs to store the data from the boxes you typed in.

Outlook forms are the same way. If you want the user to enter a name that
will be stored in the item, you need to provide a box for the user to type
in ***and*** and database field (technically called a property in Outlook)
for the permanent storage of that information.

I'd suggest that you step away from the computer for a few minutes and get
out a pencil and a piece of paper. On the paper, make two columns. In the
left column, list every piece of information that you want the user to enter
on the first page of your form. Skip a line. Now do the same for every other
page until you have a complete list of what information you want to store in
your item.

Now, in the right-hand column, decide which Outlook field will store each
piece of information. You can use your computer to look up the available
fields by referring to the All Fields page of your form. Each piece of
information you want to store must have its own field. In other words, you
can't reuse the same field for two different pieces of information. When you
run out of existing Outlook fields, start making your own fields by clicking
the New button on the All Fields tab on your form.

When you're done, you'll have a complete data map for your form. The next
step is to implement it. Here you have a choice. If you want to try to fix
your form, it may be easiest to just delete any existing text boxes from
your form and drag the correct fields (the ones laid out on the data map
that you must made) from the Field Chooser to the custom form page. For
other types of fields, add the correct kind of control if you don't already
have it on the form, right-click the control and choose Properties, then go
to the Value tab and select the field for that control at the top of that
tab. Click OK when you're done.

Be systematic about this. Make sure that the number of controls on each page
exactly matches the number of fields on your data map, no more, no less.
Check off each field for each page as you drag it from the Field Chooser or
assign it to the right control.

If you do your "homework" and then take your time implementing the data map,
I think you'll have a form that does what you want it to do.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
URG!!! Oh my goodness - I think I have bitten off more than I can chew! I
have neither the time nor the energy to learn. decipher, understand and carry
out what it was that you just outlined - as much as i need to and want to !
I think i just may have to pass this onto someone else - I am in a catch 22
where i am trying to get a new business up and rolling and spending far too
much time on something i know nothing about and am just "winging it" ! I
tried - got it wrong - tried it again - and the next thing i knew 2 weeks had
passed - the thinng is if i dont get this done - i may miss a whole year of
business - is there someone i can contact to help me out - to simply do it
for me if i explain??? Literally - i have run out of time now ......
 
If you want to hire an Outlook developer to help with this, you might want
to consult with some of the folks listed at
http://www.slipstick.com/dev/devlist.asp. However, mind reading skills are
not widely available. Anyone taking the job is going to require that you go
through something like the pencil and paper exercise that I outlined. So,
why not do it yourself? I am certain you can do it in an hour or two as long
as you are methodical and get past the flustered stage.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top