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  

jumping data



 
 
Thread Tools Display Modes
  #1  
Old April 16th, 2010, 06:28 PM posted to microsoft.public.access.forms
dosima
external usenet poster
 
Posts: 20
Default jumping data

hi

i have a form which shows customer details, and this has a subform where you
can enter the date and notes about the customer. the subform is in a
datasheet view. so everytime you want to add some notes about the customer,
you enter the date and write the notes.

there are many customers on the database, and we make quite a few notes for
each customer.

Now when i go into the customer and put in a note, then come out and go back
into it, the data has moved up a few columns and goes into the wrong place,
rather than stay in the same place where it was entered.

also when notes are added in each record, it's not always dated as we enter
the notes up to a certain line, then carry on in the next record. this is why
he column is not ordered by date, it should be the recent information entered
at the bottom

i would be grateful if someone could help me and tell what i do to resolve
this.

dosima

  #2  
Old April 16th, 2010, 10:09 PM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default jumping data

You could put a default value for the date in the date control's default
value on the date controls property dialog.
If you put
= Now()
for the default value, the date and time will be stored with each record.

Then you can sort the subform's record source by date ascending.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"dosima" wrote in message
...
hi

i have a form which shows customer details, and this has a subform where
you
can enter the date and notes about the customer. the subform is in a
datasheet view. so everytime you want to add some notes about the
customer,
you enter the date and write the notes.

there are many customers on the database, and we make quite a few notes
for
each customer.

Now when i go into the customer and put in a note, then come out and go
back
into it, the data has moved up a few columns and goes into the wrong
place,
rather than stay in the same place where it was entered.

also when notes are added in each record, it's not always dated as we
enter
the notes up to a certain line, then carry on in the next record. this is
why
he column is not ordered by date, it should be the recent information
entered
at the bottom

i would be grateful if someone could help me and tell what i do to resolve
this.

dosima



 




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 09:24 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.