Category "ms-access"

How to specify the max of a field +1 when defining a SetField value in a Before Insert trigger?

I have a database with a table that has as its primary key an autoincrement number field I call id. In the datasheet view, I want to create some new records us

How to specify the max of a field +1 when defining a SetField value in a Before Insert trigger?

I have a database with a table that has as its primary key an autoincrement number field I call id. In the datasheet view, I want to create some new records us

DLookUp select secondary email if primary is empty or null

I have a form that is selecting emails based on companies that have expired insurances. Some companies have both a Business and personal emails whilst others ha

Looking for a complete Python script so that it runs my Macro?

I'm trying to create a Python script that opens MS Access and runs a Macro. I have the following script: import win32api,time from win32com.client import Dispat

Opening MS Access database with Powershell?

I am trying to open a form in an access database using powershell: $application = New-Object -ComObject Access.Application $Fullpath = "path.accdb" $appli

Microsoft Access 2013 Input Mask

How do I place on a input mask on an entity on my table? I want the entity LibraryID's mask to consist of 2 uppercase letters followed by 4 numbers.

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