macro or vba

Question

I would like to show the dates of a subform. When line 5 is completed, I need those dates, if not, the dates of line 4 should be taken, if not, the dates of line 3 and so on till line 0. Can someone tell me how to do?

Thanks

karl_donaubauer · Answer

Hi,
&nbsp;
&gt; When line 5 is completed, I need those dates
&nbsp;
1. What is your "line" in database or Access terms? A record stored in a table or some unbound text boxes in the form or ...?
&nbsp;
and related:
2. How is 5, 4, 3..., i.e. the sort order, defined?
&nbsp;
ServusKarl****************Access ForeverAccess NewsAccess DevConAccess-Entwickler-Konferenz AEK - 19./20.10. Nürnberg

annevaes · Answer

Karl_Donaubauer&nbsp;Good morning,I'm sorry I haven't replied earlier but I took a week of.The line is the sum of a date and a number of days in another form, transfered to a subform in another form, transfered to another subform in yet another form. The last line of this last subform should be put in the form.I must confess, a collegue who is retired now, made this database. I don't know a lot of access.Hopefully, my explanation was clear enough for you.thanks a lot,Anne

annevaes · Answer

annevaes&nbsp;To clarify my question, I have explained the process in an appendix

annevaes · Answer

@Karl_Donaubauer&nbsp;To clarify the problem, I put some printscreens in an appendix

annevaes · Answer

Karl_Donaubauer&nbsp;Hello,I wanted to post a document explaining my problem but I see now I posted it to myself. I try again.

Forum Discussion

macro or vba

Share

Resources