Recent content by DavidJMancini

I needed to initialize a key container, like so: Private Const CRYPT_NEWKEYSET = 8 Call CryptAcquireContext(lngContext, vbNullString, MS_STRONG_PROV, _ PROV_RSA_FULL, CRYPT_NEWKEYSET ) Then the other call (using CRYPT_VERIFYCONTEXT) works. The full (fixed) module: Option Compare Database...

So a while back I implemented my own VBA Cryptographically Secure Pseudo-Random Number Generator (CSPRNG) by using a call to MS API for Microsoft Strong Cryptographic Provider. It spits out random bytes 0-255 (00000000-11111111) in a cryptographically secure fashion. The call is accomplished...

Figured it out (on accident). The answer is TWIPS. Or, in other words, units of measurement sized at 1/1440th of an inch. Turns out twips are the default unit of measurement (programmatically) for sizing Access controls in VBA! If doing something like this: Me.txtFirstName.Width = 5 '...

SHORT: So, the title pretty much says it all; I have a subform in continuous mode, each one having a command button to activate "that" item. Whenever I make a programmatic change to the command button's properties, it disappears entirely and never comes back without completely closing the form...

One thing that comes to mind: if this form is meant to enter data (I notice your AllowAdditions setting) then you may want to rethink the way the form is loaded. It looks like if two people open this form, they're initially looking at the same record; if one deletes the record, and another tries...

Ok, so for one - this line: ElseIf (Len(Nz(Me.cboCurrentEmployee, "")) = 0) And ((Me.Status <> "Expired") And (Me.Status <> "Care validated”)) Then you have a "fancy" quote... Still reading it

Is the form for basic data entry/editing, or are there macros or vba tied to it? If so, what kinds of functions does the form run?

And it happens specifically when you open *that* form?

If you have a Recordset opened on a table it is captured as a snapshot; updates someone else makes do NOT propogate into the recordset without a requery. If from that recordset you (read code) try(ies) to modify a deleted record, you'll get a nasty-gram.

There might be code running on your instance of the Front-End that is trying to parse records that someone else has already removed since you opened it?

OMW - The PAIN :banghead:

I have a subform (continuous forms) that pulls data from a query, which pulls data from two tables that are in a one-to-many relationship. Basically, one table lists documents (many-side), and the other table lists document types (one-side). In the type (one-side) table, there is an attachment...