Search results

365, but I doubt this is a bug that varies with Office versions. There is something else going on.

Hey Ben, paste your code into ChatGPT, and ask the AI what it does. I pasted in this class... Implements ICommand Private obj_ As Object Private name_ As String Private sub_ As String Private prp_ As String '******************************************************** Aug 16 2024 ***** ' '...

On my machine the link provides an exact match. As far as the table data goes, you have not specified how you did the import, so we can't test your process.

To understand what VBA code does, you need to look at and understand the VBA code. The code itself is the "map."

If you are only returning two states you can shorten the code a bit...

What kind of security? I mean, you declare yourself and Access newbie, and it sounds like you are in a development process, so just distribute .accdb files. Put functionality way out in front of security.

Maybe you can describe in greater detail what this means.

Debug.Print "DSPT" & Split("7501243706 For Transaction: 7501021926DSPT21174531807", "DSPT")(1)

I have actually only seen this happen if the WithEvents variable is declared in a SubForm (and only if that variable still has another valid reference to it, like the global event raising class you describe). I had exactly this symptom, that the main form had closed, but multiple instances of...

A WithEvents variable must hold a list of references to objects in which it is declared, since it needs to call back to them when it raises an event. If you close a form that contains a WithEvents variable that has another pointer to it, it doesn't go out of scope, nor does its reference list...

The triviality of the solution IS the triviality of the problem.

My FE does auto-backups on the BE routinely. I have been doing this for probably 15 or 20 years in a multi-user environment with an MS Access file as the BE on a server. There has never been an issue. I take copies of the BE home with me on a flash-drive, routinely making that copy while...

Easiest to do this In VBA, in the database itself... Sub BackupCurrentDatabase() Const BACKUP_FILE = "W:\common\Reports\dbbackup\DB_BU_{0}.accdb" With CreateObject("Scripting.FileSystemObject") .CopyFile CurrentDb.Name, VBA.Replace(BACKUP_FILE, "{0}", Format(Now...

So you are good? You have a solution?

Here's a Ping function... Function Ping(ServerName As String) As Boolean ' returns true if the server responds ' to ping a url, remove the protcol, like https://, ' eg: google.com Const PING_CMD As String = "%SystemRoot%\system32\ping.exe -n 1 -l 1 -w 500 " Ping =...

If you are offering to purchase, what is your offer? I wrote a .NET command line program that I call from VBA like this... Public Sub QRCodeCreate(Payload As String, Filespec As String, Optional PixelsPerModule As Integer = 10, Optional Async As Boolean = True) Dim Command As String...

Watching AccessBlaster pedal backwards.

And it is apparent you know something, possibly everything, about hyper-partisanship.

If the form does not have a module, you cannot create an instance using... Dim frm As Form Set frm = New Form_fNoModule Only forms with modules are considered "Microsoft Access Class Objects". Forms without modules, for instance, do not appear in the VBE Project Explorer window. But in the...

No, I agree, but I am making the point that the failure you describe is not partisan, and not confined historically to the current administration. To your argument the solution is change of administration. To my argument the solution is that US politicians and electorate put aside their petty...