Recent content by Slade2000

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?