A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

################



 
 
Thread Tools Display Modes
  #1  
Old August 6th, 2004, 03:54 PM
paul
external usenet poster
 
Posts: n/a
Default ################

Hi,
For my Access 2000 application, my user told me, when
she tried to review the previous record (she entered
Yesterday), all the fields only dispaly "################"
(luckily only one record).
How this happen? Any way to prevent it?
Thanks.
  #2  
Old August 6th, 2004, 07:30 PM
Ken Snell
external usenet poster
 
Posts: n/a
Default ################

Is the field's column width is too narrow to display the entire number or
value in the field?
--

Ken Snell
MS ACCESS MVP


"paul" wrote in message
...
Hi,
For my Access 2000 application, my user told me, when
she tried to review the previous record (she entered
Yesterday), all the fields only dispaly "################"
(luckily only one record).
How this happen? Any way to prevent it?
Thanks.



  #3  
Old August 6th, 2004, 09:32 PM
paul
external usenet poster
 
Posts: n/a
Default ################

Ken,
This happen to all the fields in one record. I checked
the backup tape, on 08/03/2004, (the day it got input) the
data was good, but 08/04/2000,the data only
dispaly "############".
Thanks.
-----Original Message-----
Is the field's column width is too narrow to display the

entire number or
value in the field?
--

Ken Snell
MS ACCESS MVP


"paul" wrote in

message
...
Hi,
For my Access 2000 application, my user told me, when
she tried to review the previous record (she entered
Yesterday), all the fields only

dispaly "################"
(luckily only one record).
How this happen? Any way to prevent it?
Thanks.



.

  #4  
Old August 6th, 2004, 11:26 PM
Ken Snell
external usenet poster
 
Posts: n/a
Default ################

Do you see this only in the form? Or also in the table?

--

Ken Snell
MS ACCESS MVP

"paul" wrote in message
...
Ken,
This happen to all the fields in one record. I checked
the backup tape, on 08/03/2004, (the day it got input) the
data was good, but 08/04/2000,the data only
dispaly "############".
Thanks.
-----Original Message-----
Is the field's column width is too narrow to display the

entire number or
value in the field?
--

Ken Snell
MS ACCESS MVP


"paul" wrote in

message
...
Hi,
For my Access 2000 application, my user told me, when
she tried to review the previous record (she entered
Yesterday), all the fields only

dispaly "################"
(luckily only one record).
How this happen? Any way to prevent it?
Thanks.



.



  #5  
Old August 6th, 2004, 11:52 PM
paul
external usenet poster
 
Posts: n/a
Default ################

Both in form & table.
-----Original Message-----
Do you see this only in the form? Or also in the table?

--

Ken Snell
MS ACCESS MVP

"paul" wrote in

message
...
Ken,
This happen to all the fields in one record. I

checked
the backup tape, on 08/03/2004, (the day it got input)

the
data was good, but 08/04/2000,the data only
dispaly "############".
Thanks.
-----Original Message-----
Is the field's column width is too narrow to display

the
entire number or
value in the field?
--

Ken Snell
MS ACCESS MVP


"paul" wrote in

message
...
Hi,
For my Access 2000 application, my user told me,

when
she tried to review the previous record (she entered
Yesterday), all the fields only

dispaly "################"
(luckily only one record).
How this happen? Any way to prevent it?
Thanks.


.



.

  #6  
Old August 7th, 2004, 12:41 AM
Mike Painter
external usenet poster
 
Posts: n/a
Default ################

Ken Snell wrote:
Is the field's column width is too narrow to display the entire
number or value in the field?

"paul" wrote in message
...



Make sure teh format is not set to password.


  #7  
Old August 7th, 2004, 12:41 AM
Ken Snell
external usenet poster
 
Posts: n/a
Default ################

Well, now, this is a new problem...I've not seen this before. It's possible
that something may have happened to the database while the record was being
viewed (corruption?).

If you can zip up the backup and current copies of the database and email to
me, I'll take a look. Be sure to identify the table and record of interest.
My email address is obtained by removing this is not real from my reply
address.

--

Ken Snell
MS ACCESS MVP

"paul" wrote in message
...
Both in form & table.
-----Original Message-----
Do you see this only in the form? Or also in the table?

--

Ken Snell
MS ACCESS MVP

"paul" wrote in

message
...
Ken,
This happen to all the fields in one record. I

checked
the backup tape, on 08/03/2004, (the day it got input)

the
data was good, but 08/04/2000,the data only
dispaly "############".
Thanks.
-----Original Message-----
Is the field's column width is too narrow to display

the
entire number or
value in the field?
--

Ken Snell
MS ACCESS MVP


"paul" wrote in
message
...
Hi,
For my Access 2000 application, my user told me,

when
she tried to review the previous record (she entered
Yesterday), all the fields only
dispaly "################"
(luckily only one record).
How this happen? Any way to prevent it?
Thanks.


.



.



  #8  
Old August 7th, 2004, 04:22 AM
Leinad Kong
external usenet poster
 
Posts: n/a
Default ################

Hm..I faced the same problem several times, it happens after
corruption occured.
So, now what we have to do is focusing on how to reduce mdb.
corruption. I'm now split the system into Front-end(Application) on
each user pc and back-end(Database) on server pc. It's seems still
working quite well "in these days". I'm still watching the result of
using this method.

Hope this helps.

Leinad Kong
  #9  
Old August 13th, 2004, 01:14 PM
Lou
external usenet poster
 
Posts: n/a
Default ################

Funny, I have a DBase on a network that went down and the
last record was filled with ########### in every cell like
yours. There has to be a greater reason I think. I ran the
repair utility and everything was ducky from there, but
what about the #######'s..? Any other ideas..?

Thank you.
Lou
-----Original Message-----
Ken Snell wrote:
Is the field's column width is too narrow to display

the entire
number or value in the field?

"paul" wrote in

message
...



Make sure teh format is not set to password.


.

 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.