python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - ms-access-2016

Formatting Mac Address in MS Access

New to MS Access. Had a question regarding formatting of a MAC Address in one of my Access forms. There is a field I have set up using an input mask aa:aa:aa:aa:aa:aa;;a where users can manually enter...
test-img

AAA

ms-access-2010

ms-access-2013

ms-access-2016

mac-address

Votes: 0

Answers: 1

Latest Answer

My function FormatMacAddress is for you: ' Formats a MAC address using one of the four de facto formats used widely. ' Thus, the format can and will be defined by the specified delimiter to use. ' The...
test-img

Gustav

Select top n (variable) for each criteria in a table based on another table

I want a VBA code to make a query to show Equip with Top ActiveTime for each ModelID (from 1st table) based on TopN for each ModelID (from the 2nd table), I know i have to use QueryDef and Sql VBA but...
test-img

MMN

sql

vba

ms-access-2016

Votes: 0

Answers: 1

Latest Answer

You can do it in straight SQL - but oooh is it ugly to follow and construct I created 4 queries with the final one resulting in what you're looking for. The key was to get a RowID based on the sorted ...
test-img

dbmitch

How to read/set Excel Textbox property from MS-Access VBA

I have a simple Textbox in Excel worksheet (.xlsx) where I can read the BackColor property in Excel VBA sub with: Debug.Print TextBox1.BackColor I'm trying to reference that same textbox from MS-Acce...
test-img

dbmitch

excel

vba

textbox

excel-2016

ms-access-2016

Votes: 0

Answers: 1

Latest Answer

Excel.Worksheet is a generic worksheet object - it only provides access to "out of the box" methods of the Worksheet object: if you've "subclassed" your worksheet by adding members...
test-img

Tim Williams

Access/MS 365 for Enterprise: Find specific text within a string in an Access table's column and update each instance

I have a file with 80K+ records that I compare to another file in Access to find address changes. The problem is that the data in the address columns are not apples to apples, so using queries I chang...
test-img

karin21201

sql

vba

module

ms-access-2016

find-replace

Votes: 0

Answers: 1

Latest Answer

You can use the find and replace option in ms access, CTR+F. look closely at the options I picked in the find and replace dialog box. I have attached the image of the table data before and after the f...
test-img

Sola Oshinowo

Posts

Questions

Blogs

Jobs