Search results

except it's everywhere I use the format() function. Not just on one control. I feel like I'm going bonkers!

Thanks for the reply. Nothing seems to be missing ... I can compile with no error messages as well. Just seems to be on the controls on forms.

Hi there, I have just updated from Access2013 to Access 2016. All my Forms and Reports with the Format function in show an error. =Format([fromdate];"dddd") just displays #name. What to do now? If I add a new field it seems as though the format function is still there. Can anyone help me out...

Oh wow! Thank you so much! Easy when you know how. Works great! Marion

Hi all, I know this is an age old question but I just can't get it right. I have to display -0,029171 as time 00:00 I use this formula in an unbound field on the form =([zuvielstd]*1440\60) & ":" & Format(Abs([zuvielstd])*1440 Mod 60;"00"). It sems to work fine unless the first part not a...

Sorry folks! Post to hasty! Problem solved.... Dim I as date of course. Everything works fine now.

Hi there World, I need a bit of help! Is it possible to use "For I=1 to 10 " using dates? eg. for I=startdate to enddate where the dates are passed from a form. Can't seem to get it to work. Not strictly true... it does exactly what I want, but doesn't stop! Starts beautifully on my startdate...

WOW! Thanks a Million Steve.....works like a charm!

Both the Main Report and the subreport are based on tables which have a date stored in them (called Arbdatum). On the Report I have an unbound field with the contents set as =year(arbdatum). Also in the Sub Report I have the same field "Arbdatum" and an unbound field with control source...

Hi there, Is there any way to link a sub report to a main report with unbounf fields? I have a form where I put in Person _ID and Month end Date. By a button I print a report noting different detail for the Month. At the bottom I need to print a summary for the year per person. I have tried...

Hi there, don't know if till relevant but I found an easy workabout: If guthabenrecs!Endwert > 0 Then Me.guthaben_std = (Me.Guthaben * 1440) \ 60 & Format(Me.Guthaben * 1440 Mod 60, "\:00") Else Me.guthaben_std = (Me.Guthaben * 1440) \ 60 & Format((0 -...

Thanks again for the tip! You live and learn!

Hi there! Only reason is I don't know how! Will Google it and see how it works. Thanks for the tip... this is the first time I've had to do this! Or do you have an example ?:):)

Thanks again!

Sorry- I'm so used to thinking in 2 languages... It saya a file with the name Resume.xlw is already there. Do I want to replace it. But my file is calles something completely different.. it also an xlsx... no idea what an .xlw is.

sorry forgot to upload

another small Problem... When I try to save the Excel sheet with xlApp.save..... I get the attached message-- If I click OK it saves perfectly....

Perfect! Thanks a ton!

Hi there all, I am trying to fill an excel sheet from an access recordset, using this code newdata.MoveFirst With xlapp Do Until newdata.EOF x = x + 1 For y = 1 To 22 ' the recordset has 22 fields...

Hi there, Thanks for the answer but I think I have not really explained well. I'll try again. In the tbl_Klient I have 5 check boxes - Monday to Friday. If the Client chooses to come generally on a Monday and Friday then those boxes are ticked. All I need now is a Report (not to store...