Recent content by olxx

Thank you all for info. Little clarification is required. Price field is already formated as currency, no invalid data cannot be entered because access will prevent it. This sanitizing process is only for automatic correction if data is pasted. Usually because there is "." instead of "," or €...

Hi. I have numeric field (price) on form which sometimes needs sanitizing because values are pasted from different sources. I have working function for that, it checks if decimal separator is correct, removes any text parts (€ signs for example) etc. Problem is that i can't figure out which...

TempVars("username") = userName.Value should be TempVars("username") = Me.txt_username.Value And please take a note what others recommended about declaring variables.

This is shot in the dark, because outlook behaves mystically and i'm no expert but, Try this: after line If olNS Is Nothing Then Set olNS = Application.GetNamespace("MAPI") add olNS.Logon

I don't know what that database suppose to do, but it seems to me that you have design and normalization issue, not the form issue.

I know, that this is ages old thread, but anyway, maybe it will be useful for someone. If you need to store licensing info like valid_until_date etc, you don't have to hide it or encrypt it. You can store it in registry or even table. Just pair every value you want to store, with the test value...

OK, it seems that i managed to get it to work, thanks for pointing me the right direction @ebs17 and @AHeyne If it has any use to anybody, here is the code: Public filePathsToDelete As Collection Private Sub Form_AfterDelConfirm(Status As Integer) DoCmd.SetWarnings True If Status =...

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.