Search results

Thanks Pat, I fixed that (copied header text instead of url ;()

No, I always use the same nick except on Github. What are you thinking, who I am?

And now I do the same ;) Mixed that up with sth. else. But to open the BE you need the pwd, what then can be recovered from the FE (or is that wrong too?). Thanks for correction! Do you agree on TS, as only way to really secure it?

Without a terminal server, you always need access to the backend, via share. You can try to hide the path, but that's bad security by obscurity! Ms Access encryption before Ms Access 2010 is useless (https://www.everythingaccess.com/accessdatabaserepair_info.asp) On a terminal server you can...

Read Optimizing Microsoft Office Access Applications Linked to SQL Server: This doc explains what is going on.

remove DoCmd.SetWarnings False and use DoCmd.SetWarnings True on top of code (as it might be turned off by you) to get an error message

Avoid DoCmd as it depends on actual focus. You can set focus with Docmd.SelectObject, but there are better alternatives.Me.RecordSet.Delete is referencing the Form-Instance Recordset explicit! btw. DoCmd.SetWarnings is used to suppress deletion warning? Better use Application.SetOptions to only...

Me is only valid in VBA Code. In form design properties you have to reference the form by name from the forms collection:Forms("FormName")and avoid the Bang-Operator.

Fieldnames with blanks need to be enclosed by square brackets like you did(unnecessarily) on CodeNo and the last double quote is wrong: DLookUp("SerialNumber","ImportEquipment","[Code No] = " & Me!CodeNo)

Now my message count is 10, but it was very annoying, not to know why post where rejected! New users may not be as patient as me ;)

Bots should fail on captchas, as they are designed for that (Completely Automated Public Turing test to tell Computers and Humans Apart). There are options in xenforo https://xenforo.com/features/spam/

Picture of the error message, to prevent bots reading it.

I prefer ISO Format yyyy-mm-dd, as it can be used almost everywhere and can be sorted as text. If tbl_emailLog.sentDate is type DateTime you can use: DCount("*", "tbl_emailLog", "[sentDate] > Date()") = 0

Or a picture as error message

Then use a captcha on first ten post, if links are included. Or allow plain text URLs. I even can#t write 3 consecutive 'w' in a post

Hi, as new user with less than 10 messages I can't post URLs (as theDBGuy told me). but the error message is Your content can not be submitted. This is likely because your content is spam-like or contains inappropriate elements. Please change your content or try again later. If you still have...

Hi hys408, a salutation is always a good start and a sentence should usually contain a verb ;) ListBoxes can't have a conditional format, but you can use a subform instead (includes filters and sorting too). You can access the conditional formats of a control by looping its .FormatConditions...

VBS using ProductCode: With CreateObject("Access.Application") If Mid(.ProductCode, 21, 1) = 0 Then wscript.echo "Office is x86 ProductCode is " & .ProductCode Else wscript.echo "Office is x64 ProductCode is " & .ProductCode End If End With

I presume your website and database are not hosted in your LAN! Did you consider using a Remote Desktop? Club membership doesn't sound like heavy multiple user usage, so if only one user at same time is sufficent, a standard Windows PC can be used locally. Connection to that PC can be done by...