I have a populated TEXT field that I would like to change to LOOKUP on another table for all new records. I receive an error msg stating that all records will...

I want to change the data type "text" length value 100 by 250 but since I am having access 2000 with access 97 file format i can not change the length. I...

I have a table, EMPL_ISH, that is created automatically and I need to change the definition of one its fields, EMPL_NBR from a Number\Double to...

I am trying to change all the text fields in my tables with a certain name to a size of 33 characters using a module. It worked for setting AllowZeroLength,...

How am I change the "required" property in the field column in ADOX. It is default value as "Yes". I wanna change it to "No" when I create a new table & field...

I am importing an Excel spreadsheet into Access. Access in its infinite wisdom decides on the data type for the fields in the import. I need to be able to...

First- I did not set this program up and am slowly teaching myself how to use it. I am recording archaeological sites in a database and there is a set heading...

In a query expression, how do I change only the initial character in a text field to lower case? Thanks, group.

I need to change the look-up field in a form to "LimitToList" to "No", but I keep getting the message: "Microsoft Office Access can't set the Limit to List...

Is there any way to change the lookup properties in multiple feilds without having to click each one in the design veiw? I want to link about 60 different...

I accidentally changed one of my fields to a lookup field that takes multiple values, but now I can't change it back to just a regular text field. How do I...

I am a self-taught novice (the worst kind!) so am hoping I can get a nice simple answer to my question. First the history: I want to re-build a database...

I've got a database which includes a number of tables, some of which are linked on a primary key. When I first designed it, they didn't have a unique...

I need to change this query because I needed a join file between company and car_owners. There is a many to many between cars and owners for rental purposes....

Is there any way to setup a combo/list box with zip codes so that when I select a zip code, the query the form is based on only displays the...

I originally created a table with LookUp tables/fields. I have queries and forms based on this table. Now I have seen the light and need to get rid of the...

I'm reposting this question from 10-31 as I fear it has slipped through the cracks... ____ I have a database I used all last year. One of the primary...

How do I change a field of text datatype to number, long int datatype, where all the values in the text field are numbers (within the range of long int)? I...

How can I change the length of a text field programatically? TIA, Lou

how do I change the display in contacts in addresses, eg show business numbers and cellular phone numbers