Search results

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...

Hi all, Hoping someone can give me an idea how best to do this. Background: My DB is the administration of a day care centre. I have a list of clients, and the days they have chosen to attend. eg. Monday and Friday or Tuesday and Wednesday etc. ( as check box) Now I need to print a monthly...

Thanks so much from Germany to USA! - Works fine Have a great day! Marion

Hi all, I have created a report to print address labels using the wizard. It works fine for one client after another - but I want to print 1 page of labels for the same client. If I do openreport.... etc. where Id = me.ID (Client is the selected record on the form) I get just 1 label, not one...

Thanks so much! Works like a charm. M

Hi all, I have to check the "access level" of the current user and close the form if the user is not supposed to have access. I have put a bit of code on the On Load Event of the form. This works fine, and even displays my message "Access denied" Now I have tried putting docmd.close or...

Thank you so much! Have just spent 2 hours at a customers office trying to figure out what went wrong!! After decompiling, recompiling, copying all the files to a new DB, compacting, repairing, recreating the accde on the local computer, etc...... I gave up, loaded a full version...came home and...