Search results

  1. O

    Sanitizing number field on form

    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 €...
  2. O

    Sanitizing number field on form

    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...
  3. O

    Solved Tempvars username not displaying on subsequent forms

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

    Outlook import csv error

    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
  5. O

    Delete All controls from A Form

    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.
  6. O

    Annual subscription requirement process

    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...
  7. O

    Delete event triggers for moving files

    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 =...
  8. O

    Delete event triggers for moving files

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

    Delete event triggers for moving files

    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...
  10. O

    Delete event triggers for moving files

    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...
  11. O

    Delete event triggers for moving files

    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?
  12. O

    Delete event triggers for moving files

    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...
  13. O

    Solved ESC key behavior in reports

    Yes, thak you!
  14. O

    Solved ESC key behavior in reports

    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?
  15. O

    VBA Outlook SQL problem

    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.
  16. O

    VBA output report to PDF and email

    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...
  17. O

    VBA output report to PDF and email

    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.
  18. O

    Solved Closing specific folders using VBA

    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...
  19. O

    VBA Outlook SQL problem

    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...
  20. O

    VBA Outlook SQL problem

    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.
Back
Top Bottom