Search results

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.

The PDF is just a tryout to ser if I could do some adjustments to send the ics instead.

I would like the code to pick it automatically - then i'll work as a flow. Create .ics file, pick it and email it.

Hi I've created an .ics file (which is working perfectly) and saved it in C:\iCalender. The file is called "SendToTechiCalendar795" were 795 is referring to an errand number. Since I can't use the same method as when I email .pdf files, I need to make this workaround (save the file first). I...

It worked perfectly :D Thank you for all your comments and help

I tried to disable the navigation bottoms and create my own. But still if I press next record it'll go to a new record (after the last record of cause). And that's what I want to avoid.

Hi I have a form to witch I import some data. These data need to be update manually also. But I need to avoid to go to a new (and empty) record. I can't really figure out how to make sure that i only can choose records with data in :banghead: Any ideas? Best regards, Ole

Thanks everyone #SPIKEPL Right now are we using a Swedish db, and we are online from Denmark. When we are using a Windows with a Danish setup, the db won't accept our date format. We need to work with a Swedish setup, and that's a bit difficult. My thought was that we could work with 2...

:banghead:Hi I would like to convert the date format (Swedish) yyyy/mm/dd to (Danish) dd/mm/yyyy. And I need it to be done via programming. The reason is that I need my database to work in both Denmark and Sweden. I will use 2 databases who needs to be synchronised, but we are using different...

I solved the problem by looking an extra time at the link you suggested, and then I was able to figure it out. The final code: ----- Private Sub Kommandoknap212_Click() On Error GoTo MailTilGodkendelse_Err DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 Dim MailAtt As String Dim...

My English might not be that good (I'm from Denmark), but what I meant was that I've tried the way you suggested, but I couldn't get it to Work with the code I have written until now. I'm not familiar with first opening the report filtered, then send it and close it again.

Before I posted the thread I searched the forum and i found the link in earlier posts. And i dosen't Work for me. And I forgot - these lines are disabled: ' stLinkCriteria = "Turnr=" & Me!Turnr ' DoCmd.OpenReport File, acViewPreview, , stLinkCriteria, , acNormal So I don't have an open report...

:banghead:Hi I'm trying to send at report based on a Query from a specific form. Everything is (almost) working fine, except the fact that I can't get a criteria into DoCmd.SendObject method. My code is: ------- Private Sub Kommandoknap212_Click() On Error GoTo MailTilGodkendelse_Err...

This is where I stand now (I only test it with File2): Private Sub Fakturanr_DblClick(Cancel As Integer) Dim stLinkCriteria As String Dim File1 As String Dim File2 As String Dim File3 As String Dim File4 As String File1 = "Faktura" File2 = "FakturaSpec" File3 = "FakturaSpecPakker" File4 =...