Is there a way for MS Access to grab the current Active Directory user??

I'm working on a spec for a piece of software for my company and as part of the auditing system I think it would be ...

SQL Server Express vs MS Access?

A colleague I work with recently told me that SQL Express and MS Access were essentially the same thing; that does n...

Recommended way to read and write .ini files?

Are any methods available in VBA to read and write INI files? I know I could use; Open "C:\test.ini" For Input As #...

How to save an Access OLE Object (BLOB) image to disk using VBA?

So I seem to be able to save BLOB files from Access okay using the code below (which I found while searching how to ...

Code to loop through all records in MS Access?

I need a code to loop through all the records in a table so I can extract some data. In addition to this, is it also...

Connect to web service in MS Access with VBA?

Is it possible to connect to a web service (for example send a HTTP Request) via VBA in Microsoft Access? For exampl...

UPDATE statement with multiple WHERE conditions?

I'm trying to run an UPDATE query in Access with different WHERE conditions: UPDATE Table1 SET [Ticker] = "TXSFI" W...

CountIf formula within MS Access report?

Something terrible as happened with my poor attempt at adding a CountIf forumula to my access report. I am trying t...

When opening a RecordSet in Access VBA, if the type is dbOpenSnapshot, does it make the option dbReadOnly redundant??

In Access VBA, when opening a recordset as a snapshot, does it make the read-only option redundant? At first thought...

How to hide button control in VBA?

Is there anybody out here still programming VBA? I'm trying to get this code to work Private Sub button3_click() ...

How do I comment SQL code out in Microsoft Access??

Is it possible to comment code out in the SQL window in Microsoft Access? ...