Search results

Good idea! I guess that's the very least I can do in return. Shall I send you a pm with my mail address?

Hi Uncle Gizo, I have been watching your Advanced Search Criteria videos and you are using some very nice functions. Are these available for download anywhere?

Yes, I think this function from Access MVP Ken Schnell is what you are looking for http://www.accessmvp.com/kdsnell/VBA_Functions.htm#BreakText

Hi Dhyangya, welcome to the forum. I'm not entirely sure, but I think you can use the code from the following URL to set a reference to the required DLL using code and for different versions of Office. http://gainingaccess.net/GainingAccess/CodeDownloads/FolderDialog.htm I hope it helps.

You can take a look at this tool, created by the great Allen Brown... http://www.everythingaccess.com/tutorials.asp?ID=Easily-copy-an-SQL-statement-from-a-query-to-VBA

I tested it today, but adding the line height parameter in the HTML code makes no difference. The content is generated correctly, but as soon as you start typing in the email, it starts using a massive line height.

In my case, I generate an email with text, all this has the correct line height, default I guess. But when you start typing in there, it gets a huge line height 1,5 or maybe even 2.0 I didn't try specifying the line height like above yet. Will try

Yes, I have the same problem with my HTML styled e-mails. Would be interesting if anyone knows a solution for this...

Why not use an inputmask for this?

You can easily test this right? You will see a lockfile on the backend if the connection is established, so just try and see...

Excellent stuff, thank you very much. Yes, passing the object directly is what I actually wanted. Thanks again CJ.

I am trying to create a dynamic function that will calculate the sum of a column of a listbox. When calling the function I would like to specify the form, the listbox and the column. Somehow the form name and listbox name are not coming through. Do you have any suggestions? Function...

I think you are referring to a filter or linkcriteria. Normally you would open your report from a form using a command button. If you use the wizard to create this button it will ask you if a specific record should be opened. With for example a combobox on the form you can select what record...

Ok, thank you both very for your detailed response. It can be that one of the operators was in a hurry to go home, and as the last one shuts down, the DB will perform a compact on close. Maybe this took too long for him/her and force closed it. I checked the functions and I can't find...

Thank you, yes that helps although I still don't understand why it corrupted my DB. Does the combination of Subs and Functions mixed through each other make any difference?

Hi all, Today my precious database got corrupted and I think the reason was that I put several functions in the same module. I often read with functions that people post, paste the following code in a new module... Are there any known issues putting several functions in the same module? Is...

Are you referring to 'IntelliSense'? See this article on Devhut http://www.devhut.net/2016/08/10/vba-programming-a-form-or-report-with-intellisense/

Oh right, that's a good point. I didnt actually implement it yet, but it will indeed be displayed in textbox. So if it does work when you reference the textbox it's great. Thx!

Ok, thank you for the responses. I was indeed hoping I could somehow pass the double quote directly in the paramater, but if that's not possible, I will just keep removing it from the call. It doesn't make sense to double double quote, then I can just as well remove it. Thanks for catching the...

Yes, I am aware of that page. The conversion is not the problem, it's handling the 'Seconds' indicator when calling the function that's giving me problems