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 Replies


ADVERTISEMENT

Selecting Memo Field From ComboBox

May 29, 2005

Hi All,
I am not sure if this is an easy one or not..
I have a field in a table named Stock_Alias. This field was originally set as a Number field. I have a combo box on a form, which contains the Stock_Alias numbers. When a number is selected, the remaining fields are shown in text boxes.
I have had to change the Stock_Alias field to a memo, to incorporate Numbers & Characters.
I cannot seem to hit on the right code to get the same results as i did when the field was a number field..


This was the code I was using to select the field as a number...

Private Sub Cmbo_Stock_Alias_AfterUpdate()
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Stock_Alias] = " & Str(Me![Cmbo_Stock_Alias])
Me.Bookmark = rs.Bookmark

End Sub

View 4 Replies View Related

Combobox Selections Show In Memo Field

Jan 17, 2005

Is there a way to show all combobox selections in a memo field so the user knows what they have already selected? Thanks for any help.

View 2 Replies View Related

Forms :: Update Row-source Of Combobox Based On Value Selected On Another ComboBox?

Apr 26, 2015

I am trying to use a combobox called Manufacturer to select which table the combobox called Model gets it's rowsource from using the code below.

Code:

Private Sub Manufacturer_AfterUpdate()
If (Me.Manufacturer.Value = "Siemens") Then
Me.Model.RowSourceType = "Table/Query"
Me.Model.Recordset = "SeimensTable"
Me.Model.RowSource = "SELECT Model FROM SeimensTable"
Else
If (Me.Manufacturer.Value = "Samsung") Then
Me.Model.RowSourceType = "Table/Query"
Me.Model.Recordset = "SamsungTable"
Me.Model.RowSource = "SELECT Model FROM SamsungTable"
End If
End If
End Sub

But when I run the form and select Manufacturer. Combobox Model remains empty. tell me what I'm doing wrong?

View 5 Replies View Related

Update Memo Field With Line Breaks

Jan 6, 2006

I have a memo field that contains several text strings separated by line breaks. I would like to write a query to add another text string to the end of the field. How do I embed a line feed in the SQL?

View 3 Replies View Related

Update Query Memo Field Question

Oct 7, 2007

I have a field [InternalComments] which is a memo field. Lots of data per customer

Can I make an update query to add data to the existing data without overriding the data currenty there?

Thanks

View 14 Replies View Related

New Recordset's Memo Field Data Lost On Update

Feb 29, 2008

morning

i am adding a new row to an adodb.recordset, one of the fields being a Memo datatype.

all the other fields will write to the database fine, but with the memo, it will mysteriously disappear when i call rs.update

response.write(rs("my_memo_field")) 'give correct output
rs.update
response.write(rs("my_memo_field")) 'gives nothing!

any one else had this happen and have a solution?


cheers

View 2 Replies View Related

Update A Record Of One Table And Save The History Of Changes In Another.

Jun 10, 2007

Hello!
I am trying to update the current status of an asset, when it was returned or checked out. At the same time, save the changes in a history table to record all the changes in past. I can do individually from different tables and different forms, but I would like to do from one form and one record entry. Is it possible? If so can anybody help?
Thanks
JVirk

View 4 Replies View Related

Append Value To History Table And Update Current Value

May 18, 2015

I have form1 that has the current commodity When i need to change the commodity I want the following to happen when they click a button: open the commodity change formthat form has a drop down to select a new commodity and a date of commodity change date fieldWhen the user submits it will move existing value to history along with the Date of change (separate table)Next it will take the value in the new commodity box and make it the current commodity

My thinking is that when i click the button to open the change form I can save the commodity at that time but I wont have the date yet. Just not sure of they best way to go about this.

View 6 Replies View Related

Forms :: Update Table Via Combobox?

Mar 20, 2013

I have a form with a Combobox that gets it's data from the table 'countries' and stores information in accounts.

Now I would need data entered in the cobobox to be checked against the table 'countries' if the data already exists...

if a.) yes - then all good
if b.) no - then new entry should be added to table and combobox (after confirmation)

View 6 Replies View Related

Forms :: Lock The Combobox After Update

Jun 3, 2013

The company's register of projects we select the customer from a combo box that is related to the customer table. However, the way this works now, the individual may choose another customer by mistake, and if this is not corrected at the time the project will be listed with the wrong customer.

I would like to have a feature that when you select a customer receive a message if you are sure this is the right customer and if you answer yes then the customers name is being locked to this project ID.

View 5 Replies View Related

Need To Retain History And Update Records Based On Condtion

Nov 26, 2007

I have this scenerio that I am trying to work through and find a proper solution:

Main table stores a part # and an index (Primary Key) along with a bunch of other data. I want to store with the part # the current active version of firmware (aka software) associated with that particular part# / index. Part # may be a duplicate, so for this reason the PK is the index, so that each index / part # will have which firmware has been used with it.

I would like the ability to retain a history of firmware versions used for a particular part # / index so that if we need to go back to a previous version of software we will know which ones have been used.

I have been able to create the relationship to show all previous versions of the firmware used for a particular part # / index, but cannot figure out how to only have one 'current' and update the others as 'archived'. I would like to either use a boolean or selectable lookup (ie Current vs. Archived). What I want is that when I select one firmware to be ‘current’ all others related to the particular part # / index are updated to ‘archived’ leaving the other records not related to that part # / index alone. Also note that I am trying to make the update of the firmware status in the table view without having to go through a form.

Main Table
ID (PK)
Part No
Product

Firmware History
FirmwareVerIndex (PK)
PartNo
Firmware
ChangeDate
ChangeName
FirmwareStatus

Firmware Table (lookup table)
FirmwareIndex (PK)
Firmware
FirmwareFileName

FirmwareStatus (lookup table)
ID (PK)
FirmwareStatus

View 1 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 :: Using Combobox In Continuous Subform To Update A Record

Feb 25, 2014

I have a continuous subform of 'static data' whose record source is a SELECT query across multiple linked tables.

Most of the fields are locked and purely there for information purposes but I need to be able to allow end users to change one particular field in each record if they need to - choosing a value from a predetermined list (i.e. one of the tables)

Usually, when I need to do this, I add a command button to the subform and use that to open a separate pop-up form specific to that record, from which the user can make whatever changes they like and then update the record. So in this scenario, a simple unbound combobox linked to that table, on that separate form, would work quite easily.

But I would prefer if users could make their changes directly from the subform without (yet another) pop-up form required each time, to make managing these records more fluid and less time-consuming.

So my thought was to use a bound textbox in the continuous subform (to take the existing value for each record), hide it and overlap it with a visible unbound combobox whose row source is the table of available options and whose default value is driven by the hidden bound textbox. And then to use the AfterUpdate event of the combobox to run the UPDATE query on the record in question.

However, while the combobox is getting the correct default value and the correct list items, I can't make a selection from it. Now I am aware there are 'issues' with using a combobox in a continuous subform but I was hoping I could circumvent them by not binding it.

View 14 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

Mulitple Inputs To A Single Field Query

Feb 10, 2006

Hey guys, my problem is this:

I want to run a query that runs off of two list boxes on a form. However, I want both these parameters to filter a single field in my query. Why I want to do this is I have several types of accessories made by several manufacturers, both included in the "Description" field. I don't want to include an entirely new field for manufacturer because it's only 4 out of about 5 items that need this.

Is there a way this can be done or will I be forced to include a manufacturer's field.

Thanks in advance
Nathan

View 3 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 :: 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 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







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