 |
|
|
|
Next: Loosing emails at work
|
| Author |
Message |
External
Since: Feb 17, 2007
Posts: 7
|
(Msg. 1) Posted: Thu Jan 01, 2009 10:43 am
Post subject: "invisible" data
Archived from groups: microsoft>public>access (more info?)
|
|
|
Hi,
An application writes data to a memo-field in an access-database (*.accdb).
Opening the database with Access 2007 the memo-field is empty: The content
of the memo-field does not seem to be written to this database. But in fact
the data is here, since the correct content of this field is visible again as
soon as I import the database into Excel 2007.
What could be the reason, why the data is not visible within Access 2007?
Thanks for your help.
Patrick |
|
| Back to top |
|
 | |
External
Since: Jan 20, 2008
Posts: 583
|
(Msg. 2) Posted: Thu Jan 01, 2009 12:02 pm
Post subject: RE: "invisible" data [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi Patrick,
By any chance are you opening the form in Access 2007 in AddNew mode? This
means that the form is opened ready to add a new record, without displaying
any records in the form's recordset.
Another possibility that comes to mind is if your memo field is in a
separate table versus the rest of the fields displayed on the form. Perhaps
some error is preventing a foreign key value from being written to the table.
Questions for you:
1.) Is the memo field in an isolated table, or is it in the same table as
other fields that are shown on your form?
2.) When you open the form in question, can you see data in any other
fields? (If so, this would indicate that you are not opening the form in
AddNew mode).
3.) You stated that "An application writes data to a memo-field...". Can you
expand on this a bit? What application?
Try writing a new value to this field that is easily recognized. Then
inspect the table(s) to see what data has been written where.
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
"Patrick D." wrote:
> Hi,
>
> An application writes data to a memo-field in an access-database (*.accdb).
> Opening the database with Access 2007 the memo-field is empty: The content
> of the memo-field does not seem to be written to this database. But in fact
> the data is here, since the correct content of this field is visible again as
> soon as I import the database into Excel 2007.
> What could be the reason, why the data is not visible within Access 2007?
>
> Thanks for your help.
>
> Patrick |
|
| Back to top |
|
| |
External
Since: Feb 17, 2007
Posts: 7
|
(Msg. 3) Posted: Thu Jan 01, 2009 12:49 pm
Post subject: RE: "invisible" data [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi Tom
Thanks for your input.
In fact, I have no form. I was talking about the table.
The table-field seems to be empty, although the field contains data.
Remember that the field was filled by a different application.
The question is here, if there is a case, where Access data can be wrongly
not visible due to a coding problem (or what ever).
(Of course I don't want to discuss the .NET Application here which fills the
data, since this is not the newsgroup for this kind of topic)
Patrick
"Tom Wickerath" wrote:
> Hi Patrick,
>
> By any chance are you opening the form in Access 2007 in AddNew mode? This
> means that the form is opened ready to add a new record, without displaying
> any records in the form's recordset.
>
> Another possibility that comes to mind is if your memo field is in a
> separate table versus the rest of the fields displayed on the form. Perhaps
> some error is preventing a foreign key value from being written to the table.
>
> Questions for you:
> 1.) Is the memo field in an isolated table, or is it in the same table as
> other fields that are shown on your form?
>
> 2.) When you open the form in question, can you see data in any other
> fields? (If so, this would indicate that you are not opening the form in
> AddNew mode).
>
> 3.) You stated that "An application writes data to a memo-field...". Can you
> expand on this a bit? What application?
>
> Try writing a new value to this field that is easily recognized. Then
> inspect the table(s) to see what data has been written where.
>
>
> Tom Wickerath
> Microsoft Access MVP
> http://www.accessmvp.com/TWickerath/
> http://www.access.qbuilt.com/html/expert_contributors.html
> __________________________________________
>
> "Patrick D." wrote:
>
> > Hi,
> >
> > An application writes data to a memo-field in an access-database (*.accdb).
> > Opening the database with Access 2007 the memo-field is empty: The content
> > of the memo-field does not seem to be written to this database. But in fact
> > the data is here, since the correct content of this field is visible again as
> > soon as I import the database into Excel 2007.
> > What could be the reason, why the data is not visible within Access 2007?
> >
> > Thanks for your help.
> >
> > Patrick >> Stay informed about: ""invisible"" data |
|
| Back to top |
|
| |
External
Since: Jan 20, 2008
Posts: 583
|
(Msg. 4) Posted: Thu Jan 01, 2009 1:00 pm
Post subject: RE: "invisible" data [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Are you opening the database to inspect for data before the record has been
committed (saved) by your .NET application? Can you see any other records in
the table that were previously saved, or is just the last record invisible?
Are there any weird formats applied to this memo field, as revealed in table
design view?
If you create a new query in Access, based on the table, can you see all
data in the memo field? If not, try testing for the length of the field's
content, using the len function.
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
"Patrick D." wrote:
> Hi Tom
>
> Thanks for your input.
> In fact, I have no form. I was talking about the table.
> The table-field seems to be empty, although the field contains data.
> Remember that the field was filled by a different application.
> The question is here, if there is a case, where Access data can be wrongly
> not visible due to a coding problem (or what ever).
>
> (Of course I don't want to discuss the .NET Application here which fills the
> data, since this is not the newsgroup for this kind of topic)
>
> Patrick >> Stay informed about: ""invisible"" data |
|
| Back to top |
|
| |
External
Since: Feb 17, 2007
Posts: 7
|
(Msg. 5) Posted: Thu Jan 01, 2009 1:11 pm
Post subject: RE: "invisible" data [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi Tom
Thanks for this quick answer.
The field "TimeStamp" of the type "date" belonging to the same record is
updated correctly with the current time.
Patrick
"Tom Wickerath" wrote:
> Are you opening the database to inspect for data before the record has been
> committed (saved) by your .NET application? Can you see any other records in
> the table that were previously saved, or is just the last record invisible?
>
> Are there any weird formats applied to this memo field, as revealed in table
> design view?
>
> If you create a new query in Access, based on the table, can you see all
> data in the memo field? If not, try testing for the length of the field's
> content, using the len function.
>
>
> Tom Wickerath
> Microsoft Access MVP
> http://www.accessmvp.com/TWickerath/
> http://www.access.qbuilt.com/html/expert_contributors.html
> __________________________________________
>
> "Patrick D." wrote:
>
> > Hi Tom
> >
> > Thanks for your input.
> > In fact, I have no form. I was talking about the table.
> > The table-field seems to be empty, although the field contains data.
> > Remember that the field was filled by a different application.
> > The question is here, if there is a case, where Access data can be wrongly
> > not visible due to a coding problem (or what ever).
> >
> > (Of course I don't want to discuss the .NET Application here which fills the
> > data, since this is not the newsgroup for this kind of topic)
> >
> > Patrick >> Stay informed about: ""invisible"" data |
|
| Back to top |
|
| |
External
Since: Jan 20, 2008
Posts: 583
|
(Msg. 6) Posted: Thu Jan 01, 2009 1:17 pm
Post subject: RE: "invisible" data [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Feb 17, 2007
Posts: 7
|
(Msg. 7) Posted: Thu Jan 01, 2009 1:37 pm
Post subject: RE: "invisible" data [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
you're right Tom, I usually don't work with Access and I was not fast enough,
but I just discovered that the data is visible again when I display the table
in a form-view.
By the way, I save html-code into the memo field. This is even not the
problem: When I place the string like this "<strong>the text</strong>" to
write to the db with the .NET app the data is visible. The saved string is
only invisible in Access when I place the above string in a string var, which
is in the sql-command.
. . .i still need to create the query in Access you told me with the test
of the lenght.
I never work in Access . . .I do my best.
Patrick
"Tom Wickerath" wrote:
> You've still left several questions unanswered....
>
>
> Tom Wickerath
> Microsoft Access MVP
> http://www.accessmvp.com/TWickerath/
> http://www.access.qbuilt.com/html/expert_contributors.html
> __________________________________________
>
> "Patrick D." wrote:
>
> > Hi Tom
> >
> > Thanks for this quick answer.
> > The field "TimeStamp" of the type "date" belonging to the same record is
> > updated correctly with the current time.
> >
> > Patrick >> Stay informed about: ""invisible"" data |
|
| Back to top |
|
| |
External
Since: Jan 11, 2008
Posts: 68
|
(Msg. 8) Posted: Thu Jan 01, 2009 1:45 pm
Post subject: Re: "invisible" data [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Thu, 1 Jan 2009 13:17:01 -0800, Tom Wickerath <AOS168b AT comcast
DOT net> wrote:
>You've still left several questions unanswered....
And here's another one: Is it possible that a CRLF character begins
the field, so that it just looks blank but there are more characters
below? If you click into the field and use the down arrow you can
test this.
Armen Stein
Microsoft Access MVP
www.JStreetTech.com >> Stay informed about: ""invisible"" data |
|
| Back to top |
|
| |
External
Since: Feb 17, 2007
Posts: 7
|
(Msg. 9) Posted: Thu Jan 01, 2009 2:03 pm
Post subject: Re: "invisible" data [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi Armen
Congratulations !!!
I'm terribly sorry, but the only "problem" was, that I didn't made the line
higher.
I thought, that in table view all data is displayed in a line. Wrong!
As soon as I can see more lines the data is visible 
Patrick
"Armen Stein" wrote:
> On Thu, 1 Jan 2009 13:17:01 -0800, Tom Wickerath <AOS168b AT comcast
> DOT net> wrote:
>
> >You've still left several questions unanswered....
>
> And here's another one: Is it possible that a CRLF character begins
> the field, so that it just looks blank but there are more characters
> below? If you click into the field and use the down arrow you can
> test this.
>
> Armen Stein
> Microsoft Access MVP
> www.JStreetTech.com
>
> >> Stay informed about: ""invisible"" data |
|
| Back to top |
|
| |
| Related Topics: | Set the controls to invisible - Hi folks, Hope you guys can help. I have a form"frmSafetyLevel1" in which users will enter data and once they submit, the results will be displayed on "frmSL1Registration". My problem here is i need to set some controls in the "...
Command button won't initialise as invisible! - Hi, I have a problem with some of my command buttons, in design view I set their properties to not visible. When I load up the form they appear (visible). I can create another button to set them to not visible, this works.. I tried setting them to..
Set tabbed page to invisible - Hi folks, Firstly, a great thanks to all members of this group who has been of great help to me. Due to your help, i have been able to proceed with my project. Now, i have another question.Please help I have a form with 10 tabs on it. I use this tabbed....
How to make control invisible when text value is zero? - I have a report with a text box named Discount. If this text box shows a value of 0, I do not want the text box to be visible. I have tried the following code, but it disables the control even when the value is greater than zero. My IF statement seems...
Make a PopUp Dialog Form Invisible - I can't seem to make a PopUp Dialog form Invisible! 'My main form calls the PopUp DoCmd.OpenForm "F-PAUSE", WindowMode:=acDialog 'My PopUp form "F-PAUSE" contains this code Private Sub Form_Open(Cancel As Integer) Forms
FAQ
Search
Profile
Private Messages
Log in
