some fields of Memo type

[rodich]

Now I have other question.

I have form with unbounded textboxes. After filling I save them with button rstTable!Field1.value = me!textbox1.value and etc.

When I put data in the fields I have problem with 2 of them. I use some text boxes to fill long text in 4 Memo fields.
But in 2 of them data is going to table corectly, for example:
in form field I write "qwerty", and after the save I have in table filed "qwerty"
and data is going the other 2 fileds wrong, for example
in form field I write "asd1234", and after the save I have in table filed "<div>asd1234</div>"

My fileds in the form and the table are:
data of Text box1 added in Field1 - Memo type (is ok)
data of Text box2 added in Field2 - Memo type (is wrong)
data of Text box3 added in Field3 - Memo type (is ok)
data of Text box4 added in Field4 - Memo type (is wrong)

Where is the defect ot my button ?!?!?! Is this method to save old? How I can to save better?

 

[missinglinq]

Exactly how do you expect us to detect the "defect ot my button " when we cannot see the code you have behind your button?

Many of us have been accused to being out of our minds, but none of us have been accused of being in others minds!

 

[georgedwilkinson]

Why aren't you using bound fields?

 

[rodich]

Exactly how do you expect us to detect the "defect ot my button " when we cannot see the code you have behind your button?

Many of us have been accused to being out of our minds, but none of us have been accused of being in others minds!

You are right.
My button make this
....
with rstTable
!Field1.value = me!textbox1.value
!Field2.value = me!textbox2.value
!Field3.value = me!textbox3.value
end with
.......


......... I know thatt the "wrong" is behaind the keyboard

 

[rodich]

Why aren't you using bound fields?

... I'm not sure, but when I write code to Delphi I don't use direct access to table .... and I think that is better to work for the network app;lication
Is this a right?

 

[georgedwilkinson]

Seems there may be a language barrier here.

I just created a table like yours (with 4 memo fields) and created a bound form with navigation buttons. It took me about 1 1/2 minutes from start to finish and tests fine...all memo fields have the exact data that I put into them. I'm not sure why you need to write code at all.

If you insist on writing code, you are at the mercy of your own, potentially buggy, code and I would suggest using other programming tools than Access since the only thing Access has over any other programming environment is that the data is tightly "bound" to the presentation layer.

You should be using breakpoints and watches along with single step if this is the approach you want to take. You'll be able to tell so much more about what is going on than any stranger on a forum will be with those simple tools.

 

[missinglinq]

I agree with George! A big part of the reason to use Access for database development is the speed with which it can be created, using bound forms. Several developers I know, experienced in Visual Basic database development and Access development, estimate that development using unbound forms takes twice as long as it does when using Access and bound forms.

If you insist on using unbound forms, you'd be far better off using a VB or C++ front end with a SQL Server or Oracle back end.

1. You can create an EXE file which gives total protection to your code/design
2. You can distribute the db to PCs without a copy of Access being on board
3. Your data security if far, far better than anything you can do in Access

 

[rodich]

Ok, I will try to optimize my application (I use link manager yet ) .... somewhere I read that Access 2007 dosn't support MDE, becausethat I save my work in 2000-2003 format .......

Gays, thank you about your opinions! But is not normally to save some Memo field in table with "<div>....</div>"

And sorry, that I ask you as dummies, but I'm woman and IT I will tel you one funny story
"Woman engineer is like a guinea pig - neither a pig nor has to do with the sea"

 

[missinglinq]

In re-reading the whole thread, the <div>asd1234</div> looks like formatting code. Is some of the data in these memo fields being copied and pasted from elsewhere?

 

[rodich]

In re-reading the whole thread, the <div>asd1234</div> looks like formatting code. Is some of the data in these memo fields being copied and pasted from elsewhere?

I fill data "asd1234" in the filelds trought subform. I save it with button
There is code:
""Set dbsTasksMNG = CurrentDb
Set rstTasks = dbsTasksMNG.OpenRecordset("Tasks" , dbOpenDynamic, dbAppendOnly, dbOptimistic)

With rstTasks
.AddNew
!Problem = Me!AddProblem
!ProblemBG = Me!AddProblemBG
,,,,,,,
!CorrPrevAction = Me!AddCorectivePrevAction
!CorrPrevActionBG = Me!AddCorectivePrevActionBG
!AdditInformation = Me!AddAdditInformation
!AdditInformationBG = Me!AddAdditInformationBG
,,,,,,,,

the last 4 rows are my 4 Memo fields

 

[georgedwilkinson]

Why don't you just display the "previous" stuff from it's source? What happens if somebody edits the previous record? Then you get data anomalies...a bad thing.

 

[rodich]

Thank you, gays! I resolved the mistake with older method - I just added new text boxes

Have a nice day!