Recent content by MarionD

Thank you everyone for the conversation, ideas and lessons learned here. I have abandoned the idea but have learnt a lot. THank you all

Thank you so much for your friendly and helpful comment! I am just off to Switzerland for a weekend in the mountains... will get straight back to work after that.

Thank you.

OK thanks.... I dont know how to do that. I thought that it would be quite simple in VBA as it's so easy change in the table design manually! Thanks for the input everybody - I think I will abandon the idea. Yes - it's these headings that I'm trying to change. Not the table names, or the field...

I am also in agreement - this is more trying to adapt to make it understandable for German user.

Set tmp_property = td.Fields("DPurchasePrice").CreateProperty("description", 20, "Einkaufspreis") the error occurs on this line - I think the proble is with set tmp_property- thats why I asked as what should I dim tmp_property? it doesn't get as far as changing the description.... thanks anyway

Dim ws As DAO.Workspace Dim prog_db As DAO.Database 'verweist auf die currentdb der REBECCA.mdb Dim rs As DAO.Recordset Dim db As DAO.Database 'verweist auf die db der Back end daten.mdb Dim td As DAO.TableDef Dim fld As DAO.Field Dim idx As DAO.Index Dim tmp_property As Property '********* On...

Yes thanks I did do that....

Hi Plog, Thanks so much for the answer. I get an error message on the set tmp_property..... as what must I dim tmp_property? I have tried dim tmp_property as property and as accessobject property but somehow it's not working for me. Thanks again

Hi Pat, No not the user - I am trying to include this in an automatic Version Update - of course on the back end Tables. Just a once of converting the back end from Version 1.09 to 2.00 Thanks for the input

Hi there, I am trying to change the caption of a field in a table per VBA. Set td = db.TableDefs("tbl_Dress") With td Set fld = td.Fields("DPurchasePrice") fld.????? = "Einkaufspreis" td.Fields.Refresh Cn anyone tell me how to reference this property please? Sorry, I am using a German...

thanks so much! This works well for the field in the main form. I know I don't need 2 fields displaying the same but I am really puzzled as to why it doesn't work in VBA. (Unbound Field) Thanks again

thanks so much for the answer. Unfortunately it does not seem to make a difference. In the screenshot 1 is the Field with the control source set to =[subform_name].[Form]![endamount1] on the form before a customer is selected. on the second screenshot is the field showing correctly when records...

I have a very strange problem. Background: I have a main form on based on a table. I have an unbound combo search field on this form. After update I select the correct record from the table to display (recordset bookmark). I have sub form on the main form containing transactions pertaining to...