Recent content by Ole

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

Working perfectly like this: Left(Format(OpgaveStart, "hhnn"), 5) Thank you :cool:

Hi I'm trying to convert Time (hh:mm) into a text string (hhmm). I'm using 24 hour not AM/PM. It is working fine except when it's before 10 o'clock. When it's 09:15 the text string is 915 instead of 0915. How do I keep the leading 0? OpgaveStart is a Date/Time field (hh:mm) My code is simple...

The code is: DoCmd.OutputTo acOutputReport, File, acFormatTXT, Filename, False No secret there :) My problem is that ".Recipients.Add(MailAtt) should work as long as MailAtt = "ole.traulsen@gmail.com"" doesn't quite work. It seems like I can't transfer MailAtt from my Class Object to the...

No - it's quite easy. I simple made a report with the necessary information and saves it as a .ics file. No rocket science :) I've attached the .txt file which I saved as an .ics file. But I got the Outlook part to work as bastanu asked me to. So thank you all for your input - now I need to...

I tried to look into the Outlook code, but Access won't recognize the code?! There must be a way to grab the file in the directory and attach it to an email generated from Access - at least I hope so

Here is the code which produce the .ics file. I've tried to use...acFormatTXT, but it didn't work. That's why I need to grab the file directly from the directory - if it's possible. The "DoCmd.SendObject acReport, File, "PDFFormat(*.pdf)", MailAtt, "ole.traulsen@gmail.com", "", SubjectEmail...

I would very much like to send as code in Access instead of Outlook. I honestly don’t understand how the Outlook automation works. But I am using Outlook, so if I can be guided I’m ready to try.