PC Review


Reply
Thread Tools Rate Thread

Names too long?

 
 
Linda RQ
Guest
Posts: n/a
 
      7th Aug 2006
Hi Everybody,

Starting to draw out a new database and in the past I have had problems in
certain areas of the database seeing the whole field name. I can see this
may be a problem with the names I have below since they would all look the
same if cut off but I tried to make them short but descriptive. Perhaps
it's in the expression builder section and or other places...Anyway, are
there any suggestions?

Also, I notice that many of the same people answer in the different
newsgroups, queries, reports, etc...I usually post in here but have
occasionaly posted in one of the other spots. I won't cross post but what
is the best way to post...I was thinking getting started meant, new users
but it maybe the place I should have come before I went to table design?
What is getting started for?

tblPtVentThpy
PtVentThpyID
VentThpyTypeID_fk
PtVentThpyStartDate
PtVentThpyEndDate
PtVentThpyStartTime
PtVentThpyEndTime
PtVentThpyOrderNum
PtVentThpyFreq
PtVentThpyOrderPhys
PtVentThpyOnProtocols?
PtVentThpyActive?

Thanks,
Linda


 
Reply With Quote
 
 
 
 
gls858
Guest
Posts: n/a
 
      7th Aug 2006
Linda RQ wrote:
> Hi Everybody,
>
> Starting to draw out a new database and in the past I have had problems in
> certain areas of the database seeing the whole field name. I can see this
> may be a problem with the names I have below since they would all look the
> same if cut off but I tried to make them short but descriptive. Perhaps
> it's in the expression builder section and or other places...Anyway, are
> there any suggestions?
>
> Also, I notice that many of the same people answer in the different
> newsgroups, queries, reports, etc...I usually post in here but have
> occasionaly posted in one of the other spots. I won't cross post but what
> is the best way to post...I was thinking getting started meant, new users
> but it maybe the place I should have come before I went to table design?
> What is getting started for?
>
> tblPtVentThpy
> PtVentThpyID
> VentThpyTypeID_fk
> PtVentThpyStartDate
> PtVentThpyEndDate
> PtVentThpyStartTime
> PtVentThpyEndTime
> PtVentThpyOrderNum
> PtVentThpyFreq
> PtVentThpyOrderPhys
> PtVentThpyOnProtocols?
> PtVentThpyActive?
>
> Thanks,
> Linda
>
>

I would probably just use VT instead of VentThpy, but you may have a reason
for the longer name. That would shorten the name up a bit.

Cross posting is certainly preferable to multi-posting.
It's acceptable to cross post to relevant groups. Usually
2 or three groups will suffice. So if it's a question concerning
tables cross-posting to the table design group would be acceptable.
If answered in one group the answer will show in all the cross-posted
groups.

gls858
 
Reply With Quote
 
Bill Ridgeway
Guest
Posts: n/a
 
      8th Aug 2006
A couple of solutions come to mind.

Highlight a column(s) and click on <Format><Column><Autofit selection> will
change the width of the column to the widest cell.

Highlight a column(s) and click on <Format><Cells><Alignment><Wrap text>
will allow you to specify the width of the column and create a higher row to
accommodate any overlength data. You will also need to click on
<Format><Row><Autofit selection> to change the height of rows to see the
overlength data.

Regards.

Bill Ridgeway
Computer Solutions

"Linda RQ" <(E-Mail Removed)> wrote in message
news:uk%(E-Mail Removed)...
> Hi Everybody,
>
> Starting to draw out a new database and in the past I have had problems in
> certain areas of the database seeing the whole field name. I can see this
> may be a problem with the names I have below since they would all look the
> same if cut off but I tried to make them short but descriptive. Perhaps
> it's in the expression builder section and or other places...Anyway, are
> there any suggestions?
>
> Also, I notice that many of the same people answer in the different
> newsgroups, queries, reports, etc...I usually post in here but have
> occasionaly posted in one of the other spots. I won't cross post but what
> is the best way to post...I was thinking getting started meant, new users
> but it maybe the place I should have come before I went to table design?
> What is getting started for?
>
> tblPtVentThpy
> PtVentThpyID
> VentThpyTypeID_fk
> PtVentThpyStartDate
> PtVentThpyEndDate
> PtVentThpyStartTime
> PtVentThpyEndTime
> PtVentThpyOrderNum
> PtVentThpyFreq
> PtVentThpyOrderPhys
> PtVentThpyOnProtocols?
> PtVentThpyActive?
>
> Thanks,
> Linda
>
>



 
Reply With Quote
 
LMB
Guest
Posts: n/a
 
      8th Aug 2006

"gls858" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Linda RQ wrote:
>> Hi Everybody,
>>
>> Starting to draw out a new database and in the past I have had problems
>> in
>> certain areas of the database seeing the whole field name. I can see
>> this
>> may be a problem with the names I have below since they would all look
>> the
>> same if cut off but I tried to make them short but descriptive. Perhaps
>> it's in the expression builder section and or other places...Anyway, are
>> there any suggestions?
>>
>> Also, I notice that many of the same people answer in the different
>> newsgroups, queries, reports, etc...I usually post in here but have
>> occasionaly posted in one of the other spots. I won't cross post but
>> what
>> is the best way to post...I was thinking getting started meant, new users
>> but it maybe the place I should have come before I went to table design?
>> What is getting started for?
>>
>> tblPtVentThpy
>> PtVentThpyID
>> VentThpyTypeID_fk
>> PtVentThpyStartDate
>> PtVentThpyEndDate
>> PtVentThpyStartTime
>> PtVentThpyEndTime
>> PtVentThpyOrderNum
>> PtVentThpyFreq
>> PtVentThpyOrderPhys
>> PtVentThpyOnProtocols?
>> PtVentThpyActive?
>>
>> Thanks,
>> Linda
>>
>>

> I would probably just use VT instead of VentThpy, but you may have a
> reason
> for the longer name. That would shorten the name up a bit.
>
> Cross posting is certainly preferable to multi-posting.
> It's acceptable to cross post to relevant groups. Usually
> 2 or three groups will suffice. So if it's a question concerning
> tables cross-posting to the table design group would be acceptable.
> If answered in one group the answer will show in all the cross-posted
> groups.
>
> gls858


Thanks, I thought I put this on the Access Getting started group. What is
the difference in crossposting vs multi-posting?



 
Reply With Quote
 
LMB
Guest
Posts: n/a
 
      8th Aug 2006
Hi Bill,

I am really sorry, this was intended for the MSAccess Getting started group.
I think I was looking in here when I decided to post in there.

Linda

"Bill Ridgeway" <(E-Mail Removed)> wrote in message
news:eb8ef2$g9s$(E-Mail Removed)...
>A couple of solutions come to mind.
>
> Highlight a column(s) and click on <Format><Column><Autofit selection>
> will change the width of the column to the widest cell.
>
> Highlight a column(s) and click on <Format><Cells><Alignment><Wrap text>
> will allow you to specify the width of the column and create a higher row
> to accommodate any overlength data. You will also need to click on
> <Format><Row><Autofit selection> to change the height of rows to see the
> overlength data.
>
> Regards.
>
> Bill Ridgeway
> Computer Solutions
>
> "Linda RQ" <(E-Mail Removed)> wrote in message
> news:uk%(E-Mail Removed)...
>> Hi Everybody,
>>
>> Starting to draw out a new database and in the past I have had problems
>> in
>> certain areas of the database seeing the whole field name. I can see
>> this
>> may be a problem with the names I have below since they would all look
>> the
>> same if cut off but I tried to make them short but descriptive. Perhaps
>> it's in the expression builder section and or other places...Anyway, are
>> there any suggestions?
>>
>> Also, I notice that many of the same people answer in the different
>> newsgroups, queries, reports, etc...I usually post in here but have
>> occasionaly posted in one of the other spots. I won't cross post but
>> what
>> is the best way to post...I was thinking getting started meant, new users
>> but it maybe the place I should have come before I went to table design?
>> What is getting started for?
>>
>> tblPtVentThpy
>> PtVentThpyID
>> VentThpyTypeID_fk
>> PtVentThpyStartDate
>> PtVentThpyEndDate
>> PtVentThpyStartTime
>> PtVentThpyEndTime
>> PtVentThpyOrderNum
>> PtVentThpyFreq
>> PtVentThpyOrderPhys
>> PtVentThpyOnProtocols?
>> PtVentThpyActive?
>>
>> Thanks,
>> Linda
>>
>>

>
>



 
Reply With Quote
 
gls858
Guest
Posts: n/a
 
      8th Aug 2006
LMB wrote:
> "gls858" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Linda RQ wrote:
>>> Hi Everybody,
>>>
>>> Starting to draw out a new database and in the past I have had problems
>>> in
>>> certain areas of the database seeing the whole field name. I can see
>>> this
>>> may be a problem with the names I have below since they would all look
>>> the
>>> same if cut off but I tried to make them short but descriptive. Perhaps
>>> it's in the expression builder section and or other places...Anyway, are
>>> there any suggestions?
>>>
>>> Also, I notice that many of the same people answer in the different
>>> newsgroups, queries, reports, etc...I usually post in here but have
>>> occasionaly posted in one of the other spots. I won't cross post but
>>> what
>>> is the best way to post...I was thinking getting started meant, new users
>>> but it maybe the place I should have come before I went to table design?
>>> What is getting started for?
>>>
>>> tblPtVentThpy
>>> PtVentThpyID
>>> VentThpyTypeID_fk
>>> PtVentThpyStartDate
>>> PtVentThpyEndDate
>>> PtVentThpyStartTime
>>> PtVentThpyEndTime
>>> PtVentThpyOrderNum
>>> PtVentThpyFreq
>>> PtVentThpyOrderPhys
>>> PtVentThpyOnProtocols?
>>> PtVentThpyActive?
>>>
>>> Thanks,
>>> Linda
>>>
>>>

>> I would probably just use VT instead of VentThpy, but you may have a
>> reason
>> for the longer name. That would shorten the name up a bit.
>>
>> Cross posting is certainly preferable to multi-posting.
>> It's acceptable to cross post to relevant groups. Usually
>> 2 or three groups will suffice. So if it's a question concerning
>> tables cross-posting to the table design group would be acceptable.
>> If answered in one group the answer will show in all the cross-posted
>> groups.
>>
>> gls858

>
> Thanks, I thought I put this on the Access Getting started group. What is
> the difference in crossposting vs multi-posting?
>
>
>

Here's a link that explains it:

http://www.blakjak.demon.co.uk/mul_crss.htm

gls858
 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      8th Aug 2006
Cross-posting is achieved by posting to more than one group in a single posting.
Just keep adding groups to the address bar.

Those of us with a real newsreader have cross-posting detection so we can weed
out the cross-posts.

Multi-posting is posting the same or similar message to each group.

Multi-posting cannot be detected so is more disruptive.


Gord Dibben MS Excel MVP

On Tue, 8 Aug 2006 00:55:50 -0400, "LMB" <(E-Mail Removed)> wrote:

>Thanks, I thought I put this on the Access Getting started group. What is
>the difference in crossposting vs multi-posting?
>


 
Reply With Quote
 
LMB
Guest
Posts: n/a
 
      9th Aug 2006
Thanks,

I don't usually do either unless I post a question in the wrong group! <g>

Linda

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> Cross-posting is achieved by posting to more than one group in a single
> posting.
> Just keep adding groups to the address bar.
>
> Those of us with a real newsreader have cross-posting detection so we can
> weed
> out the cross-posts.
>
> Multi-posting is posting the same or similar message to each group.
>
> Multi-posting cannot be detected so is more disruptive.
>
>
> Gord Dibben MS Excel MVP
>
> On Tue, 8 Aug 2006 00:55:50 -0400, "LMB" <(E-Mail Removed)>
> wrote:
>
>>Thanks, I thought I put this on the Access Getting started group. What is
>>the difference in crossposting vs multi-posting?
>>

>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cut Long Names Tramp Freeware 11 10th May 2006 04:56 AM
Long file names suddenly converted to short file names Saira Windows XP General 1 29th Mar 2005 11:01 AM
How can I view long DL names in the Select Names window? =?Utf-8?B?bXV6emE3Nw==?= Microsoft Outlook Discussion 1 12th Oct 2004 06:05 PM
Long file names in long paths Deirdre McIntyre Microsoft Windows 2000 File System 1 1st Dec 2003 09:54 PM
names too long Paul Loy Microsoft Windows 2000 0 14th Aug 2003 05:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:42 PM.