Search results

In a module there is a function that takes a Form as an argument: Public Function FormRecordCount(ByRef frm As Form) As Long . I can work out if the form is a subform by seeing if it has a parent: On Error Resume Next Dim bSubform As Boolean bSubform = (Len(frm.Parent.Name) > 0) (If...

This is a quite simple but quite sturdy Access 2007 database with the following features: Custom logon form with hidden passwords Failed logon attempts recorded Passwords are stored with SHA1 encryption (using CAPCOM reference) so cannot be decrypted Admin account cannot be deleted, disabled...

I've taken it upon myself to copy out The Story so we can see the plot (:D) unfold more easily. (I've taken some liberties with punctuation and occasionally had to omit one or two posts that weren't followed through by subsequent posts.) Currently I've done up to page 15 (600th post). All...

Not at all useful but quite a pleasant effect I think. Can be applied to any control that has either BackColor or ForeColor: Private Sub Form_Timer() DriftColors Label1 End Sub Sub DriftColors(ByRef ctl As Control) On Error Resume Next Dim iR As Integer, iG As Integer, iB As...

I had a glance and couldn't see if another demo like this had been done. I made it for an individual request but it could be useful in general

There is a common structure in access database I build where there is continuous form (for example I'll call it frmList) showing a list of records with a button on each record to open the record's detail in anoterh form designed for that purpose (for example I'll call that frmDetail). Changes...