Re: Help with default fields...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bill B. (bbushong_at_IHATESPAMsidebandsys.com)
Date: 07/16/04 

Date: Thu, 15 Jul 2004 22:06:59 -0400

This time I'm a little more awake... Let me try again <grin>... I have a
Trouble Call database list that is designed so our operation manager can add
incidents for specific accounts. What I have done is created a list simply
of company names (IE: XYZ Corp, Widgets Inc., etc) and have designed the
Trouble Call database to reference that list. So when our OM (Operations
Manager) clicks on "Add", he gets a drop-down field called "Company" with
several choices retrieved from that company list. This works great!

The problem is this... I have not found a way to make that "Company" field
be the "default" field. Simply put, when you create a new custom list, there
is a default column called "Title"... It can be renamed, but not deleted, or
have its type changed. I would like to make that "Company Field" be my
"Default" column! This may not seem like a big deal however, when I create a
calendar view of that database, instead of getting companies' names in the
boxes, I get whatever is in that default "Title" field (Which is basically
nothing). Even when I look at the normal listing, I have to show that field
since it is the only one that will let me edit the entry (In other words,
the only column that is underlined). When alerts get sent, instead of the
e-mail showing what company is getting a Trouble Call, it simply shows what
is in the default title column and lastly, when a new entry is added, the
"New" icon is only shown if the default column is present!

I would do pretty much anything to get this to work... Ideally, I would like
to have the "Company" field be the "Default" or reference field WSS uses to
title an entry... Seems like it should be simple, but I cannot figure it
out!

I hope this makes a little more sense...

Thank you for reading,

Bill Bushong

"Mike Walsh" <englantilainen@hotmail.com> wrote in message
news:uFZoNujaEHA.3944@tk2msftngp13.phx.gbl...
> >The issue is that I can't make this the "edit" field (In other >words, I
> can't make this column linked to the edit item, >the "new" icon, and what
> shows in the calendar view).
>
> Can you explain this in a different way? I don't understand what you want.
>
> Mike Walsh, Helsinki, Finlan
> WSS FAQ at wss.collutions.com
> Please reply to the newsgroup
>
> "Bill B." <bbushong@IHATESPAMsidebandsys.com> wrote in message
> news:eYmdnYbJHvXtdGjd4p2dnA@comcast.com...
> > I have really killed myself on this one... I have a list that containes
> > serveral company names and have linked that list to a "Database" like
list
> > (In other words the user can choose what company the entry is for). The
> > issue is that I can't make this the "edit" field (In other words, I
can't
> > make this column linked to the edit item, the "new" icon, and what shows
> in
> > the calendar view). I have tried e v e r y t h i n g I can possible
think
> > of, but cannot figure it out. If I could get one of the following
scenrios
> > to work, I would be happy!!
> >
> > 1) Choose the Company field (Which is linked to the database of names)
as
> > the new Linked to edit and item... This would be GREAT (I have frontpage
> > 2003, and Office 2003) - I just want to make sure that if I have to edit
> > files, I am only editing this one database... not the other (Those work
> > great!)
> >
> > 2) Have that seperate list show up when you add an item (Which I could
do
> > via HTML with an inline HTML database, but yuch) and when someone
clicks,
> > that field is filed with the data.
> >
> > Please let me know how I can make this solution work (Preferable
solution
> > 1)!!
> >
> > Thank you in advance!
> >
> > Bill Bushong
> >
> >
>
>

Relevant Pages

  • Re: Click Function Problem - Code Help Required
    ... 60 odd queries in this database. ... what I need replaced with a valid function. ... Data member not found ... >I'm having trouble getting my message across on this one. ...
    (microsoft.public.access.forms)
  • Re: Out of Memory (Error 7) when adding a VBA function
    ... Thanks for the rapid response and comprehensive troubleshooting method. ... corrupted file through your methodology at first chance and will report back. ... Compact the database to get rid of this junk: ... trouble. ...
    (microsoft.public.access.formscoding)
  • Re: ms access 2003
    ... The database seemed to have run out of job numbers for 2009. ... Now playing with it in 2010, it seems to be working again but obviously ... I have a database that is based on MS access that I am having trouble ... I actually paid someone to create this for me but they refuse help ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Looking for advice on how to get started
    ... least trouble) way is to put this into a database. ... be able to ruin the format of your data. ... Another matter is security. ...
    (comp.programming)
  • Re: William Sanders vs. just about everybody
    ... Wayne Throop wrote: ... It's more trouble to make an entry in the database than to move the ...
    (rec.arts.sf.written)