Change field to combo box w/out data loss

Using access 2003 is it possible to change the type of a field from text to combo/picklist without data loss? Whenever I use the Lookup wizard it warns me that all the data will be lost when I try to change it.

I have a field in which the user is typing the same 4 values over again so it makes sense to change the field to a picklist. There are 400 records so I'd rather avoid having to go through each record and re enter the data.

Sponsored Links:

Related Topics

Change existing combo box to new one
I have a database that needs to be modified and I'm kind of a newbie.

I have a form to be filled out that currently uses a query to fill four fields.
The user clicks a combo box (Sub/Vendor ID) to select a specific vendor and the 4 fields of Sub Vendor ID, Company, Address, and Taxrate are then filled in. The only value stored in the Work Order table is SVID and none of the values appear on the work order report.

The old form worked fine but they now want to use the companyname field as the combo box for selection to fill all 4 fields.

I thought I made the mods correctly, but the only field that gets updated is the companyyname field.

I'm actually at a loss as to how the fileds get populated from the original query but not from the query I made.

I can send a sample data base and 2 screen snapshots of the old and new forms


Cancel combo box event if there is not data in another field
I have a continuous form where I have a field “Description” and a combo box. If you’re on a new record and click on the combo box I want to display a message stating that there must be data in the Description field before the combo box.

...

I get the message but the combo box still opens. How do I keep the box from opening?


change textbox value after combo update
I have combo box. Its values are from a query. No I want that after updating value of combo the value of text box will change. For example

1. I have a table named table_bill containing Item & Description field
2. In a form name form_bill containing one combo box. Values of this combo box is items of table table_bill.
3. Now I want that when I change the value of combo box automatically value of text filed Description will change. And the value will be corresponding description of item from table_bill


Manually changing attribute
When adding a combo box to a form with the wizard active, there is a setting that says "Store that value in this field" and you can choose a field from the source table. Is there any way to manually go in and change what field it stores in? You're probably asking why not just make a new combo box? Simple. I added new fields to the table I want to choose a field from. The new fields do not show up in the list. I tried closing out of everything, exiting Access and yet they still not appear. So I need to manually change the target field for the combo box to store its data in


Best Way to Assign a Value to a Field with a Combo Box
I have a question concerning combo boxes and the best way to implement them. When creating a field in a table I can choose to set the lookup for the field as a combo box and it will allow the use of a combo box in the table.

I could also leave it alone and use a form with a combo box on it. or are there particular situations where one ispreferred?

I can only think that using a combo straight from a table is good if you plan editing data via the table. If data entry is only to take place through the form then I see no need to set the combo box value on the table.


Change existing text box to combo box
On my form, I have a field that is a text box data type. I want to change it to a lookup field. Is this possible to change a specific text box on a form to a combo box


Using combo box to look up records?????
So I have a combo box. I am using it in my small scale sample DB so as not to screw up my huge DB.

Combo box is named Field 1. It works to lookup the other fields in the DB. It woerks well at this.

Enter wrench in the plan. I bound the combo box to a textbox that I am using a Mid function to pull the data form a barcode that I need.

It pulls the data just fine. Matches what is in the combo box letter for letter. But the combo box won't look up the record anymore


Text to Combo Box
I have some 20,000 entires populating a text filed that ideally should be a combo box. The data in the text field needs to be restricted to a small number of options, I'm thinking that I need a combo box for this but then the original data will be in a different field.

Is it possible to create a new combo box and then populate it with the data from the text field retrospectively or is there some other way forward for this problem?


Convert text to Combo
I have some 20,000 entires populating a text filed that ideally should be a combo box. The data in the text field needs to be restricted to a small number of options, I'm thinking that I need a combo box for this but then the original data will be in a different field.

Is it possible to create a new combo box and then populate it with the data from the text field retrospectively or is there some other way forward for this problem?


Changing a combo box's record source?
I'm basically trying to change a combo box's record source based on another combo box. However, to make matters a little more complicated (at least for me!), depending on what is slected in the first combo box, the number of columns in the second combo box will change. They will therefore also need to change widths


How to Change Field with a Combo Box Twice
I am trying to change two fields with the same form using a combo box. When I change the record (serial number) in the field using a combo box, it automatically updates the records in the other fields (which is what I want), but it also changes the field (serial number - installed) and it's associated records/fields, which I do not want it to do.

I would like to be able to change these records separately on one form and then click my 'save' button and move on to my next change out.

I have included a picture to show what I want my form to look like. Is thiswhere a sub form would be used?


Display a text box based on Combo Box value
I have a combo box that filters a field called [SDT], which picks out a date and time. This is done via a query. However I need this combo box to filter from another list into a text box after the selection is made in the combo box.

The combo box is called cboSDT which enter data into a field called Schedule.SchedDateTime. I need the text box to enter data into a field called JO.

The cboSDT get its info from a table called L_SDT which lists the required data for this field when a date has been selected.

The L_SDT table has two field names SDT and JO.

When the cboSDT selection is chosen I need the JO field to display in the txtJO text box, which adds that record to the JO field in the Information table.


Combo box and Text box link
I have a combo box and text box in a form. The combo box is displaying fields from a table. What I want to do is input data into the text box so that this data appears in the field selected in the combo box


Populate one combo box based on the selection of another combo box
I have a combo box that displays values based on the selection of another combo box. My problem is that when I make a different selection in the first combo box, the text in the second combo box does not change. Although the drop-down items are correctly changed in the second combo box...


Combo box wil not sort
I have a form with only a combo box in the form. The combo box is used to update data in single field table. My problem is that I want the data in the combo box to be sorted. I can't seem to find out how to do this.


unbound combo box
I have an unbound combo box on my database to search on a primary field. How do I make this combo box to match the primary field each time I move the record on my database? At present the combo box does not change.


Creating a query based on 2 Combo Boxes
I hope someone can point me in the right direction.

I have created a table that has records that have more than one field that is a look up field (combo box).

My problem is one of the look up fields (combo box) needs to display only that data that is based on the data in another field in the record.

I searched the help and it said to base the second combo box on a query that matches the rows containing the value selected in the first combo box.

I am not sure how to generate the query.

Example:

If in the record one field I choose Risk Level "1".
In the second field I want to display the Areas assigned as a Risk Level


Requery Button
I have and query and a form. ON the form I have two combo boxes. I have a function that I call on update of the combo boxes it requerys the data
..........
But when I change data on the other combo box it does requery right. It disregards the other combo box and adds ALL its data in the results. Instead of filtering some data out based on what I already have.


trying to manage DLOOKUP
I'm trying to create a field in a query that automatically displays a value depending on a previously filled field of the table from which the query is based.
I'll try to explain it better
I have a value of "decibels hearing loss at 500 Hz" which is always a multiple of 5 (0, 5, 10 15, 20, etcc.)
Depending on this value, when calculating the global hearing loss, I go and look up a % value of loss wich is given in a table:
0 dBs loss in 500 --> 0% in global hearing loss
10 dBs loss in 500 --> 0,2% in global hearing loss
50 dBs loss in 500 --> 35% in global hearing loss
and so on.
I've created a table in acces that has this two fields, dBs and %, and I'm tryng to retriev the % value in a query from it with the DLOOKUP function but I can't seem to get it done


synchronized Combo Boxes in subforms
I am using MS Access 2003 and have created a form using two combo boxes where I select the state from the first combo box. The second combo box is controlled by a query that looks at the first combo box so that when you change the state name in the first combo box it requires and then lists the available counties in the second combo box. This works very well but when I place this form as a subform and link the master and child fields the form finds several records which is right.

But when I try to change the state name on one of the records in the in the first combo box in the subform and then pick the second combo box for the updated county list it does not find the correct state and wants me to enter the parameter value. I think that because I have it require the list of available counties that it looses track of the record that I changed in the subform. Is there something I can do so that works right in the subform?