History

[AndyPandy]

I have two fields one call notes and one called history

What I want to happen is the following is i enter the note in the notes box i then press enter and in the history field i get date time and the note details.

whilst the note box autmaticaly clears i have the two fields as i still want to store the information can this be done.

and if so how instructions please

 

[Mile-O]

Re: Hitory

I have two fields one call notes and one called history

Just these two fields in a table? Or are there more fields to this table? What is the table?

What I want to happen is the following is i enter the note in the notes box i then press enter and in the history field i get date time and the note details.

Are you entering directly into the table? Or are you using a form? If a form, is it bound to the table or a query based on the table? When you say in the history field you get the date/time (meaning timestamp, I guess) and the note details, you're not actually storing two separate things in the same field, are you?

whilst the note box autmaticaly clears i have the two fields as i still want to store the information can this be done.

Why would the note box 'automatically' clear? Surely there's user intervention in there somewhere.

It all seems so vague right now. Elaborate.

 

[AndyPandy]

Re: Hitory

Just these two fields in a table? Or are there more fields to this table? What is the table?


Are you entering directly into the table? Or are you using a form? If a form, is it bound to the table or a query based on the table? When you say in the history field you get the date/time (meaning timestamp, I guess) and the note details, you're not actually storing two separate things in the same field, are you?


Why would the note box 'automatically' clear? Surely there's user intervention in there somewhere.

It all seems so vague right now. Elaborate.

Sorry i think the easist way to explan it is i enter the notes regarding the job i press enter the txt box i guesse if you wanna call it then transfers ito to history box where it is time and date stamped and displayes what i have just entered

like so

customer called at press enter it clears

then in hisroty 10:43/27/03/14 customer called at

or can this only be done using a unbound list box.

jobdetails form

 

[Mile-O]

Re: Hitory

What is the relationship between CallDetails and JobDetails here?

Is a Call a single issue from a customer. And then a single Call can have multiple jobs (fix this, fix that, etc)?


(To me the issue appears to be structural in that the Job Details form is used for data entry, yet its recordsource is a query with a few joins that may not allow for updating, hence your issue with trying to archive.)

 

[AndyPandy]

Re: Hitory

Ok I am creatting one form via multiple subforms, to enter call details, customer calls in and i log the details etc and then when it comes to the fault description i will be able to enter a description of the fault and if anyone calls in chasing i will then be able to add notes that will populate the history ie customer called at chasing job. etc

 

[Mile-O]

Re: Hitory

I would probably favour creating a history table on the understanding that there's a many to many relationshop between jobs and history. Therefore you would have a table for jobs (which you do), a table for history (which isn't in the attached), and a third table to model the many-to-many - essentially a history to jobs table. This would just contain the history ID and the job ID.

Effectively you can put a tab control on to your job details form and reserve one tab for your basic job information. Then, on the other tab, you can have a subform that allows for the entering of notes, which in effect would become your history. So, what's happening is comments are getting logged against a job (and you can sort them on date, if need be) but there's no need to move them between tables like what you are currently trying to do.

 

[AndyPandy]

Re: Hitory

Hi I will proberbly go for this however what fields would I need int the tblhistory i know how to do the junction table.

 

[CazB]

As a minimum you would need a History ID field (PK, probably an Autonumber?), a Date/Time field to store the date/time the note was made, and a field to store the note details - this could be a Text field or a Memo field, depending on how long the notes will be. Name them according to your current naming conventions...

 

[AndyPandy]

As a minimum you would need a History ID field (PK, probably an Autonumber?), a Date/Time field to store the date/time the note was made, and a field to store the note details - this could be a Text field or a Memo field, depending on how long the notes will be. Name them according to your current naming conventions...

I know you can do now()

date()
time()

is it possible to combine both date() & time() as one default value

 

[CazB]

You can use Date() as the default value on a field in a table, but you can't use Now() as a default.
You CAN however, use Now() as the default on a field in a form! That would give you the date and time.... but if data is entered directly into the table, it won't apply...

 

[AndyPandy]

You can use Date() as the default value on a field in a table, but you can't use Now() as a default.
You CAN however, use Now() as the default on a field in a form! That would give you the date and time.... but if data is entered directly into the table, it won't apply...

when i enter the note i need the date and time in the datime field to be added automaticaly etc so would it be better to have two seperate coloums one for date and one for time.

or will =date() & time() work

 

[CazB]

You only need one field in your table for the date and time.

On the FORM, set the default value of the field to =Now()





Just remember though, that if anyone ever adds information into the table directly in datasheet, not via the form, then the date/time won't be set.

 

[AndyPandy]

Also can you advise how do i get spaced to appear between each section of this as it stands at the moment it combines it all into one word.

Expr1: [eforname] & [eSurname] & [eEngineerID] & [ePhoneNumber]

 

[CazB]

You need to add the spaces in manually..... norm is to put & " " & between each field rather than just &

Expr1: [eforname] & " " & [eSurname] & " " & [eEngineerID] & " " & [ePhoneNumber]

or you could even add extra punctuation in

Expr1: [eforname] & " " & [eSurname] & ", " & [eEngineerID] & " : " & [ePhoneNumber]

 

[jdraw]

You only need 1 field. It should be a Date/Time data type. I'm not sure why CazB is saying you can't use Now() as a default value in your table.

I do. And this from M$oft seems to confirm its use.

I'm not sure why you don't just structure your table with the fields you need and populate them. Why are you concatenating a string??

 

[CazB]

Hmmm, must be something in my setup then, cos it never works for me!

 

[AndyPandy]

Write I shall try again

I have created a main form that contains customer name and address then a subfrm that holds the call type and the operater details, the next subform i am trying to create is one that holds the job details who dispatched it and notes.


1. it should store the job details or each customer as long with all the noted for that customer and that specific job linked to main form sub form 1 and main form
2. what happens is is says unable to update field, i have experiemented with different forms as well by removing the jusntion table and this seems to work, however whenever i have add the notes to the notes section saved it and then gone back into that same recod the notes i entered have now dissapeared.

can anyone help resolve this please

Then this form needs to be linked with the main form.