Access Database - How to:

jasmin10

I have created a customer management database form and a client wants a comments text box but so he can put the date in . i.e. he wants to make notes/record log of telephone conversation and include the date.
The way I have done this for my own database was just simply one text box, type the date, tab over one and type my text and leave a carriage return to separate the different dates.

Any ideas on how I can do what he wants?

I'm sure Superscrapers out there somewhere

patwa_2

Ooooh gotta be at least two years since I used Access but if I remember correctly there's a 'Memo' field type? You could use this and then when you generate the forms it should give you a nice multi-line box.

Sorry if this doesn't work, as I said a while since I used Access, it's MySQL for me now.

H.

jasmin10

I do have a multi line text box on my form already but I need to be able to list it by date order to look up notes.

johnmc

I would create a new field on the table called something like "CommentDate" and put that on the form. Make it "not visible".

When the user enters something in the text box (ie, "OnExit") set the value of "CommentDate" to today.

Now when you view the data you can either have a seperate date and comment or you can concatenate the two;
Dim strMessage as string

strMessage = [CommentDate] & " " & [CommentText]

If you're really flash you can use date & time as the format for the field, clear the InputMask on the form and report the exact time an entry was made.

Hope that helps.

I recommend signing up to Utter Access which is free and carries a wealth of information (a bit like MSE).

jasmin10

I'm sorry but I'm reallt lost. I understand about having a new field in the table and make it "not visable" but then you have lost me on that. Fronm the form how would I do it. Create a new text box yep and ...

johnmc

Jasmin,
PM waiting for you.