Recent content by olxx

I tried filePathsToDelete.Add Me.uxFilePath.Value & Me.uxFileName.Value, gives error: object variable or with block variable not set.

Thanks for replies. @ebs17 The whole delete process is canceled if any of the files is open. @arnelgp Thanks for your demo. But i have no idea how to integrate that demo to my own code. Those scripting.dictionary objects and timers are way beyond my comprehension and vba skill. I´ll keep it as...

Thanks for replies. I try to explain it a bit more. User form is a split form, that shows multiple records. One of the fields is filepath that contains file name and location. User can delete records from that form using standard built-in Access interface (lets say drag mouse over records and...

Well that was the question, how do i get the selected records that are about to be deleted? if it is one record then you can catch that currently selected record in OnDelete event before actually deleting. If there are more than one, how to get that recordset?

I have a bit of struggle with delete events. I have table that consist filepaths and filenames. I need to delete those corresponding files (actually moved, but not relevant) if that record is deleted. if i use before delete event, user might cancel the operation but files are getting deleted. if...

Yes, thak you!

Does anyone know keyboard shortcut to close report? If my report is in print view, the ESC key works, but in report view, it doesn' t. What am i missing here?

I really don' t need it anymore but i still have genuine interest so i made demo, let's call it for educational purposes. See if you can make it to work because i sure can' t. I think the items.restrict method is a culprit. Thanks for your time and effort.

In my case, report' s recordsource is the same query that is used in form that is creating the report. No filtering is needed as it is already filtered. Pdf file gets saved in both cases, but in my approach you can choose where it is saved (for let's say archiving purposes). And if you don' t...

You have a weird approach. You don' t actually need to open report. Try it that way: Grab the data from the form to construct file name (quoteref etc.). Use DoCmd.OutputTo acOutputReport method to save the pdf file. Open email, fill the fields and attach the pdf file.

I assume that the explorer window you want to close is identified by folder path. In this case this code closes the explorer window you want. Edit thetargetFolderPath part in quotes. Sub CloseExplorerWindowByPath() Dim shellWindows As Object Dim explorerWindow As Object Dim...

I use pop3 not imap. All messages are saved locally in pst file. Unless i don' t move messages myself, the entryID will remain intact. The reason for using subject field to add ID tag, instead of custom field, is that i'm not sure how the custom fields behave in other computers/mail clients...

I tried that earlier. If two or more messages are received at the same minute, it will not open correct one. But i already changed my solution completely so i don't need that time finding approach anymore. But thank you for your reply anyway.

I reworked my solution entirely. It's task management app what we are talking about here. Actually a Access template, that i' m now modifying to integrate Outlook to it (importing new tasks form e-mail messages, managing replys etc.). I now store Outlook EntryID in access database and tag the...

I already tried that earlier. It does not work. The problem is that items.restrict method just won' t work correctly if you use seconds. By changing approach, i meant that i won't try to find messages by date/time anymore. But thanks for the reply.