Search results

Jip this is what i wanted to do. tnx allot for all the help.

Got it to work tnx allot

Sorry it works i see it does it when i press the button for the seccond time coz it does not contain the origenal field name any more. Tnx alllllot

error is a Run Time: 3265

Private Sub Command1_Click() RenameField "Table1", "Field1", "Jeffrey" End Sub This is my code in the button, table1 is my actual table name and field1 is what my field name is and jeffry is what i want it to be. id i click the button it gives me a compile error on the botled line. Sub...

ok i added it to a module and insert a button on a form and it calls the module. if my field are named field1 field2 and field3 what should i then change in the code in the module then?

can i just copy that into a button? if so how would it look like. I understand a bit of VB

vb i understand a bit. Can i just copy that code into a button?

Tnx allot let me try.

Yup i have seen the "alter table" but dont know where to type it in to see if it will work.

LOL...maybe a update query?

I want it to actualy rename a table field coz i import a text file then it name it field 1,2 and 3 that is the 3 imported fields and i give it a table name (table2)then i want to rename them te be the same as table1 that is maybe name,surename,tel. coz i use a append to add the imported data...

I would like to rename fields with a query. I did do a search and came up with this: "ALTER TABLE "your_table" RENAME COLUMN "old_field" to "new_field" But where do i type this? or is this SQL? How do i do it in access? Tnx allot. Bob: sorry for all the questions....tnx for your help.

Grate tnx allot

okay so then lets say i want to recall the data in table 1 with the long text that i want and then it returns it in a form in 2 text boxes one longtext and the other short text so split it only when i want to query it in a form or report?

ok grate i understand now. It works but now i need to have both the longtext and short text in 1 table for example table 1 must then have tables TestID, LongText,ShortText. Tnx allot for the sample helped allot.

Ok why i want to do this is because i have a main table with all my data with 3 fields. field 1 contains the original barrcode and in field 2 and 3 partial numbers from field 1. Field 2 will have then the first 4 numbers of field 1 and field 3 the last 9 numbers. field 1 consists of 13 numbers...

I did try the update query but it gives me an error for the mid function that i use to extract the certain data.

Howdi. What i have is a is a table with 2 fields. field 1 contains numbers field 2 empty. Then i have a query that extract certain data from field 1 and put it in field 2 and it displays correctly in the query but now i want to take that data in field 2 in the query and copy it to the table. I...

Got it to work. What i need now is how to save the data from the query to the table.