Search results

I haven't done that yet. I need to do some changes since I got inspired by your way to do it. Unfortunately, I'm a bit busy today, so I might need to wait until the weekend. Thank you for your help. It's much appriciated :)

Wouw! Thanks a lot :) This is exactly what I needed. I very grateful!

I don't min seeing it as 123,4 hours. But to see it as 75,93 is a bit confusing (the xx,93 part)

This woked! But not with format xxx:xx like Time: Minute

I got no error, but the result is the same. No data are shown in the field "TotalTime". Could it be because the field "TotalTime" not are in the ReportFooter, but in "Personaledata.Navnfod"?

It seems to be working, but I get no result in the "Sum" field ("TotalTime"). The variable you'er using TempVars("TotalTime") is automatically changed to MidlertidigeVariabler("TotalTime"). Maybe this is causing some problems. This is how the code looks like now:

Print preview. But it doesn't really matter how it's shown.

This is my Report - named "Timereport": This is the Query named "Timereport": I hope this helps

Thank you for helping me. I do get an error highlighting the "With db.OpenRecordset(Me.RecordSource)"

Hi I have a time report which contains a field formatted as Short Time. In the report there is a field for each day in the month. I need to make a Sum of the field, so I can se the total amount of time spend for the month. But it seems like the format "Short Time" can't chow more than XX:XX not...

It’s an attachment

Hi I have a table containing different kind of data including attachment. When I generate a report I can’t display the attached pdf-file. If I change it to a J-peg it’s no problem. Does anyone knows how to display the pdf-file in a report?

I know the primary key. But I'm aware that forms don't store data. It was just to make it clear the I'm handling it from a Form (AfterUpdate)

Well the point is not inventory. It's just one of the functions I need. I can refrase it like this. I need to update a specific field in a specific record in a specific Table from another Form. Is that possible?

Hi I have a table ("Vare") which contains products and stock. When I make an order in my order module ("Lagersystem") i would like to update the field "Antalpålager" in the table "Vare". The information comes from "Form_Lagersystem.Antal" which I want to use to subtract from "Vare.Antalpålager"...

I've tested it now and it works perfectly :-9 Thank you so much for your help!

Thank you do much. I’ll test it tomorrow. I really appreciate your effort 😊

Thanks! Now It'll show 28-02-2022 in the report. But when I change the date, it still shows 28-02-2022. Even if I leave it blank. This is my code: Private Sub Kommandoknap7_Click() On Error GoTo Err_Kommandoknap7_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 Dim...

Hi I try to open a report using a filter. I manage to set the filter correct (DRDate=28-02-2022), but the report won't show me any data. It's blank. If you're wondering - it's in Danish. DRDato has the correct format. I can't get my head around it - need fresh set of eyes on this.

Hi I'm creating a report in which I want to display all attached files for each record. My problem is that the report only display the first file instead of all the files. What am I missing here? /Ole