Access Multi-field Search with Results as you type

Good morning, all, My question today is regarding multi-field search. I have a split form (fields and individual record at the top, all data in datasheet view on the bottom). I have multiple fields I would like to search on, so that a user may find...
more »

2017-10-18 14:10 (2) Answers

Import XML with multiple nested rows into Access

I'm importing some XML documents (created in InfoPath) into MS Access using an XSLT. It's working fine except for one issue. Many of the nested elements (child tables) contain multiple values, but the import is only bringing in one record. In this s...
more »

2017-10-15 18:10 (1) Answers

How to use an array of objects in vb

I'm trying to learn how to use an array of objects, but I don't understand very well. I have to export data from an Excel file to an Access db. Private Sub Import_XLS(ByVal fileData As String, ByVal dbEmpty As String, ByVal dbDest As String) If...
more »

2017-09-28 11:09 (1) Answers

recordset.find using variable VBA ADODB

I am getting pretty desperate trying to get this trivial search to work: rst2.Find "ID = '" & messID & "'" I have tried just about any combination but it just never returns a search result. the whole code would be here: Option Compare Da...
more »

2017-01-16 14:01 (2) Answers

Setting User Permissions Within MS Access on Login

I am currently working within MS Access 2016. One of the requirements for the project that I am working on is tying the users Windows login to MS Access. I am only grabbing the users "User Name". Within Access there will be permissions set to users w...
more »

2016-12-06 19:12 (0) Answers

POST Parameters not passing to Web API using VBA

I have a bog standard WebAPI that accepts a POST and takes those parameters and processes certain things. I'm not certain if the problem is the VBA or the ASP.Net WebAPI so I am cross posting. I've used Postman to test the API and it works fine when...
more »

2016-06-20 10:06 (1) Answers