Search results

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

Hi, backticks``delimit identifiers like[], so try replacing each other. Usually they are used in MySQL.

Check bitness of ODBC Driver (should match Office bitness). If Office (not Windows!) is x64 install x64 version of ODBC-Driver, if Office is x86 install x86 version of ODBC-Driver!

You can't set the Report.RecordSet property unless it is an ADP Database. Workaround: Link the view(MC_PrescriptionQ) then your code can set the Report.RecordSource property (or use a DAO Pass-Through query or a temp table with data from ADO query).

Your DSNLess connection code? What if you add a DSN by hands using %systemdrive%\Windows\SysWoW64\odbcad.exe ? Are you using Office x86 or x64 (app bitness = connector bitness)?

Quite sure you need the x86 version of myodbc, but since release 8.1 the x86 version is no longer included! So use the 8.0.x version of myodbc for x86 apps.