Search results

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...

Thank so much to everyone for the very helpful hints and answers. A very special thsnks to arnelgp! I have a very nice little system up and running - Apart from a few minor updating of forms that I'm still working on Couldn't have done it without you all! Thanks again!

Wow again thank you so much. If you ever in Germany please come round! I owe you one big time-We have really good wines in our region

Good morning Arnelgp! I cannot thank you enough for this sample DB! The concert is on the 5th Nov. and ticket sales are really coming in now so I am under a bit of time pressure. You have made my life sooo much easier. I just have one question :) I actually posted an older version of the plan...

Hi there! Sorry found it! I hadn't unblocked the db!