The first column is the clients name, the seconds is the day summary and the 3rd is the order details, the others are common function-subrutine used.
the day summary is usually avoided by my employee because they have to type a lot in short time so I try to make it faster because it is useful...
I have 1 normal form and 2 manually populated form (the records is a date from a function so the query is not updatable) depend on the filter on that query for 70-100 record in 5 employee is no more than 20 records, one for the opening and one for the closing, on more than half I need to add a...
the problem is that I have 3 forms and on every is more that 20 textbox to fill
When I enter in the box in the new form save the form name in the text55 and the textbox name in the text0 so I call the correct event. and avoid :
Select Case Me.Text0
Case "Text21"
Call...
nice... but you need to be careful
centre europe is in CET +1 zone but now in summer we are on legal CEST +2 and that function calculate the correct time but not the difference between we and 0 zone
example:
Rome 14:05
London 13:05
ConvertLocalToGMT(Now()) 'Rome time 12:05 because GMT is...
I'm interested too if someone know how to get GMT time not from system time.
if your time is -9 and your system clock is correct you can set
dateadd("h",9,time())
unbound control = Mike
unbound control2 = Brown
me.control=me.parent.unbound control & " " & me.parent.unbound control2
me.control = Mike Brown
is this what you ask?
try to put grouping on the field you want to see in the top and force new page before selection of group header, and remove the report header.
this way you will have on top the field you want on every new page.
the problem as I see is the open event not in the code
put that code newrec and if on the first button and not on open event and should work.
if not put all in a module and call it from the 1st button, it works to me