Category "ms-access"

Outlook Redemption error in MS Access: ActiveX component can't create object

Code: Dim Application As Object, namespace As Object Set Application = CreateObject("Outlook.Application") Set namespace = Application.GetNamespace

VBA-Json Parse Nested Json

Thank you to @QHarr for working on this with me! My goal is to grab the values for each of the nested categories from "orders" my json: { "total": 14, "

Getting Outlook Redemption to work on 64-bit operating systems?

Our servers are upgrading to Windows 10 64-bit (which is also using Office 64-bit products) and I noticed that in this environment, the old Outlook Redemption c

Setting the location of a form in access vba

I'm working on an Access application with multiple nested forms on which the users clicks on selections in order to do specific tasks, e.g., enter new data, sea

MSAccess 2010 VBA Open a read-only database

I have a MSAccess database that I'm trying to pull archived data into, from other MSAccess databases that live in read-only folders. So ... Dim aidbx As DAO.Da

MSAccess 2010 VBA Open a read-only database

I have a MSAccess database that I'm trying to pull archived data into, from other MSAccess databases that live in read-only folders. So ... Dim aidbx As DAO.Da

Expression Builder for a command Button in MS Access

I am new to MS Access and would like to work with buttons of a form. I wanted to understand a point I have a text box search and I have a button in the form I d

openform Macro Where criteria

I am using a button from an unbound nav form to open a different form. The button Macro closes the nav form and opens the form I want with no issues. I have a q

HorizontalAnchor gives wrong value in Access

The problem: Control.HorizontalAnchor or Control.VerticalAnchor gets a value out of the accepted range. In the IDE window: Debug.Print Btn.VerticalAnchor -->

Wordpress WebToffee alternatives

I am planning to use WordPress WebToffee plugin to setup my online WooCommerce site. The plugin however only supports CSV files. I can easily convert all of my

Set and retain column widths of Split Form datasheet columns in MS-Access

I'm using a Split Form in Access 2012. Basic datasheet view on top with individual record and form header in bottom pane. I'm trying to figure if there's a way

olMailItem - ReplyRecipients.Add

I am in MS Access 2013 trying to set the Reply To address for a olMailItem with Outlook 2013. My current code is giving me: Run-time error '287' Application-d

C# - ASP.NET - Inserting Date from a calendar into a DataBase

I am trying to store the date from a calendar which the user has selected into a database. It seems to not being inserting it into the Access Database. The DB f

Invalid procedure call or argument applying Excel conditional formatting from Access vba

I have read numerous examples where this code works; however, when I try to execute it, it isn't working and I don't see why. Dim xl As Object Set xl = CreateO

Invalid procedure call or argument applying Excel conditional formatting from Access vba

I have read numerous examples where this code works; however, when I try to execute it, it isn't working and I don't see why. Dim xl As Object Set xl = CreateO

MS Access ignores trailing space(s) in primary key validation

I have an Access table with a TEXT primary key. If I use an INSERT statement to add a row where the primary key value is 'PART' and then try to INSERT anoth

Controlling MSG file draft/sent state

I've an Access database that records and saves email on the mailitem_send event. Saved email looks like: I want email to appear like an already sent email, li

Excel cells from Access export look empty but are not (=isblank=FALSE)

My problem is that an Excel spreadsheet (exported from Access as .xls) has cells that look empty, but are not. This is mucking up my calculations & navigati

Entire Union query returns no results if part of it returns no results

I've created the folllowing Union query, which works fine most of the time: SELECT [%$##@_Alias].[Contact ID], [%$##@_Alias].[Mailing Name] FROM (SELECT [Refer

MS Access Form button that allows user to browse/choose file excel , then imports file to a table

In my form access I want to make a button to browse / choose an excel file and import it in format a table in access. This is my code. ' Requires reference to