Recent content by ComputerVersteher

No, not even that. Post count 59;) Thank you again, but now I have to leave!

@cheekybuddha: thanks for your encouragement! (but extrapolating my posting frequency (about 3 per month) shows ETA > 12 months)

Hi, what about using an url whitelist of allowed links for new users? They (especially me;)) should be allowed post links to trustworthy sources like accessforever.org, nolongerset.com, isladogs.co.uk, rubberduckvba.blog, utteraccess.com, stackoverflow.com, microsoft.com etc. Losing the rights...

@cheekybuddha: some valid points on traffic and complaining, but I was used to post links for 19 months. @isladogs: I will open a thread on Site Suggestions for the whitelist (and of course isladogs.co.uk should be on that list too ;))

To clearify, I was speaking of Utter Access, where I just registered and was able to post URLs on my first post! I don't know how they avoid spam, but do you know another site that handles this problem same as here. I don't! I want to help others, but without (or crippled) links, it's no fun...

That is very annoying! Forces me to use a different forum (where I can post URLs from first post).

Is the DB slow from startup or does it slowdown when used? If so it may be caused by the OpenForm bug (accessforever.org/post/performance-issues-and-crashes-when-loading-forms-in-version-2405). Is the performance of other DB's as expected? Is the performance off other apps on TS as expected...

Hi, for Yes/No-Fields use TinyInt type (0 is true <>0 is false). Also read the docs, especially the examples and notes/tips section. This will also reveal the correct usage of timestamps. They need Current_Timestamp as default and on update.

Seems like there are several commercial ODBC-Drivers available for Google Sheets. Simply search for: google sheets odbc connection.

You have to quote the path to exe as it contains blanks! Error would have shown if you tested your Shell Command with a Debug.Print [Edit added missing & after "winscp.exe"] Dim shellCmd As String shellCmd = strQuote & strSFTPDir & "winscp.exe" & strQuote & " " & strQuote & strCommand & strQuote...

Seems like search field txt_search has been deleted, but not its code. Delete all code in Form_FmasterList=today()(and never again name anything like that!!)

As Bob said compile your code (devhut.net/how-to-compile-vba-code/) . Code can't compile -> can't create accde!

Have a look at isladogs.co.uk/hide-duplicate-column-values/index.html

To display a pdf you can convert the pdf to a displayable format (bitmap, jpg, ...) and display the images. That allows usage of print preview with the contents of the pdf(s) shown. On Report_Open I use IrfanView via shell command to extract from pdf and wscriptshell.run with waitOnReturn =...

You can prevent the usage of the saved filter with Form.FilterOnLoad = False in forms property-sheet or in Form_Open event (more appropriate than Form_Load as that event fires after form with data is loaded).