Forms :: Comments In Descending Order In Memo Field

May 5, 2015

Having some trouble with a memo field. For each record, the notes field is present on the Form.... I added an unbound text box (txtMemoAdd) and a command button (Add New Note). When the button is selected, it adds the note to the Read Only Notes Field and adds a timestamp using the following code:

Me.Notes = Me.Notes & vbCrLf & Now () & VbCrLf & Me.txtMemoAdd
Me.txtMemoAdd = ""

The note is added to the bottom, and I was wondering if there was a way to make the new note go to the TOP of the field (Descending Order rather than Ascending).

View Replies


ADVERTISEMENT

Forms :: Copying Memo Field Comments To Other Queried Record

Jan 15, 2015

I have one memo per change (user input)...I need to have the comment the user inputs to copy into other records that were queried. I tried insert. My coding does one of the records or all of the records ..I need it to copy just to the queried records ...and I have a query but no filter set.

View 4 Replies View Related

Ascending E Descending Order Of A Table.

Jan 4, 2006

Happy new year everyone.

I have a table in which the data input comes from a dropdown list selected in a form combo box as:

contract signed
PIN issued
PDD issued
validation finished
Host country approval
EB approved
CER's issued.

I am designing a report in which I want to display the above list in Ascending or Descending order but as shown rather than alphabetically.
What I mean is no matter how the information is on the table the report showd display it in Ascending as contract signed, PIN issued, etc and in Descending as CER's issued, EB approved, Host country approval , etc.

Any ideas?

Thank you

dfuas

View 6 Replies View Related

Displaying DATE Of Text Format In Descending Order

Jul 4, 2005

Hi All,

I have a field named "PICK_DATE" in text format where pickup date is stored in DD/MM/YYYY format.

Now I wanted to generate a report with the order by clause of PICK_DATE. But it is not giving me the desired result. I want to see the latest PICK_DATE at the top of the report in desending order.

Can any one pls help me out to solve this problem ? :confused:

Thanks in advance,

Jignesh

View 3 Replies View Related

Duplicate A Form And Sort A Form In Ascending Or Descending Order?

Oct 2, 2005

Hello,

Is their a a way I can have a button or something in which duplicates all the data in the text boxes instead of re-entering data?

Also how can I sort data (DATES) that is in a form in descending order.

Thank you,

Onofrio

View 5 Replies View Related

Sorting A Field In Certain Way Which Is Neither Ascending Nor Descending

Jan 25, 2015

I have this form for data entry. I want to sort a field in a certain way which is neither ascending nor descending. The items in this field should be ordered as say, C, A, D, B. What I want is a custom order. How can we do it?

The field I am referring to is not on this form, but in the underlying table.

I am thinking of a VB code to achieve this purpose, where I can define the order. But not sure how to do it.

View 5 Replies View Related

Memo Fields - Order Of Data

Dec 6, 2007

Hello people.

Im just after a bit of advice please??

I have created an audit trail for data held on a form so that when a field is changed it adds a line of text to a memo field with the date of the change and the old and new field values. The problem I have is that each time something is changed the line of text is added beneath the existing text in the memo field. This means that for users to view the most recent change they have to scroll all the way down to the bottom of the memo field. Is there a "Quick" way of me having the most recent entry first.
I am using the vbnewline command when adding the text. A sample is shown below:

Dim Response As Integer
Dim AnotherItem As Integer
Dim sqlstr As String

Set Myform = Forms![DataDetail]
Producer = Forms![ListOfProducers(Existing Data Item)]![LstProducers].Column(1)

Response = MsgBox("Are you sure you wish to add a Producer?", vbYesNo, "Data Dictionary v1.0")
sqlstr = "INSERT INTO DataProducers ( Data_Id, Producer_Id ) SELECT Data.Data_Id, Producers.Producer_Id FROM Data, Producers WHERE (((Data.Data_Id)=[Forms]![DataDetail]![Data_ID]) AND ((Producers.Producer_Id)=[Forms]![ListOfProducers(Existing Data Item)]![LstProducers]));"
If Response = 6 Then
DoCmd.RunSQL sqlstr
Myform!LstHistory = Myform!LstHistory & vbNewLine & "Changes made on " & Now & ""
Myform!LstHistory = Myform!LstHistory & vbNewLine & "The Producer '" & Producer & "' was added to this data item"""
Myform!LstHistory = Myform!LstHistory & vbNewLine & "-----------------------------------------------------"
MsgBox "Producer has been successfully added.", vbInformation, "Data Dictionary v1.0"


Thanks folks...

View 2 Replies View Related

Forms :: Memo Field With Many Entries

Aug 25, 2014

A user enters text into a memo field for an existing client, then it's closed, the same record reopened and more entered into the memo.The problem is when it's reopened the existing text is hi-lighted, and it's really easy for someone to begin typing and write over it.I want to reopen it, create a new line, enter a date stamp maybe, create another line with the cursor in it, ready for the user to enter new text.

View 6 Replies View Related

Forms :: New Line In A Memo Field

Jun 1, 2013

When I am displaying a memo field, is there any way that I can force a new line? Can I add a character to the text to do that?

View 7 Replies View Related

Forms :: Memo Field Has Color

Jan 14, 2015

I have just noticed that one of my forms (memo field) with copied text from internet has lots of different color letters when the text is highlighted.

View 2 Replies View Related

Forms :: Prevent Wrapping In Memo Field Box?

Aug 28, 2013

Is there a way I can prevent wrapping in a memo field box?

I have a memo field with a list of email addresses and usernames however the email addresses often just wrap around the end of the memo box just creating a new line in the memo box rather than properly showing the email without the wrapping.

Even if the message scrolls out of the box, id rather that then wrap the text.

Also is there a way in which I can enable someone to open the "ZoomBox" whilst the text box is locked/disabled.

View 5 Replies View Related

Forms :: Memo Field In Rich Text Box

May 6, 2014

When I changed the memo field from plain text to Rich Text, I got the below divs and slashes. Is there any way to get rid of them?

<div>GC in process - EB1.</div>
<div> </div>

I had only "GC in process - EB1" in plain text.

View 1 Replies View Related

Forms :: Memo Field Display In Form

Apr 1, 2014

I have a form with a memo field which is used by users to input transctiptions of Customer Contacts but the form is getting busy and the box now only 2.77 wide X 0.683 High.

this makes it impossible to read on the form even as a text box with scrolling..how to add a mouse over on it so that it fires up a large text/meg style box to display the contents?

View 1 Replies View Related

Forms :: Delete Search Field In Order To Point To Appropriate Field?

May 6, 2013

I am using access 2010. I technically have an unbound form but I am changing the record source by command buttons. Switching between 3 command buttons. My problem is that I have a subform that I was linking to the form to an unbound search field. Now I want to switch the master and child links to a field on the form when I switch the record source which happen to be the same field as the unbound search field; however; it still pulls from the unbound search field rather than the field on the form. Do I need to delete the search field in order to get is to point to the appropriate field?

View 1 Replies View Related

Force Update Into Unbounded Comments Field

Oct 24, 2005

Hopefully there's someone who can help me with this!!! I've had several unsuccesfull attempts and don't know what else to try...

We're trying to force users to make entries in a field called txtComments in the frmQuestionnaire form if they provide negative responses and to stay on that record until the comments are changed. Inside the form is an option group (fraResponses) which contains options (OptA, OptB..etc.) valued from 1 through 7, based on a likert 7 scale. We're only using a likert 6 scale, so the respondents will only see 2-7 on the form. If they options B-D (valued 2-4), they are considered negative, so we want to make sure they enter a comment.

I tried to enter the italicized code under the form on BeforeUpdate, AfterUpdate, CmdUp (click to next question) and CmdDown (click to previous question), with frmQuestionnaire but nothing happens:

There is a module called clsUser which contains the following and where I tried to insert the code:

Set myForm = Forms!frmQuestionnaire
' ================================================== ==
' First, set the value of the variables
' ================================================== ==
lngQuestion = arrQ(lngArray, 0)
lngSession = GetCustomInfo("TestSession")
lngUser = UserID
lngBillet = BilletID

strComment = Nz(myForm.txtComment, "")

strComment = "None"

'If user selects negative responses
If Form_frmQuestionnaire.fraResponses.OptionValue = 2 Or 3 Or 4 And strComment = "None" Then
MsgBox "Please explain the problems you encountered with the system which " & _
"caused you to select an unfavorable response."
Form_frmQuestionnaire.txtComment.SetFocus

End If

lngResponse = myForm.fraResponses


When I place the code there, the dialog box appears for all values and goes to the next record. This is what appears for the CmdUp (click to next question):

If cUser.blnDirty = False And Me.fraResponses = 153 (this is default value for the entire option group) And cUser.blnNew = True Then
cUser.blnDirty = True
End If

cUser.CaptureAnswer
If cUser.lngArray < cUser.UBound_ArrQ() Then
cUser.lngArray = cUser.lngArray + 1
Else
cUser.lngArray = cUser.UBound_ArrQ()
End If
cUser.FillQuestions
cUser.blnDirty = False

I've tried to enter the line of code with the form and the module, but no luck.

I also want it to remain on the same record until the field is changed. The form is unbound and has the following:

Public Sub FillQuestions()


'************************************************* ****
' Purpose: Scroll through the questions
'
' Assumptions: N/A
'
' Effects: N/A
'
' Inputs:
' None
'
' Returns:
' None
'************************************************* ****

Dim lngRG As Long

Set myForm = Forms!frmQuestionnaire
myForm.txtQuestion = arrQ(lngArray, 1)
lngRG = arrQ(lngArray, 2)
myForm.prgProgress.Value = lngArray + 1
myForm.lblProgText.Caption = "Question " & (lngArray + 1) & " of " & lngQuestions
myForm.lblTS.Caption = "Test Session: " & arrQ(lngArray, 3)
myForm.lblQID.Caption = "Question ID: " & arrQ(lngArray, 0)

GetResponseSet lngRG
FillAnswers
If lngArray = 0 Then
myForm.txtComment.SetFocus
myForm.cmdDown.Enabled = False
Else
myForm.cmdDown.Enabled = True
End If

If lngArray >= UBound(arrQ) Then
myForm.txtComment.SetFocus
myForm.cmdUp.Enabled = False
Else
myForm.cmdUp.Enabled = True
End If
End Sub

Public Sub FillAnswers()
'************************************************* ****
' Purpose: Fill out the user's previous responses
'
' Assumptions: N/A
'
' Effects: N/A
'
' Inputs:
' None
'
' Returns:
' None
'************************************************* ****

Dim strSQL As String
Dim recAnswer As New ADODB.Recordset

Set myForm = Forms!frmQuestionnaire
strSQL = "SELECT datResponse.reDatQuestionID, datResponse.reDatRespondentID, "
strSQL = strSQL & "datResponse.reDatResponseSetID, datResponse.reComment "
strSQL = strSQL & "FROM datResponse "
strSQL = strSQL & "WHERE datResponse.reDatQuestionID=" & arrQ(lngArray, 0)
strSQL = strSQL & "AND datResponse.reDatRespondentID=" & UserID

recAnswer.Open strSQL, CurrentProject.Connection, adOpenForwardOnly, adLockOptimistic

If Not recAnswer.EOF Then
myForm.fraResponses = recAnswer!reDatResponseSetID
myForm.txtComment = recAnswer!reComment
blnNew = False
Else
If myForm.fraResponses <> 152 Then
myForm.fraResponses = 153
myForm.txtComment = ""
blnNew = True
End If
End If

recAnswer.Close
Set recAnswer = Nothing

End Sub

Thanks in advance for your help!!

View 1 Replies View Related

General :: Append Comments Field With User Name

Aug 20, 2013

I need to save a user's machine name when they comment on a record.

I have a form that has a comments field, and a separate area that shows the historical entries from comments.

I also have an invisible field populated by "=fOSMachineName()" that shows the users machine name. Getting this running was tough on my 64 bit machine, but it now works!)

I wish to have the machine name included in the comments field every time the "Save Record and Close" button (which runs a macro) is clicked.

Right now, when someone adds comments, it shows a date and time stamp (which I still want to keep) but I want to also capture the machine name at the same time.

View 11 Replies View Related

Forms :: Comma Delimited List In Memo Field

Oct 9, 2013

I have inherited a database where technicians track equipment that has been repaired.In this database, there is a memo field where the technician lists all the part numbers he / she uses to repair the piece of equipment. This field was never reported against and was strictly used for reference. However, someone is coming to me now and asking that a report be generated with that information. Then she will separate those parts out on her end. because it is a free form field, the technician is not forced to put a comma between each part number. I was wondering if there is a way for the database to go through approximately 62,000 records and ensure that there is a comma between each part number? I was also wondering if there is way to program the database to automatically insert a comma after each part number.

View 5 Replies View Related

Forms :: Using A Form To Search Keywords In Memo Field

Dec 6, 2013

Currently, I am trying to search a memo field on a table by having the user enter keywords on a form (up to 10 keywords can be entered). It works when just one keyword is entered, however it doesn't work if more than one is entered. How do I account for more than one keyword being entered to search the memo field and return the recors where any of the terms show up in that field. Each one of the keywords [KW1] ...etc are in a separate unbound box.

Current formula looks as follows:
Like "*" & [Forms]![KeywordInputForm]![KW1] & "*" OR "*" & [Forms]![KeywordInputForm]![KW2] & "*" OR "*" & [Forms]![KeywordInputForm]![KW3] & "*" OR "*" & [Forms]![KeywordInputForm]![KW4] & "*" OR "*" & [Forms]![KeywordInputForm]![KW5] & "*" OR "*" & [Forms]![KeywordInputForm]![KW6] & "*" OR "*" & [Forms]![KeywordInputForm]![KW7] & "*" OR "*" & [Forms]![KeywordInputForm]![KW8] & "*" OR "*" & "*" & [Forms]![KeywordInputForm]![KW9] & "*" OR "*" & [Forms]![KeywordInputForm]![KW10] & "*"

Should I be using AND?

View 14 Replies View Related

Forms :: Place Cursor At The End Of First Line In Memo Field

Dec 2, 2014

I have created a button that takes the contents of a memo field and adds a new line of text at the top with the date, time and initials of staff member. So far, so good...

However I want it to end with the cursor ready at the end of the first line (to type the note) The following code does everything but ends by putting the cursor right at the end of all of the text in the memo field (instead of the end of the first line):

Code:
Private Sub Command59_Click()
Me.Note = Format(Now, "d mmm yyyy hh:nn") & " - " & "(" & DLookup("[login]", "logintable") & ") " & Chr(13) & Chr(10) & Me.Note
Me.Note.SetFocus
Me.Note.SelStart = Len(Me.Note)
Me.Note.SelLength = 0
End Sub

View 6 Replies View Related

Forms :: Using Combo Box To Populate A Field From Memo Source?

Aug 22, 2014

I am programming a database for a reorganized group in my office. For whatever reason they want their correspondence letters within the Database instead of in Word templates. This way I can standardize their headings and automatically import data from their tables onto their letters.

For this reason I chose a form. I felt using a report wouldn't give them enough editing power. Almost all of the fields on this form are unbound and set to default values. I want to use a combo box so the worker can select the "letter type" they want from the drop down and it will automatically update the body of the letter with the standard format of that type of letter.

Just one problem--these letters are wordy, so the "content" field had to be a memo. I know you can't set memo fields to combo box columns, so I'm in a jam.

how I could populate this memo field into the unbound field using some kind of selector? It doesn't necessarily have to be a combo box.

I want to populate the memo field into the unbound box, but I don't want it to establish a link or control source because I don't want the worker modifying the original record (think of it as a template).

View 11 Replies View Related

Forms :: Include Scroll Bar On A Memo Field In A Form

Oct 24, 2014

I gather that there is no way to include a scroll bar on a memo field in a form. What is the best workaround? The source is a mysql odbc table. It is set as medium text and comes into Access 2010 as a memo field. For a user coming to this field to read the material entered there, unless they click somewhere within the field, there isn't a scroll bar. It isn't obvious that that is what they need to do to see all of it. Is there any way to work around this limitation?

View 4 Replies View Related

Forms :: Log History Of Inputs - Using ComboBox To Update Memo Field

Jun 25, 2013

I am currently using the column history to log the history of inputs into a memo field.

But i now need to swap how my database runs and now require a combo box to have the same history function, as this is for a status updates and i require users to only input certain status's.

I no that I cant use the columnhistory command with a combo box.

When selecting a status from the combo box it automatically update the memo field (which will be hidden on the form) so the column history function works.

View 1 Replies View Related

Forms :: Handling Large Amount Of Data In Memo Field

Jun 9, 2013

My DVD library database I have a memo field which has the description of the movies.

In some cases, like my tv show records, I have a lot of data because of the episodes and episode descriptions.

I'm currently displaying this data using a split form with the datasheet on the left

I must use a small font in the memo field in order to display all data.

I could use a larger font and simply scroll but I'm looking for an alternative.

I've even thought of creating a hyperlink filed and point to the movie on IMDB's web site. But when I click the link nothing happens even though I copied and pasted the link into the field.

View 8 Replies View Related

Forms :: Show History Of Comments?

Sep 7, 2014

I am developing a new tool which needs to show the history of updates to the users, i.e.:

An observation is entered into a field on the MAIN FORM by user 1.

User 2 reviews the observation on the MAIN FORM and adds a separate comment in another field on the same form.

When the record is saved, the updates are NOT written to the Main Form Table but to the UPDATES TABLE for audit purposes.

I am also using current date/ time as a timestamp, which is protected and needs to be carried over to the UPDATES TABLE Every time a new comment is added in the MAIN FORM, I need it to be written to the UPDATES TABLE as a new record.

What I need to be able to show is:

Each comment added, as a list of readable records, in a table within the main form AND Each time the main form is refreshed/ opened the separate comment field is blank to enable each new update to be applied.

View 4 Replies View Related

Forms :: Access 2013 - Click On Memo Field And Hit Enter To Go To New Line

Apr 12, 2013

When I click on my memo field and hit enter to go to a new line, it moves to a new record. Where do I look?

View 2 Replies View Related

Forms :: Format Memo Field To Ensure That Sentences Begin With Capital Letters

Nov 4, 2014

Is there a way to format a memo field to ensure that sentences begin with capital letters. There might have been something in the strConv function, but it seems my hopes are dashed?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved