Search results

Wow! Thank you sooo much - thats amazing. You did all the work for me!! Thank you again - you saved my day! Hope you have an amazing one!

Good morning World, I know this is probably a beginner question and I'm just having a bad hair day, but I am battling! I have a form with an unbound list box for multiple selections. (2 columns - ID and DanceName) It gets it's data from a table called "tbl_Dance". I have a report that prints...

oh wow! ok thanks, i'll try that then. Only tested in design view. I didn't think it would work

Thats what I was trying, but apparently I cannot put the same report 3 times on a main report...even if I name it differently and link it to different fields. Thanks for the input!

Thank you so much everyone for the input! I have solved my problem by creationg 3 different but identical reports, and link them to the the main report by link child/parent fields. Works well. Thanks again to all!!

Hi All, Is it possible to use the same sub report on a main report... with a different name.? Scenarion: I have 3 different shifts to be worked at a street festival, Chips stand, Drinks Stand, Cleaning. The same Data, eg. Start time end time is in each shift. I would like to print all three...

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