Recent content by MarionD

Thank you all so very much! Got it working now with all your advice!

Hi Guys, Sorry - I know this should be easy but it's just not working for me. I have a form with a combi field - 3 Columns - ID;Description; Startdate I click a button to open a report and want to set the heading on the Report (textfield) to the description & startdate on the form (column2 and...

Thank you so much for this!

Good morning, I was just wondering if anyone has written a simple cash register for example to be used at a street festival....only selling +-10 different meals and a selection of drinks. I only need to log the meals and drinks on one order, calculate change and print separate bons (receipts)...

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