Topics Search

Change field to combo box w/out data loss

Change field to combo box w/out data loss
Views: 6
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:

More topics

 

Change existing combo box to new one

Preview
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

Preview
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?
 

Manually changing attribute

Preview
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
 

change textbox value after combo update

Preview
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
 

Best Way to Assign a Value to a Field with a Combo Box

Preview
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

Preview
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
 

Text to Combo Box

Preview
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?
 

Using combo box to look up records?????

Preview
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
 

Convert text to Combo

Preview
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?

Preview
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